Skip to Content
0
Former Member
Apr 22, 2009 at 05:51 PM

SQL0430N in R3trans -d, dbsl can't connect to database! help!

272 Views

ECC 6 ABAP

kernel 700 non-unicode patch 190

DB2 for LUW 9.1 fp 3

Pre SR3 style kernel set-up (executables in /usr/sap/SID/SYS/exe/run)

No client, db2 runtime instance used.

I stopped SAP but left database up.

Ran Unicode Export of Central ABAP system.

Ran target create on another host.

SAP on the source host has not been up since the export ran.

Now I want to repeat the export, but DBSL can no longer connect to the database

(R3load -testconnect fails, but it doesn't tell me much)

R3trans -d also fails ... the trans.log trace shows

4 ETW000 [dev trc ,00000] *** ERROR in DB6Fetch[dbdb6.c, 3602] CON = 0 (BEGIN) 21 4.056848

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLFetch ): [IBM][CLI Driver][DB2/AIX64] SQL0430N User defined function "SYSPROC.REG

LISTVARIABL

4 ETW000 22 4.056870

4 ETW000 [dev trc ,00000] &+ ES" (specific name "REG_LIST_VARIABLES") has abnormally terminated. SQLSTATE=38503

4 ETW000 21 4.056891

4 ETW000 [dev trc ,00000] &+

4 ETW000 20 4.056911

4 ETW000 [dev trc ,00000] &+ SELECT COUNT(*) FROM TABLE( REG_LIST_VARIABLES() ) AS X WHERE REG_VAR_NAME = 'DB2_WORKLOAD' AND UPPER

( REG_VAR_VAL

4 ETW000 34 4.056945

4 ETW000 [dev trc ,00000] &+ UE ) = 'SAP'

4 ETW000 21 4.056966

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

0, reopt=0

4 ETW000 24 4.056990

4 ETW000 [dev trc ,00000] &+

4 ETW000 20 4.057010

4 ETW000 [dev trc ,00000] &+ Output SQLDA:

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

0, reopt=0

4 ETW000 24 4.056990

4 ETW000 [dev trc ,00000] &+

4 ETW000 20 4.057010

4 ETW000 [dev trc ,00000] &+ Output SQLDA:

4 ETW000 21 4.057031

4 ETW000 [dev trc ,00000] &+ 1 CT=LONG T=INTEGER L=4 P=4 S=0

4 ETW000 515 4.057546

4 ETW000 [dev trc ,00000] &+

4 ETW000 21 4.057567

4 ETW000 [dev trc ,00000] &+

4 ETW000 20 4.057587

4 ETW000 [dev trc ,00000] *** ERROR in DB6Fetch[dbdb6.c, 3602] (END) 13 4.057600

4 ETW000 [dev trc ,00000] Could not check DB2 registry settings. 9834 4.067434

Any Ideas? How do "User defined functions" work?

Ken Chamberlain

University of Toronto