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