PH18437: INVALID OPERAND 'INVALIDATECACHE' KEYWORD 'REORG'; ADB9003W Invalid text file(RUNPARMS): DB2AFL='nnn';SP formatting

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  
  
  1. Specifying INVALIDATECACHE=NO on REORG TABLESPACE panel
  ADB2USO 'Specify Utility Options - REORG' may cause the job to
  fail with the following error:
  
  
  DSNUGPRS - INVALIDATECACHE NO
  DSNUGPRS - INVALID OPERAND 'INVALIDATECACHE' FOR KEYWORD 'REORG'
  
  2. The user-specified 'Target DB2 Function level' may be ignored
  during Change Management Analyze processing, with the
  following message issued:
  
  Invalid text file(RUNPARMS): DB2AFL='nnn'
  ADB9003W Invalid input from the input parameter file is ignored.
  
  3. DELETE and UPDATE statements may not be formatted correctly
  when part of a stored procedure.
  
  
  KEYWORDS:  msgadb9003w
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration and Object   *
  *                 Comparison Tool for z/OS.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes for below DB2  *
  *                      v12 related issues:                     *
  *                                                              *
  *                      1. INVALIDATECACHE=NO option in REORG   *
  *                      TABLESPACE and REBUILD INDEX causes     *
  *                      failure.                                *
  *                                                              *
  *                      2. Target DB2 Function level is ignored *
  *                      during change management analyze        *
  *                      process. The following warning is       *
  *                      issued:                                 *
  *                      Invalid text file(RUNPARMS):            *
  *                      DB2AFL='100'                            *
  *                                                              *
  *                      3. DELETE and UPDATE statements are not *
  *                      formatted correctly when part of a      *
  *                      stored procedure.                       *
  ****************************************************************
  This APAR provides fixes for below DB2 v12 related issues:
  
  1. Specifying INVALIDATECACHE=NO on REORG TABLESPACE panel
  ADB2USO 'Specify Utility Options - REORG' causes job to fail
  with below error:
  DSNUGPRS - INVALIDATECACHE NO
  DSNUGPRS - INVALID OPERAND 'INVALIDATECACHE' FOR KEYWORD 'REORG'
  
  Similar error exist while using REBUILD INDEX panel ADB2UXB
  'Specify Utility Options - REBUILD INDEX'.
  
  2. User specified Target DB2 Function level is ignored during
  change management analyze process. Below warning message is
  enountered:
  Invalid text file(RUNPARMS) : DB2AFL = '100'
  ADB9003W Invalid input from the input parameter file is ignored.
  
  3. DELETE and UPDATE statements are not formatted correctly when
  part of a stored procedure.
  

Problem conclusion

• Incidents have been 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:

  UI66306

Modules/Macros

• ADB2PA   ADB2USO  ADB2USOP ADB2UXB  ADB2UXBO ADBCVOC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66306

     UP19/11/12 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.