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
