Unsolved

This post is more than 5 years old

2 Intern

 • 

161 Posts

2985

January 27th, 2015 05:00

DB2 transaction log backup

Hi folks,

a while ago I started a discussion about DB2 transaction log backup with NMDA, here: DB2 transaction log backup with NMDA. I didn't get much response, so I'm gonna ask again.

I have a DB2 instance with multiple databases. Online backup of all instances runs fine. But I wanna backup the transaction logs every few hours and delete them afterwards. The NMDA documentation offers 1 1/2 pages about this (p.116-117).

If I configure the backup like described, I get multiple messages that parameters are not set in the NMDA config file. I insert them one after one and in the end it won't run either:

64673:nsrdasv: Unable to backup database due to backup request failure, SQLCODE : -1035, SQL1035N  The operation failed because the specified database cannot be

connected to in the mode requested.

Which is just some random message because online backup runs fine.

I'm asking myself: Is it possible to backup up just the transaction logs with NMDA and delete them afterwards (like RMAN and oracle does it for years)?

Cheers

Jan

No Responses!

0 events found

No Events found!

Top