cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 Restore

Former Member
0 Kudos

Hi,

I am trying to restore the DB2 database from backup of the same server. I have run the command "db2 restore database from /backup taken at 20150824183623 on '/db2/ED1/sapdat1',  '/db2/ED1/sapdata2', '/db2/ED1/sapdata3', '/db2/ED1/sapdata4' with 32 buffers buffer 16384 parallelism 32"

After the restore is complete, I have rollforwarded using the command "db2 rollforward database ED1 to end of logs and complete". After this in the command "db2 rollforward database ED1 query status" I am getting the status not pending.

Can anyone please suggest how to bring the database in running state after this ?

Regards

Ivan

Accepted Solutions (0)

Answers (3)

Answers (3)

kaus19d
Active Contributor
0 Kudos

in case you are not logged in as DB2SID, you can from CLP give the command to login as "connect to SID user <DB2SID> using <password of DB2SID>.

former_member182505
Contributor
0 Kudos

Hi Ivan

You have done it, just connect you database as suggested by Manu

Thanks

Sadiq

manumohandas82
Active Contributor
0 Kudos

db2 connect to ED1