PM22315: DB2 TABLE LOAD ROW INSERTS OF CURRENT DATE, CURRENT TIME AND CURRENT TIMESTAMP TYPES NOT BEING ALTERED BY HOURGLASS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In the DB2 environment, IBM HourGlass provides altered date/time
  values for references to the DB2 special registers CURRENT DATE,
  CURRENT TIME and CURRENT TIMESTAMP. Also provided is support for
  altered date/time values for inserts of rows containing columns
  of those types when the "default not null" attribute is
  specified, during table load operations using the DSNUTILB DB2
  utility program.  Some time ago the support for altered
  date/time values during table loads fell out of the product.
  Prior to that point, the code mechanism used to retrieve the
  date/time values for normal SQL process and table loads via the
  DSNUTILB utility were the same. But at some point, a change was
  made in DB2 that caused the time requests for table loads in
  DSNUTILB to be handled differently. With the help of DB2
  Support, the code mechanism for retrieving date/time values for
  table loads via DSNUTILB has been identified. The fix for this
  APAR provides a second set of Process Control Elements to be
  used by the HourGlass patch installer to re-integrate HourGlass
  into the DSNUTILB utility. With the second DB2 integration patch
  installed, HourGlass will again supply HourGlass-altered
  date/time values for inserts of rows containing columns of the
  types CURRENT DATE, CURRENT TIME and CURRENT TIMESTAMP, when
  defined with the "default no null" attribute.
  

Local fix

• None available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM HourGlass R610 users utilizing       *
  *                 HourGlass with the DB2 Batch Load            *
  *                 Utility DSNUTILA program.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: HourGlass is not providing altered      *
  *                      date/time values in DB2 batch loads for *
  *                      date and time columns. HourGlass is     *
  *                      supposed to provide HourGlass-altered   *
  *                      date/time values in DB2 bacth loads of  *
  *                      table rows containing colums defined as *
  *                      one of the date/time types, with the    *
  *                      "not null with default" attribute, but  *
  *                      is not doing so.                        *
  ****************************************************************
  * RECOMMENDATION: Apply PTF.                                   *
  ****************************************************************
  This problem occurred due to a restructuring of DB2 load
  modules, such that the time request resulting in the above
  described scenario is now handled by an instance of the DB2
  DSNXVCTS CSECT that is now part of the DSNUTILA program
  object. This means that an additional integration patch,
  for program object DSNUTILA, will be required to enable the
  HourGlass logic to receive control to handle time requests
  that may occur in executions of the DB2 DSNUTILB Batch Load
  Utility program. In order to satisfy this requirement, a new
  set of HourGlass integration patches, that are applicable to
  the DSNXVCTS CSECT of DB2 program object, are being provided
  in the fix for this APAR. In addition, the HourGlass DB2
  integration patch installation procedure, AGG$DB2, is
  updated to provide the capability to install the additional
  DSNUTILB integration patch.
  

Problem conclusion

• Fix Description:
  
  This problem occurred due to a restructuring of DB2 load
  modules, such that the time request resulting in the above
  described scenario is now handled by an instance of the DB2
  DSNXVCTS CSECT that is now part of the DSNUTILA program
  object. This means that an additional integration patch,
  for program object DSNUTILA, will be required to enable the
  HourGlass logic to receive control to handle time requests
  that may occur in executions of the DB2 DSNUTILB Batch Load
  Utility program. In order to satisfy this requirement, a new
  set of HourGlass integration patches, that are applicable to
  the DSNXVCTS CSECT of DB2 program object, are being provided
  in the fix for this APAR. In addition, the HourGlass DB2
  integration patch installation procedure, AGG$DB2, is
  updated to provide the capability to install the additional
  DSNUTILB integration patch.
  
  ***************************************************************
  * PRODUCT ELEMENTS AFFECTED BY THIS FIX:                      *
  ***************************************************************
  * NEW ELEMENTS ADDED:                                         *
  *   SAGGPINT(AGGDBUAA).#000002.2010/11/03.13:25:20.PM22315    *
  *   SAGGPINT(AGGDBUAC).#000002.2010/11/03.13:03:35.PM22315    *
  *   SAGGPINT(AGGDBUAD).#000002.2010/11/03.13:26:18.PM22315    *
  *   SAGGPINT(AGGDBUAE).#000002.2010/11/03.13:33:38.PM22315    *
  *   SAGGPINT(AGGDBUAF).#000002.2010/11/03.13:43:34.PM22315    *
  *   SAGGPINT(AGGDBUAG).#000002.2010/11/03.13:46:24.PM22315    *
  *   SAGGPINT(AGGDBUAH).#000002.2010/11/03.13:49:01.PM22315    *
  *   SAGGPINT(AGGDBUAI).#000002.2010/11/03.13:58:50.PM22315    *
  *                                                             *
  ***************************************************************
  * EXISTING ELEMENTS MODIFIED:                                 *
  *   SAGGPINT(AGG$DB2) .#000006.2010/11/03.16:18:08.PM22315    *
  *                                                             *
  ***************************************************************
  * EXISTING ELEMENTS DELETED:                                  *
  *     None.                                                   *
  *                                                             *
  ***************************************************************
  * IMPLEMENTATION:      Re-install the HourGlass DB2 integra-  *
  *                      tion patch as needed/directed by IBM   *
  *                      HourGlass Support.                     *
  *                                                             *
  ***************************************************************
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PM15382

• APAR is sysrouted TO one or more of the following:

  UK61957

Modules/Macros

• AGG$DB2  AGGDBUAA AGGDBUAC AGGDBUAD AGGDBUAE
  AGGDBUAF AGGDBUAG AGGDBUAH AGGDBUAI
  

Fix information

• Fixed component name

  IBM HOURGLASS

• Fixed component ID

  5655U4200

Applicable component levels

• R610 PSY UK61957

     UP10/11/06 P F011

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.