PK06348: ADMIN TOOL INCORRECTLY SPECIFIES A VIEW IS AN INVALID OBJECT TYPE FOR A DSNTIAUL U.U LINE COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool U.U line command Unload Utility (using DSNTIAUL)
  when used on a view incorrectly states it is an "Invalid
  Object Type". The DSNTIAUL program works with VIEWs.
  .
  Additional symptoms: GTT ALIAS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of  DB2  Administartion Tool, who      *
  *                 use the DSNTIAUL unload utility against      *
  *                 views, aliases, or GTTs, are affected.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: "Invalid object type"  message  was     *
  *                      displayed when U.U line command was     *
  *                      issued  against object  types other     *
  *                      than table or MQT on  panel ADB21T.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• DB2 Administration  Tool did not allow unload utility using
  DSNTIAUL against   views, aliases, or GTTs, even though DB2
  does support it.   Note  that  DB2  does  not support other
  utilities against these types.
  .*
  Now, it  has  been  changed to support the U.U line command
  against  views and  GTTs on panel ADB21T as well as aliases
  on panels  ADB21T  and ADB21A. In addition, the U.BP (batch
  parameters) line command is now supported against all types
  on panel ADB21T as well as aliases on ADB21A.
  

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

•    ADB2U    ADB21A   ADB21T   ADB34
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK06726

     UP05/09/15 P F509

• R710 PSY UK06727

     UP05/09/15 P F509

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.