PK33466: ALC COMMAND USED DSNTIAD TO EXECUTE DROP COMMAND / INVALID OBJEC T NAME MESSAGES INCORRECT DUE TO FORMATTING ISSUE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool ALC line commands formatting of the
  DROP command to be processed by the DB2 sample program DSNTIAD
  results in an incorrect / truncated object name being reported
  in the messages from DSNTIAD.
  

Local fix

• Amend the DDL DROP command so that all SQL starts in the
  same column.
  Example:
        DROP
        "MY"."TABLE"
  rather than:
        DROP
  "MY"."TABLE"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who        *
  *                 use ALC line command, may be affected.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALC  line  commands, formatting  of the *
  *                      DROP  command  to be processed  by  the *
  *                      DB2  sample program  DSNTIAD,  resulted *
  *                      in   an  incorrect / truncated   object *
  *                      name  being  reported  in the  messages *
  *                      from DSNTIAD.                           *
  *                      .*                                      *
  *                      Used  ALC to  alter a table that causes *
  *                      the  table  to be dropped and the print *
  *                      output from DSNTIAD truncated the table *
  *                      owner name.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADB27DC0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK20015

     UP06/11/30 P F611

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.