Hello all,

I am new to UDB, and I have a question. How canI perform a global table reorg? I know how to do an indiviual table reorg using the utility, but it would be a big pain to do this to eahc individual table in the database. Any ideas?

We are on UDB 7.2 running on Win2K.

Thank you,

Write an sql like this to generate a script and just run it:


SELECT 'RUNSTATS ON TABLE ' || TABSCHEMA || '.' || TABNAME || ' WITH DISTRIBUTION AND DETAILED INDEXES ALL ; '
FROM SYSCAT.TABLES
WHERE TYPE = 'T'
AND TABSCHEMA = 'YOURSCHEMA'
;

You can change any option in the SQL above and customize for your use.

HTH

dollar

There is no concept of 'REORG ALL' ..

The option available is to script as dollar489 suggests .. Thanks dollar ./.

Cheers
Sathyaram

For runstats all you can also use

REORGCHK UPDATE STATISTICS

command, its similar to what dollar489 SQL is generating (without distribution and detailed indexes).
For reorg all just rewrite this sql with reorg command.

Regards,
Adam AC