Problem when performing online backup

[jose.arotinco]

Hi,

when I try to backup online database, I get the following message:

C:\IBM\OnDemand for Windows\bin>arsdb -z E:\BackupDB
Unable to backup database ARCHIVE.  err=-912
arsdb:  Unable to backup DB2 ARCHIVE database to E:\BackupDB. The return code is -912

anyone can help me on this error?

CMOD: 8.5
DB2: 9.7
Windows 2008

thank you very much

[Justin Derrick]

Sounds like your database is still very busy at the time you're backing up.  Stopping user access and loading is recommended.

Here's the documentation for an SQLCODE -912:

The maximum number of lock requests has been reached for the database.
Explanation:

The maximum number of locks for the database was reached because insufficient memory was allocated to the lock list.

The statement cannot be processed.
User response:

The application should submit a COMMIT or ROLLBACK statement before submitting other SQL statements. Consider increasing the database configuration parameter ( locklist) to allow more lock list space.