PH15524: AVZ AUGUST 2019 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• AVZ August 2019 Release
  - SQL Engine ABEND when running our JDBC unit tests
  - Update parm IMSSUFFIX to AFIN=NO
  - Virtual View create validates WHERE AND as Successful
  - Problem using 'short' day format in where clause with a Db2
    timestamp column
  - Incorrect message for IMS DBCTL Virtual tables - IMS-Direct
    skipped for DBD xxx - map reduce is disabled for this DBD
  - DRDARANGE Support for JGATE
  - 0C4 abend when SQL rexecute on IMS-Direct table reverts to
    schedule a PSB
  - ++SET INTERIM not working in DSCLIENT - gives error Invalid
    ++SET key or value: INTERIM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: -    SQL Engine ABEND when running      *
  *                      our JDBC unit tests                     *
  *                      -    Update parm IMSSUFFIX to AFIN=NO   *
  *                      -    Virtual View create validates      *
  *                      WHERE AND as Successful                 *
  *                      -    Problem using 'short' day format   *
  *                      in where clause with a Db2 timestamp    *
  *                      column                                  *
  *                      -    Incorrect message for IMS DBCTL    *
  *                      Virtual tables - IMS-Direct skipped for *
  *                      DBD xxx - map reduce is disabled for    *
  *                      this DBD                                *
  *                      -    DRDARANGE Support for JGATE        *
  *                      -    0C4 abend when SQL rexecute on     *
  *                      IMS-Direct table reverts to schedule a  *
  *                      PSB                                     *
  *                      -    ++SET INTERIM not working in       *
  *                      DSCLIENT - gives error Invalid ++SET    *
  *                      key or value: INTERIM                   *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI65055

Modules/Macros

• AVZCDRCK AVZCPRSE AVZCSEAC AVZCTVRD AVZOAPDR AVZOBRID AVZOBRSQ
  AVZOBRTV AVZOPPA  AVZPB    AVZSIN00 AVZSQ29D AVZSQ29N AVZSQ2AD
  AVZSQ2AN AVZSQ2BD AVZSQ2BN AVZSQ2CD AVZSQ2CN AVZSQL9D AVZSQL9N
  AVZSQLAD AVZSQLAN AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI65055

     UP19/09/04 P F909  

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.