IBM Support

PM32228: ZALLT AND USING FILTER ZFILT ON LOCATION DOES NOT WORK CORRECTLYAFTER MIGRATION TO DB2 V910. KO2OQALK AB/S0C4

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ZALLT and using filter ZFILT on location does not work correctly
    after migration to DB2 V910.
    Thread display shows ip address  =' ::192.8.235.86 ' : but ZFILT
    is not able to filter for this location.
    
    Example:
    _________ ZFILT    VTM     O2  410.PN DBCC 01/24/11 11:34:44   2
    > Help PF1     Back PF3
    > T.J
    >  Thread Activity:  Enter a selection letter on the top line.
    .
    > A-All-Idle  B-TSO  C-CICS  D-IMS  E-Background F-Dist Allied
    > G-Dist DBAC H-Util  I-Inact *-Filter K-Functions L-Stored Proc
    > M-Triggers  N-Sysplex O-Enclaves P-Worksta Q-All+Idle
    ===============================================================
    >              Filter Options For Thread Activity Displays
    THFL
    +
    + Specify the values to be used as filtering criteria for Thread
    + Activity displays. Wildcard values * (multiple characters) or
    + ? (single character) may be specified for character values.
    +
    : PLAN             =  ________           (plan name)
    : PACKAGE/DBRM     =  ________           (name      )
    : COLLECTION       =  __________________ (collect id)
    : AUTHID           =  ________           (authorization id)
    : CONNID           =  ________           (connection id)
    : CORRID           =  ____________       (correlation id)
    : LOCATION         =  192*____________   (location)
    ......
    gives :
    ================================================================
    >                    Threads Summary Excluding Idle Threads
    THDA                                                     FLTR ON
    +      No Threads Are Currently Active
    ================================================================
    .
    This apar also fixes, ABEND 0C4 in KO2OQALK at PM42983 level
    offset +402, where Reg14 point to a Freed Storage.
    .
    OMEGAMON II FOR DB2: COMPID=5655OPE00, JOB=OMD2COL ,
    LMOD=KO2CDB2K#L, CSECT=#UNKNOWN, OFFSET=053C7A
    Symptom             Description
    -------             -----------
    RIDS/KO2CDB2K#L     Load module name: KO2CDB2K
    RIDS/#UNKNOWN       Csect name: #UNKNOWN
    AB/S00C4            System abend code: 00C4
    PRCS/00000011       Abend reason code: 00000011
    REGS/0A3AA          Register/PSW difference for R0A: 3AA
    .
    PSW: 07752000 80000000 00000000 3B838002
    Instruction length: 04   Interrupt code: 0011
    Failing instruction text: 1211A784 00089200 E000A7EA
    Translation exception address: 00000000_40E00400
    
    Breaking event address: 00000000_3B83800A
    AR/GR 0-1    00000000_00000007  00000000_00000001
    AR/GR 2-3    00000000_40DFF080  00000000_7E53C61C
    AR/GR 4-5    00000048_00000014  00000000_7E53C630
    AR/GR 6-7    00000000_FFFFF118  00000000_40DFF960
    AR/GR 8-9    00000000_00000002  00000000_41287730
    AR/GR 10-11  00000000_3B837C58  00000000_7E53C168
    AR/GR 12-13  00000000_4127EFC0  00000000_40DFF080
    AR/GR 14-15  00000000_40E00000  00000000_00000000
    .
    ___________________________________________________
    

Local fix

  • Please apply PTF when available.
    Circumvention is:
    Use filter for '::192.8.235.86' as follows:
    : LOCATION         =  ??192*__________   (location)
    The filter will work correctly.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Classic Interface                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: FILTER ZFILT ON LOCATION DOES NOT WORK  *
    *                      CORRECTLY AFTER MIGRATION TO DB2 V910   *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    DB2 VERSION 9 AND ABOVE SUPPORTS IPV6 STANDARD. ACCORDING TO
    IPV6 STANDARD A VALID WAY TO DISPLAY IPV4 ADDRESSES IS TO
    DISPLAY :: OR ::FFFF: BEFORE IPV4 ADDRESS.
    IT CAUSED TO A PROBLEM DURING PROCESSING LOCATION FILTER VALUES,
    WHICH DO NOT HAVE :: OR ::FFFF:
    
    PROBLEM CONCLUSION:
    CHANGE LOGIC TO BYPASS symbols :: OR ::FFFF: DURING PROCESSING
    LOCATION FILTER.
    

Problem conclusion

  • CHANGE LOGIC TO BYPASS symbols :: OR ::FFFF: DURING PROCESSING
    LOCATION FILTER.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM32228

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-02-08

  • Closed date

    2011-09-01

  • Last modified date

    2017-02-04

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

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

    UK71534 UK71535 UK71536

Modules/Macros

  •    DGOVDB2F DGOVMSTR DGOVSTQL FPEVDB2F KO2CT2SA
    KO2CT2SK KO2CT2SS KO2CT2S2 KO2OQALA KO2OQALK KO2OQAL2
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R410 PSY UK71534

       UP11/09/02 P F109

  • R420 PSY UK71535

       UP11/09/02 P F109

  • R510 PSY UK71536

       UP11/09/02 P F109

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 February 2017