PH64802: DB2ZAI BACKUP OR FALLBACK JOBS MAY FAIL WHEN DBZAI MAINT LEVEL IS AT PH62110 AND PH62111 OR LATER 25/01/27 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2ZAI Backup or Fallback jobs may fail when DBZAI
  maintenance level is at PH62110 and PH62111 or later .
  
  A Restore metadata database to a maint level after PH60101,
  PH61349, PH61372, PH61373, and PH62655 during LOAD
  zaischema.DSN_ML_CONNECTIONS table , may get error message:
  
  DSNU323I   DSNURWUF - COLUMN 'WMLZ_DATASOURCE_GUID' IS OMITTED
  DSNU323I   DSNURWUF - COLUMN 'NON_LOB_BUFFERPOOL' IS OMITTED
  DSNU323I   DSNURWUF - COLUMN 'LOB_BUFFERPOOL' IS OMITTED
  DSNU323I   DSNURWUF - COLUMN 'PROFILE_BUFFERPOOL' IS OMITTED
  DSNU323I   DSNURWUF - COLUMN 'NON_LOB_STOGROUP' IS OMITTED
  DSNU323I   DSNURWUF - COLUMN 'LOB_STOGROUP' IS OMITTED
  DSNU323I   DSNURWUF - COLUMN 'PROFILE_STOGROUP' IS OMITTED
  DSNU012I   DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
  RETURN CODE=8
  
  
  Possible Backup error:
  LEVEL IS INCORRECT, THIS SCRIPT IS ONLY FOR 1.6.0.0
  EXIT WITH ERRORS
  .
  Additional keywords: DB2AIV1R6/K MSGDSNU323I
  

Local fix

• Workaround for Backup:
  Modify job COYF060B , go to line 119 or find '1.6.0.0' as below:
  
  
  
  IF cat_level = '1.6.0.0' THEN
  SAY 'LEVEL IS CORRECT'
  ELSE
  DO  SAY 'LEVEL IS INCORRECT, THIS SCRIPT IS ONLY FOR 1.6.0.0'
  SIGNAL HALT
  END
  
  change to:
  
  IF cat_level = '1.6.0.0' | cat_level = '1.6.1.0'
  THEN  SAY 'LEVEL IS CORRECT'
  ELSE
  DO  SAY 'LEVEL IS INCORRECT, THIS SCRIPT IS ONLY FOR 1.6.0.0'
  SIGNAL HALT
  END
  
  -------------------------------
  Workaround for Restore error:
  In job COYF060C , comment out line 66, 68, 69, 70, 71, 72,
  
  and 73 as shown here:
  000056 CREATE TABLE &SCHEMA..DSN_ML_CONNECTIONS (
  000057     NAME        VARCHAR(255) NOT NULL,
  000058     DATASOURCE_ALIAS VARCHAR(300) NOT NULL WITH DEFAULT
  ,
  000059     SCHEDULER_ID VARCHAR(8) NOT NULL,
  000060     HOST        VARCHAR(512) NOT NULL,
  000061     PORT        CHAR(5) NOT NULL,
  000062     LOCATION    CHAR(32) NOT NULL,
  000063     ADDITIONAL_PROPERTIES  VARCHAR(2000) NOT NULL,
  000064     DB2_IDENTIFIER  VARCHAR(8) NOT NULL,
  000065     SYSTEM_NAME VARCHAR(8) NOT NULL,
  000066   -- WMLZ_DATASOURCE_GUID VARCHAR(64) NOT NULL,---remove
  000067     CREATED_BY  VARCHAR(500) NOT NULL,
  000068     -- NON_LOB_BUFFERPOOL VARCHAR(8) NOT NULL,--- remove
  000069     -- LOB_BUFFERPOOL VARCHAR(8) NOT NULL,--- remove
  000070     -- PROFILE_BUFFERPOOL VARCHAR(8) NOT NULL,--- remove
  000071     -- NON_LOB_STOGROUP VARCHAR(128) NOT NULL,--- remove
  000072     -- LOB_STOGROUP VARCHAR(128) NOT NULL,--- remove
  000073     -- PROFILE_STOGROUP VARCHAR(128) NOT NULL,--- remove
  000074     CREATED_TIMESTAMP     NOT NULL
  000075        GENERATED BY DEFAULT FOR EACH ROW ON UPDATE
  000076                           AS ROW CHANGE TIMESTAMP,
  000077     APPLNAME VARCHAR(16) NOT NULL,
  000078  DB2ZAI_CATALOG_LEVEL VARCHAR(16) NOT NULL,
  000079     SCHEDULER_ID_PW VARCHAR(128) NOT NULL
  000080    ) CCSID UNICODE
  000081    IN &DBNAME..SYSMLCON
  
  -------------------------------------------------
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Db2 AI for z/OS version 1.6     *
  *                 with PH62110 and PH62111 or later who        *
  *                 attempt to fall back to previous             *
  *                 maintenance.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: A user trying to either back up Db2ZAI  *
  *                      on a target connection fails with       *
  *                      Db2ZAI level not supported, or to       *
  *                      fall back metadata database fails       *
  *                      with a LOAD utility error.              *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  Additional keywords:
  DB2AIV1R6/K
  

Problem conclusion

• The problems of backup and fallback have been addressed.
  

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:

  UI99747

Modules/Macros

• COYF060A COYF060B COYF060C
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R160 PSY UI99747

     UP25/01/29 P F501 {

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.