https://ebasso.net/wiki/index.php?action=history&feed=atom&title=NsfDb2_Dica_de_Performance
NsfDb2 Dica de Performance - Revision history
2026-04-10T11:41:21Z
Revision history for this page on the wiki
MediaWiki 1.40.0
https://ebasso.net/wiki/index.php?title=NsfDb2_Dica_de_Performance&diff=2755&oldid=prev
Ebasso at 18:12, 27 February 2014
2014-02-27T18:12:54Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 18:12, 27 February 2014</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l47">Line 47:</td>
<td colspan="2" class="diff-lineno">Line 47:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''REORG INDEXES ALL FOR TABLE <Table_name>'''</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''REORG INDEXES ALL FOR TABLE <Table_name>'''</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">= Ver também =</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [[Lotus Domino e Notes| Mais artigos sobre IBM Domino e Notes]]</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [[Variaveis do Notes.ini]]</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category: IBM Domino]]</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category: Lotus Domino]]</ins></div></td></tr>
<!-- diff cache key ebasso_wikidb:diff::1.12:old-12:rev-2755 -->
</table>
Ebasso
https://ebasso.net/wiki/index.php?title=NsfDb2_Dica_de_Performance&diff=12&oldid=prev
201.12.4.4: New page: 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) Atua...
2007-04-10T17:22:41Z
<p>New page: 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) Atua...</p>
<p><b>New page</b></p><div>Estou testando o domino com db2. Então vai uma boa dica de performance.<br />
<br />
"Fazer o reorg check da base domino no db2"<br />
<br />
Como fazer:<br />
<br />
1) Conecte-se ao db2.<br />
<br />
'''CONNECT TO DOMINO;'''<br />
<br />
2) Atualiza as estatísticas das tabelas<br />
<br />
'''REORGCHK UPDATE STATISTICS ON TABLE ALL > REORG.TXT ;'''<br />
<br />
Veja o resultado no arquivo reorg.txt<br />
<br />
3) Execute o reorg para as tabelas e índices <br />
<br />
'''REORG TABLE <Table_name>'''<br />
<br />
e índices com<br />
<br />
'''REORG INDEXES ALL FOR TABLE <Table_name>'''<br />
<br />
<br />
''English Version:''<br />
<br />
I trying domino with db2. So a good performance tip is <br />
<br />
Find needed reorg checks in domino db2 database<br />
<br />
1) Connect to Db2<br />
<br />
'''CONNECT TO DOMINO;'''<br />
<br />
2) Update the statistics for tables<br />
<br />
'''REORGCHK UPDATE STATISTICS ON TABLE ALL > REORG.TXT ;'''<br />
<br />
See the reorg.txt file for the results, after this, reorg the tables with<br />
<br />
3) Run reorg for tables and for indexes<br />
<br />
'''REORG TABLE <Table_name>'''<br />
<br />
and indexes with <br />
<br />
'''REORG INDEXES ALL FOR TABLE <Table_name>'''</div>
201.12.4.4