PH16368: SEPTEMBER RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Update parm IMSSUFFIX to AFIN=NO
  Unsupported field type PIC S9(7)V99 COMP should be treated as
  SQL Decimal
  Virtual View create validates WHERE AND as Successful
  Invalid date/time comparison on Virtual Table with DB2 Direct
  SQL Engine ABEND when running our JDBC unit tests
  ++SET INTERIM not working in DSCLIENT - gives error
  Invalid ++SET key or value: INTERIM
  SMF 26 Data can not be added for column SMF26AC1
  length 258 error
  Invalid Column reference message when creating VT from
  attached copybook and run SQL Query
  Missing data using LEFT OUTER JOIN between PARENT and CHILD
  Table
  Problem using "short" day format in where clause with a
  Db2 timestamp column
  SQL Engine parsing IMS DBD fail and S0C3 ABEND
  Incorrect message for IMS DBCTL Virtual tables - IMS-Direct
  skipped for DBD xxx - map reduce is disabled for this DBD
  Unable to process map error/Invalid column name length when
  creating VSAM Virtual table
  Documentation needs to include TRACE IMS paramters
  TOR/DOR using IDF for load balancing/routing capability
  IDF (Integrated DRDA Facility) DRDA App Server front end
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Update parm IMSSUFFIX to AFIN=NO        *
  *                                                              *
  *                      Virtual View create validates WHERE AND *
  *                      as Successful                           *
  *                                                              *
  *                      Invalid date/time comparison on Virtual *
  *                      Table with DB2 Direct                   *
  *                                                              *
  *                      SQL Engine ABEND when running our JDBC  *
  *                      unit tests                              *
  *                                                              *
  *                      ++SET INTERIM not working in DSCLIENT - *
  *                      gives error Invalid ++SET key or        *
  *                      value: INTERIM                          *
  *                                                              *
  *                      SMF 26 Data can not be added for column *
  *                      SMF26AC1 length 258 error               *
  *                                                              *
  *                      Invalid Column reference message when   *
  *                      creating VT from attached copybook      *
  *                      and run SQL Query                       *
  *                                                              *
  *                      Missing data using LEFT OUTER JOIN      *
  *                      between PARENT and CHILD Table          *
  *                                                              *
  *                      Problem using 'short' day format in     *
  *                      where clause with a Db2 timestamp       *
  *                      column                                  *
  *                                                              *
  *                      SQL Engine parsing IMS DBD fail and     *
  *                      S0C3 ABEND                              *
  *                                                              *
  *                      Incorrect message for IMS DBCTL Virtual *
  *                      tables - IMS-Direct skipped for DBD xxx *
  *                      - map reduce is disabled for this DBD   *
  ****************************************************************
  .
  

Problem conclusion

Temporary fix

Comments

• ×**** PE19/11/18 FIX IN ERROR. SEE APAR PH19355  FOR DESCRIPTION
  

APAR Information

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

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

  UI65673

Modules/Macros

• HLVCPRSE HLVCRDBD HLVIMPMP HLVOAPDR HLVOPAGN 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 UI65673

     UP19/10/08 P F910  

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.