I have a DB2 9.7 database stuck in a backup pending state and cannot seem to clear the issue

the error is:

SQL1116N

connection or activation of database <db> cannot be made because of BACKUP PENDING SQLSTATE=57019

the specified database requires a backup to be taken to provide a starting point for roll-forward recovery.

i have tried the GUI and the command line to no avail, the GUI returns the above error and the command line will not allow connection to run the backup

please help

Views: 23

Reply to This

Replies to This Discussion

ah sorted it i was putting the user and password in the wrong place in the db2 command

RSS

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

Posted by Paul McWilliams on September 21, 2018 at 17:26 0 Comments

 



For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out…

Continue

Videos

  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service