unable to connect to db after re-directed restore

[former_member618864]

Hi,

Recently we performed re-directed restore and roll-forward  from PRD to DEV System. I able to connect to database successfully with db2<sid>, no issues.

When i able to connect with connect user "sapsid" and "sidadm (devadm)". it is throwing exception message

db2dev 5> db2 connect to dev user sapdev using XXXXXXX

SQL0104N  An unexpected token "qe1" was found following "DB".  Expected tokens

may include:  "USER".  SQLSTATE=42601

db2dev 6> db2 connect to dev user devadm using XXXXX

SQL30082N  Security processing failed with reason "15" ("PROCESSING FAILURE").

SQLSTATE=08001

I have already gone through couple of  links... none of them worked from me. I have updated sidadm & sapsid  passwords with dscdb6up... But, still iam having the same issue..

You're help is highly appreciated..

Thanks

Regards,

sai

[Frank-Martin]

Hi,

since the errors originate for DB2 CLP the problem can not be related to dscdb6up.

Try to OS logon to the DB server with the given user/password. If this works, try to update your database instance as root using "<instdir>/instance/db2iupdt db2sid" to make sure that the SUID bits of your instance executables are set correctly.

The SQL0104N error looks very strange. Maybe an instance update can repair this too.

Regards

                 Frank

[Former Member]

Hi Sai,

can you check if the encryption is the problem ? see

https://css.wdf.sap.corp/sap/support/notes/767448

Regards,
Javier

[former_member188883]

Hi Raj,

Please check whether DB has roll forward pending

db2 rollforward db <DBNAME> query status

Regards,

Deepak Kori