IBM Support

JR27904: 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

  • see problem description
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR27904

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-23

  • Closed date

    2008-05-05

  • Last modified date

    2008-05-05

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

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

    JR28491

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 May 2008