× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

ARCHIVING FILES

  • emehaj
  • Topic Author
  • Visitor
  • Visitor
12 years 8 months ago #12830 by emehaj
ARCHIVING FILES was created by emehaj
Dears

We have RO6 and jbase 4.1 in linux server. My question is for files that are around 2 Giga it must archived or emerge can work even the files are more than 2 Giga?

Best Regards

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
12 years 8 months ago #12833 by jpb
Replied by jpb on topic ARCHIVING FILES
Check out what the master of jBase thinks about:

Jim Idle
Hi,
The limitation is that the offsets and so on in the file format are
limited to signed 32 bit integers. However, internally, these numbers
can appear to get bigger than that, but will end up going negative, or
wrapping and so on and the C runtime assumes you know what you are
doing. I know programmers who use these quirks as 'optimizations' in
fact - they shouldn't, but they do.

So, when a file gets to a point where the 2GB limit is reached, you can
end up writing a record that pushes the file over 2GB, but not
discovering this until you try to read it, at which point the pointers
will be wrong and be rejected. In turn, this is because most file
systems these days do not limit a file to a 2GB limit, so the write the
extends the file beyond 2GB will not be rejected (though a write to an
incorrect offset that tries to be >2GB will throw an error).

Other jBASE file types are not limited to the 2GB, 32 bit interface to
the file system and you might wish to use these. However, in general
your system will probably be more efficient if you archive data or
partition it and so on, so that you do not get files of 2GB (though
there are of course times when this is desirable).

Jim


So try using partitioning, see e.g. t24all.com/forum/43-jbase-utilities/2576...e-creation.html#2576

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago #14489 by phucmu
Replied by phucmu on topic ARCHIVING FILES
Dears,
We have run Achiving for STMT.ENTRY with tables
AC.STMT.HANDOFF
ACCT.STMT.PRINT
ACCT.STMT2.PRINT
STMT.ENTRY
STMT.PRINTED
STMT2.PRINTED
RE.CONSOL.STMT.ENT.KEY

We run Achiving by used ARC.GENERIC.REQUEST. Service done with no error, but no records in $ARC tables and no record delete form live file.
What's wrong in this case?

Thanks & Regards,

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
11 years 11 months ago #14491 by jpb
Replied by jpb on topic ARCHIVING FILES
What have you set up in F.ARCHIVE - STATEMENT?
Do you use ARC.STATEMENT ?
Have you checked the COMOs and F.ARCHIVE for any messages (also 'positve') ?
Do you have records in F.ARC.STATEMENT.PROCESSED ?

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago #14497 by phucmu
Replied by phucmu on topic ARCHIVING FILES
--> Yes, I have setup in F.ARCHIVE and used routine ARC.STATEMENT.
ARCHIVE.ID......... STATEMENT
PURGE.DATE.........
RETENTION.PERIOD... 01Y
ARCHIVE.DATA....... Y
.ARC.PATHNAME......
CHECK.NO.OF.RECS... 100
ROUTINE............ ARC.STATEMENT

STOP.REQUESTED..... NO
RECS.DELETED....... 0 !****no record delete, no record move to $ARC ???****

RECS.PROCESSED..... 329888 !***number records processed***

I list F.ARC.STATEMENT.PROCESSED --> 6 records listed

Thanks,

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
11 years 11 months ago #14500 by jpb
Replied by jpb on topic ARCHIVING FILES
We developed our own arc-service as we needed selection for e.g. only NOSTRO accounts so I'm not total aware of the ARC.STATEMENT logic.

What I miss is the .ARC.PATHNAME as I think to remember that the default might not work correctly (files created in ./0 directory ?) [but that shouldn't stop the archiving itself]

329888 records doesn't look much data, do you have entries older than 1 year ?
Do you use STMT.ENTRY.DETAILS ? I think they must be archived before STATEMENT (NOT SURE ;-)
The following user(s) said Thank You: phucmu

Please Log in or Create an account to join the conversation.

More
11 years 11 months ago - 11 years 11 months ago #14503 by phucmu
Replied by phucmu on topic ARCHIVING FILES
We'd found root cause.
Due to we used 2 APP, but routine ARC.STATEMENT diffirence version in 2 app so that it's not work well. Now update same new version in 2 App, it's working fine.

Many Thanks,
Last edit: 11 years 11 months ago by phucmu.

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago #14519 by phucmu
Replied by phucmu on topic ARCHIVING FILES
Hi
Now, we run archive via ARC.GENERIC.REQUEST and start TSM in phantom mode. How to know archiving in table name? Because of archive setup for 2->4 table and service ARC.GENERIC only show number of record processing, not show routine processing for what table?

Thanks,

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
11 years 10 months ago #14521 by jpb
Replied by jpb on topic ARCHIVING FILES
There are two files that should be updated during archiving

ARC.RECORDS.SEL
ARC.RECORDS.SELECT

When the process is finished F.ARCHIVE should show details as well.

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago #14527 by phucmu
Replied by phucmu on topic ARCHIVING FILES
Hi jpb,
Two file ARC.RECORDS.SEL, ARC.RECORDS.SELECT will show number record select to archive process, not show table's processing. How to know name table which archive service processing?

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
11 years 10 months ago #14528 by jpb
Replied by jpb on topic ARCHIVING FILES
From CONTROL.LIST display in COMO ?
The following user(s) said Thank You: phucmu

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago - 11 years 10 months ago #14534 by phucmu
Replied by phucmu on topic ARCHIVING FILES
Hi,
I list Job.list only have ids will process and COMO show ARC.GENERIC processing number record.
Now I count record on table $ARC to know table processing. You've another way?

Thanks
Last edit: 11 years 10 months ago by phucmu.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
11 years 10 months ago #14541 by jpb
Replied by jpb on topic ARCHIVING FILES

We developed our own arc-service as we needed ...


That's why I don't need another way, can show in COMO whatever we want.

Please Log in or Create an account to join the conversation.

More
7 years 10 months ago #21324 by stahir65
Replied by stahir65 on topic ARCHIVING FILES
Dear Team
I have the same issue to archive STMT.ENTRY and setup
ARCHIVE I STATEMENT
TS, I CON/ARC.STATEMENT
ARC.GENERIC.REQUEST I SYSTEM
BATCH S CON/ARC.STATEMENT
when verify the ARC.GENERIC.REQUEST V SYSTEM and start the service TS, I CON/ARC.STATEMENT the records not archived in the ARC table- please guide

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds