Hi, could someone give an example of a REORGCHK command? I would like to do a REORGCHK on all my tables inside my database.

I'm running on a S/390 DB2 v7.2.

Any help would be great.

Thanks.

db2 reorgchk current statistics on table ALL
or if you want it to run runstats
db2 reorgchk on table ALL

Hi mbourd25,

You wrote:
On witch operating sistem are you running the db2? S/390 is hardware like Intel on PC world. There are 4 operating sistems on S/390 hardware having the DB2 database:
- MVS, OS/390, z/OS
- VM, z/VM
- VSE and
- Linux for S/390.

Execute the following command in Command Window for full sintax of reorgchk command (if using z/OS or Linux):
db2 ? reorgchk

Hope this helps,
Grofaty

in O/S 390 no reogchk utility.

only reorg available.


but you can find table need reorg



if clasterratio in sysibm.sysindexe is < 90

row overflow in sysibm.systables is > 5


need to run reorg

for more detail Utility Guide and Reference for