Sql1092n & DB21009E error after upgrading the db2 database from 9.1 to 9.7 ?

[Former Member]

I had upgraded DB2 database from version 9.1 FP12 to 9.7 FP4. After the upgrading the users <db2dbsid> & <sidadm>  are unable to start db2 database from db2 command prompt. They are not having authorization to execute db2start and db2stop commands.

[former_member182967 · Accepted solution]

Hello Rupesh,

Just try the following methods:

M1. Launch the "Command Window - Administrator" shortcut and re-run the command.

M2. Disable UAC ( User Account Control) and retry.

M3. Click on Start and type db2cmd in search bar And now press crtl+Shift+Enter

Regards,

Ning Tong

[Former Member]

Hi Rupesh,

Try connecting to your db with that command ane be sure if your credentials correct:

db2 connect to SID user db2SID

Enter current password for db2sid:

As Hugo said, "R3trans -d" with sidadm also gives more information.

Also try giving needed rights:

db2 grant dbadm on database to user sidadm

db2 grant secadm on database to user db2sid

db2 grant dbadm on database to user db2sid

db2 grant secadm on database to user sidadm

db2 grant dbadm on database to user sidadm

I hope it works.

Regards,

Serhat

[Former Member]

Hi,

Thanks for you help.

I have tried all the steps but still facing the same error.

Regards

Roopesh Kumar

[Frank-Martin]

Start db2cmd as Administrator. On Windows db2cmd Window that is not run as Administrator is unusable.

Regards

               Frank

[hugo_amo]

Hi Rupesh,

I would suggest to run r3trans -d and check the trans.log generated, or check the db2diag.log entries at the time of the error attached. You will be able to see more information on why it is failing. Sometimes it is a bad combination of user name and password.

Regards,

Hugo