on 08-26-2015 1:37 PM
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
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>.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan
You have done it, just connect you database as suggested by Manu
Thanks
Sadiq
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
db2 connect to ED1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.