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:

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 51, and Figure 52.

Figure 51. 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 52. 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

Related tasks
Execution diagnostic facility (EDF)

Related concepts
Problem determination for CICS DB2
Thread TCBs (task control blocks)
Wait types for CICS DB2
Messages for CICS DB2
Trace for CICS DB2
Dump for CICS DB2
DB2 thread identification
Transaction abend codes for CICS DB2
Handling deadlocks in the CICS DB2 environment
[[ Contents Previous Page | Next Page Index ]]