Execution Diagnostic Facility (EDF) for CICS DB2
The CICS® DB2® task-related user exit, DFHD2EX1, is enabled with the FORMATEDF keyword and is called by CICS to format the screen for SQL API requests when the transaction is being run under EDF.
In EDF mode, the CICS DB2 attachment facility:
- Stops on every EXEC SQL command and deciphers the SQL statement showing it in a file on the panel
- Shows the results before and after SQL calls are processed
- Displays the following:
- The type of SQL statement.
- Any input and output variables.
- The contents of the SQLCA.
- Primary and secondary authorization IDs. (This helps diagnose SQLCODE -922.)
An EDF panel displays a maximum of 55 variables, which is about ten screens. Each EDF SQL session requires 12KB of CICS temporary storage, which is freed on exit from EDF.
EDF screens for SQL statements are shown in Figure 1, and Figure 2.
Figure 1. EDF example of the "before" SQL EXEC panel
TRANSACTION: XC05 PROGRAM: TESTC05 TASK:0000097 APPLID: CICS41 DISPLAY:00
STATUS: ABOUT TO EXECUTE COMMAND
EXEC SQL OPEN
DBRM=TESTC05, STMT=00221, SECT=00001
OFFSET: X'001692' LINE: UNKNOWN EIBFN=X'0E0E'
ENTER:
PF1 : UNDEFINED PF2 : UNDEFINED PF3 : UNDEFINED
PF4 : PF5 : PF6 :
PF7 : PF8 : PF9 :
PF10: PF11: UNDEFINED PF12:
Figure 2. EDF example of the "after" SQL EXEC
panel
TRANSACTION: XC05 PROGRAM: TESTC05 TASK:0000097 APPLID: CICS41 DISPLAY:00
STATUS: COMMAND EXECUTION COMPLETE
CALL TO RESOURCE MANAGER DSNCSQL
EXEC SQL OPEN P.AUTH=SYSADM , S.AUTH=
PLAN=TESTC05, DBRM=TESTC05, STMT=00221, SECT=00001
SQL COMMUNICATION AREA:
SQLCABC = 136 AT X'03907C00'
SQLCODE = -923 AT X'03907C04'
SQLERRML = 070 AT X'03907C08'
SQLERRMC = ' ACCESS,00000000,00000000, '... AT X'03907C0A'
SQLERRP = 'DSNAET03' AT X'03907C50'
SQLERRD(1-6) = 000, 000, 00000, 0000000000, 00000, 000 AT X'03907C58'
SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _' AT X'03907C70'
SQLSTATE = 57015 AT X'03907C7B'
OFFSET: X'001692' LINE: UNKNOWN EIBFN=X'0E0E'
ENTER: CONTINUE
PF1 : UNDEFINED PF2 : UNDEFINED PF3 : END EDF SESSION
PF4 : SUPPRESS DISPLAYS PF5 : WORKING STORAGE PF6 : USER DISPLAY
PF7 : SCROLL BACK PF8 : SCROLL FORWARD PF9 : STOP CONDITIONS
PF10: PREVIOUS DISPLAY PF11: UNDEFINED PF12: ABEND USER TASK