ARCHIVING FILES
- emehaj
- Topic Author
- Visitor
-
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
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
- Posts: 2859
- Thank you received: 650
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.
- phucmu
- Offline
- Junior Member
-
- Posts: 24
- Thank you received: 1
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
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
- Posts: 2859
- Thank you received: 650
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.
- phucmu
- Offline
- Junior Member
-
- Posts: 24
- Thank you received: 1
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
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
- Posts: 2859
- Thank you received: 650
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 ;-)
Please Log in or Create an account to join the conversation.
- phucmu
- Offline
- Junior Member
-
- Posts: 24
- Thank you received: 1
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,
Please Log in or Create an account to join the conversation.
- phucmu
- Offline
- Junior Member
-
- Posts: 24
- Thank you received: 1
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
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
- Posts: 2859
- Thank you received: 650
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.
- phucmu
- Offline
- Junior Member
-
- Posts: 24
- Thank you received: 1
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
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
- Posts: 2859
- Thank you received: 650
Please Log in or Create an account to join the conversation.
- phucmu
- Offline
- Junior Member
-
- Posts: 24
- Thank you received: 1
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
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
- Posts: 2859
- Thank you received: 650
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.
- stahir65
- Offline
- New Member
-
- Posts: 14
- Thank you received: 0
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.