Welcome To Support Community

Direct, Draw, and JDraw

Advanced Search
Ask Search:
Joe_BJoe_B 

Altering Index to enable the Keep Buffer

Hi,

I'd like to try enabling the keep buffer in Direct 9.0 HF2 for our Markush (generics) and molecule tables as outline on page 121 of the Admin guide 'The Fastsearch index cache and searching'  section.

However from the guide I'm not clear about the syntax of the alter index command to do this. Looking at the _FSIX  index/table  it appears to show the buffer pool as default

 CREATE TABLE "xxxxx"."xxxxxINDEX_FSIX" 
   (    "SEGNO" NUMBER(9,0), 
    "FSINDEX" BLOB
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" 
 LOB ("FSINDEX") STORE AS BASICFILE (
  TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 5
  CACHE READS LOGGING 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) 
  MONITORING ;

How do I update this using the Alter Index to set it to a keep buffer instead?

Thanks

Joe
DanielDaniel (BIOVIA) 
Hi Joe,

the command to run to change the buffer cache from DEFAULT to KEEP is

ALTER INDEX xxxxxINDEX PARAMETERS ('FS_BUFFER_POOL=KEEP');

Regards
Daniel