Debugging of SQL procedures on zOS

Debugging of SQL procedures on zOS

 

  

I am trying to setup debugging for a developers of SQL procedures that
run on zOS. We are using UDB V8 fixpak 12 Development Center on the
workstations, with DB2 V8, zOS 1.6 on the mainframe.



I have had the debug tools installed on the mainframe, and followed the
setup instructions I can find, but I am getting an LE error whenever I
try to run in debug mode. The error occurs in trying to run the
procedure db2debug.create_session, and it indicates that there is a
missing module. I have pasted the abend info below.



Has anyone actually gotten this to work? Any pointer you could give
would be appreciated.





+CEE0374C CONDITION=CEE3201S TOKEN=00030C81 59C3C5C5 00000000

WHILE RUNNING PROGRAM UNKNOWN

AT THE TIME OF INTERRUPT

PSW 078D2400 80000002

GPR 0-3 1E2AD028 9E19A642 00000000 00000000

GPR 4-7 00000000 00000000 1DCA1680 1E2AE478

GPR 8-B 1DCA16A0 00000000 1DCC1C18 9DCCBCF0

GPR C-F 1DC9B868 1DCA17D8 00000000 00000000

IEA995I SYMPTOM DUMP OUTPUT 182

USER COMPLETION CODE=4083 REASON CODE=00000003

TIME=07.24.43 SEQ=00064 CPU=0000 ASID=001B

PSW AT TIME OF ERROR 078D1400 9DB5E0E0 ILC 2 INTC 0D

ACTIVE LOAD MODULE ADDRESS=1DA712A0 OFFSET=000E

NAME=CEEPLPKA

DATA AT PSW 1DB5E0DA - 00181610 0A0D9500 C39D4770

GR 0: 00000000_84000000 1: 00000000_84000FF3

2: 00000000_00006D00 3: 00000000_1DC96E60

4: 00000000_00000000 5: 00000000_1DC985A0

6: 00000000_1DCA17D8 7: 00000000_00000000

8: 00000000_1DC98358 9: 00000000_00000003

A: 00000000_1DCC1C18 B: 00000000_9DB5D3E8

C: 00000000_1DC9B868 D: 00000000_1DC97460

E: 00000000_9DB5E0CE F: 00000003_00000003

END OF SYMPTOM DUMP





Michael Barton

Application Analyst - Level 2

Bally Technologies

950 Sandhill Road

Reno, NV 89521

(702) 584-6522 office

(775) 338-6552 cell

(775) 336-2432 fax




DB2 & UDB email list listserv db2-l LazyDBA home page