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

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.

Forum

Register Now IBM Data Tech Summit virtual event October 6th!

Started by Surekha in What's hot ? Sep 24. 0 Replies

Data Tech Summit Virtual Event - The Latest News on Enterprise Data & AIDate:  Tuesday, October 06, 2020Time: 11:00 AM Eastern Daylight TimeRegister NowBusiness cycles are…Continue

Introducing IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code

Started by Calene Janacek in Application Development and DB2 Jul 30. 0 Replies

We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the…Continue

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service