PI46324: ROLLUP APAR

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR contains the following enhancements:
  1. Provide an IVP (Installation Verification Program) to
     confirm the correct setup of the Accelerator Loader WLM
     address space.
  2. Provide an option of adding the table to the IDAA before
     running the Load. In cases where the table already exists in
     the IDAA, user should optionally be able to remove the table
     and then re-add it.
  3. Enable customer to toggle case sensitivity on or off on
     panel HLOLETCL.
  
  4. Various panel changes to help the panels be more
     task-oriented.
  
  5. On the Consistent Data Load panel, change the defaults for
     ‘Buffers in 31 bit storage’ from NO to YES. Change ‘Log
      Reader copy preference’ to read the active logs first, and
      not the archive logs.
  
  6. Changes to accept field specifications created from running
     a DB2 UNLOAD utility, and parse the LOAD control cards
     accordingly to be used by the JCL generator.
  
  7. ISPF changes to support and generate consistent load job to
     load from image copy.
  
  8. Synchronize the input datasets for the SYSREC and Field
     specification input.
  
  9. Option to reduce the elapsed time of non-parallel dual
     loads.  This option can increase CPU usage so a parameter
     will be provided to run with or without the option.
  
  10. Option to add ACCEL_ON_SUCCESS_ENABLE YES parameter to
      group consistent load.
  
  11. The ACCEL_LOAD_TASKS keyword and options module setting
      will now be honored when performing an IDAA_ONLY load to a
      non-partitioned or partition-by-growth object.
  
  12. Provide support for a LOAD statement that has no FORMAT
      clause and no field specifications.
  
  13. Add DISCARDS field to ISPF interface.
  
  14. IDAA ONLY load jobs are inherently NOT restartable. If an
      error occurs during the IDAA_ONLY load, the utility should
      be terminated and the worklist deleted if there is only 1
      executable statement in the SYSIN.
  
  15. Enhancement to snap dump the LDA if  'SNAPLDA DD SYSOUT=*'
      is coded in the utility job step.
  
  This APAR also addresses the following defects:
  
  1. SQLCODE 466 followed by S222 abend if an object name
     contains a space.
  
  2. Load job terminates with S0C4 abend in module HLORERD.
  
  3. Load job terminates with error message:
     HLOP9948E Keyword IDAA_DUAL is incompatible with FLOAT.
  
  4. When the HLO started task is starting with a policy of %,
     the HLOS0606I message does not correspond to the value in
     the ZPARM.
  
  5. Various abends (ie. S0C4 and S0E0) when z/OS diagnostic trap
     IEAINITREGSTASK is active.
  
  6. Message HLOP9930E may occur when the parser encounters the
  value 'BIT'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader    *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR contains the following        *
  *                      enhancements:                           *
  *                      1. Provide an IVP (Installation         *
  *                      Verification Program) to confirm the    *
  *                      correct setup of the Accelerator        *
  *                      Loader WLM address space.               *
  *                      2. Provide an option of adding the      *
  *                      table to the IDAA before running the    *
  *                      Load. In cases where the table already  *
  *                      exists in the IDAA, user should         *
  *                      optionally be able to remove the table  *
  *                      and then re-add it.                     *
  *                      3. Enable customer to toggle case       *
  *                      sensitivity on or off on panel          *
  *                      HLOLETCL.                               *
  *                      4. Various panel changes to help the    *
  *                      panels be more task-oriented.           *
  *                      5. On the Consistent Data Load panel,   *
  *                      change the defaults for not the         *
  *                      archive logs.                           *
  *                      6. Changes to accept field              *
  *                      specifications created from running     *
  *                      a DB2 UNLOAD utility, and parse the     *
  *                      LOAD control cards accordingly to be    *
  *                      used by the JCL generator.              *
  *                      7. ISPF changes to support and          *
  *                      generate consistent load job to load    *
  *                      from image copy.                        *
  *                      8. Synchronize the input datasets for   *
  *                      the SYSREC and Field specification      *
  *                      input.                                  *
  *                      9. Option to reduce the elapsed time    *
  *                      of non-parallel dual loads.  This       *
  *                      option can increase CPU usage so a      *
  *                      parameter will be provided to run with  *
  *                      or without the option.                  *
  *                      10. Option to add                       *
  *                      ACCEL_ON_SUCCESS_ENABLE YES parameter   *
  *                      to group consistent load.               *
  *                      11. The ACCEL_LOAD_TASKS keyword and    *
  *                      options module setting will now be      *
  *                      honored when performing an IDAA_ONLY    *
  *                      load to a non-partitioned or            *
  *                      partition-by-growth object.             *
  *                      12. Provide support for a LOAD          *
  *                      statement that has no FORMAT clause     *
  *                      and no field specifications.            *
  *                      13. Add DISCARDS field to ISPF          *
  *                      interface.                              *
  *                      14. IDAA ONLY load jobs are inherently  *
  *                      NOT restartable. If an error occurs     *
  *                      during the IDAA_ONLY load, the utility  *
  *                      should be terminated and the worklist   *
  *                      deleted if there is only 1 executable   *
  *                      statement in the SYSIN.                 *
  *                      15. Enhancement to snap dump the LDA    *
  *                      if  'SNAPLDA DD SYSOUT=*' is coded in   *
  *                      the utility job step.                   *
  *                      This APAR also addresses the following  *
  *                      defects:                                *
  *                      1. SQLCODE 466 followed by S222 abend   *
  *                      if an object name contains a space.     *
  *                      2. Load job terminates with S0C4 abend  *
  *                      in module HLORERD.                      *
  *                      3. Load job terminates with error       *
  *                      message:                                *
  *                       HLOP9948E Keyword IDAA_DUAL is         *
  *                        incompatible with FLOAT.              *
  *                      4. When the HLO started task is         *
  *                      starting with a policy of %, the        *
  *                      HLOS0606I message does not correspond   *
  *                      to the value in the ZPARM.              *
  *                      5. Various abends (ie. S0C4 and S0E0)   *
  *                      when z/OS diagnostic trap               *
  *                      IEAINITREGSTASK is active.              *
  *                      6. Message HLOP9930E may occur when     *
  *                      the parser encounters the value 'BIT'.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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:

  UI31627

Modules/Macros

• HHLO110J HLO$ACCS HLO$INFO HLO#AMIN HLO#ASYS HLO#CARD HLO#CHKR
  HLO#CMTS HLO#CNTL HLO#CPNT HLO#CPOL HLO#DS
  
  ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R110 PSY UI31627

     UP15/10/16 P F510

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.