Re: <Start Disk Reorganization> questions

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Alan

STRDSKRGZ is the defragment command for the 400. A Knowledge Base article 
has more to say. 
<http://www-1.ibm.com/support/docview.wss?uid=nas1e6f5ea2c8c14d1508625670600726566&rs=110>. 
It's not for the files. It should be run when you get CPI0997 - Nearly all 
available machine addresses used. Reason 1 in QSYSOPR

I advise first checking how much space is lost to deleted records. Run

DSPFD *ALLUSR/*ALL TYPE(*MBRLIST) FILEATR(*PF) OUTPUT(*OUTFILE) 
OUTFILE(SOMELIB/FDMBRLIST)

and

DSPFD *ALLUSR/*ALL TYPE(*ATR) FILEATR(*PF) OUTPUT(*OUTFILE) 
OUTFILE(SOMELIB/FDATRPF).

SELECT sum(PHMXRL * (MLNRCD + MLNDTR)) totsize, sum(PHMXRL * MLNDTR) dltsize
FROM vern/fdatrpf, vern/fdmbrlist
WHERE PHFILE = MLFILE and PHLIB = MLLIB

will give you an idea of any problem. It'll also tell you about how much of 
total disk is in use by the physical files.

SELECT MLLIB, MLFILE, MLNAME, PHMXRL * (MLNRCD + MLNDTR) totsize, PHMXRL * 
MLNDTR dltsize, mlndtr / (mlnrcd + mlndtr) pctdlt
FROM vern/fdatrpf, vern/fdmbrlist
WHERE PHFILE = MLFILE and PHLIB = MLLIB and mlndtr <> 0
ORDER BY pctdlt desc

Check with your vendors, to see if they depend on RRN order for anything. 
If not, consider changing the physical files to REUSEDLT(*YES). Candidates 
are files that have ADD/UPD/DLT activity - you can see this with DSPFD 
TYPE(*MBR) - look for those with high percent deletes over writes.

HTH

Vern

At 11:30 AM 5/16/2003 -0400, you wrote:
> Arrgh! I am at 85% storage space on my 9406-170 and according to PM400
> reports am in the "critical" zone. Performance has gotten pretty sluggish
> during the day but I do not know if this is directly tied in to this.
>
> Anyway, I am familiar with reorganizing files...pretty much database file
> compaction to weed out holes left from deleted records and reindexing I
> suppose. I also know that it is difficult sometimes to get this to work on
> the files that need it most since the program has to have exclusive access
> to the object (usually a high-volume production table).
>
> But in trying to reclaim disk space over the entire 400 I ran across command
> STRDSKRGZ. This looks like a good command for the job but I had a couple of
> questions:
>
> It seems to be an "open ended" command that requires I set a time limit or
> nomax. Obviously I would like it to do the complete disk system. Does it
> stop when the entire disk is reorganized or does it just keep going?
>
> If I run it for a set length of time what are the implications behind that?
>
> Does it have the same "file lock" limitations as RGZPFM? If so I would have
> to have everyone off the system apparently.
>
> Any advice is appreciated.
>
> Alan