Data Backup and Recovery

Problem with deleting archive log files

ANDREAS_JANKOWIAK
5,025 Views

Dear Community,

 

I have a problem with our snapcreator ver 3.5 implementatation.

We take snapshots for some db2 (SAP) databases serially, so we have db2 plugin configurations which quiesces the dbs, after that we take a snapshot of the relevant volumes and unquiesece the dbs. After the unquiesce we run:

 

POST_APP_UNQUIESCE_CMD01=snapcreator.exe -profile Q-Landscape -config <SID1> -action arch

POST_APP_UNQUIESCE_CMD02=snapcreator.exe -profile Q-Landscape -config <SID2> -action arch

POST_APP_UNQUIESCE_CMD03=snapcreator.exe -profile Q-Landscape -config <SID3> -action arch

POST_APP_UNQUIESCE_CMD04=snapcreator.exe -profile Q-Landscape -config <SID4> -action arch

   

for each db in the main configuration.

The db specific configuration looks like this:

 

ARCHIVE_LOG_ENABLE=Y

ARCHIVE_LOG_RETENTION=9

ARCHIVE_LOG_DIR=/db2/<SID>/archdir/db2<sid>/<SID>/NODE0000/

ARCHIVE_LOG_EXT=LOG

ARCHIVE_LOG_RECURSIVE_SEARCH=Y

Sometimes the automatic erease of archive logs is working but often we get the following error, ie:

[Sun Sep 23 23:00:26 2012] ERROR: Could not delete Archive Log .../NODE0000/C0000008/S0000003.LOG: Inappropriate ioctl for device

[Sun Sep 23 23:00:26 2012] ERROR: [scf-00112] Archive Log Deletion failed, Exiting!

[Sun Sep 23 23:00:26 2012] DEBUG: Exiting with error code - 1

Sometimes the log file creation data is very strangly recongnized:

INFO: Performing recursive search on dir ...NODE0000

DEBUG: Found following Archive Log ...NODE0000/C0000008/S0000000.LOG, was created on Jan 01 1970 01:00:00

DEBUG: Found following Archive Log ...NODE0000/C0000008/S0000001.LOG, was created on Jan 01 1970 01:00:00

DEBUG: Found following Archive Log ....NODE0000/C0000008/S0000002.LOG, was created on Jan 01 1970 01:00:00

DEBUG: Found following Archive Log ..../NODE0000/C0000008/S0000004.LOG, was created on Sep 14 2012 00:04:02

DEBUG: Found following Archive Log ...PHA/NODE0000/C0000008/S0000005.LOG, was created on Sep 14 2012 00:05:14

For some files the deletion is working

[Sun Sep 23 23:00:25 2012] INFO: Archive Log ....NODE0000/C0000008/S0000111.LOG is not older than 9 days, Skipping!

[Sun Sep 23 23:00:25 2012] INFO: Archive Log ...NODE0000/C0000008/S0000110.LOG is not older than 9 days, Skipping!

[Sun Sep 23 23:00:25 2012] INFO: Archive Log .....NODE0000/C0000008/S0000011.LOG is older than 9 days, Deleting!

[Sun Sep 23 23:00:25 2012]  INFO: Archive Log ....NODE0000/C0000008/S0000011.LOG has been successfully deleted

    

After restarting the snapcreator agent it works again! But after 1 or 2 days the next error occurs.

Does anyone has the same problem?

Thanks a lot for your help.

 

Best Regards,

Andreas

10 REPLIES 10
Public