DB2 backups and archive logs...

[Stephan]

I am questioning myself on our DB2 backups. We are running TSM5.5 and DB2 8.1.

We are running full backups each week just fine. If i issue a q backup of my DB2 filespace, i can see my full each week. But should i see the archive logs as well? I have the LOGARCHMETH1 = TSM: DISK_DB2.

Also, should logs in the SLQLOGDIR be automatically deleted? Do i need to run a script to delete those logs? I am running a script to expire backups within TSM, but what about those logs in the directory??

Thanks.

 

[ChrisRees]

Stephan

You will not see the archive logs when you do a q backup, as the archive logs are stored as Archives in TSM.

You can run this SQL to see archives

select node_name,filespace_name,ll_name,archive_date from archives where node_name='$1' order by archive_date

You can save the above as a script and give it a nodename as $1.

I'm not sure about the best practice regarding housekeeping SQLOGDIR.

Cheers

 

[Stephan]

Thanks for the reply.

So, if i check using your query, i have only 2 logs for a specific Node that dates back to March!? So it worked, but now seems to have stopped? Are you running a v8 DB2 that you could post your db config and your options file?

Thanks.

Stephan

 

[rore]

Stephan From you DB2 server with your DB2 user run:
db2adutl query

It will report all your full backups and archive logs.

Rudy