PK07974: MIGRATE BUILDS INVALID LOAD CARD. MISSING QUOTES ON TABLE NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool using MIG line command ( migrate ) an
  invalid LOAD control statement can result when a table name is
  18 characters and quotes are required around the table name.
  .
  Error messages appear similar to:
  .
  DSNU088I    DSNUGTIS - INVALID CHARACTER OPERAND -
              "$TED".VLDPROD_ACCT_RLSHP
  DSNU012I    DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
              RETURN CODE=8
  .
  Additional symptom: rc8 rc08 msgdsnu088i msgdsnu012i
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 the Migrate function, may be affected.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When migrating  a  Data Base that had a *
  *                      Table with  its Owner name  starts with *
  *                      '$'  and  the  Table name contains '_', *
  *                      the  Load job  failed with  a  'INVALID *
  *                      CHARACTER OPERAND'  message  due to the *
  *                      Table name not being double quoted.     *
  *                      .*                                      *
  *                      Using  MIG  line command ( Migrate ) an *
  *                      invalid LOAD control statement could be *
  *                      produced  when  quotes were required to *
  *                      mark the  Table name which has a length *
  *                      of 18 characters.  Error  messages were *
  *                      DSNU088I DSNU012I with RETURN CODE=8.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Migrate built invalid Load card: missing Quotes on Table name.
  

Problem conclusion

• The Table name has now been properly quoted with double quotes.
  The reported problem has been fixed.
  

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

•    ADB28MC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK10430

     UP05/12/31 P F512

• R710 PSY UK10431

     UP05/12/31 P F512

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.