PI14071: DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES ERROR MESSAGE ADB1951E WHEN USING DDL COMMAND AND DSNWZP NOT AVAILABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS issues error message
  ADB1951E when using DDL command and DSNWZP not available
  .
  msgADB1951E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user's system does not have a    *
  *                      Workload Manager (WLM) DB2 stored       *
  *                      procedure environment installed, the    *
  *                      stored procedure DSNWZP is not          *
  *                      available.  When issuing the Generate   *
  *                      (GEN) or DDL command on panels          *
  *                      ADB21D 'Databases', ADB21S 'Table       *
  *                      Spaces', ADB21T 'Tables, Views and      *
  *                      Aliases' and ADB21X 'Indexes', the      *
  *                      command issues a SQLCODE=-471 /         *
  *                      SQLCODEN471 rc00E7900C error.           *
  *                                                              *
  *                      DSNT408I SQLCODE = -471,                *
  *                      ERROR: INVOCATION OF FUNCTION           *
  *                      OR PROCEDURE                            *
  *                      SYSPROC.DSNWZP FAILED DUE               *
  *                      TO REASON 00E79002                      *
  *                      DSNT418I SQLSTATE   = 55023             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      DB2 Admin does not generate the DDL     *
  *                      and ends with error message             *
  *                      ADB1951E / msgadb1951e:                 *
  *                                                              *
  *                      ADB1951E An error occurred when         *
  *                      the Gen component called the ADB2ZP     *
  *                      program to get the DB2 system           *
  *                      parameter (DSNZPARM) values.            *
  *                      ADB1192I ADB2GEN - Now terminating      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user's system does not have a WLM DB2 stored procedure
  environment installed, the stored procedure DSNWZP is not
  available.  When issuing the Generate (GEN) or DDL command,
  the command issues a SQLCODE=-471 / SQLCODEN471 rc00E7900C
  error. DB2 Admin does not generate the DDL and ends with
  error message ADB1951E / msgadb1951e.
  

Problem conclusion

• Problem has been resolved.
  
  The DB2 system parameter (DSNZPARM) values are needed when
  writing a version file. When the option GETDB2ZP='N' is
  specified on panel ADB2P2 'Change DB2 Admin Defaults'.,
  the Generate (GEN) function does not call the DB2 stored
  procedure DSNWZP and does not retrieve the DB2 system
  parameter (DSNZPARM).
  
  When the option GETDB2ZP='N' is specified on panel ADB2P2
  and writing to a version file is needed, DB2 Admin will end
  with a RC=8 / Return Code 8 and issues new error message
  ADB1957E / msgadb1957e:
  
  ADB1957E
  The option GETDB2ZP='N' is specified; therefore GEN cannot
  call the DB2 stored procedure DSNWZP and get the DB2 system
  parameter (DSNZPARM) values. The DSNZPARM values are
  required when GEN generates a version file.
  
  Explanation
  The DB2 system parameter (DSNZPARM) values are needed when
  writing to a version file. The DSNZPARM values are required
  by downstream functions.
  
  System action
  Processing stops.
  
  User response
  Specify YES for the option 'Get DB2 ZPARM' on panel ADB2P2
  'Change DB2 Admin Defaults'.
  
  When the option GETDB2ZP='N' is specified on panel ADB2P2
  and writing to a version file is not needed, DB2 Admin will
  end with Return Code 4 / RC =4  and issue new warning message
  ADB1958W / msgadb1958w:
  
  ADB1958W
  The option GETDB2ZP='N' is specified; therefore GEN cannot
  call the DB2 stored procedure DSNWZP and get the DB2 system
  parameter (DSNZPARM) values. The following DSNZPARM values
  will be used when removing DDL default values and generating
  ADMIN ALTER IMPLICIT statements:
  
  TBSBPOOL=BPP0; TBSBP8K=BP8K0;
  TBSBP16K=BP16K0; TBSBP32K=BP32K; TBSBPLOB=BP0;
  TBSBPXML=BP16K0; IDXBPOOL=BP0; WLMENV=''; PADIX=NO;
  IMPTSCMP=NO; LOB_INLINE_LENGTH=0;
  IMPTSCMP = NO; MAX_UTIL_PARTS=''; RRF=TRUE.
  
  Explanation
  The DB2 system parameter (DSNZPARM) values are needed when a
  request is made to remove default values or generate ADMIN
  ALTER IMPLICIT statements.
  
  System action
  Processing continues.
  
  User response
  If needed, specify YES for the option 'Get DB2 ZPARM' in the
  Change DB2 Admin Defaults panel (ADB2P2).
  

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:

  UI20892 UI20893

Modules/Macros

•    ADBCCM   ADBCVOB  ADBCVOC  ADBP8MV  ADBSALT
  ADB1000  ADB2GEN  ADB2GEN2 ADB2P2   ADB2RE   ADB2REE  ADB2REZ
  ADB2ZP   ADB2000  ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20892

     UP14/08/29 P F408

• RB10 PSY UI20893

     UP14/08/30 P F408

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.