PH70560: INVALID LOAD COMMAND DUE TO UNDETECTED GENERATED ALWAYS ATTRIBUTE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A LOAD command generated by Db2 HPU is invalid when at least one
  of the unloaded columns matches the following characteristics:
  
  - it has the GENERATED ALWAYS attribute
  - its matching value in the DEFAULT column of the
    SYSIBM.SYSCOLUMNS catalog table is distinct from I, A, E, Q,
    R, X. See the IBM documentation for the SYSIBM.SYSCOLUMNS
    catalog table regarding the column attributes listed in the
    DEFAULT column for more information.
  
  An example of an invalid LOAD statement is as follows:
  
  LOAD DATA
  LOG NO ENFORCE NO
  EBCDIC CCSID(0037)
  
  INTO TABLE TSNAME.TBNAME
  NUMRECS 1000
  (
  USERID
       POSITION (   1  )        VARCHAR
       NULLIF(   145 ) = '?'
  
  )
  
  Local fix:
  
  This issue can be circumvented by following these steps:
  
  - Manually correct the generated LOAD command by adding a suffix
    to the column name leading to the invalid command
  - Add IGNOREFIELDS YES after INTO TABLE tablename
  
  For example:
  
  LOAD DATA
  LOG NO ENFORCE NO
  EBCDIC CCSID(0037)
  
  INTO TABLE TSNAME.TBNAME IGNOREFIELDS YES
  NUMRECS 1000
  (
  USERID_GENERATED
       POSITION (   1  )        VARCHAR
       NULLIF(   145 ) = '?'
  )"
  

Local fix

• This issue can be circumvented by following these steps:
  
  - Manually correct the generated LOAD command by adding a suffix
    to the column name leading to the invalid command
  - Add IGNOREFIELDS YES after INTO TABLE tablename
  
  For example:
  
  LOAD DATA
  LOG NO ENFORCE NO
  EBCDIC CCSID(0037)
  
  INTO TABLE TSNAME.TBNAME IGNOREFIELDS YES
  NUMRECS 1000
  (
  USERID_GENERATED
       POSITION (   1  )        VARCHAR
       NULLIF(   145 ) = '?'
  )"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A LOAD command generated by Db2 HPU is  *
  *                      invalid when at least one of the        *
  *                      unloaded columns matches the following  *
  *                      characteristics:                        *
  *                                                              *
  *                      - it has the GENERATED ALWAYS attribute *
  *                      - its matching value in the DEFAULT     *
  *                        column of the SYSIBM.SYSCOLUMNS       *
  *                        catalog table is distinct from I, A,  *
  *                        E, Q, R, X. See the IBM documentation *
  *                        for the SYSIBM.SYSCOLUMNS catalog     *
  *                        table regarding the column attributes *
  *                        listed in the DEFAULT column for more *
  *                        information.                          *
  *                                                              *
  *                      An example of an invalid LOAD statement *
  *                      is as follows:                          *
  *                                                              *
  *                      LOAD DATA                               *
  *                      LOG NO ENFORCE NO                       *
  *                      EBCDIC CCSID(0037)                      *
  *                                                              *
  *                      INTO TABLE TSNAME.TBNAME                *
  *                      NUMRECS 1000                            *
  *                      (                                       *
  *                      USERID                                  *
  *                           POSITION (   1  )        VARCHAR   *
  *                           NULLIF(   145 ) = '?'              *
  *                                                              *
  *                      )                                       *
  *                                                              *
  *                      Local fix:                              *
  *                                                              *
  *                      This issue can be circumvented by       *
  *                      following these steps:                  *
  *                                                              *
  *                      - Manually correct the generated LOAD   *
  *                        command by adding a suffix to the     *
  *                        column name leading to the invalid    *
  *                        command                               *
  *                      - Add IGNOREFIELDS YES after INTO TABLE *
  *                        tablename                             *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      LOAD DATA                               *
  *                      LOG NO ENFORCE NO                       *
  *                      EBCDIC CCSID(0037)                      *
  *                                                              *
  *                      INTO TABLE TSNAME.TBNAME IGNOREFIELDS   *
  *                      YES                                     *
  *                      NUMRECS 1000                            *
  *                      (                                       *
  *                      USERID_GENERATED                        *
  *                           POSITION (   1  )        VARCHAR   *
  *                           NULLIF(   145 ) = '?'              *
  *                      )"                                      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Invalid LOAD command due to undetected GENERATED ALWAYS
  attribute
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UO07520 UO07521

Modules/Macros

• INZADTOO INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO07520

     UP26/04/18 P F604

• R610 PSY UO07521

     UP26/04/18 P F604

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.