110 pts.
 ASP getting increasing
Hi All, One of the our production server its V5R4.3 months back only we bought this server.Perviously its working fine.But Nowadays ASP is getting increasing some times its went 55% also.we deleted some JRNRCVRs which are in SAVED status.but still its getting increasing.Any one know why its increasing.please suggest to this matter..

Software/Hardware used:
ASKED: January 13, 2009  1:15 PM
UPDATED: January 14, 2009  6:12 PM

Answer Wiki:
Hi, Try using RTVDSKINF and PRTDSKINF - this should give you an overview of where your space is being used. If you've been using the machine in production for 3 months I guess you now have at least 3 months worth of production data.. Regards, Martin Gilbert.
Last Wiki Answer Submitted:  January 13, 2009  1:38 pm  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Hi All,

One of the our production server its V5R4.3 months back only we bought this server.Perviously its working fine.But Nowadays ASP is getting increasing some times its went 55% also.we deleted some JRNRCVRs which are in SAVED status.but still its getting increasing.Any one know why its increasing.please suggest to this matter..

 110 pts.

 

The line % system ASP used on the Work with System Status screen tells you how much of your available disk space has been used.

 830 pts.

 

Here is another thought.

When records (rows) are deleted from tables the space occupied by the row typically remains reserved until the table is reorganized. That means, without reorg’s files will get bigger over time, but never smaller. The DSPFD command will show the number of records and number of deleted records. Use MBRLIST option

Here is what one of mine looks like
Total records . . . . . . . . . . . . . . : 6432
Total deleted records . . . . . . . . . . : 29232
Total of member sizes . . . . . . . . . . : 34467840

In this case, of the 34 megabytes about 80% is deleted records!
The DSPFD command can be run to an “outfile” so you have a file of this data for all the files in a library or all user libraries.

Phil

 44,190 pts.

 

You can clean up a file with the RGZPFM command – but not when the file is in use.

Spooled files will take up space – or at least allocate space. Delete what you don’t need and run the RCLSPLSTG command.

You should also run the RCLSTG command – but you’ll need the system in a restricted state for that. It may take a while the first go around.

See the help on these command for more information.

Last resort – shoot the developers who are making big copies of files… :)

Regards
Mike

 2,725 pts.