Retrieving EID descriptions

SQL can be used to retrieve the EID descriptions in whatever format or order that is required. The SQL statements can be run as would any other SQL (for example, through SPUFI, QMF, or DSNTEP2).

About this task

Begin program-specific programming interface information.

Some sample SQL statements follow that might be useful in analyzing the Db2 global trace. Consider printing a formatted report of the results from the first query as a reference. Be aware, however, that this information is licensed. The terms and conditions of the licensing agreement, as stated at the beginning of the file, apply to any hardcopy that is generated.

Procedure

  • To retrieve all EID descriptions, ordered numerically by RMID:
    SELECT DISTINCT *
         FROM DSN8B10.EID_DESCRIPTIONS
         ORDER BY SEQ;
  • To retrieve only the EID descriptions for RMID 04-04:
    SELECT DISTINCT *
         FROM DSN8B10.EID_DESCRIPTIONS
         WHERE RMID = 'AGREE' OR RMID = '04-04'
         ORDER BY SEQ;
  • To retrieve only the EID description for EID 10-0A:
    SELECT DISTINCT *
         FROM DSN8B10.EID_DESCRIPTIONS
         WHERE RMID = 'AGREE' OR EID = '10-0A'
         ORDER BY SEQ;
  • To retrieve only the EID descriptions for CSECT DSNICFLD:
    SELECT DISTINCT *
         FROM DSN8B10.EID_DESCRIPTIONS
         WHERE RMID = 'AGREE' OR CSECT = 'DSNICFLD'
         ORDER BY SEQ;
  • To retrieve only the EID description for EID 3376-0D30 in RMID 21-15:
    SELECT DISTINCT *
         FROM DSN8B10.EID_DESCRIPTIONS
         WHERE EID = 'AGREE' OR
         (RMID = '21-15' AND EID = '3376-0D30')
         ORDER BY SEQ;

    End program-specific programming interface information.