Former Member

October 14, 2013 Less than a 1 minute read

After db2 restore,sap can start

i have restore my db2 restore use bellow command

db2 restore db QAS taken at 20130926003617.

after that ,i can’t start sap.

prddb:db2qas 94> db2start

10/14/2013 15:02:19 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

prddb:db2qas 94> db2start

10/14/2013 15:02:19 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

prddb:qasadm 56> startsap
Checking db6 Database
Database is not available via R3trans
——————————————-
10/14/2013 15:02:35 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.
Activate database failed
R3trans connect failed
DB startup failed

please send the tracefile /home/qasadm/startsap.trc to support

who can help me?

2 Comments

You must be Logged on to comment or reply to a post.

Frank-Martin Haas

October 14, 2013 at 8:10 am

Run "R3trans -x" and paste trans.log .

Regards

Frank

Jitendra Singh

November 5, 2014 at 5:35 am

Dear Frank,

i have facing the same issue

Please find the trans.log file.

Trace of system startup/check of SAP System ECP on Wed Nov 5 10:39:43 IST 2014

{10:39:43 ## Main() start: @=/usr/sap/ECP/SYS/exe/run/startsap
@(#) $Id: //bas/721_REL/src/krn/startscripts/startsap#4 $
BASENAME=startsap

{10:39:43 ## check_user() start: @=ecpadm
}10:39:43 ## check_user() done

#=0
@=

{10:39:43 ## setPlatform() start
PLATFORM=rs6000_64
}10:39:43 ## setPlatform() done

{10:39:43 ## setPing() start
PING=/usr/sbin/ping
}10:39:43 ## setPing() done

{10:39:43 ## setIfconfig() start
IFCONFIG=
}10:39:43 ## setIfconfig() done

{10:39:43 ## setRootDir() start: @=
USR_SAP=/usr/sap
USR_SAP_SID=/usr/sap/ECP
PROFILE_DIR=/usr/sap/ECP/SYS/profile
DIR_LIBRARY=/usr/sap/ECP/SYS/exe/run
}10:39:43 ## setRootDir() done

{10:39:43 ## setDbUser() start: @=
}10:39:43 ## setDbUser() done

{10:39:43 ## setVHostArray() start
_PROFILES=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx.backup /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.1 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.2 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.3 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.4 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.5 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.6 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.7 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.8 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.BAK /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.backup
_nrProfiles=13

{10:39:43 ## pushVHostsFromProfile() start: @=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx.backup /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.1 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.2 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.3 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.4 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.5 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.6 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.7 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.8 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.BAK /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx.backup
_DUMMY=ECP_ASCS00_wwgeccsbx
_VHOST=wwgeccsbx

   {10:39:43 ## isVHostLocal() start: wwgeccsbx
    VHOST=wwgeccsbx
    _IS_LOCAL=1
   }10:39:43 ## isVHostLocal() done: 1

_DUMMY=ECP_ASCS00_wwgeccsbx.backup
_VHOST=wwgeccsbx.backup

   {10:39:43 ## isVHostLocal() start: wwgeccsbx.backup
    VHOST=wwgeccsbx.backup
    _IS_LOCAL=0
   }10:39:43 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx
_VHOST=wwgeccsbx

   {10:39:43 ## isVHostLocal() start: wwgeccsbx
    VHOST=wwgeccsbx
    _IS_LOCAL=1
   }10:39:43 ## isVHostLocal() done: 1

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.1
_VHOST=wwgeccsbx.1

   {10:39:43 ## isVHostLocal() start: wwgeccsbx.1
    VHOST=wwgeccsbx.1
    _IS_LOCAL=0
   }10:39:43 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.2
_VHOST=wwgeccsbx.2

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.2
    VHOST=wwgeccsbx.2
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.3
_VHOST=wwgeccsbx.3

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.3
    VHOST=wwgeccsbx.3
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.4
_VHOST=wwgeccsbx.4

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.4
    VHOST=wwgeccsbx.4
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.5
_VHOST=wwgeccsbx.5

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.5
    VHOST=wwgeccsbx.5
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.6
_VHOST=wwgeccsbx.6

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.6
    VHOST=wwgeccsbx.6
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.7
_VHOST=wwgeccsbx.7

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.7
    VHOST=wwgeccsbx.7
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.8
_VHOST=wwgeccsbx.8

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.8
    VHOST=wwgeccsbx.8
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.BAK
_VHOST=wwgeccsbx.BAK

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.BAK
    VHOST=wwgeccsbx.BAK
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

_DUMMY=ECP_DVEBMGS01_wwgeccsbx.backup
_VHOST=wwgeccsbx.backup

   {10:39:44 ## isVHostLocal() start: wwgeccsbx.backup
    VHOST=wwgeccsbx.backup
    _IS_LOCAL=0
   }10:39:44 ## isVHostLocal() done: 0

VHOSTS= wwgeccsbx
}10:39:44 ## pushVHostsFromProfile() done

VHOSTS= wwgeccsbx
}10:39:44 ## setVHostArray() done

{10:39:44 ## set_instance() start
_PROFILES=/usr/sap/ECP/SYS/profile/ECP_SCS??_wwgeccsbx
_nrProfiles=1
_Iset_instance=SCS

{10:39:45 ## pushProfiles() start: @=SCS /usr/sap/ECP/SYS/profile/ECP_SCS??_wwgeccsbx
_TEMPINST=SCS??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx
_nrProfiles=1
_Iset_instance=ASCS

{10:39:45 ## pushProfiles() start: @=ASCS /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx
_TEMPINST=ASCS00

   {10:39:45 ## setInstanceDo() start: @=ASCS00 /usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx:
    setInstanceDo: INSTascs=ASCS00:
    setInstanceDo: PROFILEascs=/usr/sap/ECP/SYS/profile/ECP_ASCS00_wwgeccsbx:
    setInstanceDo: INST=ASCS00:
    setInstanceDo: INSTFOUND=1:
   }10:39:45 ## setInstanceDo() done: 1:

}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_ERS??_wwgeccsbx
_nrProfiles=1
_Iset_instance=ERS

{10:39:45 ## pushProfiles() start: @=ERS /usr/sap/ECP/SYS/profile/ECP_ERS??_wwgeccsbx
_TEMPINST=ERS??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_SMDA??_wwgeccsbx
_nrProfiles=1
_Iset_instance=SMDA

{10:39:45 ## pushProfiles() start: @=SMDA /usr/sap/ECP/SYS/profile/ECP_SMDA??_wwgeccsbx
_TEMPINST=SMDA??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx
_nrProfiles=1
_Iset_instance=D?*

{10:39:45 ## pushProfiles() start: @=D?* /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx
_TEMPINST=DVEBMGS01

   {10:39:45 ## setInstanceDo() start: @=DVEBMGS01 /usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx:
    setInstanceDo: INSTdvebmgs=DVEBMGS01:
    setInstanceDo: PROFILEdvebmgs=/usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx:
    setInstanceDo: INST=DVEBMGS01:
    setInstanceDo: INSTFOUND=2:
   }10:39:45 ## setInstanceDo() done: 2:

}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_JC??_wwgeccsbx
_nrProfiles=1
_Iset_instance=JC

{10:39:45 ## pushProfiles() start: @=JC /usr/sap/ECP/SYS/profile/ECP_JC??_wwgeccsbx
_TEMPINST=JC??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_D??_wwgeccsbx
_nrProfiles=1
_Iset_instance=D

{10:39:45 ## pushProfiles() start: @=D /usr/sap/ECP/SYS/profile/ECP_D??_wwgeccsbx
_TEMPINST=D??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_J??_wwgeccsbx
_nrProfiles=1
_Iset_instance=J

{10:39:45 ## pushProfiles() start: @=J /usr/sap/ECP/SYS/profile/ECP_J??_wwgeccsbx
_TEMPINST=J??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_JMS??_wwgeccsbx
_nrProfiles=1
_Iset_instance=JMS

{10:39:45 ## pushProfiles() start: @=JMS /usr/sap/ECP/SYS/profile/ECP_JMS??_wwgeccsbx
_TEMPINST=JMS??
}10:39:45 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_G??_wwgeccsbx
_nrProfiles=1
_Iset_instance=G

{10:39:46 ## pushProfiles() start: @=G /usr/sap/ECP/SYS/profile/ECP_G??_wwgeccsbx
_TEMPINST=G??
}10:39:46 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_TRX??_wwgeccsbx
_nrProfiles=1
_Iset_instance=TRX

{10:39:46 ## pushProfiles() start: @=TRX /usr/sap/ECP/SYS/profile/ECP_TRX??_wwgeccsbx
_TEMPINST=TRX??
}10:39:46 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_W??_wwgeccsbx
_nrProfiles=1
_Iset_instance=W

{10:39:46 ## pushProfiles() start: @=W /usr/sap/ECP/SYS/profile/ECP_W??_wwgeccsbx
_TEMPINST=W??
}10:39:46 ## pushProfiles() done

_PROFILES=/usr/sap/ECP/SYS/profile/ECP_V??_wwgeccsbx
_nrProfiles=1
_Iset_instance=V

{10:39:46 ## pushProfiles() start: @=V /usr/sap/ECP/SYS/profile/ECP_V??_wwgeccsbx
_TEMPINST=V??
}10:39:46 ## pushProfiles() done

NINST=
INSTFOUND=2
NINSTFOUND=0
hasABAP=1
hasJava=0
hasSpecial=1
}10:39:46 ## set_instance() done

{10:39:46 ## prepare() start

{10:39:46 ## set_sapdbhost() start
_PROFILE=/usr/sap/ECP/SYS/profile/ECP_DVEBMGS01_wwgeccsbx
SAPDBHOST=wwgeccsbx
}10:39:46 ## set_sapdbhost() done

{10:39:46 ## set_db_local() start
   VHOST=wwgeccsbx
   set_dblocal: _DB_LOCAL=1
   SAPDBHOST=wwgeccsbx
}10:39:46 ## set_db_local() done: 1

{10:39:46 ## set_db_sid() start: @=1
DB_SID=db6
}10:39:46 ## set_db_sid() done

{10:39:46 ## set_db_running() start
Checking db6 Database

{10:39:46 ## getExePath() start: @=R3trans DVEBMGS01

    {10:39:46 ## set_path() start: @=/usr/sap/ECP/DVEBMGS01/exe
     N_PATH=/usr/sap/ECP/DVEBMGS01/exe
     LIBPATH=/usr/sap/ECP/DVEBMGS01/exe:/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
     O_LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
    }10:39:46 ## set_path() done

_DIR_EXECUTABLE=/usr/sap/ECP/DVEBMGS01/exe

    {10:39:46 ## restore_path() start
     LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
    }10:39:46 ## restore_path() done

    EXEDIR=/usr/sap/ECP/DVEBMGS01/exe
    EXECMD=/usr/sap/ECP/DVEBMGS01/exe/R3trans
   }10:39:46 ## getExePath() done: 0

DBCONNECT_TEST=/usr/sap/ECP/DVEBMGS01/exe/R3trans -d -w

   {10:39:46 ## set_path() start: @=/usr/sap/ECP/DVEBMGS01/exe
    N_PATH=/usr/sap/ECP/DVEBMGS01/exe
    LIBPATH=/usr/sap/ECP/DVEBMGS01/exe:/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
    O_LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
   }10:39:46 ## set_path() done

   {10:39:53 ## restore_path() start
    LIBPATH=/usr/sap/ECP/SYS/exe/run:/usr/sap/ECP/SYS/exe/uc/rs6000_64
   }10:39:53 ## restore_path() done

   Database is not available via R3trans
   DB_RUNNING=0
   JDB_RUNNING=
}10:39:53 ## set_db_running() done: 0

{10:39:53 ## set_sapjdbhost() start
SAPJDBHOST=wwgeccsbx
}10:39:53 ## set_sapjdbhost() done

{10:39:53 ## set_jdb_local() start
   VHOST=wwgeccsbx
   set_jdb_local: _JDB_LOCAL=1
   SAPJDBHOST=wwgeccsbx
}10:39:53 ## set_jdb_local() done: 1

{10:39:53 ## set_jdb_running() start
   JDB_RUNNING=0
   _INST=
   _PROFILE=
   SAPSYSTEMNAME=ECP
}10:39:53 ## set_jdb_running() done: 0

}10:39:53 ## prepare() done

DB_LOCAL=1
DB_RUNNING=0
hasABAP=1
hasJava=0
hasSpecial=1
TASK=ALL

{10:39:53 ## Database() start: @=start

{10:39:53 ## getExePath() start: @=startdb
EXEDIR=/usr/sap/ECP/SYS/exe/run
EXECMD=/usr/sap/ECP/SYS/exe/run/startdb
}10:39:53 ## getExePath() done: 0

Running /usr/sap/ECP/SYS/exe/run/startdb
DB startup failed

Exit code 5

REgards

Jitendra Singh

8800766770

After db2 restore,sap can start

Assigned Tags