Home > AS/400 Tips > iSeries administrator tips > Using the WRKDSKSTS command to increase performance
iSeries 400 Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

ISERIES ADMINISTRATOR TIPS

Using the WRKDSKSTS command to increase performance


Ron Turull
10.29.2003
Rating: -4.69- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


If you're still running OPM programs, you're suffering considerably at the hands of ILE. As you know, OPM programs run slower than their ILE counterparts: Because the native environment on Version 3 is ILE, the OPM environment has to be emulated.

If you haven't been able to convert all your programs to ILE, but you still want to boost performance, you must look elsewhere. One of the places you should look is the work with disk status command (WRKDSKSTS). This command can tell you a lot about your system -- information you can use to boost your system's performance. We've also put together a few utility programs that use the WRKDSKSTS command to help you get even more horsepower out of your system.


Ron Turull

How to determine disk activity at the system level

The work with disk status command (WRKDSKSTS) will give you a quick picture of the activity of the disks in your system. Figure 1 shows you an example of the WRKDSKSTS display for a simple three-disk system. When the WRKDSKSTS command is run for the first time in a job, the elapsed statistics (those requiring a time interval to measure) are set to zero. This can also be forced by specifying *YES for the RESET parameter on the WRKDSKSTS command or by pressing the F13 key on the WRKDSKSTS display.

Figure 1: Example of the Work with Disk Status display for a three-disk system.

To see some elapsed numbers for your system, you must press either the

  • F5 key (refresh), which will measure the interval between the last time the statistics were reset.
  • F10 key (restart statistics), which is a specialized version of the F5 key. It is the equivalent of resetting the statistics the last time you pressed a function key (i.e., the last time the display was written to the screen) and pressing the F5 key presently. In other words, F10 will give you the statistics for the time interval measured from the time you last pressed an F-key to the present.

System level distribution is shown in the "% Used" column. The system will try to even these numbers out automatically. But if you have recently added a disk, you may see numbers way out of balance. In that case, you can help the system out by following one or more of the procedures discussed in the next installment.

The six columns following the "% Used" column show detailed information about the number of reads and writes per second requested during the elapsed time and the average size in KB of the data transferred. The first two of these six columns ("I/O Rqs" and "Request Size (K)") are figures for reads and writes combined, while the remaining four columns show statistics for reads and writes individually.

The last column on the WRKDSKSTS display ("% Busy") provides an estimate of the percentage of time a particular disk unit was busy during the elapsed time. Monitoring this column throughout a typical day will give you a pretty good idea of the distribution of disk activity at the system level. Note: When you exit the WRKDSKSTS display, the elapsed statistics are not reset the next time you execute the WRKDSKSTS command in the same job.

Time-saving program

If you're like me and don't really have time to monitor the WRKDSKSTS display all day, try out this time-saving program: PRTDSKRPT0. This program takes a number of five-minute time-elapsed "photographs" randomly spaced throughout the day (or for however long you run it). I have taken advantage of a utility program that I wrote, #CEERAN0. It returns a pseudo-random number between 0 and 1 in packed decimal format. You can substitute in your favorite random-number generator, or if you want a copy of this one, drop me an e-mail at ront@the400group.com.

After you have let the program run for a day or two, you will have a series of printouts that can be studied. You are looking for equivalent numbers in the "% Busy" column.

You can also run this program-- PRTDSKRPT2 -- simultaneously to produce two 12-hour snapshots of the disk activity, one for day time and the other at night. These reports will give you a longer average, but remember it will include periods of very low activity (e.g., lunch time).

How to determine disk activity at the object level

If the activity figures (i.e., "% Busy") on the reports produced by these utility programs seem out of balance, it is time to start looking at distribution at the object level. The first targets -- large files. We need to determine if the file is evenly distributed over the available disk units. (Even if the numbers for your system look good, you may want to check you very large files anyway.)v

To do this, use the programs DSPFILDST and DSPFILDST0. These two programs make up a single utility that estimates the distribution of a file's data. This utility should be used only on a dedicated system or, best of all, while the system is in the restricted state. It can be run at other times, but the "noise" from other jobs on the system will render the information on the reports suspect at best and useless at worst.

The utility reads every record in the file you specify and then prints a WRKDSKSTS report. The figures in the "Read Rqs" column will indicate the relative distribution of the file's data. Uneven numbers in this column indicate an uneven distribution. A word of caution: Do not use this utility twice in a row for the same file without doing some other intervening work because the file's data may still be in the system's many caches.

More to come

In the next installment, we'll discuss what can be done to even out imbalances in your disks or the objects they contain. For now, take the time to run the reports and monitor your system for a while.

-----------------------------------
About the author: Ron Turull is editor of Inside Version 5. He has more than 20 years' experience programming for and managing AS/400-iSeries systems.

==================================
MORE INFORMATION
==================================

  • Three basic system tools to help you tune your iSeries
    The three basic performance management tools -- WRKSYSSTS, WRKDSKSTS and WRKACTJOB -- come with OS/400. Unfortunately, they aren't always put to the best use at the best time.
  • Speed up system with "STRASPBAL"
    Search400.com member Mario Haeck says even though the WRKDSKSTS display shows a consistent I/O sharing between the disks, it does not always reflect reality.
  • Checking for failed RAID arrays
    Search400.com member Justin Haase says SST is great for checking out your DASD, but there's a better command if you want a quick way to see if you've lost a drive over the weekend.


Rate this Tip
To rate tips, you must be a member of Search400.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries administrator tips
Translating Linux for IBM i admins: Using GUI to make it easy
Translating Linux for IBM i admins: Working with jobs and networking
OpenOffice: What to know before making the transition from Microsoft Office
OpenOffice: An enterprise open source solution
Database performance comparisons on IBM i
Translating Linux for IBM i admins: User profile commands
Modern System i reports using Client Access
Tips for installing Lotus Domino server on a System i partition
The iSeries Blog has a new home on IT Knowledge Exchange
Virtualization for IBM i: Backups

Systems Management
Can you trust all those trigger programs?
Are your backups complete?
Controlling remote command processing
Watch your profiles
Avoid locking issues
Send message to users at a remote site
Security journal receiver management
Top 10 backup commands
Tracking critical file access in real time
Create an iSeries Access image and update it with the latest Service Pack

OS/400
Top 10 backup commands
Take control of your iSeries
How to save time using the CPYTOPCD and CPYFRMPCD commands
Top Q&A's on the OS/400
Top 10 security tips
Use caution when providing access to file shares
How to set up an autostart job
How does Sarbanes-Oxley affect you?
Automated disaster recovery revisited
Top 10 Administrator Tips

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



iSeries Security - Security Tools, Physical Security and System Security
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts