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

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

IDUG Db2 Tech Conference coming to San Paulo, Brazil and Mexico City! Register Now

Started by Surekha Parekh in What's hot ? on Thursday. 0 Replies

For the first time IDUG is hosting two events in Latin America. These seminars will bring together Db2 professionals from around the world for expert-led technical sessions and networking opportunities. This is your chance to connect! …Continue

Tags: Education

MSSQL linked server attaching to DB2 LUW

Started by Mike Jett in Application Development and DB2 on Thursday. 0 Replies

I am trying to create a linked server from MSSQL 2014  to DB2 11.1  I am able to create one linked server and get it to work with one DB.  I have not been able to figure out how to add additional catalogs(DB's).  Is it possible to use just one…Continue

Tags: server, linked

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service