PM04459: MISSING TBOWNER IN FROM CLAUSE FROM VIEW CAUSES ADB1847E WARNING ERROR PARSING DDL VIEW OR TABLE STATEMENT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Views missing tbowner in the FROM clause and using MASK to
  alter the OWNER field causes ADB1847E WARNING : Error parsing
  DDL VIEW or TABLE statement.
  

Local fix

• Users who have SYSADM authority will not see the issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN or DDL line commands    *
  *                 with an ID that does not have SYSADM         *
  *                 authority.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: One of the internal programs that       *
  *                      queries DB2 attempts to change the      *
  *                      CURRENT SQLID of the process to an ID   *
  *                      that DB2 does not allow for non-SYSADM  *
  *                      users. Since the SQLID cannot be        *
  *                      changed, the required information from  *
  *                      DB2 is not retrieved and the Admin      *
  *                      parser is not able to complete.  This   *
  *                      results in the parser error:            *
  *                                                              *
  *                      ADB1847E WARNING : Error parsing DDL    *
  *                      VIEW or TABLE statement.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following parser error was received when using the GEN or
  DDL command:
  
  ADB1847E WARNING : Error parsing DDL VIEW or TABLE statement.
  

Problem conclusion

• The program has been changed such that a SET CURRENT SQLID is
  no longer done for DB2 R810 new function mode and later.  The
  reported problem is only fixed for DB2 R810 new function mode
  and later since the required DB2 features are not available on
  DB2 R710.
  

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:

Modules/Macros

•    ADB2PA   ADB2PRP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK67971

     UP11/05/26 P F105

• R720 PSY UK67972

     UP11/05/26 P F105

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.