db2 connect failed

[former_member547765]

Hi,

after restore the online database completed I cannot connect to database using "db2 connect to SID"

SQL1117N A connection to or activation of database "SID" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019

I have restore the log with log target "/db2/ABC/logs"

rollforward complete didn't work

here is my rollforward status

please help so i can connect to database

Regards

[hans-juergen_zeltwanger · Accepted solution]

Hello Irfan:

two possible reasons come to my mind:

(1)

Did you perform any ROLLFORWARD DATABSE activity post the restore of the online backup?
If yes, to which point in time? The point in time has to be at least the end-of-backup timestamp.

If you just want to restore the online backup as-is, you also can as well use use the "TO END OF BACKUP" option of the ROLLFORWARD

(2)
Required log files are missing, so double check whether the log file(s) mentioned in the QUERY STATUS output are really available and and are accessible.
The log files should be available in the location defined by the OVERFLOWLOGPATH database configuration parameter. Alternatively, use the "OVERFLOW LOG PATH" option of the ROLLFORWARD command to point to the location of the log files.

- Hans-Juergen

[former_member547765 · Accepted solution]

Hi hans-juergen.zeltwanger

Thanks for your help.

I can connect to my database now, but when running "select * from sapsid.nast" show error SQL0551N user does not have the required authorization or privilege to perform operation "SELECT" on object ......

how to grant the user for select operation?

Thanks