Skip to Content
avatar image
Former Member

db2 restor error help

hello,

I am trying to restor sap sysytem with same SID, same OS

at the time of ofline backup

1-create dir in e:/db2/SID/log_archive

2-db2 update db cfg for AXI using LOGARCHMETH1 DISK:E:\db2\SID\log_archive\

3-db2stop force

4-db2start

5-db2 backup database dbname to E:\backup with 3 buffers buffer 1024 parallelism 6 compress without prompting

at the tme of restore

1- login as db2<SID>

2- db2start

3- db2 restore database <SID>    from /<taken backup location>

4- db2 rollforward db  <SID>  to end of logs

5- db2 rollforward db <SID> COMPLETE

6- db2 connect to SIDADM user

for the restoration purpose I used offline backup image

i used system copy target system export method

All above commands are successful but, after restoration when I continu to installation I am facing the error on phase no 15 (grant db privilages)

I using same os & same db2 databse.

please help me to troubleshoot {which step I am missing}

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 08, 2015 at 09:01 AM

    Hello Rohit,

    Please share your OS SAP and DB details ,

    Alos post the installation log for butter understanding,

    Meanwhile you can check the ling

    Thanks

    Sadiq

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I took some errors from sapinst.log file can someone help me

      WARNING[E] 2014-12-09 13:10:52.377

      FSL-06002  Error 1060 (The specified service does not exist as an installed service.

      ) in execution of a 'OpenService' function, line (267), with parameter (SAPHostControl).

      WARNING[E] 2014-12-09 13:26:26.367

      FSL-06002  Error 1060 (The specified service does not exist as an installed service.

      ) in execution of a 'OpenService' function, line (267), with parameter (ClusSvc).

      ERROR 2014-12-09 13:26:29.440

      FSL-03001  Error converting from service name sapdb2PRD, protocol tcp to port number.

      ERROR 2014-12-09 13:26:30.969

      FSL-03001  Error converting from service name DB2_DB2PRD, protocol tcp to port number.

      ERROR 2014-12-09 13:26:30.969

      FSL-03001  Error converting from service name DB2_db2prd, protocol tcp to port number.

      ERROR 2014-12-09 13:26:30.969

      FSL-03001  Error converting from service name DB2_DB2PRD_END, protocol tcp to port number.

      ERROR 2014-12-09 13:26:30.969

      FSL-03001  Error converting from service name DB2_db2prd_END, protocol tcp to port number.

      INFO 2014-12-09 13:26:31.0

      Working directory changed to C:/Program Files/sapinst_instdir/NW702/LM/COPY/DB6/SYSTEM/CENTRAL/AS-ABAP.

      INFO 2014-12-09 13:26:31.16

      Execute step DB6_PortsDialog of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_Ports|ind|ind|ind|ind|2|0

      ERROR 2014-12-09 13:26:31.109

      FSL-03001  Error converting from port number 5912, protocol tcp to service names.

      ERROR 2014-12-09 13:26:31.109

      FSL-03001  Error converting from service name sapdb2PRD, protocol tcp to port number.

      ERROR 2014-12-09 13:26:31.109

      FSL-03001  Error converting from port number 5914, protocol tcp to service names.

      ERROR 2014-12-09 13:26:31.109

      FSL-03001  Error converting from port number 5915, protocol tcp to service names.

      ERROR 2014-12-09 13:26:31.109

      FSL-03001  Error converting from port number 5916, protocol tcp to service names.

      ERROR 2014-12-09 13:26:31.109

      FSL-03001  Error converting from port number 5917, protocol tcp to service names.

      ERROR 2014-12-09 13:26:31.140

      FSL-03001  Error converting from service name DB2_db2prd, protocol tcp to port number.

      ERROR 2014-12-09 13:26:31.140

      FSL-03001  Error converting from service name DB2_db2prd_END, protocol tcp to port number.

      ERROR 2014-12-09 13:26:31.140

      FSL-03001  Error converting from service name DB2_DB2PRD, protocol tcp to port number.

      ERROR 2014-12-09 13:26:31.140

      FSL-03001  Error converting from service name DB2_DB2PRD_END, protocol tcp to port number.

      ERROR 2014-12-30 07:57:10.999

      FCD-00001  The package with name SAPINST was requested but this package is not defined in the packages section of the component. SOLUTION: Contact installation development.

      ERROR 2014-12-30 07:57:11.295

      MUT-03025  Caught ESAPinstException in module call: There exists no package with name SAPINST ..

      ERROR 2014-12-30 07:57:11.498

      FCO-00011  The step AppendRoutineGrants_WLM_95 with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_Privileges|ind|ind|ind|ind|28|0|AppendRoutineGrants_WLM_95 was executed with status ERROR ( Last error reported by the step :The package with name SAPINST was requested but this package is not defined in the packages section of the component. SOLUTION: Contact installation development.).

      INFO 2014-12-30 07:57:11.701

      Creating file C:\Program Files\sapinst_instdir\NW702\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\__instana_tmp.xml.

      INFO 2014-12-30 13:13:59.164

      An error occured and the user decided to retry the current step: "|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_Privileges|ind|ind|ind|ind|28|0|AppendRoutineGrants_WLM_95".

      INFO 2014-12-30 13:13:59.180

      Working directory changed to C:/Program Files/sapinst_instdir/NW702/LM/COPY/DB6/SYSTEM/CENTRAL/AS-ABAP.

      ERROR 2014-12-30 13:13:59.226

      FCD-00001  The package with name SAPINST was requested but this package is not defined in the packages section of the component. SOLUTION: Contact installation development.

      ERROR 2014-12-30 13:13:59.226

      MUT-03025  Caught ESAPinstException in module call: There exists no package with name SAPINST ..

      ERROR 2014-12-30 13:13:59.226

      FCO-00011  The step AppendRoutineGrants_WLM_95 with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_DB6_DB|ind|ind|ind|ind|1|0|NW_DB6_Privileges|ind|ind|ind|ind|28|0|AppendRoutineGrants_WLM_95 was executed with status ERROR ( Last error reported by the step :The package with name SAPINST was requested but this package is not defined in the packages section of the component. SOLUTION: Contact installation development.).

      INFO 2014-12-30 13:14:00.396

      Creating file C:\Program Files\sapinst_instdir\NW702\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\__instana_tmp.xml.

  • Jan 08, 2015 at 01:27 PM

    Hi Rohit,

    Execute db6_update_db.sh script  from the installation directory and subsequent out script and try again.


    Regards, Juan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2015 at 10:31 AM

    Hi Rohit ,

    Is the source and target servers the same .

    Can you post the error screenshot from db2diag

    Thanks ,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      my db2diag file is

      2014-12-07-14.47.03.550000-480 E3250538F528       LEVEL: Info

      PID     : 3036                 TID  : 4036        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 4036                 EDUNAME: db2bm.2320.5 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      17

      DATA #2 : String, 9 bytes

      PRD#DOCUI

      2014-12-07-14.47.06.280000-480 E3251068F531       LEVEL: Info

      PID     : 3036                 TID  : 3876        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3876                 EDUNAME: db2bm.2320.3 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      5

      DATA #2 : String, 12 bytes

      SYSTOOLSPACE

      2014-12-07-14.47.10.711000-480 E3251601F528       LEVEL: Info

      PID     : 3036                 TID  : 3588        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3588                 EDUNAME: db2bm.2320.2 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      24

      DATA #2 : String, 9 bytes

      PRD#LOADD

      2014-12-07-14.47.11.413000-480 E3252131F528       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      25

      DATA #2 : String, 9 bytes

      PRD#LOADI

      2014-12-07-14.47.13.332000-480 E3252661F530       LEVEL: Info

      PID     : 3036                 TID  : 3152        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3152                 EDUNAME: db2bm.2320.4 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      29

      DATA #2 : String, 10 bytes

      PRD#EL702I

      2014-12-07-14.47.14.907000-480 E3253193F527       LEVEL: Info

      PID     : 3036                 TID  : 4036        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 4036                 EDUNAME: db2bm.2320.5 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      26

      DATA #2 : String, 8 bytes

      PRD#CLUD

      2014-12-07-14.47.17.091000-480 E3253722F527       LEVEL: Info

      PID     : 3036                 TID  : 3588        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3588                 EDUNAME: db2bm.2320.2 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      27

      DATA #2 : String, 8 bytes

      PRD#CLUI

      2014-12-07-14.47.18.168000-480 E3254251F523       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      1

      DATA #2 : String, 5 bytes

      ROHIT

      2014-12-07-14.47.18.324000-480 E3254776F528       LEVEL: Info

      PID     : 3036                 TID  : 3876        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3876                 EDUNAME: db2bm.2320.3 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      34

      DATA #2 : String, 9 bytes

      PRD#FACTD

      2014-12-07-14.47.18.324000-480 E3255306F529       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      9

      DATA #2 : String, 10 bytes

      PRD#USER1I

      2014-12-07-14.47.18.480000-480 E3255837F529       LEVEL: Info

      PID     : 3036                 TID  : 3876        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3876                 EDUNAME: db2bm.2320.3 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      8

      DATA #2 : String, 10 bytes

      PRD#USER1D

      2014-12-07-14.47.18.480000-480 E3256368F527       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      33

      DATA #2 : String, 8 bytes

      PRD#DIMI

      2014-12-07-14.47.18.667000-480 E3256897F527       LEVEL: Info

      PID     : 3036                 TID  : 3876        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3876                 EDUNAME: db2bm.2320.3 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      30

      DATA #2 : String, 8 bytes

      PRD#ODSD

      2014-12-07-14.47.18.682000-480 E3257426F527       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      31

      DATA #2 : String, 8 bytes

      PRD#ODSI

      2014-12-07-14.47.18.807000-480 E3257955F527       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      32

      DATA #2 : String, 8 bytes

      PRD#DIMD

      2014-12-07-14.47.18.823000-480 E3258484F528       LEVEL: Info

      PID     : 3036                 TID  : 3876        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3876                 EDUNAME: db2bm.2320.3 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1221

      MESSAGE : Backing up tablespace

      DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes

      35

      DATA #2 : String, 9 bytes

      PRD#FACTI

      2014-12-07-14.47.18.994000-480 E3259014F440       LEVEL: Info

      PID     : 3036                 TID  : 2844        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2844                 EDUNAME: db2bm.2320.1 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1480

      MESSAGE : Finished tablespaces

      2014-12-07-14.47.19.026000-480 E3259456F440       LEVEL: Info

      PID     : 3036                 TID  : 3876        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3876                 EDUNAME: db2bm.2320.3 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1480

      MESSAGE : Finished tablespaces

      2014-12-07-14.47.19.135000-480 E3259898F440       LEVEL: Info

      PID     : 3036                 TID  : 4036        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 4036                 EDUNAME: db2bm.2320.5 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1480

      MESSAGE : Finished tablespaces

      2014-12-07-14.47.19.868000-480 E3260340F440       LEVEL: Info

      PID     : 3036                 TID  : 3152        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3152                 EDUNAME: db2bm.2320.4 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1480

      MESSAGE : Finished tablespaces

      2014-12-07-14.47.20.289000-480 E3260782F440       LEVEL: Info

      PID     : 3036                 TID  : 3588        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 3588                 EDUNAME: db2bm.2320.2 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1480

      MESSAGE : Finished tablespaces

      2014-12-07-14.49.33.326000-480 E3261224F440       LEVEL: Info

      PID     : 3036                 TID  : 2348        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2348                 EDUNAME: db2bm.2320.0 (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubBMCont, probe:1480

      MESSAGE : Finished tablespaces

      2014-12-07-14.49.33.498000-480 E3261666F428       LEVEL: Info

      PID     : 3036                 TID  : 2320        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2320                 EDUNAME: db2agent (PRD) 0

      FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:906

      MESSAGE : Backup complete.

      2014-12-07-14.49.33.576000-480 E3262096F474       LEVEL: Event

      PID     : 3036                 TID  : 2320        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-350                APPID: *LOCAL.DB2PRD.141207224213

      AUTHID  : PRDADM 

      EDUID   : 2320                 EDUNAME: db2agent (idle) 0

      FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000

      STOP    : DATABASE: PRD      : DEACTIVATED: NO

      2014-12-09-13.14.22.511000-480 I3262572F327       LEVEL: Event

      PID     : 3540                 TID  : 3252        PROC : db2start.exe

      INSTANCE: DB2PRD               NODE : 000

      EDUID   : 3252

      FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:21

      DATA #1 : <preformatted>

      Single node instance [0] is starting

      2014-12-09-13.14.22.526000-480 I3262901F1686      LEVEL: Event

      PID     : 3540                 TID  : 3252        PROC : db2start.exe

      INSTANCE: DB2PRD               NODE : 000

      EDUID   : 3252

      FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130

      DATA #1 : String, 44 bytes

      D:\db2\db2prd\db2_software\\bin\DB2STAR2.EXE

      DATA #2 : Hexdump, 256 bytes

      0x00000000001271E0 : 443A 5C64 6232 5C64 6232 7072 645C 6462    D:\db2\db2prd\db

      0x00000000001271F0 : 325F 736F 6674 7761 7265 5C5C 6269 6E5C    2_software\\bin\

      0x0000000000127200 : 4442 3253 5441 5232 2E45 5845 004E 4F4D    DB2STAR2.EXE.NOM

      0x0000000000127210 : 5347 0000 0000 0000 0000 0000 0000 0000    SG..............

      0x0000000000127220 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127230 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127240 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127250 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127260 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127270 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127280 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x0000000000127290 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x00000000001272A0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x00000000001272B0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x00000000001272C0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      0x00000000001272D0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

      2014-12-09-13.14.31.216000-480 I3264589F453       LEVEL: Warning

      PID     : 3036                 TID  : 3648        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-376                APPID: *LOCAL.DB2PRD.141209211424

      AUTHID  : SAPSERVICEPRD

      EDUID   : 3648                 EDUNAME: db2agent (PRD) 0

      FUNCTION: DB2 UDB, relation data serv, sqlrr_db_init, probe:700

      MESSAGE : DB2_IMPLICIT_UNICODE enabled

      2014-12-09-13.14.31.231000-480 E3265044F476       LEVEL: Event

      PID     : 3036                 TID  : 3648        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-376                APPID: *LOCAL.DB2PRD.141209211424

      AUTHID  : SAPSERVICEPRD

      EDUID   : 3648                 EDUNAME: db2agent (PRD) 0

      FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000

      START   : DATABASE: PRD      : ACTIVATED: YES

      2014-12-11-11.50.59.880000-480 I3265522F607       LEVEL: Error

      PID     : 3036                 TID  : 1200        PROC : db2syscs.exe

      INSTANCE: DB2PRD               NODE : 000         DB   : PRD

      APPHDL  : 0-380                APPID: *LOCAL.DB2.141209211435

      AUTHID  : SAPSERVICEPRD

      EDUID   : 1200                 EDUNAME: db2lused (PRD) 0

      FUNCTION: DB2 UDB, database monitor, sqmLastUsedDaemon::main, probe:20

      RETCODE : ZRC=0x870F00B9=-2029059911=SQLO_SEM_TIMEOUT

                "Return code from sqlowait when time out value has been reached"

      DATA #1 : String, 31 bytes

      Last Used Daemon Shutting Down.

  • Jan 13, 2015 at 03:04 PM

    Hi Rohit,

    Did you fix this issue ?

    Is the source and target server names the same . ?

    Can you check SAP KBA "1386320 - DB6: systemcopy backup / restore - SECADM authority"

    Thanks ,

    Manu

    Add comment
    10|10000 characters needed characters exceeded