PK15051: U.R OR UTL/UTIL COMMAND AND RUNSTATS WITH COLGROUP MISSING RNPRIN01 DDNAME RESULTS IN DSNU047I DSNUSDRB MESSAGE RC=08

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The U.R or UTIL line command with RUNSTATS and COLGROUP option
  generates incorrect JCL as the RNPRIN01 ddname is missing.
  
  When run the job fails with a message:
  DSNU047I    DSNUSDRB - A REQUIRED DD CARD OR TEMPLATE IS
  MISSING. NAME=RNPRIN01
  

Local fix

• Add the missing DDNAME RNPRIN01.
  
  Chapter 2.27.2.2 'Data sets that RUNSTATS uses' in the DB2 R810
  Utility Guide and Reference was revised to say state that the
  ddname was required when collecting distribution statistics for
  column groups.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 RUNSTATS  utility  with  COLGROUP option,    *
  *                 are affected.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running  RUNSTATS  with   the  COLGROUP *
  *                      option results in msg DSNU047I DSNUSDRB *
  *                       -  A REQUIRED DD CARD  OR  TEMPLATE IS *
  *                      MISSING: NAME=RNPRIN01                  *
  *                      .*                                      *
  *                      The U.R   or   UTIL  line  command with *
  *                      RUNSTATS and COLGROUP option  generates *
  *                      incorrect JCL as the RNPRIN01 ddname is *
  *                      missing.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• DD statment RNPRINT was used instead of the correct DD name
  RNPRIN01. The reported problem has been fixed.
  

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:

Modules/Macros

•    ADB2USR  ADB2WL4
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK10430

     UP05/12/31 P F512

• R710 PSY UK10431

     UP05/12/31 P F512

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.