PK79517: MISSING DB2 R810 TEMPLATE UTILITY KEYWORD DSNTYPE MISSING FROM P ANEL ADB25TS "TEMPLATE DISK OPTIONS" - ADMIN LOBTEMPLATE ADBL1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS panel ADB25TS
  "Template Disk Options" does not provide the ability to code
  the DB2 R810 TEMPLATE UTILITY DSNTYPE keyword therefore the
  LOBCOLDDN template / ADMIN LOBTEMPLATE ADBL1 is not able to
  pass the DSNTYPE parms LIBRARY,PDS,HFS or NULL.
  "Zerrmsg: ISPT034 Zerrsm: Table is not open"
  .
  Special note from ++HOLDDATA
  This APAR added a new column, DSNTYPE, to the user
  Template table. If the column is not present then a -206
  will occur.
  Use AL table and add the new column DSNTYPE to each user
  table.
  .
  ALTER TABLE "owner"."template table"
  ADD "DSNTYPE" VARCHAR (8) NOT NULL WITH DEFAULT;
  Additional keywords: sqlcode206 sqlcoden206 msgdsnt408i
  

Local fix

• Code the DSNTYPE keywords manually once the JCL is generated.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: USERS OF ADMIN 720  UTILITY MISSING DSNTYPE  *
  *                 PARAMETER IN TEMPLATES FOR LOBS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: UTILITY  MISSING  DSNTYPE   PARAMETER   *
  *                      IN  TEMPLATES  FOR  LOBS AND  THE PDS   *
  *                      ALLOCATED IS RUNNING OUT OF DIRECTORY   *
  *                      SPACE.                                  *
  *                                                              *
  *                      DSNU1015I  DSNUGDYN - ERROR ALLOCATING  *
  *                                 DATA SET DSN                 *
  *                                 =SOUSER.UNLOAD.CIXXXL02.T23  *
  *                                                              *
  *                      DSNU1042I  DSNUGDYN - START OF IDCAMS   *
  *                                            MESSAGES          *
  *                                                              *
  *                      IKJ56893I  DATA SET 'TSOUSER.UNLOAD.    *
  *                                 CIXXXL02.T230513.LOBTMPL1'   *
  *                                 NOT ALLOCATED.               *
  *                                                              *
  *                      IGD17036I  DIRECTORY SPACE BEING        *
  *                                 REQUESTED IS GREATER THAN    *
  *                                 PRIMARY SPACE FOR DATA SET   *
  *                                 'TSOUSER.UNLOAD.CIXXXL02.    *
  *                                 T230513.LOBTMPL1'.           *
  *                                                              *
  *                      DSNU1043I  DSNUGDYN - END OF IDCAMS     *
  *                                 MESSAGES.                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  UTILITY MISSING DSNTYPE PARAMETER IN TEMPLATES FOR LOBS.
  

Problem conclusion

• PROBLEM IS RESOLVED.
  

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

•    ADB2PTPL ADB25C   ADB25TD  ADB25TE  ADB25TL1
  ADB25TS  ADB25TU  ADB25TU0 ADB28M   ADB28UL1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK47570

     UP09/06/26 P F906

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.