NsfDb2 Dica de Performance

Estou testando o domino com db2. Então vai uma boa dica de performance.

"Fazer o reorg check da base domino no db2"

Como fazer:

1) Conecte-se ao db2.

CONNECT TO DOMINO;

2) Atualiza as estatísticas das tabelas

REORGCHK UPDATE STATISTICS ON TABLE ALL > REORG.TXT ;

Veja o resultado no arquivo reorg.txt

3) Execute o reorg para as tabelas e índices

REORG TABLE <Table_name>

e índices com

REORG INDEXES ALL FOR TABLE <Table_name>

English Version:

I trying domino with db2. So a good performance tip is

Find needed reorg checks in domino db2 database

1) Connect to Db2

CONNECT TO DOMINO;

2) Update the statistics for tables

REORGCHK UPDATE STATISTICS ON TABLE ALL > REORG.TXT ;

See the reorg.txt file for the results, after this, reorg the tables with

3) Run reorg for tables and for indexes

REORG TABLE <Table_name>

and indexes with

REORG INDEXES ALL FOR TABLE <Table_name>