could not start DB2 database

[former_member206167]

Hi dear SAP Gurus,

    I cannot start my DB2 database after installing a Java stack:

db2start

08/22/2012 14:32:10     0   0   SQL1026N  The database manager is already active.

SQL1026N  The database manager is already active.

db2 activate database PJ2

SQL1092N  "" does not have the authority to perform the requested command or

operation.

OS: AIX 6.1 DB2 9.7 FP5

I can backed up database successfully but I can't activate it

R3trans -x shows this error:

4 ETW000  [     dev trc,00000]  *** ERROR in DbSlConnectDB6[dbsldb6.c, 1294] CON

= 0 (BEGIN)           29583  0.296671

4 ETW000  [     dev trc,00000]  &+     DbSlConnectDB6: unable to open file: '/us

r/sap/PJ2/SYS/global/dscdb6.conf'

In fact, file  /usr/sap/PJ2/SYS/global/dscdb6.conf does not exist

thanks for your kind help

[Former Member · Accepted solution]

Hi Jose

Looks like you do not have the authorizations to start the database.

Please make sure you are logged in as <sid>adm or db2<sid> before starting the db.

"does not have the authority to perform the requested command or

operation."

you can generate dscdb6.conf by following this sap note.

Note 1532727 - DB6: dscdb6up generates incorrect sidadm password

you need to have your <sid>adm and sap connect user password.

If you run into any issues let me know.

Regards

Amit Padmawar

Regards

Amit Padmawar

[former_member206167 · Accepted solution]

Dear Amit,

Thanks for takin your time to response, I executed command

dscdb6up -create as per Note 1532727

dscdb6up -create
Enter new password for connect_user:

Confirm password for connect_user:

Enter new password for sidadm_user:

Confirm password for sidadm_user:

failed to set ownership on password file directory '/usr/sap/PJ2/SYS/global'
  chown <sid>adm:sapsys /usr/sap/PJ2/SYS/global
failed to set ownership on password file '/usr/sap/PJ2/SYS/global/dscdb6.conf'
  chown <sid>adm:sapsys /usr/sap/PJ2/SYS/global/dscdb6.conf
password file '/usr/sap/PJ2/SYS/global/dscdb6.conf' successfully written

SERVSAPDEVBI:db2pj2 4> cat /usr/sap/PJ2/SYS/global/dscdb6.conf

pj2adm 179 169  65 155  25 129 220  82 119  78  47 218   3  99 193 135  1

sappj2db 124  86 193 193  25 129 220  82 119 208 208 219 182  99 193 135  2

timestamp 201208221658

SERVSAPDEVBI:db2pj2 3> db2 activate database PJ2
SQL1092N  "" does not have the authority to perform the requested command or
operation.

thanks in advance

[Former Member · Accepted solution]

Hi Jose

Now you have dscdb6.conf created at the right location.

As i have recommended before please make sure  pj2adm and db2pj2 have correct authorizations on the unix level . This is what is preventing you from starting the database.

Please go through this table and make sure that users have right access.

Regards

Amit Padmawar

[Former Member · Accepted solution]

Above table is for NW 7.3 java systems. What is the version of your NW system ?

Regards

Amit

[Former Member · Accepted solution]

Please check this sap note i think it might be helpful in your case.

Note 819876 - DB6: Additional info about upgrade (based) on SAP NW AS 7.0

check the section d021078

Also check this thread

http://scn.sap.com/thread/1878835

Regards

Amit Padmawar

[former_member189725 · Accepted solution]

You login as user pj2adm .

Set the environment dbs_db6_schema to pj2adm .

Then run dscdb6up -create <password_of_sappj2> <password_of_pj2admadm>

Then run R3trans -d.

Then check the dscdb6.conf' file which should have users pj2adm and sappj2 (not sappj2db)

Regards

Ratnajit

[former_member206167 · Accepted solution]

Thanks for all your responses, I finally solved my problem using

note 997635

SERVSAPDEVBI:db2pj2 5> su

root's Password:

# mv /usr/sap/PJ2/SYS/global/dscdb6.conf

/usr/sap/PJ2/SYS/global/dscdb6.conf.viejo

# dscdb6up -create

Enter new password for connect_user:

Confirm password for connect_user:

Enter new password for sidadm_user:

Confirm password for sidadm_user:

password file '/usr/sap/PJ2/SYS/global/dscdb6.conf' successfully written

    And finally, SAP instance is running