DB2 backup query

[Former Member]

In DBACOCKPIT, the database backup section is empty although a DB online backup has run last night. Till yesterday, it was visible. When I check from DB2 Level using db2 LIST HISTORY BACKUP SINCE 20111117 FOR XXX, it returns no matching entries. However surprisingly, when I issue db2 get snapshot for db on XXX, it does state that there was a backup run on 17th with the exact same timestamp as the SAP background job time stamp. The backup runs as Backup ground job with an OS command db2 backup database DB online to tape via netbackup utilities. I am wondering what could be the problem here. Another point to note here is this applies only to the database backup, there is no problem with the log file backup as I can see them via DB12. May be database and log file backup write to different DB tables.

db2diag.log shows backup run as per schedule.

Parameters num_db_backups is set to 12,rec_his_retentn is 60 and auto_del_rec_obj is not set

Any thoughts how could the db backup history could have been wiped out. Are there any other command utilities that can delete the history interactively and if so how can I trace it back to it.

One final thing, we have run the online backup without including logs. Do you think this could have any impact at all.

Regards

Kal

[Former Member]

Hello,

>> One final thing, we have run the online backup without including logs. Do you think this could have any impact at all.

This doesn't impact.

Did this problem (backup history wiped out) happen just once or does it happen everyday ?

Any parameter in netbackup utility to check and confirm ? Not sure , I never worked on netbackup.

Thanks