Unable to start db2

[Former Member]

Hi,

When I'm starting sap using startsap:

Checking db6 db Database

Database is not available via R3trans

Running /usr/sap/MSL/SYS/exe/run/startdb

SQL1042C An unexpected system error occurred. SQLSTATE=58004

Activate database failed

R3trans connect failed

DB startup failed

Output of 'db2 list db directory':

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = MSL

Database name = MSL

Local database directory = /db2/MSL

Database release level = b.00

Comment = SAP database MSL

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

O/P of db2stop

10/07/2011 14:28:06 0 0 SQL1032N No start database manager command was issued.

SQL1032N No start database manager command was issued. SQLSTATE=57019

O/P of db2start

10/07/2011 14:29:14 0 0 SQL1042C An unexpected system error occurred.

SQL1032N No start database manager command was issued. SQLSTATE=57019

startdb.log:

Fri Oct 7 14:22:03 IST 2011

LOGFILE FOR STARTING DB6 (DB2 UDB)

Fri Oct 7 14:22:03 IST 2011

checking required environment variables

DB2INSTANCE is >db2msl<

INSTHOME is >/db2/db2msl<

DB2DBDFT is >MSL<

Fri Oct 7 14:22:03 IST 2011

starting database manager

SQL1042C An unexpected system error occurred. SQLSTATE=58004

Database Manager started

SQL1032N No start database manager command was issued. SQLSTATE=57019

Activate database failed

Fri Oct 7 14:22:04 IST 2011

R3trans connect to the database

R3trans check finished with return code: 12

R3trans connect failed

Notify your SAP/database administrator

Fri Oct 7 14:22:04 IST 2011

/usr/sap/MSL/SYS/exe/run/startdb: Terminating with error code 2

Logfile db2diag.log

2011-10-07-18.36.18.878126+330 I12101983E369 LEVEL: Error

PID : 13754 TID : 47753900820688

FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:30

MESSAGE : ECF=0x90000520 Failed to obtain the install path

CALLED : DB2 Common, Fault Monitor Facility, fmGetInstPath

RETCODE : ECF=0x90000521 No proper access permisions to the install path

2011-10-07-18.36.28.940338+330 I12102353E288 LEVEL: Error

PID : 13760 TID : 47512339155152

FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:60

MESSAGE : ECF=0x90000521 No proper access permisions to the install path

DATA #1 : String, 0 bytes

2011-10-07-18.36.28.940426+330 I12102642E369 LEVEL: Error

PID : 13760 TID : 47512339155152

FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:30

MESSAGE : ECF=0x90000520 Failed to obtain the install path

CALLED : DB2 Common, Fault Monitor Facility, fmGetInstPath

RETCODE : ECF=0x90000521 No proper access permisions to the install path

2011-10-07-18.36.39.006669+330 I12103012E288 LEVEL: Error

PID : 13766 TID : 46941183113424

FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:60

MESSAGE : ECF=0x90000521 No proper access permisions to the install path

DATA #1 : String, 0 bytes

2011-10-07-18.36.39.006788+330 I12103301E369 LEVEL: Error

PID : 13766 TID : 46941183113424

FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:30

MESSAGE : ECF=0x90000520 Failed to obtain the install path

CALLED : DB2 Common, Fault Monitor Facility, fmGetInstPath

RETCODE : ECF=0x90000521 No proper access permisions to the install path

2011-10-07-18.36.49.075016+330 I12103671E288 LEVEL: Error

PID : 13772 TID : 47524013938896

FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:60

MESSAGE : ECF=0x90000521 No proper access permisions to the install path

DATA #1 : String, 0 bytes

2011-10-07-18.36.49.075157+330 I12103960E369 LEVEL: Error

PID : 13772 TID : 47524013938896

FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:30

MESSAGE : ECF=0x90000520 Failed to obtain the install path

CALLED : DB2 Common, Fault Monitor Facility, fmGetInstPath

RETCODE : ECF=0x90000521 No proper access permisions to the install path

2011-10-07-18.36.59.138472+330 I12104330E288 LEVEL: Error

PID : 13778 TID : 46938405894352

FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:60

MESSAGE : ECF=0x90000521 No proper access permisions to the install path

DATA #1 : String, 0 bytes

2011-10-07-18.36.59.138559+330 I12104619E369 LEVEL: Error

PID : 13778 TID : 46938405894352

FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:30

MESSAGE : ECF=0x90000520 Failed to obtain the install path

CALLED : DB2 Common, Fault Monitor Facility, fmGetInstPath

RETCODE : ECF=0x90000521 No proper access permisions to the install path

2011-10-07-18.37.09.210719+330 I12104989E288 LEVEL: Error

PID : 13866 TID : 47139096107216

FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:60

MESSAGE : ECF=0x90000521 No proper access permisions to the install path

DATA #1 : String, 0 bytes

2011-10-07-18.37.09.210843+330 I12105278E369 LEVEL: Error

PID : 13866 TID : 47139096107216

FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:30

MESSAGE : ECF=0x90000520 Failed to obtain the install path

CALLED : DB2 Common, Fault Monitor Facility, fmGetInstPath

RETCODE : ECF=0x90000521 No proper access permisions to the install path

Please help me

Thanks in advance

Uday

[Former Member]

I will just copy/paste my post -

I was going through another similar problem thread, some of the suggestions were -

Check the permissions of /var/db2/global.reg file. Also, you can try command 'db2iupdt instance_name to update the permission problems. Command should be executed by root user. db2iupdt program should exist in DB2DIR.

Also, what's the DB2 version and fixpack level ?

Thanks

[former_member182505]

hi

check the inside permission of sqllib Dir

thanks

sadiq