Skip to Content
avatar image
Former Member

unable to connect to db after re-directed restore

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 05, 2015 at 11:35 AM

    Hi Raj,

    Please check whether DB has roll forward pending

    db2 rollforward db <DBNAME> query status

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2015 at 11:40 AM

    Hi Sai,

    can you check if the encryption is the problem ? see

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

    Regards,
    Javier

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 09:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded