Reply from Lars-Erik Hallsten on Aug 20 at 5:08 AM Hi,
Try to shut down SAP and then shut down database completely using "db2stop force".
Now try to start the database again.
If you don't get any errors from the database tool, try to start SAP.
Regards,
LEH
| | | ---------------Original Message---------------
From: sam kuriakose
Sent: Wednesday, August 20, 2014 4:58 AM
Subject: Dispatcher Not Starting After Restarting Server for First Time
Hi,
Please see the dev_w0 below.
------
trc file: "dev_w0", trc level: 1, release: "741"
-----
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
M sysno 01
M sid EC9
M systemid 562 (PC with Windows NT)
M relno 7410
M patchlevel 0
M patchno 26
M intno 20020600
M make multithreaded, Unicode, 64 bit, optimized
M profile \\DEV\sapmnt\EC9\SYS\profile\EC9_DVEBMGS01_DEV
M pid 3816
M
M
M Wed Aug 20 10:38:53 2014
M kernel runs with dp version 203000(ext=117000) (@(#) DPLIB-INT-VERSION-203000-UC)
M length of sys_adm_ext is 500 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 3816) [dpInit.c 710]
M DpCommonParamInit: rdisp/core_file_size = default --> no change
I MtxInit: 30000 0 0
M DpIPCInit2: read dp-profile-values from sys_adm_ext
M DpShMCreate: alloate/attach shared memory (mode=ATTACH)
M DpShMCreate: sizeof(wp_adm) 23184 (1104)
M DpShMCreate: sizeof(tm_adm) 49667904 (247104)
M DpShMCreate: sizeof(ca_adm) 432000 (72)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/7464064/75831 52
M DpShMCreate: sizeof(comm_adm) 7583152 (14912)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (296)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (80)
M DpSockTableSize: max/headSize/ftSize/tableSize=500/16/520064/520080
M DpShMCreate: sizeof(sock_adm) 520080 (1016)
M DpShMCreate: sizeof(vmc_adm) 0 (3208)
M DpShMCreate: sizeof(wall_adm) (ft=41664/fi=67472/hd=64/rec=192)
M DpShMCreate: sizeof(amc_rec_adm) (ft=86464/fi=67472/hd=64/rec=416)
M DpShMCreate: sizeof(websocket_adm) (ft=28864/hd=64/rec=272)
M DpShMCreate: sizeof(gw_adm) 64
M DpShMCreate: sizeof(j2ee_adm) 3936
M DpShMCreate: SHM_DP_ADM_KEY (addr: 00000000104A0050, size: 58627552)
M DpShMCreate: allocated sys_adm at 00000000104A0250
M DpShMCreate: allocated wp_adm_list at 00000000104B1CA0
M DpShMCreate: allocated wp_adm at 00000000104B1FC0
M DpShMCreate: allocated tm_adm_list at 00000000104B7C50
M DpShMCreate: allocated tm_adm at 00000000104B7E90
M DpShMCreate: allocated ca_adm at 0000000013415FD0
M DpShMCreate: allocated comm_adm at 000000001347F950
M DpShMCreate: system runs without slock table
M DpShMCreate: allocated sock_adm at 0000000013BBB100
M DpShMCreate: allocated vmc_adm_list at 0000000013C3A290
M DpShMCreate: system runs without VMC
M DpShMCreate: allocated gw_adm at 0000000013C3A530
M DpShMCreate: allocated j2ee_adm at 0000000013C3A770
M DpShMCreate: allocated ca_info at 0000000013C3B8D0
M DpShMCreate: allocated wall_adm (ft) at 0000000013C3BB10
M DpShMCreate: allocated wall_adm (fi) at 0000000013C45FD0
M DpShMCreate: allocated wall_adm (head) at 0000000013C56960
M DpShMCreate: allocated amc_rec_adm (ft) at 0000000013C56BA0
M DpShMCreate: allocated amc_rec_adm (fi) at 0000000013C6BF60
M DpShMCreate: allocated amc_rec_adm (head) at 0000000013C7C8F0
M DpShMCreate: allocated websocket_adm (ft) at 0000000013C7CB30
M DpShMCreate: allocated websocket_adm (head) at 0000000013C83DF0
M DpShMCreate: initialized 21 eyes
M
M Wed Aug 20 10:38:54 2014
M DpCommAttachTable: attached comm table (header=000000001347F950/ft=000000001347F960/fi=000 0000013B9DDE0)
M DpSockAttachTable: attached sock table (header=0000000013BBB100/ft=0000000013BBB110)
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X <ES> EsILock: use Semphore 33 for locking
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 ThStart: taskhandler started
M ThInit: initializing DIA work process W0
M
M Wed Aug 20 10:38:57 2014
M ThInit: running on host DEV
I MtxInit: 0 0 0
M
M Wed Aug 20 10:38:58 2014
M calling db_connect ...
B Loading DB library 'C:\usr\sap\EC9\DVEBMGS01\exe\dbdb6slib.dll' ...
B Library 'C:\usr\sap\EC9\DVEBMGS01\exe\dbdb6slib.dll' loaded
B Version of 'C:\usr\sap\EC9\DVEBMGS01\exe\dbdb6slib.dll' is "741.10", patchlevel (0.24)
C DbSl trace SM50: switch request to level 1
C Registering callback for dynamic profile parameters
C
C DB6 (DB2 UDB) UNICODE database interface 741.10 [opt]
C
C DB6 shared library (dbdb6slib) patchlevels
C (0.5) 741: system does not start (note 1896684)
C (0.5) DB6: DROP INDEX to DROP CONSTRAINT (note 1911087)
C (0.5) DB6: messages related to SQL_ATTR_DB2TRC_STARTUP_SIZE (note 1836451)
C (0.5) DB6: return fsupply code to caller (note 1226290)
C (0.6) DB6: long running SQL for revalidation (note 1925706)
C (0.12) DB6: Micro outage lazy reconnect (note 1434153)
C (0.14) DB6: slowdown due to SNAP_GET_UTIL on DPF (note 1949164)
C (0.24) DB6: FOR ALL ENTRIES using remote connection (note 1973869)
C
C Supported features:
C
C ..retrieving configuration parameters
C ..done
C DB2 library has been loaded.
C Info: successfully loaded DB2 library 'C:\usr\sap\EC9\DVEBMGS01\exe/db6_clidriver\bin\db2 app64.dll'
C Running with UTF-8 Unicode
C
C Wed Aug 20 10:38:59 2014
C DB2 client driver version '10.05.0003'
C Running with CLI driver.
C
C Wed Aug 20 10:39:52 2014
C *** ERROR in DB6Connect[D:/depot/bas/741_REL/src/dbs/db6/dbdb6. c, 1835] CON = 0 (BEGIN)
C &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL1015N The database is in an inconsistent state. SQLSTATE=5502
C &+ 5
C &+
C &+
C *** ERROR in DB6Connect[D:/depot/bas/741_REL/src/dbs/db6/dbdb6. c, 1835] (END)
C *** ERROR => DbSlConnect to 'EC9' as 'sapec9' failed
[dbdb6.c 1840]
M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 75]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2280]
M
M Info for wp 0
M
M pid = 3816
M severity = 0
M status = 0
M stat = WP_NEW
M waiting_for = NO_WAITING
M workerType = DP_WORKER_DIAWP
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 0
M report = > <
M action = 0
M tab_name = > <
M
M ThIErrHandle: no current incoming request
M
M
M *******
M *
M * LOCATION SAP-Server DEV_EC9_01 on host DEV (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Aug 20 10:39:52 2014
M * RELEASE 741
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 16797709
M * MODULE D:/depot/bas/741_REL/src/krn/si/th/thxxhead.c
M * LINE 2470
M * COUNTER 1
M *
M ********
M
M PfRejectStatistic: clear statistic record
M PfClearAllRec: clear statistic area
M PfClearAllRec: statRecordAction = STAT_RECORD_ACTION_REJECT
M Entering TH_CALLHOOKS
M ThCallHooks: call hooks for event BEFORE_DUMP
M ThIErrHandle: entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workp. 0 3816) [dpnttool.c 335]
Thanks,
Sam |
| Reply to this email to post your response. __.____._ |   _.____.__ |
