sap startup failed

[Former Member]

Dear Guru's

When am tring to start sap the database is getting started but activate databse failed and R3trans failed as shown below

PLs give me the solution regading this it would be really helpful and thanks in advance db2 license and fixpack is apllied

Thanks in advance

Mohammed

Starting SAP-Collector Daemon

-

---

Start of saposcol failed

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

07/09/2010 11:31:16 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

Activate database failed

R3trans connect failed

DB startup failed

spmlbidq:biqadm 9> pwd

/home/biqadm

Trans.log

-

---

4 ETW000 [dev trc ,00000] (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000 47 0.035782

4 ETW000 [dev trc ,00000] (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000 47 0.035829

4 ETW000 [dev trc ,00000] (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000 47 0.035876

4 ETW000 [dev trc ,00000] (0.54) DB6: error handling in DBSL CLP (note 940260)

4 ETW000 46 0.035922

4 ETW000 [dev trc ,00000] (0.69) DB6: technical support of DB2 CLI driver (note 962892)

4 ETW000 57 0.035979

4 ETW000 [dev trc ,00000] (0.73) DB6: log table name on TRUNCATE failure (note 970743)

4 ETW000 47 0.036026

4 ETW000 [dev trc ,00000] (0.79) DB6: column type XML in index size calculation (note 982993)

4 ETW000 57 0.036083

4 ETW000 [dev trc ,00000] (0.82) DB6: CAST for SSTRING data types (note 989568)

4 ETW000 95 0.036178

4 ETW000 [dev trc ,00000] (0.86) DB6: long runtimes for R3szchk (note 1000847)

4 ETW000 46 0.036224

4 ETW000 [dev trc ,00000] (0.88) DB6: patch collection Dec 06 (note 1005574)

4 ETW000 46 0.036270

4 ETW000 [dev trc ,00000] (0.96) DB6: patch collection Jan 07 (note 1017852)

4 ETW000 46 0.036316

4 ETW000 [dev trc ,00000] (0.97) DB6: CLP commands with DB2 CLI Driver (note 1024102)

4 ETW000 46 0.036362

4 ETW000 [dev trc ,00000] (0.99) DB6: SUBSTITUTE VALUES with FAE statements (note 1028779)

4 ETW000 48 0.036410

4 ETW000 [dev trc ,00000] (0.107) DB6: patch collection Apr 07 (note 1047194)

4 ETW000 57 0.036467

4 ETW000 [dev trc ,00000] (0.110) DB6: SAP user names ending with non-ASCII char (note 1054555)

4 ETW000 47 0.036514

4 ETW000 [dev trc ,00000] (0.113) DB6: work process type in application snapshot (note 1059905)

4 ETW000 46 0.036560

4 ETW000 [dev trc ,00000] (0.114) DB6: connect using SAPDBHOST and DB2DB6_SVCENAME (note 1062049)

4 ETW000 47 0.036607

4 ETW000 [dev trc ,00000] (0.117) DB6: patch for execution of long DDL statements (note 1069658)

4 ETW000 47 0.036654

4 ETW000 [dev trc ,00000] (0.122) DB6: SNAPSHOT_TBS_CFG table function is deprecated (note 1077963)

4 ETW000 47 0.036701

4 ETW000 [dev trc ,00000] (0.123) DB6: CLP commands on Windows with V9.1 (note 1080149)

4 ETW000 58 0.036759

4 ETW000 [dev trc ,00000] (0.124) DB6: Set DB2CODEPAGE=819 for non-Unicode (note 1084400)

4 ETW000 46 0.036805

4 ETW000 [dev trc ,00000] (0.126) DB6: reuse optguidelines on FAE statements (note 1087375)

4 ETW000 47 0.036852

4 ETW000 [dev trc ,00000] (0.126) DB6: Enforce DB2CODEPAGE=819 for non-Unicode environments (note 1084400)

4 ETW000 47 0.036899

4 ETW000 [dev trc ,00000] (0.128) DB6: db6_free on invalid memory area (note 1092030)

4 ETW000 46 0.036945

4 ETW000 [dev trc ,00000] (0.133) DB6: statement cache enhancements (note 1101031)

4 ETW000 47 0.036992

4 ETW000 [dev trc ,00000] (0.136) DB6: change for enhancement pack installer (note 1111536)

4 ETW000 46 0.037038

4 ETW000 [dev trc ,00000] (0.138) DB6: improoved table size estimate for DB8 V8 (note 1119934)

4 ETW000 48 0.037086

4 ETW000 [dev trc ,00000] (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

4 ETW000 64 0.037150

4 ETW000 [dev trc ,00000] (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

4 ETW000 47 0.037197

4 ETW000 [dev trc ,00000] (0.148) DB6: allocate new CLI env handle if PID changes (note 1141570)

4 ETW000 47 0.037244

4 ETW000 [dev trc ,00000] (0.150) DB6: USE AND KEEP EXCLUSIVE LOCKS clause lost (note 1145580)

4 ETW000 47 0.037291

4 ETW000 [dev trc ,00000] (0.151) DB6: projection views on virtual tables (note 1146142)

4 ETW000 46 0.037337

4 ETW000 [dev trc ,00000] (0.152) Corrections of odbc-based dbsl (note 1135165)

4 ETW000 81 0.037418

4 ETW000 [dev trc ,00000] (0.156) "DB6: TRUNCATE on table with DELETE triggers" (note 1156597)

4 ETW000 57 0.037475

4 ETW000 [dev trc ,00000] (0.164) DB6: patch collection 06/08 (note 1172220)

4 ETW000 47 0.037522

4 ETW000 [dev trc ,00000] (0.167) DB2 - z/OS: performance improvement for long running LUWs (note 1179742)

4 ETW000 47 0.037569

4 ETW000 [dev trc ,00000] (0.171) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)

4 ETW000 47 0.037616

4 ETW000 [dev trc ,00000] Supported features: 29 0.037645

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 30 0.037675

4 ETW000 [dev trc ,00000] ..done 138 0.037813

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 30 0.037843

4 ETW000 [dev trc ,00000] Fri Jul 9 11:18:00 2010 5773521 5.811364

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1692] CON = 0 (BEGIN)

4 ETW000 68 5.811432

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004

4 ETW000 54 5.811486

4 ETW000 [dev trc ,00000] &+

4 ETW000 50 5.811536

4 ETW000 [dev trc ,00000] &+

4 ETW000 60 5.811596

4 ETW000 [dev trc ,00000] &+

4 ETW000 50 5.811646

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1692] (END) 31 5.811677

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'BIQ' as 'sapbiq' failed

4 ETW000 157 5.811834

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'BIQ'"

[sunny_pahuja2]

Please paste db2diag.log here.

Thanks

Sunny

[Former Member]

Dear Sunny,

Pls check the db2diaglog file

010-07-09-12.13.15.876133+330 E597933A1213 LEVEL: Event

PID : 8447 TID : 1 PROC : db2star2

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911

MESSAGE : ADM7513W Database manager has started.

START : DB2 DBM

DATA #1 : Build Level, 152 bytes

Instance "db2biq" uses "64" bits and DB2 code release "SQL09014"

with level identifier "01050107".

Informational tokens are "DB2 v9.1.0.4", "special_19276", "U811795_19276", Fix Pack "4".

DATA #2 : System Info, 104 bytes

System: HP-UX spmlbidq B.11.31 U ia64

CPU: total:2 online:2 Threading degree per core:1

Physical Memory(MB): total:16364 free:1175

Virtual Memory(MB): total:70380 free:55191

Swap Memory(MB): total:54016 free:54016

Kernel Params: msgMaxMessageSize:1048576 msgMsgMap:2048 msgMaxQueueIDs:256

msgNumberOfHeaders:2046 msgMaxQueueSize:1048576

msgMaxSegmentSize:248 shmMax:17179869184 shmMin:1 shmIDs:4096

shmSegments:300 semMap:522 semIDs:520 semNum:1024 semUndo:512

semNumPerID:2048 semOps:500 semUndoPerProcess:100

semUndoSize:824 semMaxVal:32767 semAdjustOnExit:16384

2010-07-09-12.18.40.095112+330 E599147A541 LEVEL: Warning (OS)

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80

MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

CALLED : OS, -, open

OSERR : EACCES (13) "Permission denied"

DATA #1 : File name, 38 bytes

/db2/BIQ/log_dir/NODE0000/S0000215.LOG

2010-07-09-12.18.40.102743+330 I599689A453 LEVEL: Error

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpgifl, probe:20

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource

"/db2/BIQ/log_dir/NODE0000/S0000215.LOG", operating system return

code was "".

2010-07-09-12.18.40.103478+330 I600143A327 LEVEL: Error

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpgCallGIFL, probe:2750

DATA #1 : <preformatted>

Error rc -2079391743 when initializing log file 215

2010-07-09-12.18.40.103648+330 I600471A419 LEVEL: Severe

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable, probe:9200

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2010-07-09-12.18.40.103739+330 I600891A411 LEVEL: Error

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInit, probe:430

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2010-07-09-12.18.40.103818+330 I601303A141 LEVEL: Error

PID:8891 TID:1 NODE:000 Title: SQLP_DBCB

Dump File:/db2/BIQ/db2dump/88911.000

2010-07-09-12.18.40.104518+330 I601445A298 LEVEL: Severe

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpgasn, probe:4000

MESSAGE : Logging can not continue due to an error.

2010-07-09-12.18.40.104862+330 I601744A491 LEVEL: Severe

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:9030

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2010-07-09-12.18.40.106642+330 I602236A491 LEVEL: Severe

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:3600

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2010-07-09-12.18.40.106821+330 I602728A419 LEVEL: Severe

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120

DATA #1 : Hexdump, 4 bytes

0x9FFFFFFFFFFECCD0 : 840F 0001 ....

2010-07-09-12.18.40.107008+330 I603148A418 LEVEL: Error

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120

DATA #2 : Hexdump, 4 bytes

0x9FFFFFFFFFFECCD0 : 840F 0001 ....

2010-07-09-12.18.40.121087+330 E603567A369 LEVEL: Severe

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10

MESSAGE : ADM7518C "BIQ " marked bad.

2010-07-09-12.18.40.631155+330 I603937A417 LEVEL: Severe

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10

MESSAGE : DIA0505I Execution of a component signal handling function has begun.

2010-07-09-12.18.40.631367+330 I604355A152 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** DRDA ASCB ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.631705+330 I604508A157 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** DRDA CMNMGR CB ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.631799+330 I604666A157 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** RECEIVE BUFFER ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.631936+330 I604824A155 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** SEND BUFFERS ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.632031+330 I604980A160 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** CONNECTION HANDLE ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.632148+330 I605141A158 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** DRDA ATTRIBUTES ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.632242+330 I605300A157 LEVEL: Severe

PID:8471 TID:1 NODE:000 Title: **** AS UCINTERFACE ****

Dump File:/db2/BIQ/db2dump/84711.000

2010-07-09-12.18.40.632358+330 I605458A430 LEVEL: Severe

PID : 8471 TID : 1 PROC : db2agent (BIQ) 0

INSTANCE: db2biq NODE : 000

APPHDL : 0-7 APPID: *LOCAL.db2biq.100709064834

AUTHID : DB2BIQ

FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20

MESSAGE : DIA0506I Execution of a component signal handling function is

complete.

[Frank-Martin]

2010-07-09-12.18.40.095112+330 E599147A541 LEVEL: Warning (OS)

PID : 8891 TID : 1 PROC : db2loggr (BIQ) 0

INSTANCE: db2biq NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80

MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

CALLED : OS, -, open

OSERR : EACCES (13) "Permission denied"

DATA #1 : File name, 38 bytes

/db2/BIQ/log_dir/NODE0000/S0000215.LOG

Did you check?

Regards

Frank

[sunny_pahuja2]

As per your logs it looks like the permission on the directory /db2/<SID>/log_dir is incorrect. Correct permission should be like below:

File System/Logical Volume Permissions Owner Group

/db2/<DBSID>/log_dir 755 db2<dbsid> db<dbsid>adm

Thanks

Sunny

[Former Member]

Dear Frank-Martin Haas,

The issue has been resolved and thanks for the wonderful help done by you, really appreciate you on this

Regards

Mohammed

[Former Member]

Dear Sunny,

The issue has been resolved and thanks for the wonderful help done by you

Regards

Mohammed