PM79799: DB2 HPU GENERATES INVALID A LOAD CONTROL STATEMENT FOR TEMPORAL TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• For a temporal table with generated-column-definitions such as
  GENERATED ALWAYS/DEFAULT as-row-transaction-timestamp-clause
   GENERATED ALWAYS/DEFAULT as-row-transaction-start-id-clause
  DB2 HPU generates invalid a LOAD control statement.
  
  The LOAD utility used with the invalid statement fails
  and report ?FIELD xxxx IS NOT ALLOWED? for any field defined
  with a generated-column-definition. The PERIODOVERRIDE and
  TRANSIDOVERRIDE should be specified to allow the unloaded data
  be reloaded into the table.
  
  For example:
  If the table definition includes :
  
    CREATE TABLE SCH2121.TBAD2121
      (...
      SYS_START TIMESTAMP(12) NOT NULL GENERATED ALWAYS
          AS ROW BEGIN,
      SYS_END   TIMESTAMP(12) NOT NULL GENERATED ALWAYS
          AS ROW END,
      CREATE_ID TIMESTAMP(12) GENERATED ALWAYS AS
          TRANSACTION START ID,
      PERIOD SYSTEM_TIME(SYS_START,SYS_END))
  
  the LOAD statement generated by DB2 HPU is as follows
  
  
    INTO TABLE SCH2121.TBAD2121
    (
     ...
      ,
     SYS_START
          POSITION (    35  )     TIMESTAMP EXTERNAL (    32 )
      ,
     SYS_END
          POSITION (    67  )     TIMESTAMP EXTERNAL (    32 )
      ,
  
     CREATE_ID
          POSITION (    99  )     TIMESTAMP EXTERNAL (    32 )
          NULLIF(   131 ) = '?'
  
  )
  
  The LOAD utility fails (with completion code 8) as follows:
  
  DSNU650I  @ 311 17:50:32.20 DSNURWI -    SYS_START
           POSITION(35) TIMESTAMP EXTERNAL(32),
  
   DSNU269I  @ 311 17:50:32.20 DSNURWUF - FIELD SYS_START
           IS NOT ALLOWED
   DSNU650I  @ 311 17:50:32.20 DSNURWI -    SYS_END POSITION(67)
  TIMESTAMP EXTERNAL(32),
   DSNU269I  @ 311 17:50:32.20 DSNURWUF -
               FIELD SYS_END IS NOT ALLOWED
   DSNU650I  @ 311 17:50:32.20 DSNURWI -  CREATE_ID
          POSITION(99) TIMESTAMP EXTERNAL(32) NULLIF(131)='?')
   DSNU269I  @ 311 17:50:32.20 DSNURWUF -
               FIELD CREATE_ID IS NOT ALLOWED
   DSNU012I    311 17:50:32.21 DSNUGBAC -
         UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
  
  The PERIODOVERRIDE and TRANSIDOVERRIDE keywords should be
  specified as below:
    INTO TABLE SCH2121.TBAD2121
    PERIODOVERRIDE
    TRANSIDOVERRIDE
    (
     ...
      ,
     SYS_START
          POSITION (    35  )    TIMESTAMP EXTERNAL (    32 )
      ,
     SYS_END
          POSITION (    67  )    TIMESTAMP EXTERNAL (    32 )
      ,
     CREATE_ID
          POSITION (    99  )    TIMESTAMP EXTERNAL (    32 )
          NULLIF(   131 ) = '?'
  
   )
  
   PB11770 ** RFE 28675
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The output field for SBCS CHAR or       *
  *                      VARCHAR data (encoded in EBCDIC or      *
  *                      ASCII) unloaded in UNICODE is           *
  *                      incorrect. Some characters are          *
  *                      replaced by the replacement character.  *
  *                      This occurs because the target output   *
  *                      field is encoded in the UNICODE SBCS    *
  *                      CCSID which is not valid. The output    *
  *                      should be encoded in the MIXED CCSID    *
  *                      instead.                                *
  *                      pb11770                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  N/A
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

•    INZCRXSM
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK92934

     UP13/03/30 P F303

• R420 PSY UK92935

     UP13/03/30 P F303

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.