Reg: Upgrade ECC6.0 to EhP4 "Downtime" steps R3tra...

Hi Experts,

While doing Upgrade ECC6.0 to EhP4, Now I am strucked Downtime Steps our instance could not started. R3trans -x (ok) R3trans -d recived some message. paging size I think ok. I upgrade New Kernal7.01 update version:while upgrading 150 Now 176. But still could not started

Please can anybody helping for us. I mentioned r3trans -d Message:

This is r3trans version 6.14 (release 701 -26.10.11 - 13:00:00).

unicode eabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 ----db call info ----

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 LEN<CHAR>: 5

2EETW000 key: TADIR

2EETW000 retcode: 2

r3trans finished <0012>.

SAP Managed Tags:
SAP enhancement package for SAP ERP

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

can you paste the entire trans.log file ?

Regards

Ratnajit

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Selva,

Could you post the contents of the trans.log which gets generated by running R3trans -d

I woudl always recommend using R3trans -d as its a more thorough test.

R3trans -x, as far as I am aware just checks the db is there, but -d actually logs onto the db and back out, so it test for any connection or password errors.

I await your update.

Regards,

Paul

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Power,

Thanks for Response, Now i mentioned Dev_disp and dev_ms,dev_w0,trans.log paging file size file please check it.

---------------------------------------------------

trc file: "dev_disp", trc level: 1, release: "701"

---------------------------------------------------

sysno 03

sid DMO

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 150

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 24032

kernel runs with dp version 246000(ext=110000) (@(#) DPLIB-INT-VERSION-246000-UC)

length of sys_adm_ext is 576 bytes

*** SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (03 24032) [dpxxdisp.c 1311]

Tue Jul 24 22:37:22 2012

shared lib "dw_xml.dll" version 150 successfully loaded

shared lib "dw_xtc.dll" version 150 successfully loaded

shared lib "dw_stl.dll" version 150 successfully loaded

shared lib "dw_gui.dll" version 150 successfully loaded

shared lib "dw_mdm.dll" version 150 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

Tue Jul 24 22:37:34 2012

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 11 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5541]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >dmoserver_DMO_03 <

DpShMCreate: sizeof(wp_adm) 21024 (1752)

DpShMCreate: sizeof(tm_adm) 5912704 (29416)

DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

DpShMCreate: sizeof(comm_adm) 552080 (1088)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1864)

DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000BA90050, size: 6605520)

DpShMCreate: allocated sys_adm at 000000000BA90050

DpShMCreate: allocated wp_adm at 000000000BA922A0

DpShMCreate: allocated tm_adm_list at 000000000BA974C0

DpShMCreate: allocated tm_adm at 000000000BA97520

DpShMCreate: allocated wp_ca_adm at 000000000C03ADA0

DpShMCreate: allocated appc_ca_adm at 000000000C040BA0

DpShMCreate: allocated comm_adm at 000000000C042AE0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 000000000C0C9770

DpShMCreate: allocated gw_adm at 000000000C0C97F0

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 000000000C0C9820

DpShMCreate: allocated wall_adm at 000000000C0C9890

MBUF state OFF

DpCommInitTable: init table for 500 entries

DpRqQInit: Parameter rdisp/queue_lock_level = 2

rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

Tue Jul 24 22:37:35 2012

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation view

<EsNT> Using memory model view.

<EsNT> Memory Reset disabled as NT default

<ES> 1023 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

*** WARNING => System running without ICM - check rdisp/start_icman [dpxxdisp.c 13464]

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1706]

Tue Jul 24 22:37:36 2012

***LOG Q0K=> DpMsAttach, mscon ( dmoserver) [dpxxdisp.c 12778]

DpStartStopMsg: send start message (myname is >dmoserver_DMO_03 <)

DpStartStopMsg: start msg sent

Tue Jul 24 22:37:37 2012

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

Tue Jul 24 22:37:38 2012

CCMS: Checking Downtime Configuration of Monitoring Segment.

Tue Jul 24 22:37:42 2012

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 7010, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1048]

DpMsgAdmin: Set patchno for this platform to 150

Release check o.K.

Tue Jul 24 22:38:16 2012

my types changed after wp death/restart 0x1f --> 0x1e

my types changed after wp death/restart 0x1e --> 0x1c

my types changed after wp death/restart 0x1c --> 0x18

my types changed after wp death/restart 0x18 --> 0x10

my types changed after wp death/restart 0x10 --> 0x0

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

Tue Jul 24 22:38:17 2012

NiISelect: maximum fd=1045

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Jul 24 22:38:27 2012

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Tue Jul 24 17:08:27 2012

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

-------------------------------------------------------------------------------------------------------------------------------

0 DIA 24592 Ended no 1 0 0

1 DIA 25136 Ended no 1 0 0

2 DIA 24668 Ended no 1 0 0

3 DIA 23868 Ended no 1 0 0

4 DIA 24860 Ended no 1 0 0

5 UPD 25500 Ended no 1 0 0

6 ENQ 24816 Ended no 1 0 0

7 BTC 24068 Ended no 1 0 0

8 BTC 24216 Ended no 1 0 0

9 BTC 25120 Ended no 1 0 0

10 BTC 24476 Ended no 1 0 0

11 SPO 25512 Ended no 1 0 0

Dispatcher Queue Statistics Tue Jul 24 17:08:27 2012

===========================

+------+--------+--------+--------+--------+--------+

| Typ | now | high | max | writes | reads |

+------+--------+--------+--------+--------+--------+

| NOWP | 0 | 1 | 2000 | 1 | 1 |

+------+--------+--------+--------+--------+--------+

| DIA | 3 | 3 | 2000 | 3 | 0 |

+------+--------+--------+--------+--------+--------+

| UPD | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| ENQ | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| BTC | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| SPO | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

| UP2 | 0 | 0 | 2000 | 0 | 0 |

+------+--------+--------+--------+--------+--------+

max_rq_id 7

wake_evt_udp_now 0

wake events total 3, udp 3 (100%), shm 0 ( 0%)

since last update total 3, udp 3 (100%), shm 0 ( 0%)

Dump of tm_adm structure: Tue Jul 24 17:08:27 2012

=========================

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Tue Jul 24 17:08:27 2012

=============================

Slots: 300, Used: 1, Max: 1

+------+--------------+----------+-------------+

| id | owner | pid | eyecatcher |

+------+--------------+----------+-------------+

| 0 | DISPATCHER | -1 | *WPCAAD000* |

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=1045

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Jul 24 22:38:32 2012

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >dmoserver_DMO_03 < (normal)

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes

Stop gateway

killing process (25548) (SOFT_KILL)

Terminate gui connections

wait for end of work processes

wait for end of gateway

[DpProcDied] Process lives (PID:25548 HANDLE:868)

waiting for termination of gateway ...

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=1045

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Jul 24 22:38:33 2012

NiISelect: TIMEOUT occured (1000ms)

[DpProcDied] Process died (PID:25548 HANDLE:868)

DpStartStopMsg: send stop message (myname is >dmoserver_DMO_03 <)

DpStartStopMsg: Write AD_STARTSTOP message with type= 0, name=dmoserver_DMO_03 , sapsysnr= 3, hostname=dmoserver

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 189 bytes

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=562,pac=1,MESG_IO)

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

DpStartStopMsg: stop msg sent

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 received data (rcd=274,pac=1,MESG_IO)

NiBufIIn: NIBUF len=274

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 274 bytes

MSG received, len 110+164, flag 1, from MSG_SERVER , typ 0, key -

DpHalt: received 164 bytes from message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIRead: read for hdl 2 timed out (0ms)

DpHalt: no more messages from the message server

DpHalt: send keepalive to synchronize with the message server

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=114,pac=1,MESG_IO)

MsINiWrite: sent 114 bytes

send msg (len 110+4) to name MSG_SERVER, type 0, key -

MsSndName: MS_NOOP ok

Send 4 bytes to MSG_SERVER

NiIRead: hdl 2 recv would block (errno=EAGAIN)

NiIPeek: peek successful for hdl 2 (r)

NiIRead: hdl 2 received data (rcd=114,pac=1,MESG_IO)

NiBufIIn: NIBUF len=114

NiBufIIn: packet complete for hdl 2

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -

Received 4 bytes from MSG_SERVER

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 2 recv would block (errno=EAGAIN)

Tue Jul 24 22:38:34 2012

NiIPeek: peek for hdl 2 timed out (r; 1000ms)

NiIRead: read for hdl 2 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 13124]

NiBufSend starting

NiIWrite: hdl 2 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 2 in set0

SiSelNSet: set events of sock 864 to: ---

NiBufISelRemove: remove hdl 2 from set0

SiSelNRemove: removed sock 864 (pos=2)

SiSelNRemove: removed sock 864

NiSelIRemove: removed hdl 2

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/12

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpSemRq: key: 2, units: 1, timeout: -1

DpSemRel: key: 2, units: 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 9)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 2 / sock 864

NiBufIClose: clear extension for hdl 2

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 24032) [dpxxdisp.c 11298]

Good Bye .....

------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------

trc file: "dev_ms", trc level: 1, release: "701"

---------------------------------------------------

[Thr 24844] Tue Jul 24 22:37:20 2012

[Thr 24844] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 562 (PC with Windows NT)

relno 7010

patchlevel 0

patchno 143

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 24616

[Thr 24844] Tue Jul 24 22:37:21 2012

[Thr 24844] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 24616) [msxxserv.c 1853]

[Thr 24844] load acl file = E:\usr\sap\DMO\EHPI\abap\DMO\SYS\global\ms_acl_info.DAT

[Thr 24844] MsGetOwnIpAddr: my host addresses are :

[Thr 24844] 1 : [192.168.1.120] dmoserver.myiteanz.com (HOSTNAME)

[Thr 24844] 2 : [127.0.0.1] dmoserver (LOCALHOST)

[Thr 24844] Tue Jul 24 22:37:23 2012

[Thr 24844] MsHttpInit: full qualified hostname = dmoserver

[Thr 24844] HTTP logging is switch off

[Thr 24844] ms/icf_info_server : deleted

[Thr 24844] *** I listen to port 3603 (3603) ***

[Thr 24844] CUSTOMER KEY: >B0035282027<

[Thr 24844] build version=701.2009.12.02

[Thr 24844] Tue Jul 24 22:38:33 2012

[Thr 24844] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from dmoserver_DMO_03 [msxxserv.c 4731]

[Thr 24844] Tue Jul 24 22:39:20 2012

[Thr 24844] MsSSoftShutdown: received SIGQUIT (3), start softshutdown phase

[Thr 24844] MsSCheckShutdown: no more clients connected

[Thr 24844] ***LOG Q02=> MsSHalt, MSStop (Msg Server 24616) [msxxserv.c 6041]

--------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "701"

---------------------------------------------------

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS all, MJ

M sysno 03

M sid DMO

M systemid 562 (PC with Windows NT)

M relno 7010

M patchlevel 0

M patchno 150

M intno 20020600

M make: multithreaded, Unicode, 64 bit, optimized

M pid 24592

M kernel runs with dp version 246000(ext=110000) (@(#) DPLIB-INT-VERSION-246000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 24592) [dpxxdisp.c 1373]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 21024 (1752)

M DpShMCreate: sizeof(tm_adm) 5912704 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24064 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000DE50050, size: 6605520)

M DpShMCreate: allocated sys_adm at 000000000DE50050

M DpShMCreate: allocated wp_adm at 000000000DE522A0

M DpShMCreate: allocated tm_adm_list at 000000000DE574C0

M DpShMCreate: allocated tm_adm at 000000000DE57520

M DpShMCreate: allocated wp_ca_adm at 000000000E3FADA0

M DpShMCreate: allocated appc_ca_adm at 000000000E400BA0

M DpShMCreate: allocated comm_adm at 000000000E402AE0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 000000000E489770

M DpShMCreate: allocated gw_adm at 000000000E4897F0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 000000000E489820

M DpShMCreate: allocated wall_adm at 000000000E489890

M DpRqQInit: Parameter rdisp/queue_lock_level = 2

M rdisp/queue_size_check_value : -> on,50,30,40,500,50,500,80

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

M ThInit: rdisp/cleanup_after_crash = 1

M Tue Jul 24 22:37:37 2012

M ThInit: running on host dmoserver

M calling db_connect ...

B Loading DB library 'E:\usr\sap\DMO\EHPI\abap\exe\dbdb6slib.dll' ...

B Tue Jul 24 22:37:40 2012

B Library 'E:\usr\sap\DMO\EHPI\abap\exe\dbdb6slib.dll' loaded

B Tue Jul 24 22:37:41 2012

B Version of 'E:\usr\sap\DMO\EHPI\abap\exe\dbdb6slib.dll' is "700.08", patchlevel (0.143)

C DbSl trace SM50: switch request to level 1

C Registering callback for dynamic profile parameters

C Tue Jul 24 22:37:42 2012

C DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

C DB6 shared library (dbdb6slib) patchlevels

C (0.2) DB6: patch collection 06/08 (note 1172220)

C (0.9) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)

C (0.9) IA64 alignment errors (note 1245982)

C (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963)

C (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

C (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

C (0.19) DB6: patch collection 11/08 (note 1263885)

C (0.19) DB6: patch collection 11/08 (note 1264825)

C (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

C (0.33) DB6: patch collection 02/09 (note 1294443)

C (0.36) DB6: cobra enhancements (note 1315762)

C (0.40) DB6: configurable cc_release attribute for UR cursors (note 1324532)

C (0.41) DB6: unexpected token INLINE LENGTH (note 1334179)

C (0.42) DB6: cobra enhancements part 2 (note 1315762)

C (0.48) DB6: substitution of aliases in optguidelines (note 1352458)

C (0.53) DB6: login timeout for secondary connections (note 1364372)

C (0.57) DB6: revalidate views in status active=N (note 1376439)

C (0.57) DB6: create index with 9.7 and virtual tables (note 1371882)

C (0.58) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

C (0.62) DB6: timeout for CREATE/DROP TRIGGER (note 1387865)

C (0.66) DB6: patch collection 10/09 (note 1397804)

C (0.69) DB6: Potentially unnoticed rollback during array operation (note 1406740)

C (0.74) DB6: client affinity support (note 1414616)

C (0.77) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

C (0.84) DB6: patch collection 03/10 (note 1447436)

C (0.92) Improved overflow error handling (note 1463647)

C (0.94) DB6: patch collection 05/10 (note 1364372)

C (0.94) DB6: patch collection 05/10 (note 1470824)

C (0.96) DB6: return original schema in shadow system (note 1474361)

C (0.99) ABAP: Return technical database PPMS information (note 1419552)

C (0.99) DB6: literals for decimal columns of value 0 (note 1482790)

C (0.101) MSSQL: database fingerprint (note 1405158)

C (0.102) DB6: tolerate client deletes on virtual tables (note 1484286)

C (0.111) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

C (0.112) DB6: revalidation of view failed (note 1376439)

C (0.113) DB6: DROP INDEX on virtual table ignored (note 1514380)

C (0.116) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

C (0.135) DB6: patch collection 03/11 (note 1568512)

C (0.138) DB6: REORG table causes SQL0108 (note 1575617)

C (0.139) DB2 z/OS: SET CURRENT DEGREE = 'ANY' Hint (note 1579352)

C (0.143) DB6: FOR ALL ENTRIES with SUBSTITUTE VALUES (note 1587338)

C Supported features:

C ..retrieving configuration parameters

C ..done

C Tue Jul 24 22:37:46 2012

C DB2 library successfully loaded DB2 library '\\dmoserver\sapmnt\DMO\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll' successfully loaded

C Running with UTF-8 Unicode

C Tue Jul 24 22:37:49 2012

C Running with CLI driver.

C DB2 client driver version '09.07.0003'

C Connected to DB server type 'DB2/NT64'

C Connected to DB server version '09.07.0003'

C Connected to 'DMO' as 'SAPDMO' schema 'SAPDMOSHD' o.k.

C Connected: con_hdl=0 ; appl_hdl=47436; appl_id="fe80::6461:d839:e23:3986%11.49494.120724170749"

C Current member="fe80::6461:d839:e23:3986%11:"

C Database code page is ok.

C Database collating sequence is ok.

C DB2_WORKLOAD=SAP is set in DB2 registry as required.

C CLI Insert Buffering is disabled on single partition databases.

C DbSl trace SM50: switch request to level 1

B Connection 0 opened (DBSL handle 0)

C *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN)

C &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPDMOSHD.SVERS" is an undefined name.

C &+ SQLSTATE=42704

C &+

C &+ SELECT VERSION FROM SVERS WITH UR

C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

C &+

C *** ERROR in prepareStatement[dbdb6.c, 13885] (END)

B ***LOG BZA=> table SVERS does not exist on database [dblink#4 @ 1301] [dblink 1301 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1515]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10824]

M Info for wp 0

M pid = 24592

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M *****************************************************************************

M *

M * LOCATION SAP-Server dmoserver_DMO_03 on host dmoserver (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Jul 24 22:37:49 2012

M * RELEASE 701

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 11089

M * COUNTER 1

M *

M *****************************************************************************

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 262]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 24592) [dpnttool.c 334]

-------------------------------------------------------------------------------------------------------------------------------------------

4 ETW000 r3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 16.07.2012 - 16:00:02

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

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

4 ETW000 [ dev trc,00000] Mon Jul 16 16:00:05 2012 0 0.000000

4 ETW000 [ dev trc,00000] db_con_init called 0 0.000000

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

4 ETW000 [ dev trc,00000] Loading DB library 'dbdb6slib.dll' ... 0 0.000000

4 ETW000 [ dev trc,00000] DlLoadLib success: LoadLibrary("dbdb6slib.dll"), hdl 0, addr 0000000186980000

4 ETW000 145 0.000145

4 ETW000 [ dev trc,00000] using "E:\usr\sap\DMO\SYS\exe\uc\NTAMD64\dbdb6slib.dll" 23 0.000168

4 ETW000 [ dev trc,00000] Library 'dbdb6slib.dll' loaded 31 0.000199

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library dbdb6slib.dll 26 0.000225

4 ETW000 [ dev trc,00000] Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.143) 457 0.000682

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library dbdb6slib.dll 33 0.000715

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library dbdb6slib.dll 28 0.000743

4 ETW000 [ dev trc,00000] New connection 0 created 36 0.000779

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 68 0.000847

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

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

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 63 0.000972

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

4 ETW000 [ dev trc,00000] DB6 shared library (dbdb6slib) patchlevels 43 0.006557

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

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

4 ETW000 [ dev trc,00000] (0.9) IA64 alignment errors (note 1245982) 25 0.006638

4 ETW000 [ dev trc,00000] (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963) 28 0.006666

4 ETW000 [ dev trc,00000] (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 36 0.006702

4 ETW000 [ dev trc,00000] (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 36 0.006738

4 ETW000 [ dev trc,00000] (0.19) DB6: patch collection 11/08 (note 1263885) 25 0.006763

4 ETW000 [ dev trc,00000] (0.19) DB6: patch collection 11/08 (note 1264825) 98 0.006861

4 ETW000 [ dev trc,00000] (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 66 0.006927

4 ETW000 [ dev trc,00000] (0.33) DB6: patch collection 02/09 (note 1294443) 25 0.006952

4 ETW000 [ dev trc,00000] (0.36) DB6: cobra enhancements (note 1315762) 26 0.006978

4 ETW000 [ dev trc,00000] (0.40) DB6: configurable cc_release attribute for UR cursors (note 1324532)

4 ETW000 35 0.007013

4 ETW000 [ dev trc,00000] (0.41) DB6: unexpected token INLINE LENGTH (note 1334179) 26 0.007039

4 ETW000 [ dev trc,00000] (0.42) DB6: cobra enhancements part 2 (note 1315762) 25 0.007064

4 ETW000 [ dev trc,00000] (0.48) DB6: substitution of aliases in optguidelines (note 1352458)

4 ETW000 34 0.007098

4 ETW000 [ dev trc,00000] (0.53) DB6: login timeout for secondary connections (note 1364372)

4 ETW000 35 0.007133

4 ETW000 [ dev trc,00000] (0.57) DB6: revalidate views in status active=N (note 1376439) 27 0.007160

4 ETW000 [ dev trc,00000] (0.57) DB6: create index with 9.7 and virtual tables (note 1371882)

4 ETW000 34 0.007194

4 ETW000 [ dev trc,00000] (0.58) DB6: optimized performance for R3load with DEF_CRT (note 1378018)

4 ETW000 35 0.007229

4 ETW000 [ dev trc,00000] (0.62) DB6: timeout for CREATE/DROP TRIGGER (note 1387865) 26 0.007255

4 ETW000 [ dev trc,00000] (0.66) DB6: patch collection 10/09 (note 1397804) 25 0.007280

4 ETW000 [ dev trc,00000] (0.69) DB6: Potentially unnoticed rollback during array operation (note 1406740)

4 ETW000 37 0.007317

4 ETW000 [ dev trc,00000] (0.74) DB6: client affinity support (note 1414616) 24 0.007341

4 ETW000 [ dev trc,00000] (0.77) DB6: CLI TraceRefreshInterval during parallel import (note 1426985)

4 ETW000 36 0.007377

4 ETW000 [ dev trc,00000] (0.84) DB6: patch collection 03/10 (note 1447436) 25 0.007402

4 ETW000 [ dev trc,00000] (0.92) Improved overflow error handling (note 1463647) 26 0.007428

4 ETW000 [ dev trc,00000] (0.94) DB6: patch collection 05/10 (note 1364372) 25 0.007453

4 ETW000 [ dev trc,00000] (0.94) DB6: patch collection 05/10 (note 1470824) 25 0.007478

4 ETW000 [ dev trc,00000] (0.96) DB6: return original schema in shadow system (note 1474361)

4 ETW000 34 0.007512

4 ETW000 [ dev trc,00000] (0.99) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000 35 0.007547

4 ETW000 [ dev trc,00000] (0.99) DB6: literals for decimal columns of value 0 (note 1482790)

4 ETW000 33 0.007580

4 ETW000 [ dev trc,00000] (0.101) MSSQL: database fingerprint (note 1405158) 79 0.007659

4 ETW000 [ dev trc,00000] (0.102) DB6: tolerate client deletes on virtual tables (note 1484286)

4 ETW000 40 0.007699

4 ETW000 [ dev trc,00000] (0.111) DB6: SQLE_CLIENT_INFO_USERID including quotes (note 1508803)

4 ETW000 34 0.007733

4 ETW000 [ dev trc,00000] (0.112) DB6: revalidation of view failed (note 1376439) 26 0.007759

4 ETW000 [ dev trc,00000] (0.113) DB6: DROP INDEX on virtual table ignored (note 1514380) 26 0.007785

4 ETW000 [ dev trc,00000] (0.116) DB6: FOR ALL ENTRIES statement with SUBSTITUTE LITERALS (note 1520152)

4 ETW000 37 0.007822

4 ETW000 [ dev trc,00000] (0.135) DB6: patch collection 03/11 (note 1568512) 25 0.007847

4 ETW000 [ dev trc,00000] (0.138) DB6: REORG table causes SQL0108 (note 1575617) 41 0.007888

4 ETW000 [ dev trc,00000] (0.139) DB2 z/OS: SET CURRENT DEGREE = 'ANY' Hint (note 1579352) 28 0.007916

4 ETW000 [ dev trc,00000] (0.143) DB6: FOR ALL ENTRIES with SUBSTITUTE VALUES (note 1587338)

4 ETW000 35 0.007951

4 ETW000 [ dev trc,00000] Supported features: 20 0.007971

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

4 ETW000 [ dev trc,00000] ..done 1190 0.009191

4 ETW000 [ dev trc,00000] DB2 library successfully loaded DB2 library '\\dmoserver\sapmnt\DMO\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll' successfully loaded

4 ETW000 300039 0.309230

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

4 ETW000 [ dev trc,00000] Running with CLI driver. 270261 0.579521

4 ETW000 [ dev trc,00000] DB2 client driver version '09.07.0003' 294489 0.874010

4 ETW000 [ dev trc,00000] Connected to DB server type 'DB2/NT64' 1278 0.875288

4 ETW000 [ dev trc,00000] Connected to DB server version '09.07.0003' 56 0.875344

4 ETW000 [ dev trc,00000] Connected to 'DMO' as 'SAPDMO' schema 'SAPDMO' o.k. 15549 0.890893

4 ETW000 [ dev trc,00000] Connected: con_hdl=0 ; appl_hdl=140; appl_id="fe80::6461:d839:e23:3986%11.50097.120716103005"

4 ETW000 58 0.890951

4 ETW000 [ dev trc,00000] Current member="fe80::6461:d839:e23:3986%11:" 24 0.890975

4 ETW000 [ dev trc,00000] Database code page is ok. 48 0.891023

4 ETW000 [ dev trc,00000] Database collating sequence is ok. 28534 0.919557

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

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

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

4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 38 0.924039

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

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

4 ETW000 [ dev trc,00000] NTAB: UNICODELG(SVERS) = 2, SAP_UC_LN = 2 39 0.934069

4 ETW000 [ dev trc,00000] NTAB: standalone processing 61 0.934130

4 ETW000 [ dev trc,00000] NTAB: read profile 24 0.934154

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

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

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

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

4 ETW000 [ dev trc,00000] NTAB: compute_hash_card: 2003. 31 0.934260

4 ETW000 [ dev trc,00000] NTAB: maxcnt 1000. 53 0.934313

4 ETW000 [ dev trc,00000] NTAB: hfactor 2003. 17 0.934330

4 ETW000 [ dev trc,00000] NTAB: mem_protocol_size 112 19 0.934349

4 ETW000 [ dev trc,00000] NTAB: hdr_backpack_offset 0 18 0.934367

4 ETW000 [ dev trc,00000] NTAB: hdr_backpack_size 0 17 0.934384

4 ETW000 [ dev trc,00000] NTAB: FTAB: header_size 80. 55 0.934439

4 ETW000 [ dev trc,00000] NTAB: FTAB: item_size 64. 20 0.934459

4 ETW000 [ dev trc,00000] NTAB: FTAB: item_cnt 1000. 18 0.934477

4 ETW000 [ dev trc,00000] NTAB: FTAB: unit_size 4 18 0.934495

4 ETW000 [ dev trc,00000] NTAB: FTAB: unit_cnt 128000. 19 0.934514

4 ETW000 [ dev trc,00000] NTAB: FTAB: data_size 512000. 19 0.934533

4 ETW000 [ dev trc,00000] NTAB: IREC: header_size 80. 18 0.934551

4 ETW000 [ dev trc,00000] NTAB: IREC: item_size 64. 18 0.934569

4 ETW000 [ dev trc,00000] NTAB: IREC: item_cnt 250. 18 0.934587

4 ETW000 [ dev trc,00000] NTAB: IREC: unit_size 8 18 0.934605

4 ETW000 [ dev trc,00000] NTAB: IREC: unit_cnt 12800. 18 0.934623

4 ETW000 [ dev trc,00000] NTAB: IREC: data_size 102400. 18 0.934641

4 ETW000 [ dev trc,00000] NTAB: STAB: header_size 80. 19 0.934660

4 ETW000 [ dev trc,00000] NTAB: STAB: item_size 64. 18 0.934678

4 ETW000 [ dev trc,00000] NTAB: STAB: item_cnt 250. 18 0.934696

4 ETW000 [ dev trc,00000] NTAB: STAB: unit_size 4 17 0.934713

4 ETW000 [ dev trc,00000] NTAB: STAB: unit_cnt 25600. 19 0.934732

4 ETW000 [ dev trc,00000] NTAB: STAB: data_size 102400. 19 0.934751

4 ETW000 [ dev trc,00000] NTAB: TTAB: header_size 192. 18 0.934769

4 ETW000 [ dev trc,00000] NTAB: TTAB: item_size 40. 111 0.934880

4 ETW000 [ dev trc,00000] NTAB: TTAB: item_cnt 1000. 24 0.934904

4 ETW000 [ dev trc,00000] NTAB: TTAB: unit_size 256 19 0.934923

4 ETW000 [ dev trc,00000] NTAB: TTAB: unit_cnt 1000. 18 0.934941

4 ETW000 [ dev trc,00000] NTAB: TTAB: data_size 256000. 19 0.934960

4 ETW000 [ dev trc,00000] NTAB: FTAB: hh_p 28d5bc0, hh_len 80 989 0.935949

4 ETW000 [ dev trc,00000] NTAB: FTAB: aa_p 27aa520, aa_len 16024 33 0.935982

4 ETW000 [ dev trc,00000] NTAB: FTAB: ia_p 27ae3c0, ia_len 64000 20 0.936002

4 ETW000 [ dev trc,00000] NTAB: FTAB: dat_p 93a0080, dat_len 512000 20 0.936022

4 ETW000 [ dev trc,00000] NTAB: IREC: hh_p 2740f30, hh_len 80 19 0.936041

4 ETW000 [ dev trc,00000] NTAB: IREC: aa_p 27bddd0, aa_len 16024 21 0.936062

4 ETW000 [ dev trc,00000] NTAB: IREC: ia_p 27c1c70, ia_len 16000 19 0.936081

4 ETW000 [ dev trc,00000] NTAB: IREC: dat_p 27c5b00, dat_len 102400 21 0.936102

4 ETW000 [ dev trc,00000] NTAB: STAB: hh_p 28df9a0, hh_len 80 19 0.936121

4 ETW000 [ dev trc,00000] NTAB: STAB: aa_p 27deb10, aa_len 16024 20 0.936141

4 ETW000 [ dev trc,00000] NTAB: STAB: ia_p 27e29b0, ia_len 16000 20 0.936161

4 ETW000 [ dev trc,00000] NTAB: STAB: dat_p 27e6840, dat_len 102400 20 0.936181

4 ETW000 [ dev trc,00000] NTAB: TTAB: hh_p 28dfa00, hh_len 192 19 0.936200

4 ETW000 [ dev trc,00000] NTAB: TTAB: aa_p 27ff850, aa_len 16024 20 0.936220

4 ETW000 [ dev trc,00000] NTAB: TTAB: ia_p 941d090, ia_len 40000 20 0.936240

4 ETW000 [ dev trc,00000] NTAB: TTAB: dat_p 9426ce0, dat_len 256000 20 0.936260

4 ETW000 [ dev trc,00000] NTAB: ntab_mem_protocol 28dfa00, ntab_mp_p 28dfa00, ntab_proc_id 0 36 0.936296

4 ETW000 [ dev trc,00000] NTAB: FTAB: hh_p 28d5bc0, ha_list 27aa520, hi_list 27ae3c0, buffer 93a0080

4 ETW000 94 0.936390

4 ETW000 [ dev trc,00000] NTAB: IREC: hh_p 2740f30, ha_list 27bddd0, hi_list 27c1c70, buffer 27c5b00

4 ETW000 32 0.936422

4 ETW000 [ dev trc,00000] NTAB: STAB: hh_p 28df9a0, ha_list 27deb10, hi_list 27e29b0, buffer 27e6840

4 ETW000 31 0.936453

4 ETW000 [ dev trc,00000] NTAB: TTAB: hh_p 28dfa70, ha_list 27ff850, hi_list 941d090, buffer 9426ce0

4 ETW000 32 0.936485

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

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

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

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

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

4 ETW000 5878 0.942509

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

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

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

4 ETW000 365 0.943971

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

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 81 0.945937

4 ETW000 [ dev trc,00000] dsql_fetch (con_da=(0,R/3),cu_id=9,#output=8) 874 0.946811

4 ETW000 [ dev trc,00000] dsql_close (con_da=(0,R/3),cu_id=9) 78 0.946889

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

4 ETW000 56 0.946945

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

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) 77 0.947831

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 : 16.07.2012 - 16:00:05

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: 241 0.000241

4 ETW000 [ dev trc,00000] Disconnected from 'DMO' 4694 0.004935

4 ETW000 [ dev trc,00000] Disconnected: con_hdl=0 ; appl_hdl=140; appl_id="fe80::6461:d839:e23:3986%11.50097.120716103005"

4 ETW000 57 0.004992

4 ETW000 [ dev trc,00000] Environment Handle has been released. sql_rc=0 263 0.005255

4 ETW000 [ dev trc,00000] Disconnected from connection 0 103 0.005358

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

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

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 16.07.2012 - 16:00:05

----------------------------------------------------------------------------------------------------------------------------------

Paging file:

C: Drive:

Intial size: 8000

Maximum: 10000

E Drive:

Intial size: 60000

Maxmium: 70000

Hi,

I see a few items of interest in the logs you published:

[Thr 24844] Tue Jul 24 22:38:33 2012

[Thr 24844] *** ERROR => MsSClientHandle: no server provides service ENQ (4), requested from dmoserver_DMO_03 [msxxserv.c 4731]

dev_w0

C *** ERROR in prepareStatement[dbdb6.c, 13885] CON = 0 (BEGIN)

C &+ DbSlReadDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/NT64] SQL0204N "SAPDMOSHD.SVERS" is an undefined name.

C &+ SQLSTATE=42704

C &+

C &+ SELECT VERSION FROM SVERS WITH UR

C &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, reopt=0

C &+

C *** ERROR in prepareStatement[dbdb6.c, 13885] (END)

B ***LOG BZA=> table SVERS does not exist on database [dblink#4 @ 1301] [dblink 1301 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c 1515]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10824]

The main error is

SQL0204N "SAPDMOSHD.SVERS" is an undefined name.

so it is trying to connect to and look for table SVERS i the shadow schema SAPDMOSHD

You can double check this by seeing at db level

db2 select TABSCHEMA, TABNAME, OWNER from syscat.tables where TABNAME
= 'SVERS'

Are you using the SUM tool?

I believe their was a bug that caused this behavious in SUM SP4, if using this, ensure to downlaod and use the latest SUM level.

What is the DB2 version ?

SUM does not support upgrade of systems lower on DB2 lower than 9.7 FP3.

Note 1684165 - DB6: Add. Info. - Software Update Manager 1.0 SP04

I suggest you use EHPI (if you are using EHPI).

Refer this note Note 1160166 - DB6: Add. Information - SAP Enhancement Package Installer

Regards

Ratnajit

Hi Ratna,

Thanks, I am using My Database version "DB2 v9.7 Fix Pack "3" EhPi Installer Tool version SAPehpi_134-10005807.SAR

SAPJup = BSi10SL_00

SAPehpi = lmt_001

ostype = NTAMD64

release = lmt_001_REL

date = 2012-6-26

time = 7:31:46

packversion = 25

crpkversion = 1.041

Hello Selva,

my recommendation is use SUM on this case, since you're on DB2 v9.7 FP3. But first we need to know in which exactly phase you're presently at?

Tomas Black

Hello Thomas,

Thanks for Response. My Database version v9.7 fp3, so EhPi installer running purpose atleast FP3 its enough please check I mentioned these notes.

Hi Paul,

Thanks for Reply, I dont know how to run this script in db2cmd level, Please explain this script

db2 select TABSCHEMA, TABNAME, OWNER from syscat.tables where TABNAME

= 'SVERS'

TABSCHEMA

TABNAME

OWNER

SYSCAT.TABLES

PLEASE explain.

Hi Selva,

that's OK to run SAPehpi for now, but I would use SUM in your place as this tool is gradually replacing SAPup, SAPehpi, SPAM and SAINT.

Now tell us in which phase you're getting this error?

Regards,

Tomas Black

Hi Tomas,

Thanks for Reply, I am not getting "Downtime Steps" If I opend SAPEHPI tool asking first step and keyword these are initial stage.

Severe error(s) occured in phase REV_PRPEXTRACT/RESET_PREPARE!

Last error code set: Cannot create process 'tp\pf=D:\2_7_12\ehp_tool\EHPI\abap\bin\DEFAULT.TPP execdbscript DMO -x UVERSRES.TQL': The filename, directory name, or volume label syntax is incorrect.

As per the thread http://scn.sap.com/thread/1837378

Please add the SAPLOCALHOST parameter to the instance profile and then start the SAPEHPI from scratch. This may be one solution .

You better paste the D:\2_7_12\ehp_tool\EHPI\abap\bin\DEFAULT.TPP file.

Regards

Ratnajit

Ask a Question

Top Q&A Solution Author

User

Count

103