PM41333: ADB3000E ERROR PROCESSING SYNONYM <SCHEMA>.<SYNNAME> IN CREATE STATEMENT: OBJECT ALREADY EXISTS RC=8 VALIDATE WORK STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Validate Work statement
  List WSL ) function issues a message:
  ADB3000E Error processing Synonym <schema>.<syn_name> in CREATE
  statement: Object already exists.
  causing the WSLVALn step to end with a return code 8 / RC=8.
  

Local fix

• Do not use "Validate WSL" YES on panel ADB2C11A"Generate
  Analyze Job"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 DB2 Object Comparison Tool for z/OS who      *
  *                 run Validate Work Statement List ( WSL )     *
  *                 either by setting 'Validate WSL' to 'YES'    *
  *                 on panel ADB2C11A 'Generate Analyze Job'     *
  *                 while analyzing a change, or by using the    *
  *                 'V' line command on panel ADB2W1 'Work       *
  *                 Statement List'.  Users who run DB2          *
  *                 Object Compare and specify option 'Run       *
  *                 Validate' to 'V' on panel GOC5 'Generate     *
  *                 Compare Jobs'.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Validate Work statement List (WSL)      *
  *                      function incorrectly issues a message:  *
  *                                                              *
  *                      ADB3000E Error processing Synonym       *
  *                      'schema'.'syn_name' in CREATE           *
  *                      statement: Object already exists.       *
  *                                                              *
  *                      causing the WSLVALn Validate step to    *
  *                      fail with a return code 8 / RC=8.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS Validate Work statement
  List ( WSL ) function incorrectly issues a message:
  
  ADB3000E Error processing Synonym
  'schema'.'syn_name' in CREATE
  statement: Object already exists.
  
  causing the WSLVALn Validate step to fail with a return
  code 8 / RC=8.
  

Problem conclusion

• On DB2 9, before APAR PM16023 (PTF UK64833) is available, when
  a synonym is used in a dynamic SQL statement, DB2 incorrectly
  used the CURRENT SCHEMA instead of CURRENT SQLID as the owner
  of the synonym. To tolerate this DB2 error, the DB2
  Administration Tool Validate Work Statement List ( WSL )
  function also applies CURRENT SCHEMA as the owner of the
  synonym for the CREATE SYNONYM and DROP SYNONYM statements.
  
  The code has been updated to use CURRENT SQLID as the owner
  of the synonym when processing the CREATE SYNONYM and DROP
  SYNONYM statements.
  
  This APAR only resolves the Validate error for the CREATE
  SYNONYM and DROP SYNONYM statements. The Validate error
  which is caused by the synonym being referenced in other
  statements will be resolved by a future APAR.
  
  For users of DB2 9, please ensure that DB2 APAR PM16023
  (PTF UK64833) is installed.
  

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:

  UK70730 UK70729

Modules/Macros

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK70729

     UP11/08/16 P F108

• R720 PSY UK70730

     UP11/08/16 P F108

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.