PI42239: INVALID MAPPING TABLE DATABASE NAME GENERATED WHEN THE JOB NAME CONTAINS A ' % '.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a Job Name contains the character '%', the DDL generated to
  create the mapping table may contain an invalid value for the
  database name.  The problem occurs when multiple utility jobs
  are generated and appears in the second and subsequent jobs that
  are generated.  The '%' character is not valid for a Job Name.
  This should produce an error indicating that the Job Name is
  invalid.
  

Local fix

• Remove the '%' character from the Job Name provided to the
  build.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a Job Name contains the character  *
  *                      '%', the DDL generated to create the    *
  *                      mapping table may contain an invalid    *
  *                      value for the database name.  The       *
  *                      problem occurs when multiple utility    *
  *                      jobs are generated and appears in the   *
  *                      second and subsequent jobs that         *
  *                      are generated.  The '%' character is    *
  *                      not valid for a Job Name. This should   *
  *                      produce an error indicating that the    *
  *                      Job Name is invalid.                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI29882 UI29883

Modules/Macros

•    HAA$BMSG HAA$BULJ HAA$JBRK HAA#BPRI
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R410 PSY UI29882

     UP15/08/05 P F508

• R420 PSY UI29883

     UP15/08/11 P F508

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.