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 

e índices com

REORG INDEXES ALL FOR TABLE 

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 

and indexes with

REORG INDEXES ALL FOR TABLE 