Archive logfiles to Tape in DB13

[former_member222381]

Hi all,

Archive log files are taken backup to tape and deleted in Disk.

It is planed in DB13 and showing as success

It is getting success but the job log are looking different as below.

Job started

Step 001 started (program RSDBAJOB, variant &0000000006129, user ID BASIS)

ArchiveLog:Archive Logfiles to Tape

ArchiveLog:started by CL_DB6_JOB_TAPE_MANAGER        on server sapdev

ArchiveLog:Parameter TESTMODE has not been set

ArchiveLog:Parameter PARALLELISM has not been set

ArchiveLog:Parameter RUNTIME has not been set

ArchiveLog:Parameter PARTITION has not been set

ArchiveLog:Parameter DOUBLE STORE has not been set

ArchiveLog:Parameter FILE_PATH has been set to "\\.\tape0"

ArchiveLog:Parameter TAPE_NAME has not been set

ArchiveLog:Parameter Number of Log Files has not been set

ArchiveLog:Parameter BUFFER_SIZE has not been set

ArchiveLog:db2tapemgr database KD1 store on \\.\tape0 all logs force eject

ArchiveLog:DBT2065I  Using database partition "NODE0000".

ArchiveLog:DBT2071I  Using the automatic generated tape-label "KD120160130151846".

ArchiveLog:Scanning history.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0054074.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0054075.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0054076.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0054077.LOG" is not on disk.

.

.

.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0059420.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0059421.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0059422.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0059423.LOG" is not on disk.

ArchiveLog:DBT2015W  Log file "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0059424.LOG" is not on disk.

ArchiveLog:Rewinding tape.

ArchiveLog:Reading tape header.

ArchiveLog:Scanning history.

ArchiveLog:DBT2039I  Clearing location in history for log files currently on tape "KD120160130131549".

ArchiveLog:Rewinding tape.

ArchiveLog:Writing tape header.

ArchiveLog:Writing log file "NODE0000\C0000000\S0060158.LOG"to tape.

ArchiveLog:Updating history.

ArchiveLog:Deleting "F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0060158.LOG" log file from disk.

ArchiveLog:Storing history file on tape.

ArchiveLog:Ejecting tape.

ArchiveLog:Ejecting tape failed. Reason: "1: Incorrect function.

ArchiveLog:".

ArchiveLog:DBT2008N  db2tapemgr failed with errors.

ArchiveLog:finished

Job finished

In every job log it is showing the same unwanted scanning history as S0054074 is not on disk.

Can anyone clarify the doubt and how to avoid this log error.

[former_member384109 · Accepted solution]

Hi Rajkumar,

after taking the backup in tape. have deleted all archive log file form disk F: or what?tell me.ans is this PRD environment or what?

Regards,

Ankit Patel

[former_member222381 · Accepted solution]

No This is Development system.

In Every day job log it is showing as below lines as from S0054074 to S0059424.log is not on disk.

Actually this log files are deleted from the path before few months back.

My think is this lines starting from F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0054074.LOG" is not on disk.

should not come in every day the job log.

What should i need to do? Restart the SAP.?

[manish_singh13 · Accepted solution]

Hi Rajkumar,

Since those files were manually deleted, that's why you are getting warning in backup log files for those missing archive file.

This warning won't affect your system in any manner (until unless you are restoring your system from that time period of those archive log files).

If you still want to remove these warning messages then you can reset your archive backup log file and this warning will stop. But make sure to take backup of your backup log file before resetting it.

Thanks,

MPS

[former_member222381 · Accepted solution]

Thank You Manish,

How to reset our archive backup log.?

We didn't take any backup of that.

Can i delete the planned archive log backup jobs and reschedule to a different time.?

Restarted the SAP also.

[former_member222381 · Accepted solution]

cleaned all the scheduled job and planned for a different time.

It is getting success but it is showing the unwanted line in the job log as

F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0054074.LOG" is not on disk.

to

F:\db2\KD1\log_arch\DB2KD1\KD1\NODE0000\C0000000\S0059424.LOG" is not on disk.

after this lines writing log from disk to tape.

deleting log from disk

success.

Please help me as i need to make the above bold shaded lines to disappear in the job log.

For next three days m planning not to take archive log backup to tape.

[manish_singh13 · Accepted solution]

Hi Rajkumar,

Did you try renaming your archive log backup file? With next backup system will create new backup file and then these warnings messages won't be there from here onwards.

Thanks,

MPS

[former_member222381 · Accepted solution]

Renaming in the sense, I am planning the Archive logs backup to Tape as store as "All logs"

Tape label as no change empty box.

Device as "\\.\tape0"

Block size for Tape access empty box.

Double store as unchecked box

Overwrite Expired Tapes as checked box

Eject Tape at end of operation as unchecked box

I tried by give my own Tape label, but coming error as Tape label is not in alphanumeric.

But i given in correct format only.

[manish_singh13 · Accepted solution]

Hi Rajkumar,

It seems you are having issue while resetting backup log file so please perform easy steps as below:

Prune history and log files:

db2 prune history 20160101 and delete

You give above command if your warning log files (S0059424.LOG & S0054074.LOG) were created before 01 Jan, 2016.

IBM Knowledge Center

Thanks,

MPS

[former_member222381 · Accepted solution]

Hi Manish,

Thank you so much for your suggestion.

Mentioned db2 command works.

Executed prune history 20160101 and delete, and it was successful.

Immediately mounted a new tape and executed Archive log backup to tape immediately.

The above error as log "not on disk" disappeared.

Thank you.