PM28904: ADB1219W TABLE <SCHEMA>.<GTT_NAME> NOT FOUND MESSAGE ISSUED WHEN USING VERSION SCOPE TO REFERENCE A GLOBAL TEMPORARY TABLE / GTT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ADB2GEN function does
  not find  a global temporary table / GTT via the VERSION SCOPE
  function and issues the message:
            Processing Table/View/Alias <schema>.<wildcard>
  ADB1219W Table <schema>.<wildcard> not found
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool or      *
  *                 DB2 Object Comparison Tool for z/OS          *
  *                 who use a version scope that contains        *
  *                 a version scope object with type TB.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A version scope type of TB only         *
  *                      extracted tables with                   *
  *                      systables.type = 'T'.  Globally         *
  *                      temporary tables were not extracted.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Using a version scope that has a version scope object with
  type TB, the global temporary tables are not processed even
  though the name of the global temporary table matches the
  name or the name patter of the version scope object name.
  
  e.g.  PM28904_G matches the name of a global temporary
  table, but when this version scope is used (e.g. in Object
  Compare), global temporary tables are not processed.
  
  ADB2C4O n ----------- CM - Version Scope Objects ------
  Command ===>
  
  Version scope objects for scope "USER123"."PM28904_G"
  Commands: CANCEL
  Line commands:
    I - Insert  D - Delete  R - Repeat
  
  Sel T  Qual     Name
      *  *        *
  --- -- -------> ---------------------------------------
  
      TB USER123  PM28904_G%
  ******************************* END OF DB2 DATA *******
  
  
  When the scope is used in the DB2 Object Comparison Tool,
  a message like the following will be issued:
  
  ADB1219W Table USER123."PM28904_G%" not
  found.
  

Problem conclusion

• The 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:

Modules/Macros

•    ADB2RER
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK64491

     UP11/02/06 P F102

• R720 PSY UK64492

     UP11/02/06 P F102

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.