PH09356: MAY 2019 RELEASE - COBOL FIELDS GREATER THAN 254 CHARS FAILS DURING MAPPING & LOADING OF CHAR COL WITH 19/06/04 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 'PH09356 is a fixing APAR for PE PTF UI62959'
  
  APAR PH09356
  > Error mapping IMS, VSAM, Sequential and other target where
    COBOL fields is greater than 254 characters. For IMS, it fails
    with Mapped IMS segment SQL Error Data cannot be added to
    table
  > Fail to create table when the column is CHAR that exceeds
    254 characters.
  > HLV3782S MAP FILE HLVMAPP INVALID-HEADER-RECORD FAILED RC=0
    HLV$OLGS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Analytics Accelerator Loader    *
  *                 Server for z/OS                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: 'PH09356 is a fixing APAR for PE PTF    *
  *                      UI62959'                                *
  *                                                              *
  *                      APAR PH09356                            *
  *                      > Error mapping IMS, VSAM, Sequential   *
  *                        and other target where COBOL fields   *
  *                        is greater than 254 characters.       *
  *                        For IMS, it fails   with Mapped IMS   *
  *                        segment SQL Error Data cannot be      *
  *                        added to table                        *
  *                      > Fail to create table when the column  *
  *                        is CHAR that exceeds 254 characters.  *
  *                      > HLV3782S MAP FILE HLVMAPP             *
  *                        INVALID-HEADER-RECORD FAILED RC=0     *
  *                        HLV$OLGS                              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Error mapping IMS, VSAM, Sequential and other target where COBOL
  fields is greater than 254 characters. For IMS, it fails with
  Mapped IMS segment SQL Error Data cannot be added to table
  Fail to create table when the column is CHAR that exceeds 254
  characters.
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

Comments

• ×**** PE21/04/12 FIX IN ERROR. SEE APAR PH36223  FOR DESCRIPTION
  

APAR Information

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

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

  UI63412

Modules/Macros

• HLV$4F2E HLV$4F2M HLV$4F3E HLV$4F3M HLV$OLGS HLVBINJ  HLVCMQIO
  HLVCPROC HLVCSCHE HLVCTGOP HLVCTGRD HLVDRATH HLVO2DSA HLVOIMSR
  HLVOLGUX HLVOPAGN HLVPB    HLVSIN00 HLVSQ29D HLVSQ29N HLVSQ2AD
  HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD HLVSQ2CN HLVSQL9D HLVSQL9N
  HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI63412

     UP19/06/08 P F906 ­

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.