IBM Support

JR28491: THE SWAP MEMORY METRICS RETURNED BY DB2 LUW ARE INCORRECT ON THE WINDOWS PLATFORMS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Swap memory metrics returned by DB2 LUW are incorrect on
    the Windows platforms.
    .
    This incorrect behavior can be seen in the output of the db2pd
    -osinfo command starting in DB2LUW v8.2 and the output of the
    ENV_GET_SYS_RESOURCES SQL routine and associated view
    ENV_SYS_RESOURCES starting in DB2LUW v9.5. All operating system
    platforms other than Windows are not affected.
    .
    The TotalSwap and FreeSwap parameters of the db2pd command
    below represent the incorrect values. Note that the command was
    executed on a DB2LUW V9.5 instance but the output is similar to
    it`s v8.2 counterpart.
    .
    db2pd -osinfo
    .
    Operating System Information:
    .
    OSName:   WIN32_NT
    NodeName: MyHost
    Version:  5.1
    Release:  Service Pack 2
    Machine:  x86 Family 6, model 9, stepping 5
    .
    CPU Information:
    TotalCPU    OnlineCPU ConfigCPU   Speed(MHz) HMTDegree
    1     1  1     1594 1     1
    .
    Physical Memory and Swap (Megabytes):
    TotalMem    FreeMem AvailMem    TotalSwap FreeSwap
    1023     31  31     1442 1545
    .
    Virtual Memory (Megabytes):
    Total     Reserved Available   Free
    2465     n/a  n/a     1576
    .
    CPU Usage Information:
    Total   Usr     Sys       Wait Idle
    3.000969  0.000000  2.999970  0.999990 96.999031
    .
    .
    The MEMORY_SWAP_TOTAL and MEMORY_SWAP_FREE rows returned by the
    ENV_SYS_RESOURCES view below represent the incorrect values.
    Note that this view is only available in DB2LUW v9.5 and later
    .
    db2 "SELECT SUBSTR(NAME,1,20) AS NAME, SUBSTR(VALUE,1,10)
    AS VALUE, SUBSTR(DATATYPE,1,10) AS DATATYPE, DBPARTITIONNUM
    FROM SYSIBMADM.ENV_SYS_RESOURCES WHERE
    SUBSTR(NAME,1,11)='MEMORY_SWAP'"
    .
    NAME       VALUE DATATYPE   DBPARTITIONNUM
    -------------------- ---------- ---------- --------------
    MEMORY_SWAP_TOTAL    1442 BIGINT   0
    MEMORY_SWAP_FREE     652 BIGINT   0
    .
      2 record(s) selected.
    .
    

Local fix

  • The workaround is to use windows utilities such as PERFMON.EXE o
    r the Task Manager  to get a more appropriate value.
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    DB2 LUW on Windows
    ****************************************************************
    PROBLEM DESCRIPTION:
    THE SWAP MEMORY METRICS RETURNED BY DB2 LUW ARE INCORRECT ON THE
    WINDOWS PLATFORMS.
    ****************************************************************
    RECOMMENDATION:
    Upgrade to v91FP6 or v95FP1
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 6 and Version 9.5,
    FixPack 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR28491

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-02-12

  • Closed date

    2008-11-10

  • Last modified date

    2008-11-10

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

    JR27904

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 October 2021