SEO

Dear all,

On 2 PCs with V8 FP3 installed (W2K), I have found that when
DB2ROUTINE_DEBUG=ON, you cannot build or debug SQL/PSM procs:

2003-09-10-21.24.52.265001 InstanceB2 Node:000
PID:1360(db2syscs.exe) TID:1000 Appid:*LOCAL.DB2.00C240192450
relation data serv sqlrr_fetch Probe:10 Database:SAMPLE

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x80120086".

2003-09-10-21.24.52.328000 InstanceB2 Node:000
PID:1040(db2fmp.exe) TID:1544 Appid:none
DRDA Application Requester sqljrReportServerErrReply Probe:20

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x80370086".

PID:1040 TID:1544 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 7
sqlerrmc: 0x1245
sqlerrp : sqljrerm?
sqlerrd : (1) 0x80370086 (2) 0x00000086 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

PID:1040 TID:1544 Node:000 Title: **** DRDA ARCB ****
Dump File:I:\SQLLIB\DB2\10401544.000

PID:1040 TID:1544 Node:000 Title: **** AR REQUEST LIST ****
Dump File:I:\SQLLIB\DB2\10401544.000

PID:1040 TID:1544 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:I:\SQLLIB\DB2\10401544.000

PID:1040 TID:1544 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:I:\SQLLIB\DB2\10401544.000

PID:1040 TID:1544 Node:000 Title: **** SEND BUFFERS ****
Dump File:I:\SQLLIB\DB2\10401544.000

PID:1040 TID:1544 Node:000 Title: **** AR UCINTERFACE ****
Dump File:I:\SQLLIB\DB2\10401544.000

2003-09-10-21.24.52.484000 InstanceB2 Node:000
PID:1040(db2fmp.exe) TID:1544 Appid:none
base sys utilities sqleGetSQLError Probe:10

SQL Error:

0x0012EF20 : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI Driver
0x0012EF30 : 5D20 5351 4C33 3030 3230 4E20 4C27 6578 ] SQL30020N L'ex
0x0012EF40 : E963 7574 696F 6E20 6120 E963 686F 75E9 écution a échoué
0x0012EF50 : 2065 6E20 7261 6973 6F6E 2064 2775 6E65 en raison d'une
0x0012EF60 : 2065 7272 6575 7220 6465 2070 726F 746F erreur de proto
0x0012EF70 : 636F 6C65 2072 E970 6172 7469 2071 7569 cole réparti qui
0x0012EF80 : 2065 6D70 EA63 6865 7261 206C 6120 626F empêchera la bo
0x0012EF90 : 6E6E 6520 6578 E963 7574 696F 6E20 6465 nne exécution de
0x0012EFA0 : 7320 636F 6D6D 616E 6465 7320 6574 2069 s commandes et i
0x0012EFB0 : 6E73 7472 7563 7469 6F6E 7320 5351 4C20 nstructions SQL
0x0012EFC0 : 7375 6976 616E 7465 732E 2043 6F64 6520 suivantes. Code
0x0012EFD0 : 616E 6F6D 616C 6965 2022 3078 3132 3435 anomalie "0x1245
0x0012EFE0 : 222E 2020 5351 4C53 5441 5445 3D35 3830 ". SQLSTATE=580
0x0012EFF0 : 3039 0D0A 09..

2003-09-10-21.24.52.484001 InstanceB2 Node:000
PID:1040(db2fmp.exe) TID:1544 Appid:none
base sys utilities sqlePrepareDebugger Probe:100

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFF8ABC".

2003-09-10-21.24.52.500000 InstanceB2 Node:000
PID:1040(db2fmp.exe) TID:1544 Appid:none
routine_infrastructure sqlerFmpListener Probe:500

DIA8004C A cursor is still active, file token "".
ZRC=0x00000004

From the Development Center side, you end up with:

DB2ADMIN.SQL1 - La construction a démarré.
Création de procédure mémorisée - Code retour -1131.
[IBM][CLI Driver][DB2/NT] SQL1131N Un processus DARI (procédure mémorisée)
s'est terminé de manière anormale. SQLSTATE=38503

DB2ADMIN.SQL1 - La construction a échoué.
DB2ADMIN.SQL1 - L'annulation a abouti.


Is there any workaround to be able to use both SQL and Java Procs with
integrated / distributed debugger ?

Thanks.

Jean-Marc