RE: IFS "reorg"

Thanks - probably have too much windows on the brain. My question did read weird after I read it again. Deleting an IFS object is the same as deleting a database table object. Unless you work with MS Sharepoint where putting a file in a folder is actually adding a record to a database table and deleting a file from a folder is deleting a record from a table. I had forgotten about the ASP Balance command which is probably the closest thing to windows disk reorg. Thanks for the reminder

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, October 22, 2014 2:11 PM
To: Midrange Systems Technical Discussion
Subject: Re: IFS "reorg"

(Please read the whole reply, let me have a little fun at first and then I get serious)

Um, think about what you said.
If you deleted a bunch of DB2 files you would then run a RGZPFM. I've found it quite hard to RGZPFM a file that no longer exists. How do you get that done? :-) IOW, deleting a table is a lot different than deleting rows in a table.

I suppose if you were running a S/36 you could try a COMPACT command.

But, seriously though, if it was REALLY significant you may want to consider researching TRCASPBAL and STRASPBAL.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Mike Cunningham <mike.cunningham@xxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/22/2014 02:06 PM
Subject: IFS "reorg"
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



We are in the process of deleting a lot of old unused files from the IFS.
If I were to do that for a database file I would run a RGZPFM at some
point after to free up the deleted record space. Is there a command that
should be run against the IFS if you do a lot of file deletions or does it
manage itself really well?