cancel
Showing results for 
Search instead for 
Did you mean: 

error in connecting database

Former Member
0 Kudos

my sap is ecc 7 ehp 1   adn Db is db2 in windows. i restored data from tape to server .

its completed sucess fully but sap is not getting up..

logs of dev_W0

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

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

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        RSP

M systemid   562 (PC with Windows NT)

M relno      7200

M patchlevel 0

M patchno    300

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    D:\usr\sap\RSP\SYS\profile\RSP_DVEBMGS00_rsclides

M pid        712

M

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

M  length of sys_adm_ext is 588 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 712) [dpxxdisp.c   1377]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm)                    76976          (2264)

M  DpShMCreate: sizeof(tm_adm)                    5517056          (27448)

M  DpShMCreate: sizeof(wp_ca_adm)                    64000          (64)

M  DpShMCreate: sizeof(appc_ca_adm)          64000          (64)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/1384064/1384080

M  DpShMCreate: sizeof(comm_adm)                    1384080          (2744)

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  DpShMCreate: sizeof(vmc_adm)                    0          (2152)

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

M  DpShMCreate: sizeof(gw_adm)          48

M  DpShMCreate: sizeof(j2ee_adm)          3952

M  DpShMCreate: SHM_DP_ADM_KEY                    (addr: 0000000007D50050, size: 7208880)

M  DpShMCreate: allocated sys_adm at 0000000007D50060

M  DpShMCreate: allocated wp_adm_list at 0000000007D53070

M  DpShMCreate: allocated wp_adm at 0000000007D53260

M  DpShMCreate: allocated tm_adm_list at 0000000007D65F20

M  DpShMCreate: allocated tm_adm at 0000000007D65F70

M  DpShMCreate: allocated wp_ca_adm at 00000000082A8E80

M  DpShMCreate: allocated appc_ca_adm at 00000000082B8890

M  DpShMCreate: allocated comm_adm at 00000000082C82A0

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 000000000841A140

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 000000000841A1F0

M  DpShMCreate: allocated j2ee_adm at 000000000841A230

M  DpShMCreate: allocated ca_info at 000000000841B1B0

M  DpShMCreate: allocated wall_adm at 000000000841B240

M  DpCommAttachTable: attached comm table (header=00000000082C82A0/ft=00000000082C82B0)

M  DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

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

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X Thu Oct 25 23:05:58 2012

X  <ES> client 0 initializing ....

X  <ES> EsILock: use spinlock 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  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M  ThStart: taskhandler started

M  rdisp/thsend_mode : -1 -> 0

M  ThInit: initializing DIA work process W0

M Thu Oct 25 23:06:02 2012

M  ThInit: running on host rsclides

M Thu Oct 25 23:06:03 2012

M  calling db_connect ...

B  Loading DB library 'D:\usr\sap\RSP\DVEBMGS00\exe\dbdb6slib.dll' ...

B  Library 'D:\usr\sap\RSP\DVEBMGS00\exe\dbdb6slib.dll' loaded

B  Version of 'D:\usr\sap\RSP\DVEBMGS00\exe\dbdb6slib.dll' is "720.00", patchlevel (0.211)

C  DbSl trace SM50: switch request to level 1

C  Registering callback for dynamic profile parameters

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

C  DB6 shared library (dbdb6slib) patchlevels

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

C    (0.71) DB6: SQL0301N after LONG to LOB conversion (note 1524339)

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

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

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

C    (0.92) Secondary connection to HANA (note 1481256)

C    (0.104) DB6: collection of network statistics (note 1625157)

C    (0.105) DB6: refresh connection infos on seamless failover (note 1629682)

C    (0.112) DB6: Galileo patch collection (note 1649831)

C    (0.120) DB6: reexecution of DELETE statement fails (note 1672007)

C    (0.200) Take care of warnings during database connect (note 1600066)

C    (0.210) DB6: isolation RS for select in INDX type cluster tables (note 1678935)

C    (0.211) DB6: Global Compression Option (note 1690077)

C  Supported features:

C  ..retrieving configuration parameters

C  ..done

C Thu Oct 25 23:06:04 2012

C  DB2 library has been loaded.

C  Info: successfully loaded DB2 library 'D:\usr\sap\RSP\DVEBMGS00\exe/db6_clidriver\bin\db2app64.dll'

C  Running with UTF-8 Unicode

C Thu Oct 25 23:06:05 2012

C  Running with CLI driver.

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

C  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1117N  A connection to or activation of database "RSP" cannot b

C  &+     e made because of ROLL-FORWARD PENDING.  SQLSTATE=57019                                                          

C  &+                                                                                                                      

C  &+                                                                                                                      

C  *** ERROR in DB6Connect[dbdb6.c, 1806] (END)

C  *** ERROR => DbSlConnect to 'RSP' as 'saprsp' failed

[dbdb6.c      1811]

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

M  in_ThErrHandle: 1

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

M  Info for wp 0

M    pid = 712

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 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  ThIErrHandle: current request:

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -   

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

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

M  *

M  *  LOCATION    SAP-Server rsclides_RSP_00 on host rsclides (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Thu Oct 25 23:06:05 2012

M  *  RELEASE     720

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        11610

M  *  COUNTER     1

M  *

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

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M  ThIErrHandle: 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 (Workp. 0 712) [dpnttool.c   339]

please give me the solution with step by step procedure .. bz i am not expert in DB2

reply asap

arun

Accepted Solutions (0)

Answers (3)

Answers (3)

premsukh_bishnoi
Contributor
0 Kudos

Hello Arun,

Could you please check that your database is up and running.

Command to check:

with db2<sid>

db2 connect to SID

Also you can issue R3trans -d with sidadm user.

  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1117N  A connection to or activation of database "RSP" cannot b

C  &+     e made because of ROLL-FORWARD PENDING. 

As per Error i am suspecting that database is restored but still ROLL-FORWARD PENDING.

For more error please check db2diag.log file.

Regards, Premsukh Bishnoi


Benny
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear Arun,

the SCN is not a forum for ordering free technical consulting. It is a collaborative community where people voluntarily help you to understand things better in the SAP world. As you obviously need some more understanding of this, I recommend to read the useful Blog "Asking Good Questions in the SCN Discussion Spaces will help you get Good Answers" next and first learn the principles of this before asking any more question.

Formulations like "answer asap" and "please send step by step description" are easily interpreted as orders to people who offer help for nothing more but the satisfaction to being helpful.

Thank you for taking more time to understand community help.

Regards,

Benny

anja_engelhardt2
Active Contributor
0 Kudos

moved to SAP NetWeaver Application Server by moderator