SPUFI diagnostic panels

When activated, SPUFI diagnostic panels appear on the terminal as SPUFI is run. These panels display significant variable names and their assigned values (if any). These panels can be examined to verify that the information is correct.

About this task

Using this option of the TSO maintenance system to change program variables can disrupt normal SPUFI operation.

Procedure

To use the SPUFI diagnostic panels:

  1. Display the DB2I primary menu (DSNEPRI).
  2. Select OPTION 0, which is not shown on the menu.
  3. Press Enter to pass by the panel that introduces the Db2 TSO MAINTENANCE SYSTEM. The next panel offers choices between several TSO attachment facility tracing mechanisms.
  4. Select the DISPLAY SPUFI option (option 4). Specify any options that you want, such as the SPUFI CSECTs to trace.
  5. With the SPUFI diagnostic panels activated, return to the DB2I primary menu and select the SPUFI option.
  6. On the SPUFI panel, enter the parameters required to execute an SQL statement. At that time, the first diagnostic panel is displayed. A sample of a SPUFI panel (with some of the variables assigned) is shown in the following figure.
  7. Optional: Complete the following steps:
    • Change the display or trace options identified at top.
    • Print a screen image by pressing the PF key that was defined for that purpose (the ISPF print key).
    • Change the displayed panel by altering the last two characters in the field identifying the currently displayed panel. Then, press Enter.

      For example, if the panel name is DSNEXP00, change 00 to some other valid number (20, 21, 30, 55, 56, 70, 80). To execute from the point at which you left off, press Enter.

Results

Figure 1. Sample SPUFI diagnostic panel
DSNEXP55              SPUFI INTERNAL VARIABLE DISPLAY
===>
DSNE599I DSNESM55 - BEGIN EXECUTION
CHANGE DISPLAY OR TRACE OPTIONS BELOW:
 1  TRACE SPUFI   ===> YES                          YES STARTS/CONTINUES TRACE
 2  DISPLAY SPUFI ===> 123      0           0       ENTER 0 TO 99 OR OVER 100
 3  DISPLAY PANEL ===> DSNEXP55                     ENTER SPUFI PANEL NAME
INTERNAL VARIABLES FROM DSNDSEB CONTROL BLOCK:
10  PREFIX ===> H443722    40  ILRCL ===> 80          70  ACTION ===> 4
11  LIB    ===> DSN        41  IVOL  ===>             71  ACODE  ===> 1
12  TYPE   ===> PLS        42  ORCFM ===> FB          72  RCODE  ===> 0
13  MEMB   ===> SPUFIIN    43  XXXXX ===>             73  FLAGS  ===> 000000F4
14  OTHER  ===>
15  OUTPU  ===> SEQ.DS
16  ISTAT  ===> C0         46  OSTAT ===> 00          76  OCLAS  ===> SYSDA
17  IMEMB  ===> SPUFIIN    47  OMEMB ===> ........    77  PGW    ===> 0
18  IDSN   ===> H443722.DSN.PLS                              78 OLRCL   999
19  ODSN   ===> ...........................                  70 OBSIZ   999
20  MODID  ===> DSNESM55                                     80 MSGID ===>
21  DAIRF1 ===> .............................................................
22  DAIRF2 ===> .............................................................
 ............................................................................