PH23466: HLV MARCH 2020 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Release Goals / Success Criteria:
  Goal 1
      Goal 2
      Goal N...
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: SMF View of a View not using __DSN and  *
  *                      always switching to the DEFAULT DSN in  *
  *                      the Global Variable                     *
  *                                                              *
  *                      SQL With clause only returns last       *
  *                      column                                  *
  *                                                              *
  *                      Repeated SQL query gets X'0C3' AT       *
  *                      COGTSQMM+X'000004CE'                    *
  *                                                              *
  *                      SMF70 Sub Type 2 - changes to field     *
  *                      SMF70LGO to have valid offset GMT to    *
  *                      local time                              *
  *                                                              *
  *                      DB2 Direct Read against DB2 table       *
  *                      may leave ENQs held.                    *
  *                                                              *
  *                      SELECT statement on SMF data with       *
  *                      Time filtering using BETWEEN with       *
  *                      ORDER BY and JOIN ON gives error        *
  *                                                              *
  *                      Unsupported field type PIC              *
  *                      S9(7)V99 COMP should be treated as      *
  *                      SQL Decimal                             *
  *                                                              *
  *                      SMF query returning 0c3 ABEND when      *
  *                      SQL has IS NOT NULL                     *
  *                                                              *
  *                      SELECT from TABLE WHERE KEY=1 UNION     *
  *                      with another SELECT WHERE KEY=2 fails   *
  *                                                              *
  *                      "NEW MAP DSN" parameter in HLVGNMPM     *
  *                      not working                             *
  *                                                              *
  *                      SQL INSERT to IMS child segments        *
  *                      fails using DBCTL access                *
  *                                                              *
  *                      Query of IMS Virtual Table with         *
  *                      secondary index fails                   *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  SMF View of a View not using __DSN and always switching to the
  DEFAULT DSN in the Global Variable
  
  SQL With clause only returns last column
  
  Repeated SQL query gets X'0C3' AT COGTSQMM+X'000004CE'
  
  SMF70 Sub Type 2 - changes to field SMF70LGO to have
  valid offset GMT to local time
  
  DB2 Direct Read against DB2 table may leave ENQs held.
  
  SELECT statement on SMF data with Time filtering using BETWEEN
  with ORDER BY and JOIN ON gives error
  
  Unsupported field type PIC S9(7)V99 COMP should be treated as
  SQL Decimal
  
  SMF query returning 0c3 ABEND when SQL has IS NOT NULL
  
  SELECT from TABLE WHERE KEY=1 UNION with another SELECT
  WHERE KEY=2 fails
  
  "NEW MAP DSN" parameter in HLVGNMPM not working
  
  SQL INSERT to IMS child segments fails using DBCTL access
  
  Query of IMS Virtual Table with secondary index fails
  

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:

  UI68906

Modules/Macros

• HLV$1CHE HLV$1CHM HLV$1CWE HLV$1CWM HLV$1CYE HLV$1CYM HLV$462E
  HLV$462M HLV$HCH0 HLV$HCH1 HLV$HCW0 HLV$HCW1 HLV$HCW2 HLV$HCW3
  HLV$HCW4 HLV$HCY0 HLV$HCY1 HLV$HCY2 HLV$HCY3 HLV$HCY4 HLV$K620
  HLV$K621 HLV$K622 HLV$K623 HLV$K624 HLV$W54E HLV$W54M HLV$X540
  HLV$X541 HLV$X542 HLVCBRUP HLVCSQMM HLVCVPPT HLVMFMIG HLVSQ29D
  HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD HLVSQ2CN
  HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N HLVSQLAD HLVSQLAN HLVSQLBD
  HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD HLVSQLDN HLVWSIMP
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI68906

     UP20/04/09 P F004

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.