PK07242: OBJECT COMPARE USES A QUALIFIER IN SET CURRENT SQLID STATEMENT INSTEAD OF A VALID SQLID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare uses a table qualifier (owner id) in a SET
  CURRENT SQL STATEMENT prior to the creation of the table with
  that qualifier. The qualifier is not a valid SQLID, and in
  addition is not the CREATOR or has create authority. This will
  change catalog data, resulting in data loss and incorrect
  output.
  .
  Additional symptoms: sqlcode551 sqlcoden551
  

Local fix

• adjust the SQL IDs.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 use "set current sqlid statements", are      *
  *                 affected.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Comparison Tool used a table *
  *                      qualifier  (owner id)  in a SET CURRENT *
  *                      SQL STATEMENT  prior  to  the  creation *
  *                      of  the table with that qualifier.  The *
  *                      qualifier was not a valid SQLID, and in *
  *                      addition was  not  the  CREATOR  or had *
  *                      create  authority.  This  would  change *
  *                      catalog  data,  resulting  in data loss *
  *                      and incorrect output.                   *
  *                      .*                                      *
  *                      For the RUN SQLID option on GOC5 panel, *
  *                      only  <NONE>   of   (<NONE>/Blank)  was *
  *                      supported  as  the specification, which *
  *                      indicated  that  SET CURRENT SQLID will *
  *                      not  be  generated at all. Therefore, a *
  *                      specification of  <Blank>  would  cause *
  *                      problems.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Probelm Description.
  

Problem conclusion

• The functionality has been enhanced to allow the user to
  specify  SQLID that will be used when creating, dropping
  or altering objects.
  

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:

  UK08646

Modules/Macros

•    GOCGAJOB GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS
  GOC5     GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK08646

     UP05/11/04 P F511

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.