Hi Steve,
The create table and create tablespace statements used by you are
absolutely fine .
you are telling there is nothing in bufferpool BP2.
Possible reason for this can be your table do'nt need any index.
Try creating some indexes on this table explicitly.
Then look on the index tablespace(SSAT004X) by list tablespaces show
deatil.
You will observe that free pages start reducing in tablespace SSAT004X as
you create index on "DBSAT001"."T0040STOCK_ITEM"
Then you can check from table sysibm.systablespaces bufferpoolid
corresponding to this Tablespace .
And from Bufferpoolid Using sysibm.sysbufferpool you can get bufferpool
name.
I hope this will help you.
Regards
Deepak Bansal
"steve
shapero" To: [EMAIL PROTECTED]
<[EMAIL PROTECTED] cc:
m> Subject: [DB2EUG] setting the bufferpool
for a tablespace
Sent by:
owner-db2eug@L
ugwash.org
01/04/03 05:10
AM
Please respond
to "steve
shapero"
hi list--
apologies in advance if this is stupid, but i think you guys (and girls)
will enjoy this one:
i am running UDB 7.1 (fp5) in rh linux 7.2. i am trying to get my index
tablespaces to use a separate bufferpool to begin my performance tuning
process.
i have created my tablespace and tables like this:
CREATE REGULAR TABLESPACE SSAT004
MANAGED BY DATABASE
USING(FILE '/db2db/dpsat001/ssat004/part0001' 5000)
BUFFERPOOL BP1
;
CREATE REGULAR TABLESPACE SSAT004X
MANAGED BY DATABASE
USING(FILE '/db2index/dpsat001/ssat004x/part0001' 2500)
BUFFERPOOL BP2
;
------------------------------------------------
-- DDL Statements for table "DBSAT001"."T0040STOCK_ITEM"
------------------------------------------------
CREATE TABLE "DBSAT001"."T0040STOCK_ITEM" (
blah blah a bunch of columns )
IN "SSAT004" INDEX IN SSAT004X;
i have a handy utility called advanced query tool for snooping around my
db2 setup, since i am not a DBA and certainly not a DB2 wiz. when i look
at indexes in bufferpool BP2 (which i thought ssat004x would use), i see
nothing. all my indexes are in BP1. is something wrong with my create
table syntax (where i tried to say put the indexes in their own
tablespace)?
is this feature not supported on this platform?
thank you in advance for helping a poor developer out!
steve shapero
satellite records
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
