PH10020: JULY RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• - IMS-Direct S0C3 abend
  - No range data found error on Creating virtual tables for DB2
  wizard needs to be changed to "Connection to DB server failed"
  - SQLengine returns Invalid token NOT found after left
  parenthesis
  - BIND/GRANT in Studio is calling SDBC1010 instead of HLVC1010
  - SELECT casting to DAYS/INTEGER fails with "Timestamp string
  contains invalid delimiters"
  - Abend running SQL Query using CASE
  - Server fails to recognize that the full key has been provided
    for the second virtual table in a IMS view
  - If VSAMOPENRLS is set to YES, query on a VT VSAM file causes
  the server keep the vsam file allocated
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: No range data found error on Creating   *
  *                      virtual tables for DB2 wizard needs to  *
  *                      be changed to "Connection to DB server  *
  *                      failed"                                 *
  *                                                              *
  *                      SQLengine returns Invalid token NOT     *
  *                      found after left parenthesis            *
  *                                                              *
  *                      BIND/GRANT in Studio is calling         *
  *                      SDBC1010 instead of HLVC1010            *
  *                                                              *
  *                      SELECT casting to DAYS/INTEGER fails    *
  *                      with "Timestamp string contains invalid *
  *                      delimiters"                             *
  *                                                              *
  *                      Abend running SQL Query using CASE      *
  *                                                              *
  *                      Server fails to recognize that the full *
  *                      key has been provided for the second    *
  *                      virtual table in a IMS view             *
  *                                                              *
  *                      If VSAMOPENRLS is set to YES, query on  *
  *                      a VT VSAM file causes the server keep   *
  *                      the vsam file allocated                 *
  *                                                              *
  *                      IMS record count discrepancy when       *
  *                      running with Direct vs DBCTL            *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  IMS-Direct S0C3 abend
  
  No range data found error on Creating virtual tables for DB2
  wizard needs to be changed to "Connection to DB server failed"
  
  SQLengine returns Invalid token NOT found after left parenthesis
  
  BIND/GRANT in Studio is calling SDBC1010 instead of HLVC1010
  
  SELECT casting to DAYS/INTEGER fails with "Timestamp string
  contains invalid delimiters"
  
  Abend running SQL Query using CASE
  
  Server fails to recognize that the full key has been provided
  for the second virtual table in a IMS view
  
  If VSAMOPENRLS is set to YES, query on a VT VSAM file causes the
  server keep the vsam file allocated
  
  IMS record count discrepancy when running with Direct vs DBCTL
  

Problem conclusion

• Apply the PTF
  

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:

  UI64660

Modules/Macros

• HLVCRDBD HLVCTSOP HLVIDFRR HLVOBRIM HLVODMMG HLVOIO31 HLVOLI9D
  HLVOLI9N HLVOLIAD HLVOLIAN HLVOLIBD HLVOLIBN HLVOLICD HLVOLICN
  HLVOPAGN HLVOPMS  HLVPB    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 UI64660

     UP19/08/15 P F908

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.