IBM Support

PH38505: DATA VIRTUALIZATION MANAGER JULY 2021 RELEASE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Data Virtualization Manager July 2021 Release
    - Add IDF heap memory utillization accounting
    - Debug/fix all SQLAM levels used between IDF and zOS DB2
    - Finish out DIAGLVL fd:oca support
    - DB2 unload files not handling VARCHAR columns correctly
    - DSCLIENT Panel:Changes required for the KILL/CANCEL
      thread/panel help error and renaming Option A on ISPF
    - Problem with a WHEN in a VIEWn 'a'
    - Support new license key option 'a'r in SELECT statement
    - SQL View incorrectly displays error in SELECT statement
    - Virtual Views not available in Studio after successful
      import and map refresh
    - ADABAS Binary 2, 4, 8 to Int with Negative
      numbers not converting
    - Abend 0C4 inserting to ADABAS Sub-Table
    - AVZ2700E Error 09-001 (Request has timed out
      Processing request. - IDMS Maximum run units exceeded
    - MONITOR codepoint not in instance variable
      list for RDBCMM and RDBRLLBCDK
    - Describe Input returns only 1st parameter marker info in IDF
    - Upgrade ISPF E.4 into table-type ISPF dialog for
      bound packages
    - IDF-DIRECT access to bckend DB resources w/o SQL Engine
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Add IDF heap memory utillization        *
    *                      accounting                              *
    *                                                              *
    *                      Debug/fix all SQLAM levels used         *
    *                      between IDF and zOS DB2                 *
    *                                                              *
    *                      Finish out DIAGLVL fd:oca support       *
    *                                                              *
    *                      DB2 unload files not handling VARCHAR   *
    *                      columns correctly                       *
    *                                                              *
    *                      DSCLIENT Panel: Changes required for    *
    *                      the KILL/CANCEL thread/Panel help       *
    *                      error and renaming Option A on ISPF     *
    *                                                              *
    *                      Problem with a WHEN in a VIEW           *
    *                                                              *
    *                      Support new license key option 'a'      *
    *                                                              *
    *                      SQL View incorrectly displays error in  *
    *                      SELECT statement                        *
    *                                                              *
    *                      Virtual Views not available in Studio   *
    *                      after successful import and map refresh *
    *                                                              *
    *                      ADABAS Binary 2, 4, 8 to Int with       *
    *                      Negative numbers not converting         *
    *                                                              *
    *                      Abend 0C4 inserting to ADABAS Sub-Table *
    *                                                              *
    *                      AVZ2700E Error 09-001 (Request has      *
    *                      timed out - Processing request.         *
    *                      - IDMS Maximum run units exceeded       *
    *                                                              *
    *                      MONITOR codepoint not in instance       *
    *                      variable list for RDBCMM and RDBRLLBCDK *
    *                                                              *
    *                      Describe Input returns only 1st         *
    *                      parameter marker info in IDF            *
    *                                                              *
    *                      Upgrade ISPF E.4 into table-type        *
    *                      ISPF dialog for bound packages          *
    *                                                              *
    *                      IDF-DIRECT - direct access to backend   *
    *                      DB resources w/o SQL Engine             *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    Add IDF heap memory utillization accounting
    
    Debug/fix all SQLAM levels used between IDF and zOS DB2
    
    Finish out DIAGLVL fd:oca support
    
    DB2 unload files not handling VARCHAR columns
    correctly
    
    DSCLIENT Panel: Changes required for the KILL/CANCEL
    thread/Panel help error and renaming Option A on ISPF
    
    Problem with a WHEN in a VIEW
    
    Support new license key option 'a'
    
    SQL View incorrectly displays error in SELECT statement
    
    Virtual Views not available in Studio after successful
    import and map refresh
    
    ADABAS Binary 2, 4, 8 to Int with Negative numbers not
    converting
    
    Abend 0C4 inserting to ADABAS Sub-Table
    
    AVZ2700E Error 09-001 (Request has timed out -
    Processing request. - IDMS Maximum run units exceeded
    
    MONITOR codepoint not in instance variable list for
    RDBCMM and RDBRLLBCDK
    
    Describe Input returns only 1st parameter marker info in IDF
    
    Upgrade ISPF E.4 into table-type ISPF dialog for bound packages
    
    IDF-DIRECT - direct access to backend DB resources
    w/o SQL Engine
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH38505

  • Reported component name

    DATA VIRT MGR Z

  • Reported component ID

    5698DVM00

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-06-28

  • Closed date

    2021-07-28

  • Last modified date

    2021-08-09

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

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

    UI76498

Modules/Macros

  • AVZ$Y2GE AVZ$Y2GM AVZ$Y2HE AVZ$Y2HM AVZ$Y2IE AVZ$Y2IM AVZ$Y2JE
    AVZ$Y2JM AVZ$Y2KE AVZ$Y2KM AVZ$Z2G0 AVZ$Z2H0 AVZ$Z2I0 AVZ$Z2J0
    AVZ$Z2K0 AVZCCLIP AVZCCMAL AVZCCUBI AVZCDCCB AVZCDSAL AVZCFAPI
    AVZCFILO AVZCFUNC AVZCGTBK AVZCGTMM AVZCHLCL AVZCIMAC AVZCMQIO
    AVZCPKSR AVZCPRHL AVZCSQCL AVZCSQMM AVZCVDEV AVZCVDLO AVZCVPAL
    AVZCWATK AVZO319D AVZO319N AVZO31AD AVZO31AN AVZO31BD AVZO31BN
    AVZO31CD AVZO31CN AVZO31DD AVZO31DN AVZO649D AVZO649N AVZO64AD
    AVZO64AN AVZO64BD AVZO64BN AVZO64CD AVZO64CN AVZO64DD AVZO64DN
    AVZOACDA AVZOBJ   AVZOBOSU AVZOBRIS AVZOCOSE AVZODF9D AVZODF9N
    AVZODFAD AVZODFAN AVZODFBD AVZODFBN AVZODFCD AVZODFCN AVZODFDD
    AVZODFDN AVZODMMG AVZODRTP AVZOFSQL AVZOHOPA AVZOINAE AVZOINAS
    AVZOINIM AVZOINZV AVZOIQTP AVZOKY9D AVZOKY9N AVZOKYAD AVZOKYAN
    AVZOKYBD AVZOKYBN AVZOKYCD AVZOKYCN AVZOKYDD AVZOKYDN AVZOLINK
    AVZOMAIN AVZOMAMQ AVZOMAOT AVZOMAVT AVZOMQQM AVZOMQQU AVZOOUTE
    AVZOPML  AVZOPMM  AVZOPMS  AVZOPPA  AVZOPST  AVZOQSLI AVZORXAO
    AVZORXDA AVZOSCFU AVZOSMMH AVZOTBRU AVZOTPIN AVZPAOPM AVZPB
    AVZPD61  AVZPRIMP AVZSE    AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN
    AVZSQ2BD AVZSQ2BN AVZSQ2CD AVZSQ2CN AVZSQ2DD AVZSQ2DN AVZSQL9D
    AVZSQL9N AVZSQLAD AVZSQLAN AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN
    AVZSQLDD AVZSQLDN AVZTT014 AVZVK010 AVZVKPN  AVZVPKG  AVZVS010
    AVZVSPN  AVZXMPR1
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"110"}]

Document Information

Modified date:
10 August 2021