Informix

nested-group-icon.png

DB2

BTS config and space estimates questions

  • 1.  BTS config and space estimates questions

    Posted 30 days ago
    Hi all, our developers plan to implement fulltext functionality using BTS in the application and I have a couple of questions and I did not find the answers in docs:
    Sizing of sbspaces
    - is there any estimate formula or rule of thumbs on bts_index size?
    - is there any estimate formula or rule of thumbs on temporary space needed for bts_index creation
    Memory requirements
    - on what depends virtual memory needed for fulltext query (size of result set, size of index etc), is Bufferpool used for bts_indexes - which size? (standard ie 4kb on aix)
    Concurrency and locking
    - can 1 bts vp run more than 1 bts query concurrently?
    - what is an cost of insert/delete/update of a row with bts column? the whole index must be rewritten or just a part?
    PDQ
    - can PDQ help bts index creation? or PSORT_NPROCS
    Thanks a lot for any tip

    ------------------------------
    Milan Rafaj
    ------------------------------