PI30150: CLONED WSL HAS UNQUALIFIED VIEW, ADDS INVALID QUALIFIER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Create a view on sample database, not specifying a
  qualifier(implicitly qualified), schema should
     be used:
     ***************************** Top of Data ***********
     SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC";
     SET CURRENT SQLID = 'BRADF';
     SET CURRENT SCHEMA = 'PM51467';
  
     CREATE VIEW VW_WITH_SCHEMA_AS_PM51467 AS
        SELECT * FROM DSN81010.PROJ;
     COMMIT;
  
     SELECT * from SYSIBM.SYSTABLES
     where name = 'VW_WITH_SCHEMA_AS_PM51467';
  **************************** Bottom of Data *********
  
  2. Created a WSL for a CREATE VIEW with no qualifier using
     GEN a WSL
  
  3. Clone the WSL using:
     W - Manage work statement lists =>
     1 - Show work statement list library =>
     Q - Clone
  The clone is created with CREATE VIEW using an invalid
  qualifier. The SQLID is used instead of the implicit
  qualifier SCHEMA.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who clone a Work Statement List         *
  *                 ( WSL ).                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The input WSL contains the following    *
  *                      sequence, note the created VIEW name    *
  *                      is unqualified:                         *
  *                                                              *
  *                      SET CURRENT SQLID='XXX';                *
  *                      SET CURRENT SCHEMA='YYY';               *
  *                      CREATE VIEW >view_name< AS              *
  *                      ...                                     *
  *                                                              *
  *                      When cloning the WSL, the process       *
  *                      adds the qualifier for the VIEW         *
  *                      which is unqualified in the             *
  *                      original WSL. For example:              *
  *                                                              *
  *                      SET CURRENT SQLID = 'XXX';              *
  *                      SET CURRENT SCHEMA = 'YYY';             *
  *                                                              *
  *                      CREATE VIEW XXX.VIEW_TEST AS            *
  *                        SELECT * FROM database.table;         *
  *                        COMMIT;                               *
  *                                                              *
  *                      The cloned VIEW uses an incorrect       *
  *                      qualifier. The SQLID is used instead    *
  *                      of the implicit qualifier specified     *
  *                      in the SET CURRENT SCHEMA statement.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When cloning a WSL which contains an unqualified VIEW name,
  the cloned WSL adds an invalid qualifier to the VIEW name.
  

Problem conclusion

• Problem has 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:

  UI24633 UI24634

Modules/Macros

•    ADB2WCL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24633

     UP15/01/27 P F501

• RB10 PSY UI24634

     UP15/01/27 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.