[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


DB2 Diaglog warning problem

Posted on 2005-04-18
Medium Priority
Last Modified: 2012-08-13
I have a DB2 UDB 7.2 installed on AIX 5.1, i have set  buffpage to 280000 (pages), but in db2diag.log appear:

2005-04-17-   Instance:ipmprod   Node:000
PID:29228(db2agent (PMPROD))   Appid:*LOCAL.ipmprod.050417101813
buffer_pool_services  sqlbinit   Probe:245   Database:PMPROD

WARNING: estore is OFF but bufferpools are configured to use it 0000 0000                                     ....                

At the same time the catalog table SYSCAT.BUFFERPOOLS is set to:

> db2 "select * from syscat.bufferpools"

------------------ ------------ ------------------ ----------- ----------- ------
IBMDEFAULTBP                  1 -                           -1        4096 N    

  1 record(s) selected.

and db cfg parameter, related to extended storage is:

 Extended storage segments size (4KB)    (ESTORE_SEG_SZ) = 0
 Number of extended storage segments   (NUM_ESTORE_SEGS) = 0

What does it means previous warning in db2diag.log? Could be some problems in future?

Thanks in advance
Question by:marcogibs
  • 3
  • 3
LVL 13

Accepted Solution

ghp7000 earned 250 total points
ID: 13806843
how much ram does your machine have?

Author Comment

ID: 13810680
My machine have 15 GByte of RAM, but we can allocate only 5 segment for DB2 7.2 (32bit).
From 0x4... to 0x8... for bufferpool, no more.
The extended memory seems don't work fine.


Author Comment

ID: 13813783
Each segment  size is: 256 MB

In DB2 7.2 for AIX 5L seems not possible have more than 5 segments allocated, also with extended storage.
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

LVL 13

Expert Comment

ID: 13818469
try setting your bufferpool usage to no more than 250,000 4K pages total for all bufferpools

Author Comment

ID: 13878393
Now seems working fine, without warning.

Please could you say why now work fine?

LVL 13

Expert Comment

ID: 13936421
Sorry, didnt see your last post, it works because the most memory you can assign to DB2 is 1.75GB total in 32 bit instan ce. If 64 bit instance, the amount of memory you can assign is much larger, to see if if you have 32 bit or 64 bit you can do bootinfo -k

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month19 days, 13 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question