System start error after restore

Former Member · ‎07-22-2008

Hi,

I have restored DB2 database from tape backup and applied logs to time before crash.

All processes ends successfully. But when I try to start sap system via startsap database "stands up", Java instance too, but ABAP instance ends with message:

Starting SAP Instance DVEBMSG_34

----

Killed

Startup of Instance failed

See /export/home/epdadm/startsap_DVEBMSG_34.log for details

In log file mentioned above isn't any details about reason why ABAP instance fail to run.

Is there any trace/debug method to see what causes startsap fail.

Of course I've search all files in /usr/sap/EPD/DVEBMGS34/work, but there aren't any usefull info.

PS. Tech. spec. OS: Solaris 10, DB: DB2 v9.1 FP3, NetWeaver 2004s, system consists of ABAP and JAVA instance

Thanks for any suggestions

Michael

Former Member · ‎07-23-2008

Here is R3trans -x and trans.log

sapqassma:epdadm 15% R3trans -x

This is R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

unicode enabled version

R3trans finished (0000).

trans.log

4 ETW000 R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 23.07.2008 - 10:47:47

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d -v

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Jul 23 10:47:47 2008 495 0.000495

4 ETW000 [dev trc ,00000] db_con_init called 127 0.000622

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 146 0.000768

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/EPD/SYS/exe/run/dbdb6slib.so' ...

4 ETW000 484 0.001252

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/EPD/SYS/exe/run/dbdb6slib.so), hdl 0

4 ETW000 14650 0.015902

4 ETW000 [dev trc ,00000] Library '/usr/sap/EPD/SYS/exe/run/dbdb6slib.so' loaded

4 ETW000 249 0.016151

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/EPD/SYS/exe/run/dbdb6slib.so

4 ETW000 221 0.016372

4 ETW000 [dev trc ,00000] Version of '/usr/sap/EPD/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (0.144)

4 ETW000 1012 0.017384

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/EPD/SYS/exe/run/dbdb6slib.so

4 ETW000 219 0.017603

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/EPD/SYS/exe/run/dbdb6slib.so

4 ETW000 210 0.017813

4 ETW000 [dev trc ,00000] New connection 0 created 230 0.018043

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 244 0.018287

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 136 0.018423

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 198 0.018621

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 232 0.018853

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/db2/db2epd/sqllib/lib64/libdb2.so' successfully loaded

4 ETW000 68125 0.086978

4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000 234 0.087212

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 130 0.087342

4 ETW000 [dev trc ,00000] (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

4 ETW000 205 0.087547

4 ETW000 [dev trc ,00000] (0.8) Support of SDBUPDEXCL (note 847616) 136 0.087683

4 ETW000 [dev trc ,00000] (0.9) DB6: use export file for dbdb6slib (note 835135)

4 ETW000 199 0.087882

4 ETW000 [dev trc ,00000] (0.9) DB6: Core in getAndBindSQLDA (note 833183)

4 ETW000 197 0.088079

4 ETW000 [dev trc ,00000] (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000 224 0.088303

4 ETW000 [dev trc ,00000] (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

4 ETW000 202 0.088505

4 ETW000 [dev trc ,00000] (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

4 ETW000 202 0.088707

4 ETW000 [dev trc ,00000] (0.17) DB6: special characters in sidadm passwd (note 865839)

4 ETW000 202 0.088909

4 ETW000 [dev trc ,00000] (0.21) DB6: no SAP_INFO comments (note 873889)

4 ETW000 197 0.089106

4 ETW000 [dev trc ,00000] (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 222 0.089328

4 ETW000 [dev trc ,00000] (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 206 0.089534

4 ETW000 [dev trc ,00000] (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

4 ETW000 205 0.089739

4 ETW000 [dev trc ,00000] (0.27) DB6: activate value compression (note 886231)

4 ETW000 199 0.089938

4 ETW000 [dev trc ,00000] (0.28) DB6: optimization guidelines on views part 2 (note 868888)

4 ETW000 203 0.090141

4 ETW000 [dev trc ,00000] (0.30) DB6: no SQL trace for SQLCancel (note 892111)

4 ETW000 214 0.090355

4 ETW000 [dev trc ,00000] (0.33) DB6: append SAP_TA comment (note 873889)

4 ETW000 200 0.090555

4 ETW000 [dev trc ,00000] (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000 205 0.090760

4 ETW000 [dev trc ,00000] (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000 205 0.090965

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

4 ETW000 203 0.091168

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

4 ETW000 219 0.091387

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

4 ETW000 206 0.091593

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

4 ETW000 198 0.091791

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

4 ETW000 202 0.091993

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

4 ETW000 201 0.092194

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

4 ETW000 356 0.092550

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

4 ETW000 204 0.092754

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

4 ETW000 203 0.092957

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

4 ETW000 199 0.093156

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

4 ETW000 198 0.093354

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

4 ETW000 201 0.093555

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

4 ETW000 221 0.093776

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

4 ETW000 199 0.093975

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

4 ETW000 205 0.094180

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

4 ETW000 204 0.094384

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

4 ETW000 204 0.094588

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

4 ETW000 219 0.094807

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

4 ETW000 208 0.095015

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

4 ETW000 201 0.095216

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

4 ETW000 203 0.095419

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

4 ETW000 204 0.095623

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

4 ETW000 222 0.095845

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

4 ETW000 204 0.096049

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

4 ETW000 201 0.096250

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

4 ETW000 203 0.096453

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

4 ETW000 205 0.096658

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

4 ETW000 218 0.096876

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

4 ETW000 206 0.097082

4 ETW000 [dev trc ,00000] Supported features: 127 0.097209

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 127 0.097336

4 ETW000 [dev trc ,00000] ..done 487 0.097823

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 133 0.097956

4 ETW000 [dev trc ,00000] Wed Jul 23 10:47:48 2008 1373400 1.471356

4 ETW000 [dev trc ,00000] DB2 client driver version '09.01.0003' 149 1.471505

4 ETW000 [dev trc ,00000] Connected to DB2 server type 'DB2/SUN64' 168 1.471673

4 ETW000 [dev trc ,00000] Connected to DB2 version '09.01.0003' 200 1.471873

4 ETW000 [dev trc ,00000] Connect to 'EPD' as 'SAPEPD' schema 'SAPEPD' o.k.; con_hdl=0

4 ETW000 11832 1.483705

4 ETW000 [dev trc ,00000] Database code page is ok. 155 1.483860

4 ETW000 [dev trc ,00000] Database collating sequence is ok. 85862 1.569722

4 ETW000 [dev trc ,00000] DB2_WORKLOAD=SAP is set in DB2 registry as required.

4 ETW000 26604 1.596326

4 ETW000 [dev trc ,00000] CLI Insert Buffering is disabled on single partition databases.

4 ETW000 2044 1.598370

4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'

4 ETW000 2274 1.600644

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 171 1.600815

4 ETW000 [dev trc ,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'

4 ETW000 28183 1.628998

4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 42992 1.671990

4 ETW000 [dev trc ,00000] NTAB: standalone processing 261 1.672251

4 ETW000 [dev trc ,00000] NTAB: read profile 132 1.672383

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 131 1.672514

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 129 1.672643

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 127 1.672770

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 129 1.672899

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 190 1.673089

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 175 1.673264

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 129 1.673393

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 128 1.673521

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 127 1.673648

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 127 1.673775

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 80. 128 1.673903

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 64. 127 1.674030

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 128 1.674158

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 128 1.674286

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 127 1.674413

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 280 1.674693

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 80. 131 1.674824

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 64. 128 1.674952

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 127 1.675079

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 126 1.675205

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 128 1.675333

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 128 1.675461

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 80. 127 1.675588

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 64. 127 1.675715

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 126 1.675841

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 144 1.675985

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 129 1.676114

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 128 1.676242

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 184. 128 1.676370

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 40. 127 1.676497

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 127 1.676624

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 139 1.676763

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 129 1.676892

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 129 1.677021

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 1017dc710, hh_len 80 843 1.677864

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 10186e390, aa_len 16024 139 1.678003

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 101872240, ia_len 64000 172 1.678175

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 101881c50, dat_len 512000 134 1.678309

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 1017db620, hh_len 80 130 1.678439

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 1018fec60, aa_len 16024 133 1.678572

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 101902b10, ia_len 16000 131 1.678703

4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 1019069a0, dat_len 102400 132 1.678835

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 1017db680, hh_len 80 129 1.678964

4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 10191f9b0, aa_len 16024 132 1.679096

4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 101923860, ia_len 16000 131 1.679227

4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 1019276f0, dat_len 102400 132 1.679359

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 1017e7a70, hh_len 184 146 1.679505

4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 101940700, aa_len 16024 132 1.679637

4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 1019445b0, ia_len 40000 132 1.679769

4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 10194e200, dat_len 256000 132 1.679901

4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 1017e7a70, ntab_mp_p 1017e7a70, ntab_proc_id 0

4 ETW000 210 1.680111

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 1017dc710, ha_list 10186e390, hi_list 101872240, buffer 101881c50

4 ETW000 433 1.680544

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 1017db620, ha_list 1018fec60, hi_list 101902b10, buffer 1019069a0

4 ETW000 208 1.680752

4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 1017db680, ha_list 10191f9b0, hi_list 101923860, buffer 1019276f0

4 ETW000 225 1.680977

4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 1017e7ad8, ha_list 101940700, hi_list 1019445b0, buffer 10194e200

4 ETW000 208 1.681185

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

4 ETW000 237 1.681422

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

4 ETW000 255 1.681677

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

4 ETW000 252 1.681929

4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

4 ETW000 270 1.682199

4 ETW000 [twdydbacc.c ,00571] i:0 3248 1.685447

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: PGMID 129 1.685576

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 1 120 1.685696

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 0 119 1.685815

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 4 118 1.685933

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:4 120 1.686053

4 ETW000 [twdydbacc.c ,00571] i:1 127 1.686180

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: OBJECT 120 1.686300

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 1 118 1.686418

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 4 137 1.686555

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 4 120 1.686675

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:4 120 1.686795

4 ETW000 [twdydbacc.c ,00571] i:2 125 1.686920

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: OBJ_NAME 119 1.687039

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 1 118 1.687157

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 8 119 1.687276

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 40 118 1.687394

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:40 119 1.687513

4 ETW000 [twdydbacc.c ,00571] i:3 124 1.687637

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: KORRNUM 135 1.687772

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 120 1.687892

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 48 119 1.688011

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 10 118 1.688129

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:10 119 1.688248

4 ETW000 [twdydbacc.c ,00571] i:4 125 1.688373

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: SRCSYSTEM 119 1.688492

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.688610

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 58 119 1.688729

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 10 118 1.688847

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:10 226 1.689073

4 ETW000 [twdydbacc.c ,00571] i:5 127 1.689200

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: AUTHOR 121 1.689321

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.689439

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 68 119 1.689558

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 12 118 1.689676

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:12 119 1.689795

4 ETW000 [twdydbacc.c ,00571] i:6 124 1.689919

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: SRCDEP 120 1.690039

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.690157

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 80 119 1.690276

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 9349 1.699625

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 127 1.699752

4 ETW000 [twdydbacc.c ,00571] i:7 127 1.699879

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: DEVCLASS 121 1.700000

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.700118

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 81 119 1.700237

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 30 118 1.700355

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:30 119 1.700474

4 ETW000 [twdydbacc.c ,00571] i:8 125 1.700599

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: GENFLAG 119 1.700718

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 136 1.700854

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 111 121 1.700975

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 118 1.701093

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 119 1.701212

4 ETW000 [twdydbacc.c ,00571] i:9 125 1.701337

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: EDTFLAG 119 1.701456

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 119 1.701575

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 112 119 1.701694

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 117 1.701811

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 119 1.701930

4 ETW000 [twdydbacc.c ,00571] i:10 141 1.702071

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: CPROJECT 121 1.702192

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.702310

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 113 120 1.702430

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 8 118 1.702548

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:8 118 1.702666

4 ETW000 [twdydbacc.c ,00571] i:11 126 1.702792

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: MASTERLANG 119 1.702911

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 119 1.703030

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 121 119 1.703149

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 118 1.703267

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 133 1.703400

4 ETW000 [twdydbacc.c ,00571] i:12 128 1.703528

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: VERSID 119 1.703647

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.703765

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 122 119 1.703884

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 20 119 1.704003

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:20 118 1.704121

4 ETW000 [twdydbacc.c ,00571] i:13 125 1.704246

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: PAKNOCHECK 120 1.704366

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.704484

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 142 134 1.704618

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 120 1.704738

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 120 1.704858

4 ETW000 [twdydbacc.c ,00571] i:14 126 1.704984

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: OBJSTABLTY 120 1.705104

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.705222

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 143 119 1.705341

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 118 1.705459

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 119 1.705578

4 ETW000 [twdydbacc.c ,00571] i:15 125 1.705703

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: COMPONENT 120 1.705823

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 134 1.705957

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 144 120 1.706077

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 30 119 1.706196

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:30 119 1.706315

4 ETW000 [twdydbacc.c ,00571] i:16 126 1.706441

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: CRELEASE 120 1.706561

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.706679

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 174 120 1.706799

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 10 118 1.706917

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:10 119 1.707036

4 ETW000 [twdydbacc.c ,00571] i:17 141 1.707177

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: DELFLAG 121 1.707298

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.707416

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 184 119 1.707535

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 118 1.707653

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 118 1.707771

4 ETW000 [twdydbacc.c ,00571] i:18 126 1.707897

4 ETW000 [twdydbacc.c ,00572] db_fd_p.fname: TRANSLTTXT 120 1.708017

4 ETW000 [twdydbacc.c ,00573] db_fd_p.is_key: 0 118 1.708135

4 ETW000 [twdydbacc.c ,00574] db_fd_p.offset: 185 119 1.708254

4 ETW000 [twdydbacc.c ,00575] db_fd_p.db_length: 1 214 1.708468

4 ETW000 [twdydbacc.c ,00576] db_fd_p.fixed_length:1 122 1.708590

4 ETW000 [twdydbacc.c ,00730] buffer:'' 2005 1.710595

4 ETW000 [twdydbacc.c ,00735] i:0 129 1.710724

4 ETW000 [twdydbacc.c ,00736] tw_fd_p.offset:0 119 1.710843

4 ETW000 [twdydbacc.c ,00735] i:1 118 1.710961

4 ETW000 [twdydbacc.c ,00736] tw_fd_p.offset:4 118 1.711079

4 ETW000 [twdydbacc.c ,00735] i:2 118 1.711197

4 ETW000 [twdydbacc.c ,00736] tw_fd_p.offset:8 117 1.711314

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:653}

4 ETW000 218 1.711532

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )

4 ETW000 2049 1.713581

4 ETW000 Connected to DBMS = DB6 --- DB2DBDFT = 'EPD' --- SYSTEM = 'EPD'.

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1252}

4 ETW000 1633 1.715214

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 3432 1.718646

4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)

4 ETW000 252 1.718898

4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=10,#output=8) 1957 1.720855

4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=10) 261 1.721116

4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1360}

4 ETW000 257 1.721373

4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 1594 1.722967

4 ETW000 PATCHHIST was already up to date.

4 ETW690 COMMIT "0" "0"

4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)

4 ETW000 294 1.723261

4 ETW000 trace to file pointer closed

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 23.07.2008 - 10:47:48

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 6713 0.006713

4 ETW000 [dev trc ,00000] disconnected from 'EPD', con_hdl=0 14255 0.020968

4 ETW000 [dev trc ,00000] Disconnected from connection 0 270 0.021238

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 201 0.021439

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 196 0.021635

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 23.07.2008 - 10:47:48

Michael

Former Member · ‎07-23-2008

This are messages after startsap and R3trans -d

sapqassma:epdadm 3% ./startsap

Checking db6 db Database

----

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

----

***********************************************************************

* This is Saposcol Version COLL 20.95 700 - V3.72 64Bit

* Usage: saposcol -l: Start OS Collector

* saposcol -k: Stop OS Collector

* saposcol -d: OS Collector Dialog Mode

* saposcol -s: OS Collector Status

* The OS Collector (PID 18717) is already running .....

************************************************************************

saposcol already running

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

07/23/2008 09:56:28 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

Database activated

/usr/sap/EPD/SYS/exe/run/startdb completed successfully

Starting SAP Instance SCS35

----

Startup-Log is written to /export/home/epdadm/startsap_SCS35.log

Instance Service on host sapqassma started

Instance on host sapqassma started

Starting SAP Instance DVEBMGS34

----

Startup-Log is written to /export/home/epdadm/startsap_DVEBMGS34.log

Killed

Startup of Instance Service failed 137

See /export/home/epdadm/startsap_DVEBMGS34.log for details

sapqassma:epdadm 4% R3trans -d

This is R3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

unicode enabled version

R3trans finished (0000).

I'va changed startsap script to show return code in variable $startsrvreturncode which I've marked above bold

Former Member · ‎07-23-2008

Hi,

In dev_w0 and dev_disp there is no any logs from time when I tray to start instance. Last logs in this files is from time before crash. System was successfully restored from backup.

I found strange file dev_sapstart in /usr/sap/EPD/DVEBMGS34/ which contains

----

trc file: "dev_sapstart", trc level: 1, release: "700"

----

Tue Jul 22 14:34:15 2008

SigISetDefaultAction : default handling for signal 18

SigISetIgnoreAction : SIG_IGN for signal 2