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


dfhtk2t.html | Timestamp icon Last updated: Monday, 5 June 2017