https://ebasso.net/wiki/index.php?action=history&feed=atom&title=DB2%3AReorg_Tables_in_Databases
DB2:Reorg Tables in Databases - Revision history
2026-06-02T16:07:26Z
Revision history for this page on the wiki
MediaWiki 1.40.0
https://ebasso.net/wiki/index.php?title=DB2:Reorg_Tables_in_Databases&diff=9563&oldid=prev
Ebasso: Created page with "= Shell de Criação dos arquivos de reorg = 1) Conectar com um usuário com permissão de db2admin 2) Criar o arquivo '''db2-reorg-tables.sh''' #!/bin/bash # altere o nome das bases na proxima linha for DBNAME in BLOGS DOGEAR FILES FORUM HOMEPAGE OPNACT PEOPLEDB SNCOMM WIKIS METRICS COGNOS PNS CCM do db2 connect to $DBNAME db2 reorgchk update statistics on table all > resultado$DBNAME.txt db2 terminate echo "db2 connect to $DBNAME" > reorg$DBNAMETab..."
2025-07-09T16:59:13Z
<p>Created page with "= Shell de Criação dos arquivos de reorg = 1) Conectar com um usuário com permissão de db2admin 2) Criar o arquivo '''db2-reorg-tables.sh''' #!/bin/bash # altere o nome das bases na proxima linha for DBNAME in BLOGS DOGEAR FILES FORUM HOMEPAGE OPNACT PEOPLEDB SNCOMM WIKIS METRICS COGNOS PNS CCM do db2 connect to $DBNAME db2 reorgchk update statistics on table all > resultado$DBNAME.txt db2 terminate echo "db2 connect to $DBNAME" > reorg$DBNAMETab..."</p>
<p><b>New page</b></p><div>= Shell de Criação dos arquivos de reorg =<br />
<br />
1) Conectar com um usuário com permissão de db2admin<br />
<br />
2) Criar o arquivo '''db2-reorg-tables.sh'''<br />
<br />
<br />
#!/bin/bash<br />
# altere o nome das bases na proxima linha<br />
for DBNAME in BLOGS DOGEAR FILES FORUM HOMEPAGE OPNACT PEOPLEDB SNCOMM WIKIS METRICS COGNOS PNS CCM<br />
do<br />
<br />
db2 connect to $DBNAME<br />
db2 reorgchk update statistics on table all > resultado$DBNAME.txt<br />
db2 terminate<br />
<br />
echo "db2 connect to $DBNAME" > reorg$DBNAMETable.txt<br />
cat resultadoPEOPLEDB.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorg$DBNAMETable.txt<br />
echo "db2 terminate" >> reorg$DBNAMETable.txt<br />
<br />
echo "db2 connect to $DBNAME" > reorg$DBNAMEIndex.txt<br />
cat resultadoPEOPLEDB.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorg$DBNAMEIndex.txt<br />
echo "db2 terminate" >> reorg$DBNAMEIndex.txt<br />
<br />
sh -x reorg$DBNAMETable.txt<br />
<br />
sh -x reorg$DBNAMEIndex.txt<br />
<br />
done<br />
<br />
Salvar e fechar<br />
<br />
3) Executar o arquivo<br />
<br />
sh -x db2-reorg-tables.sh<br />
<br />
= Exemplos do resultado=<br />
<br />
----<br />
<br />
db2 connect to PEOPLEDB<br />
db2 reorgchk update statistics on table all > resultadoPEOPLEDB.txt<br />
db2 terminate<br />
<br />
echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBTable.txt<br />
cat resultadoPEOPLEDB.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgPEOPLEDBTable.txt<br />
echo "db2 terminate" >> reorgPEOPLEDBTable.txt<br />
<br />
echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBIndex.txt<br />
cat resultadoPEOPLEDB.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgPEOPLEDBIndex.txt<br />
echo "db2 terminate" >> reorgPEOPLEDBIndex.txt<br />
<br />
sh -x reorgPEOPLEDBTable.txt<br />
<br />
sh -x reorgPEOPLEDBIndex.txt<br />
<br />
<br />
<br />
= Ver também =<br />
<br />
* [[IBM Connections:Reorg Connections Databases]]<br />
* [[IBM Connections:Limpeza de diretórios]]<br />
<br />
* [[IBM Connections| Mais Artigos sobre IBM Connections]]<br />
<br />
[[Category:IBM Connections]]<br />
[[Category:Tuning IBM Connections]]</div>
Ebasso