PH15782: DSN1SDMP DOES NOT ACCEPT DASH IN THE START TRACE COMMAND FOR WORKSTATION PARAMETER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Use codes a dash ( - ) in the workstation name qualified in
  the START TRACE command in DSN1SDMP and it is regected with an
  INVALID CHARACTER message.  The same dash in the real START
  TRACE command is accepted.  Also, the workstation name, which
  is entered with lower case characters, is displayed in all CAPS
  during a DISPLAY TRACE.
  

Local fix

• Use a wildcard character in place of the dash if the semantics
  allows.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of DSN1SDMP where     *
  *                 the START TRACE command contains a trace     *
  *                 parameter with a dash in the constraint or   *
  *                 filtering block.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: During the processing of a DSN1SDMP     *
  *                      utility control statement, the          *
  *                      START TRACE section can contain valid   *
  *                      dashes (-) in the constraint and        *
  *                      filtering blocks. This causes the       *
  *                      parsing of the utility control          *
  *                      statement to fail.                      *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  The utility DSN1SDMP is a tool to capture current values
  of a particular SQL statement and produce a dump when the
  condition is found.
  .
  The DSN1SDMP requires a START TRACE command to process and
  filter the corresponding threads so it can capture the values
  intended.
  .
  During the normal parsing of the utility control statement,
  optional START TRACE parameter constraint values were not
  considered valid because dashes (-) were not accepted in the
  parsing of the utility.
  .
  Once such example is below for the START TRACE section:
  
  START TRACE=P CLASS(32) IFCID(340) DEST(SMF)
     WRKSTN('CG-Gb7-p7001A-GB7')
  .
  The preceding text in the utility control statement would
  result in a syntax error as reported. Now, DB2 code has been
  changed to accept dashes in the contraint.
  

Problem conclusion

• DB2 and DSN1SDMP parsing has been modified to accept dashes
  in the START TRACE constraint block.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI66207 UI66208

Modules/Macros

•    DSN1SPAR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI66208

     UP19/11/08 P F911

• RC10 PSY UI66207

     UP19/11/06 P F911

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.