db2 UDB v7.1/AIX/Estore messages

kishore babu

db2 UDB v7.1/AIX/Estore messages
Hi,
We migrated DB2 UDB from v5.2 to v7.1 for AIX(no fixpak applied) after this
following warning message comes (whenever new connection happens to db2)
eventhough database is not configured for ESTORE use, that means
(NUM_ESTORE_SEGS) = 0.. Does anyone have idea??

Our DB2DIAGLEVEL = 3

2002-01-02-09.04.11.655854 Instance:dbadminp Node:000
PID:59188(db2agent (COM)) Appid:*LOCAL.dbadminp.020102140342
buffer_pool_services sqlbinit Probe:245 Database:COM

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


Any help will be appreciated

Thanks
Kishore Kolla
DB2 UDB Support

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com



Wayne Driscoll

Re: db2 UDB v7.1/AIX/Estore messages
(in response to kishore babu)
This message will come up if you have any bufferpools that are defined to
use ESTORE, but you have NUM_ESTORE_SEGS = 0.
Look at syscat.bufferpools to see if any of the bufferpools have ESTORE =
'Y'.
Wayne Driscoll
Product Developer
Quest Software Inc.
[login to unmask email]
Note: All opinions are strictly my own.

-----Original Message-----
From: kishore babu [mailto:[login to unmask email]
Sent: Thursday, January 03, 2002 10:46 AM
To: [login to unmask email]
Subject: [DB2-L] db2 UDB v7.1/AIX/Estore messages


Hi,
We migrated DB2 UDB from v5.2 to v7.1 for AIX(no fixpak applied) after this
following warning message comes (whenever new connection happens to db2)
eventhough database is not configured for ESTORE use, that means
(NUM_ESTORE_SEGS) = 0.. Does anyone have idea??

Our DB2DIAGLEVEL = 3

2002-01-02-09.04.11.655854 Instance:dbadminp Node:000
PID:59188(db2agent (COM)) Appid:*LOCAL.dbadminp.020102140342
buffer_pool_services sqlbinit Probe:245 Database:COM

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


Any help will be appreciated

Thanks
Kishore Kolla
DB2 UDB Support

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com





Michael McCarthy

Re: db2 UDB v7.1/AIX/Estore messages
(in response to Wayne Driscoll)
Hi Kishore,

Do you have any user created bufferpools with a "Y" in the ESTORE
column of SYSIBM.SYSBUFFERPOOLS?

-Mike.





kishore babu <[login to unmask email]>@RYCI.COM> on 01/03/2002 11:45:47
AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: [DB2-L] db2 UDB v7.1/AIX/Estore messages


Hi,
We migrated DB2 UDB from v5.2 to v7.1 for AIX(no fixpak applied) after this
following warning message comes (whenever new connection happens to db2)
eventhough database is not configured for ESTORE use, that means
(NUM_ESTORE_SEGS) = 0.. Does anyone have idea??

Our DB2DIAGLEVEL = 3

2002-01-02-09.04.11.655854 Instance:dbadminp Node:000
PID:59188(db2agent (COM)) Appid:*LOCAL.dbadminp.020102140342
buffer_pool_services sqlbinit Probe:245 Database:COM

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


Any help will be appreciated

Thanks
Kishore Kolla
DB2 UDB Support

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com








kishore babu

Re: db2 UDB v7.1/AIX/Estore messages
(in response to Michael McCarthy)
Hi Mike,
I checked this, we do not have user created bufferpools for this database,
we are using IBMDEFAULTBP only. Following is some more details about
problem::
We have 5 databases in one instance, out of which one database is configured
for ESTORE ( that means user created bufferpool with 'Y' in
SYSCAT.BUFFERPOOLS), so we are not getting any warning message.
And other 4 databases are not configured for ESTORE, only one record in
syscat.bufferpools, that is IBMDEFAULTBP. For these four databases I am
getting this warning message
"WARNING: estore is OFF but bufferpools are configured to use it"..


Thanks
Kishore Kolla
DB2 UDB Support
>From: Michael McCarthy <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: db2 UDB v7.1/AIX/Estore messages
>Date: Thu, 3 Jan 2002 12:48:17 -0500
>
>Hi Kishore,
>
> Do you have any user created bufferpools with a "Y" in the ESTORE
>column of SYSIBM.SYSBUFFERPOOLS?
>
> -Mike.
>
>
>
>
>
>kishore babu <[login to unmask email]>@RYCI.COM> on 01/03/2002 11:45:47
>AM
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>
>
>To: [login to unmask email]
>cc:
>Subject: [DB2-L] db2 UDB v7.1/AIX/Estore messages
>
>
>Hi,
>We migrated DB2 UDB from v5.2 to v7.1 for AIX(no fixpak applied) after this
>following warning message comes (whenever new connection happens to db2)
>eventhough database is not configured for ESTORE use, that means
>(NUM_ESTORE_SEGS) = 0.. Does anyone have idea??
>
>Our DB2DIAGLEVEL = 3
>
>2002-01-02-09.04.11.655854 Instance:dbadminp Node:000
>PID:59188(db2agent (COM)) Appid:*LOCAL.dbadminp.020102140342
>buffer_pool_services sqlbinit Probe:245 Database:COM
>
>WARNING: estore is OFF but bufferpools are configured to use it 0000 0000
>
>
>Any help will be appreciated
>
>Thanks
>Kishore Kolla
>DB2 UDB Support
>
>_________________________________________________________________
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
>
>
>
>
>
>
>
>


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx