Steve, The syntax is right, maybe your query tool doesn't understand index tablespaces.
Try querying the catalog directly : reading from SYSIBM.SYSTABLESPACES will give you the bufferpoolid which you can then tie up with SYSIBM.SYSBUFFERPOOLS. HTH Phil On Fri, 3 Jan 2003 18:40:22 EDT, steve shapero wrote: >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
