DB2:Reorg Tables in Databases: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

9 July 2025

  • curprev 16:5916:59, 9 July 2025Ebasso talk contribs 1,911 bytes +1,911 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..."