Skip to Content
0
Former Member
Jul 09, 2010 at 06:08 AM

sap startup failed

121 Views

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'"