View Full Version : Reorganizing SQL system tables
01-01-1995, 02:00 AM
Can I use a normal RGZPFM to reorganize the SQL system tables e.g. SYSCOLUMNS.
11-01-2000, 03:26 PM
R.O. It may work, but I would run a RCLSTG *DBXREF. David Morris
11-02-2000, 07:12 AM
The RGZPFM command should work on any DB2/400 file. I am not aware of any instance where this does not work. Dave
11-02-2000, 07:26 AM
Why do they need to be "reorged" ? bobh
11-02-2000, 07:35 AM
Huge number of deleted records.
11-02-2000, 09:00 AM
Are you adding and removing lots of tables and columns? bobh
11-02-2000, 01:16 PM
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
11-03-2000, 02:25 AM
I was responding to the post on RGZPFM. I don't know how RCLSTG came into this!?! Dave
11-03-2000, 04:00 AM
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
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.