'Unable to determine swap space info' warning message is seen repeatedly in the db2diag.log

Technote (troubleshooting)


Problem(Abstract)

The warning message in db2diag.log file 'Unable to determine swap space info' ECF=0x90000002=-1879048190=ECF_FAILED is seen in function stmmCalcMinMaxFree.

Symptom

The following warning message will be seen repeated every 3 minutes in the db2diag.log

2010-01-27-13.37.00.307961-300 I2035400A547 LEVEL: Warning
PID : 2232360 TID : 7172 PROC : db2sysc 0
INSTANCE: DB2INST1 NODE : 000 DB : SAMPLE
APPHDL : 0-388 APPID: *LOCAL.DB2.100127164259
AUTHID : DB2INST1
EDUID : 7172 EDUNAME: db2stmm (SAMPLE) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCalcMinMaxFree,
probe:1833
MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED
Failed
DATA #1 : String, 36 bytes
Unable to determine swap space info.

Cause

DB2 uses the AIX function perfstat_memory_total() which is located inside libperfstat.a library to return various information about memory usage in the system including swap space size information. However in AIX 5.3 TL09 this function has been modified and DB2 V9.5 fixpack 5 was compiled to reflect those changes.


If DB2 V9.5 Fixpack 5 is run on an AIX level lower than 5.3 TL09 these warning messages will be seen in the db2diag.log because DB2 is calling an outdated AIX perfstat_memory_total() function


Resolving the problem

Update your current AIX 5.3 level to TL09 and above to ensure that your fileset bos.perf.libperfstat version is greater than or equal to 5.3.9.0 when running DB2 V9.5 Fixpack 5.

Related information

Known issue for db2 on AIX 5.2 5.3 and 6.1

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Operating System Services (OSS) - Memory Management

Software version:

9.5

Operating system(s):

AIX

Software edition:

Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server

Reference #:

1421676

Modified date:

2012-11-10

Translate my page

Machine Translation

Content navigation