Reorganizing SQL system tables

[Guest.Visitor]

Can I use a normal RGZPFM to reorganize the SQL system tables e.g. SYSCOLUMNS.

[Guest.Visitor]

R.O. It may work, but I would run a RCLSTG *DBXREF. David Morris

[Guest.Visitor]

The RGZPFM command should work on any DB2/400 file. I am not aware of any instance where this does not work. Dave

[Guest.Visitor]

Why do they need to be "reorged" ? bobh

[Guest.Visitor]

Huge number of deleted records.

[Guest.Visitor]

Are you adding and removing lots of tables and columns? bobh

[Guest.Visitor]

David, One feature of the RCLSTG command is that you have to use it in restricted state. The catalog files are updated as files are created or updated. I would not want to find out that some internal process failed to build a table because the catalog was in use. On the other hand, it could be all process that update that table would just wait for the reorg to complete. David Morris

[Guest.Visitor]

I was responding to the post on RGZPFM. I don't know how RCLSTG came into this!?! Dave

[Guest.Visitor]

David, The file mentioned was syscolumns, which is a system file in qsys2. It contains column information for every file on the system and is maintained by the system. It is generally reorganized using rclstg. I wouldn't try rgzpfm on this file and I doubt you could get a lock on it anyway. David Morris