R3trans error on startdb for SAP PI 7.11 DB2

[yohanes_purbaya2]

Hi All,

I'm already stuck to solve DB2 issue, this is my first time installing SAP on DB2 on RHEL 5.1 x86_64 to install SAP PI 7.11. The installation is finished and I can login to SAP until restarted the system. While I'm trying to startsap appears the following error:

============================================================================

rhel51pi:piyadm 29> startsap

Checking db6 db Database

-

---

Database is not available via R3trans

Running /usr/sap/PIY/SYS/exe/run/startdb

09/01/2009 18:18:50 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

============================================================================

Then I've tried to stop sap and db2, and starting the command inside the startdb manually

============================================================================

rhel51pi:piyadm 31> $INSTHOME/sqllib/adm/db2start

09/01/2009 18:20:51 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

rhel51pi:piyadm 32> $INSTHOME/sqllib/bin/db2 activate database PIY

DB20000I The ACTIVATE DATABASE command completed successfully.

============================================================================

It doesn't show any error until I run R3trans -x

rhel51pi:piyadm 33> R3trans -x

============================================================================

This is R3trans version 6.19 (release 711 - 22.01.09 - 11:27:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'PIY'"

R3trans finished (0012).

============================================================================

With the following trans.log

============================================================================

4 ETW000 R3trans version 6.19 (release 711 - 22.01.09 - 11:27:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 01.09.2009 - 18:21:57

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Sep 1 18:21:57 2009 128 0.000128

4 ETW000 [dev trc ,00000] db_con_init called 17 0.000145

4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 39 0.000184

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 20 0.000204

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so' ...

4 ETW000 38 0.000242

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so), hdl 0

4 ETW000 254 0.000496

4 ETW000 [dev trc ,00000] Library '/usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so' loaded

4 ETW000 19 0.000515

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so

4 ETW000 19 0.000534

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so' is "710.21", patchlevel (0.20)

4 ETW000 2 0.000536

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so

4 ETW000 2 0.000538

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PIY/SYS/exe/uc/linuxx86_64/dbdb6slib.so

4 ETW000 2 0.000540

4 ETW000 [dev trc ,00000] New connection 0 created 415 0.000955

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000,

con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 67 0.001022

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 122 0.001144

4 ETW000 [dev trc ,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000 94 0.001238

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection:

4 ETW000 72 0.001310

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , timeout = 000,

con_max = 255, con_opt = 255, occ = NO , prog =

4 ETW000 55 0.001365

4 ETW000 [dev trc ,00000] DB2 library has been loaded. 21177 0.022542

4 ETW000 [dev trc ,00000] Info: successfully loaded DB2 library '/usr/sap/PIY/SYS/global/db6/LINUXX86_64/db6_clidriver/lib/libdb2.so'

4 ETW000 72 0.022614

4 ETW000 [dev trc ,00000] RLIMIT_STACK: current=10485760, max=-1 52 0.022666

4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 710.21 [opt]

4 ETW000 25 0.022691

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 34 0.022725

4 ETW000 [dev trc ,00000] (0.3) DB6: patch for VER07781 (note 1226290) 18 0.022743

4 ETW000 [dev trc ,00000] (0.3) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)

4 ETW000 29 0.022772

4 ETW000 [dev trc ,00000] (0.5) DB6: R3load wrong data in tables with STRING columns (note 1226290)

4 ETW000 18 0.022790

4 ETW000 [dev trc ,00000] (0.8) DB6: UR cursor with CC_RELEASE attribute (note 1244963)

4 ETW000 53 0.022843

4 ETW000 [dev trc ,00000] (0.8) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 23 0.022866

4 ETW000 [dev trc ,00000] (0.9) R3load: tables with STRING columns part 2 (note 1226290)

4 ETW000 18 0.022884

4 ETW000 [dev trc ,00000] (0.9) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 18 0.022902

4 ETW000 [dev trc ,00000] (0.18) DB6: patch collection 11/08 (note 1263885)

4 ETW000 23 0.022925

4 ETW000 [dev trc ,00000] (0.18) DB6: patch collection 11/08 (note 1264825)

4 ETW000 24 0.022949

4 ETW000 [dev trc ,00000] (0.20) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 29 0.022978

4 ETW000 [dev trc ,00000] Supported features: 13 0.022991

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 12 0.023003

4 ETW000 [dev trc ,00000] ..done 60 0.023063

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 13 0.023076

4 ETW000 [dev trc ,00000] Running with CLI driver 2157 0.025233

4 ETW000 [dev trc ,00000] DB2 client driver version '09.05.0004' 162034 0.187267

4 ETW000 [dev trc ,00000] Connected to DB2 server type 'DB2/LINUXX8664' 63 0.187330

4 ETW000 [dev trc ,00000] Connected to DB2 version '09.05.0004' 47 0.187377

4 ETW000 [dev trc ,00000] Connect to 'PIY' as 'SAPPIY' schema 'SAPPIY' o.k.; con_hdl=0 ; appl_hdl=12

4 ETW000 146938 0.334315

4 ETW000 [dev trc ,00000] Database code page is ok. 43 0.334358

4 ETW000 [dev trc ,00000] Tue Sep 1 18:21:58 2009 408880 0.743238

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] CON = 0 (BEGIN)

4 ETW000 64 0.743302

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLExtendedPrepare 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0440N No authorized routine named "DB_

4 ETW000 36 0.743338

4 ETW000 [dev trc ,00000] &+ GET_CFG" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

4 ETW000 20 0.743358

4 ETW000 [dev trc ,00000] &+

4 ETW000 52 0.743410

4 ETW000 [dev trc ,00000] &+ SELECT COUNT(*) FROM TABLE( DB_GET_CFG() ) AS X WHERE DBPARTITIONNUM = CURRENT DBPARTITIONNUM AND NAME = 'db_colln

4 ETW000 26 0.743436

4 ETW000 [dev trc ,00000] &+ ame' AND VALUE = 'IDENTITY_16BIT'

4 ETW000 19 0.743455

4 ETW000 [dev trc ,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=40, reopt=0

4 ETW000 29 0.743484

4 ETW000 [dev trc ,00000] &+

4 ETW000 100 0.743584

4 ETW000 [dev trc ,00000] &+

4 ETW000 23 0.743607

4 ETW000 [dev trc ,00000] *** ERROR in prepareStatement[dbdb6.c, 12743] (END)

4 ETW000 19 0.743626

4 ETW000 [dev trc ,00000] Could not check DB2 collating sequence. 39 0.743665

4 ETW000 [dev trc ,00000] disconnected from 'PIY', con_hdl=0, appl_hdl=12 1468 0.745133

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'PIY'"

============================================================================

I'm following the recommendation on OSS 582875 but I though it's not related. But when I'm following OSS 841002 I found another error (Error creating system routine : SYSPROC.DB2LK_DEP_OF):

============================================================================

[db2piy@rhel51pi /]$ db2updv95 -d PIY

_________________________________________________________________________

_____ DB2 Service Tools _____

I B M

db2updv95

This tool is a service utility designed to update a DB2 Version 9.5

database to the current fixpak level.

_________________________________________________________________________

DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007

Licensed Material - Program Property of IBM

IBM DATABASE 2 Database update to current fix pack tool

MESSAGE: Failed to prepare statement

MESSAGE: WARNING: Failed to identify current database release level.

All db2updv95 updates will be made instead of only current fixpak specific updates.

MESSAGE: Error creating system routine : SYSPROC.DB2LK_DEP_OF

db2updv95 processing failed for database 'PIY'.

[db2piy@rhel51pi /]$

============================================================================

Please help.

Thx in adv,

Yan

[Former Member]

check your environment variables like dbms_type and see if you can connect to database manually.

[http://help.sap.com/saphelp_sm32/helpdata/EN/2b/f8993af7700577e10000000a11402f/content.htm]