Skip to Content

Error After DB2 upgrade 9.7 to 10.5

After the upgrade of database from 9.7 to 10.5 , below error may occur while starting SAP,

<hostname>:<SID>adm:/home/<SID>adm> startsap
Checking db6 Database
Database is not available via R3trans
——————————————-
05/20/2015 19:00:48 0 0 SQL1063N DB2START processing was
successful.
SQL1063N DB2START processing was successful.
Activate database failed
exec(): 0509-036 Cannot load program db2 because of the following
errors:
0509-130 Symbol resolution failed for
/usr/sap/<SID>/SYS/exe/run/libdb2.a[shr_64.o] because:
0509-136 Symbol ossIfcFreeMem (number 2554) is not exported
from
dependent module
/usr/opt/db2_10_5/fp5/lib64/libdb2osse_db2.a[shr_64.o].
0509-136 Symbol ossIfcGetConfig (number 2556) is not
exported from
dependent module
/usr/opt/db2_10_5/fp5/lib64/libdb2osse_db2.a[shr_64.o].
0509-136 Symbol ossIfcGetNextInterface (number 2558) is not
exported from
dependent module
/usr/opt/db2_10_5/fp5/lib64/libdb2osse_db2.a[shr_64.o].
0509-136 Symbol ossOpenInstanceList__FPcPPvCb (number 2719)
isnot exported from
dependent module
/usr/opt/db2_10_5/fp5/lib64/libdb2genreg.a[shr_64.o].
0509-026 System error: Error 0
0509-192 Examine .loader section symbols with the
‘dump -Tv’ command.
*** ERROR: Database Configuration for DB ‘<SID>’ cannot be queried
Starting Startup Agent sapstartsrv
OK
Instance Service on host <hostname> started
——————————————-
starting SAP Instance DVEBMGS00
Startup-Log is written to /home/<SID>adm/startsap_DVEBMGS00.log
——————————————-
/usr/sap/<SID>/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function
Start
Instance on host <hostname> started

The startsap calls startdb script.  After upgrading to DB2 10 the scripts has to be replaced,

So we need to download the OSS Note :1734769 where script startdbdb6(ABAP)

and startj2eedbdb6( JAVA) are attached , download both the script and rename as startdb and startdbdb6

( SAP note fails to describe the renaming part) (backup first the old scripts, for example startdb_old, startj2eedb_old)

and now replace to /usr/sap/ <SID>/SYS/exe and try starting SAP issue should not come,

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