BRADSJ
1st April 2009, 18:10
I am trying to run "Purge Audit Files" - ttaad4161m000 using "Commit Time" so that i can add into a job eventually.
However when i run it i get the message "No data in selection", even though there are audit files stored on the server that are older than the date i specify.
Also when i run "Check Audit Files Integrity" - ttaad4460m000 the "Info Header" does not match the "Sequence Header".
See example below..
Table : tdsst000 Company : 150 Host : localhost
Sequence Integrity
000 Error
Info Header Sequence Header
Sequence 000 000
Creat Date 03-02-2003 04-07-0095
Term Date 03-08-0113 15-10-0226
Creat Time 09:35:18 09:35:18
Term Time 09:35:18 09:35:18
Status 018 002
Transaction 000000552 000000552
Do you know how i can resolve this problem to re-allign the Info Header with the Sequence Header so that i can delete audit files by "Commit Time" NOT sequence Number?
Kind Regards,
John
However when i run it i get the message "No data in selection", even though there are audit files stored on the server that are older than the date i specify.
Also when i run "Check Audit Files Integrity" - ttaad4460m000 the "Info Header" does not match the "Sequence Header".
See example below..
Table : tdsst000 Company : 150 Host : localhost
Sequence Integrity
000 Error
Info Header Sequence Header
Sequence 000 000
Creat Date 03-02-2003 04-07-0095
Term Date 03-08-0113 15-10-0226
Creat Time 09:35:18 09:35:18
Term Time 09:35:18 09:35:18
Status 018 002
Transaction 000000552 000000552
Do you know how i can resolve this problem to re-allign the Info Header with the Sequence Header so that i can delete audit files by "Commit Time" NOT sequence Number?
Kind Regards,
John