NetWorker Module for Databases and Applications: Unable to modify DB2 client from wizard on NMC
Summary: When modifying a DB2 client from the NetWorker Management Console (NMC), the connection fails because the database is in a backup pending state (SQLSTATE=57019).
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
NetWorker Module for Databases and Applications (NMDA) DB2 unable to modify DB2 client wizard on NetWorker Management Console (NMC).
The error that is displayed is:
The error that is displayed is:
Db2 returned the following error message
unable to connect to sample database due to sql connection failure SQLERROR:-1
SQL1116N: a connection to or activation of database "sample" failed because the database is in backup pending state SQLSTATE=57019 DB2 transaction logging was changed from circular to Archive logging.Cause
When logging mode is changed from Circular to Archive, the backup pending value is changes to 'YES'.
When database state is in backup pending, the database objects cannot be accessed.
To query, run command: db2 get db cfg for sample | grep backup pending
It returns value as backup pending = YES.
When database state is in backup pending, the database objects cannot be accessed.
To query, run command: db2 get db cfg for sample | grep backup pending
It returns value as backup pending = YES.
Resolution
An offline backup must be performed to turn off the backup pending state.
Perform either client-side NMDA manual DB2 backup, for example:
Or follow the steps that are outlined in the below IBM article to perform an offline native backup.
https://www.ibm.com/docs/en/license-metric-tool?topic=database-backing-up-db2
After the backup completes successfully, the backup pending value changes to 'NO' and the client can be modified from the NMC.
Perform either client-side NMDA manual DB2 backup, for example:
db2 backup db <db name> load /usr/lib/libnsrdb2.so options @/<path/to/db_backup.cfg> without prompting
Or follow the steps that are outlined in the below IBM article to perform an offline native backup.
https://www.ibm.com/docs/en/license-metric-tool?topic=database-backing-up-db2
After the backup completes successfully, the backup pending value changes to 'NO' and the client can be modified from the NMC.
Article Properties
Article Number: 000191366
Article Type: Solution
Last Modified: 09 Mar 2022
Version: 1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.