Activating the SPUFI trace facility

The SPUFI trace stream consists of trace messages sent to the ISPF LOG. Also appearing in the ISPF LOG are messages from the ISPF trace facility.

Procedure

To activate the SPUFI trace facility:

  1. Invoke 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 displays several TSO attachment facility tracing mechanisms.
  4. Enter YES by the TRACE SPUFI option. The trace messages issued during the execution of SQL statements (in an input file) are written to the ISPF LOG.
  5. Use the ISPF browse LOG option to review the SPUFI trace messages.

    For more information about the ISPF browse LOG option and other ISPF commands, refer to the z/OS® ISPF program reference publication.

  6. To save the LOG, specify the KEEP option on the ISPF panel displayed when the session is terminated.
    The SPUFI trace messages provide a high-level view of the processing events. This list describes significant factors to be aware of while reviewing the ISPF LOG and the SPUFI trace messages it contains.
    • At the beginning of the ISPF LOG is the following message:
      START OF ISPF LOG - - - - - SESSION # nnn --------
      where nnn is the number of the session.
    • Each subsequent message relates to some significant aspect of the processing involved in that session.
    • The entries in the left column indicate the time (in minutes and seconds) that each corresponding trace message was issued.
    • To the right of the time of the message is the message identifier itself; each SPUFI trace message begins with DSNE.
    • To the right of the message identifier for most of the SPUFI messages is the name of the CSECT that issued the trace message; the names of each of these CSECTs are in the format:
      DSNESMxx
      where xx are numbers between 0 and 99 that uniquely identify the CSECT.
    • The right column of the ISPF LOG describes what was happening when the message was issued.
    • If processing completes normally, the end of the ISPF LOG shows this final ISPF message:
      END OF ISPF LOG - - - - - - SESSION # nnn --------
      where nnn is the number of the session.
    • If an abend occurs during the session, the SPUFI trace messages are interrupted, and one or more TSO or ISPF error messages are printed at the bottom of the ISPF LOG. These error messages indicate the abend completion code and other pertinent information.

Example

Figure 1. Sample TSO attachment facility SPUFI trace messages. SPUFI trace messages are written to the ISPF LOG.
16:13    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 64
16:13    - DSNE420I  DSNESM30  LOOPTOP
16:13    - DSNE445I  DSNESM30  TYPE IS INTEGER OR SMALL INTEGER
16:13    - DSNE446I  DSNESM30  BEFORE CONVERSION
16:13    - DSNE447I  DSNESM30  AFTER CONVERSION
16:13    - DSNE449I  DSNESM30  NO TRUNCATION OCCURRED
16:13    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 70
16:13    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 72
16:13    - DSNE420I  DSNESM30  LOOPTOP
16:14    - DSNE445I  DSNESM30  TYPE IS INTEGER OR SMALL INTEGER
16:14    - DSNE446I  DSNESM30  BEFORE CONVERSION
16:14    - DSNE447I  DSNESM30  AFTER CONVERSION
16:14    - DSNE449I  DSNESM30  NO TRUNCATION OCCURRED
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 80
16:14    - DSNE599I  DSNESM22  - BEGIN EXECUTION
16:14    - DSNE812I  DSNESM22  ABOUT TO WRITE A LINE OF OUTPUT
16:14    - DSNE812I  DSNESM22  ABOUT TO WRITE A LINE OF OUTPUT
16:14    - DSNE581I  DSNESM22  - END EXECUTION 0
16:14    - DSNE404I  DSNESM30  EXITED
16:14    - DSNE820I  DSNESM68  - BEGIN EXECUTION
                                - SQL REQUEST = FETCH
16:14    - DSNE821I  DSNESM68  - END EXECUTION -
                                - SQLCODE = 00000000
16:14    - DSNE403I  DSNESM30  ENTERED
16:14    - DSNE409I  DSNESM30  BEFORE MAIN LOOP
16:14    - DSNE420I  DSNESM30  LOOPTOP
16:14    - DSNE453I  DSNESM30  TYPE IS CHAR, VARCHAR, or LVARCHAR
16:14    - DSNE449I  DSNESM30  NO TRUNCATION OCCURRED
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 8
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 20
16:14    - DSNE420I  DSNESM30  LOOPTOP
16:14    - DSNE425I  DSNESM30  TYPE IS CHARACTER
16:14    - DSNE449I  DSNESM30  NO TRUNCATION OCCURRED
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 28
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 30
16:14    - DSNE420I  DSNESM30  LOOPTOP
16:14    - DSNE420I  DSNESM30  LOOPTOP
16:14    - DSNE425I  DSNESM30  TYPE IS CHARACTER
16:14    - DSNE449I  DSNESM30  NO TRUNCATION REQUIRED
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 31
16:14    - DSNE454I  DSNESM30  LEAVE YSTUFBUF WITH RBUFU NOW = 36