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
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.