PH02214: MAPPING TABLE NAME VALIDATION NEEDED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Three problems:
  Online
  ------
  Problem #1:
  If create dynamic mapping table is = N and if map table creator
  and/or name is blank:
  Current functionality:
  We set the values to default and issue no error message. But the
  help text states that if Create Dynamic Mapping Table is = N,
  a value must be entered for these fields.
  Expected result:
  If create dynamic mapping table is = N and if map table creator
  and/or name is blank, issue an error message stating
  'HAA119E - Mapping Table Creator and Mapping Table Name are
  required if Create Dynamic Mapping Table is set to No.'
  Problem #2:
  Db2 basically allows any character value when creating a table
  name. We need to support all characters when either creating, or
  allowing a user to provide their own mapping table name instead
  of issuing an error message.
  When Create Dynamic Mapping Table is set to Y or N
  If an & is entered with any combination of characters for
  mapping table creator/name besides &JOBNAME or &STEPNAM, the
  following message is generated:
  
  HAA515E - Invalid variable found. Valid variables are &JOBNAME
  
  and &STEPNAM.
  This is incorrect as an '&' is a valid character for a table
  name.
  This sub-task will allow the '&' character within the map table
  creator and/or name without an error.
  When Create Dynamic Mapping Table is set to N
  The error message message 'HAA115E will be changed to a warning
  message b/c the user can create the table after creating the
  utility profile which contains the mapping table name.
  BUILD TIME
  ----------
  Problem #3
  If REORG TS, and SHRLEVEL CHANGE, and Not a LOB TS we need to
  validate the mapping table name if create dyn mapping table = N.
  If No is specified for Create Dynamic Mapping Table, a mapping
  table creator and name must be specified. There is no validation
  at build time to determine if this mapping table name exists.
  This could cause run-time errors. In this case, the build should
  continue, and a warning build message should be generated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Automation Tool z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Three problems:                         *
  *                      Online                                  *
  *                      ------                                  *
  *                      Problem #1:                             *
  *                      If create dynamic mapping table is = N  *
  *                      and if map table creator and/or name    *
  *                      is blank: Current functionality:        *
  *                      We set the values to default and issue  *
  *                      no error message. But the help text     *
  *                      states that if Create Dynamic Mapping   *
  *                      Table is = N, a value must be entered   *
  *                      for these fields.                       *
  *                      Expected result:                        *
  *                      If create dynamic mapping table is = N  *
  *                      and if map table creator and/or name    *
  *                      is blank, issue an error message        *
  *                      stating                                 *
  *                      'HAA119E - Mapping Table Creator and    *
  *                       Mapping Table Name are required if     *
  *                       Create Dynamic Mapping Table is set    *
  *                       to No.'                                *
  *                      Problem #2:                             *
  *                      Db2 basically allows any character      *
  *                      value when creating a table name. We    *
  *                      need to support all characters when     *
  *                      either creating, or allowing a user to  *
  *                      provide their own mapping table name    *
  *                      instead of issuing an error message.    *
  *                      When Create Dynamic Mapping Table is    *
  *                      set to Y or N If an & is entered with   *
  *                      any combination of characters for       *
  *                      mapping table creator/name besides      *
  *                      &JOBNAME or &STEPNAM, the               *
  *                      following message is generated:         *
  *                      HAA515E - Invalid variable found.       *
  *                       Valid variables are &JOBNAME           *
  *                       and &STEPNAM.                          *
  *                      This is incorrect as an '&' is a valid  *
  *                      character for a table name.             *
  *                      This sub-task will allow the '&'        *
  *                      character within the map table          *
  *                      creator and/or name without an error.   *
  *                      When Create Dynamic Mapping Table is    *
  *                      set to N The error message message      *
  *                      HAA115E will be changed to a warning    *
  *                      message b/c the user can create the     *
  *                      table after creating the utility        *
  *                      profile which contains the mapping      *
  *                      table name.                             *
  *                      BUILD TIME                              *
  *                      ----------                              *
  *                      Problem #3                              *
  *                      If REORG TS, and SHRLEVEL CHANGE, and   *
  *                      Not a LOB TS we need to validate the    *
  *                      mapping table name if create dyn        *
  *                      mapping table = N. If No is specified   *
  *                      for Create Dynamic Mapping Table, a map *
  *                      table creator and name must be          *
  *                      specified. There is no validation       *
  *                      at build time to determine if this      *
  *                      mapping table name exists. This could   *
  *                      cause run-time errors. In this case,    *
  *                      the build should continue, and a        *
  *                      warning build message should be         *
  *                      generated.                              *
  ****************************************************************
  * 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:

Modules/Macros

•    HAABND2
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI59242

     UP18/10/27 P F810

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.