How can I save the error message after modifying the backup parameters of the DB2 database?

This article mainly describes the DB2 database backup parameters and the error description after modification. If you are curious about the DB2 database backup parameters and report errors after modification, the following articles will unveil its secrets. The following is a detailed description of the article. I hope you can learn from it.

Today, I tried to modify a backup parameter LOGARCHMETH1 of DB2 and changed it to USEREXIT.

After the change, log out and the database will not be connected. Restart the database and report the following error:

 
 

  
  
D:\Documents and Settings\Administrator>db2 connect to sample 
 
 

SQL1116N cannot connect to or activate the Database "SAMPLE" because of backup pending ".

 
 

  
  
SQLSTATE=57019 
 
 

After checking some information, I know that I want to make a backup immediately:

 
 

  
  
D:\Documents and Settings\Administrator>db2 backup db sample 
 
 

The backup is successful. The time stamp of this backup image is: 20080604112950

Test again and solve the problem:

 
 

  
  
D:\Documents and Settings\Administrator>db2 connect to sample 
 
 

Database connection information

Database Server = DB2/NT 9.5.0

SQL authorization id = ADMINIST...

Local Database alias = SAMPLE

The above content is an introduction to the error message after modifying the backup parameters of the DB2 database. I hope you will find some gains.

The above content is the description of the error after the DB2 database backup parameters are modified. I hope it will help you in this regard.