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: 74

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

Announced today -- Innovations in IBM Db2 AI for z/OS! Learn More!

Posted by Surekha Parekh on February 12, 2019 at 13:30 0 Comments

As the market manager of IBM Db2 for z/OS, I am really excited to share with you all some great news.…

Continue

Videos

  • Add Videos
  • View All

DB2 for z/OS APARS

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service