Writing Sample:
Club Tech Systems Management Newsletter

********** Club Tech iSeries Systems Management Newsletter *********
An iSeries Network Publication         http://www.iseriesnetwork.com
Home of iSeries NEWS Magazine                 Editor: Chuck Lundgren
Issue 89                                           December 10, 2003
********************************************************************
 
THIS WEEK:
> Determining if Temporary Index Creations Are Slowing Your System
> Analyzing IFS Disk Usage
> Latest V5R1M0 iSeries Access Service Pack PTF Available

Pro and Pro VIP Edition Items:
> Programmatically Determining Keylock Position and IPL Load Source 
> Implementing an iSeries File Upload Facility
 
1. DETERMINING IF TEMPORARY INDEX CREATIONS ARE SLOWING YOUR SYSTEM
If you're tired of scanning job logs to determine if the creation of 
temporary indexes or access paths is slowing the performance of your 
system, then you may want to consider using the iSeries Navigator 
graphical interfaces for the database performance monitors. After 
connecting to your server with iSeries Navigator, expand the 
navigation tree. In the navigation tree, expand the objects under the 
Database object.
 
On iSeries Navigator, expand the Database Icon and then Right Click on 
the SQL Performance Monitors. Select the "New -> Detailed" task to 
start collecting database monitor data. The Detailed database monitors 
will collect info on both SQL and non-SQL (eg, OPNQRYF) queries. On 
the General tab of the newly displayed window, you will input a name 
for this database monitor collection and specify the library that will 
be used for storing the database monitor data. On the Monitored Jobs 
tab, you will select a job to monitor. If you decide to collect 
database monitor data for all jobs on the system, that the database 
monitor data will add overhead and consume disk space on your server. 
In general, you should collect database monitor data for short periods 
of time.
 
To stop your database monitor data collection, double-click on the SQL 
Performance Monitors component in iSeries Navigator. In the right-hand 
window, you will see a list of all database monitor collections on the 
server. Find the monitor collection that you started and then right 
click on that collection and select the "End" task.
 
Now you are all set to analyze the database monitor data has been 
collected. The analysis process is started by right-clicking on the 
collection and selecting the "Analyze Results" task that displays a 
new window. To determine if any temporary indexes were created during 
your collection period, select the Extended Detailed Results tab and 
select the "Index Created" query. Next select the "View Results" 
button and that will run the query to return details (how the long the 
index build took, what table or file the index was created over, the 
key fields used, etc.) on any temporary indexes built during your 
monitor collection. If temporary indexes were built, you have all the 
information needed to permanently create those indexes.
 
The above tip was written by Kent Milligan, who is on IBM's DB2 UDB 
for iSeries Technology Team.
 
2. ANALYZING IFS DISK USAGE
IFS storage can easily get out of hand, given that Client Access 
Express, WebSphere, and the Apache Web server at least partially 
reside in the IFS. Some third-party programs also forgo the DB2 file 
system in favor of the IFS. 
 
Fortunately, there are several ways to analyze IFS usage, some of 
which are listed below:
 
a. An interesting Windows-based tool called SpaceMonger presents a 
graphic display showing each file and folder in a box relative to all 
the other files in the disk volume. So, for example, if a directory 
box takes up 90 percent of the screen, then that directory folder and 
all its sub-folders and files are taking up 90 percent of the disk 
volume. SpaceMonger is free and is available from
http://www.werkema.com/ .
 
b. The DspIFSObj utility published in the August 2002 iSeries NEWS 
populates an output file with the name, type, and size of each object 
in that path. For any directories that the utility encounters in the 
specified path, the command will show the total size of all objects in 
that directory's tree.
 
VIP Pro iSeries Network members can read about the utility at
http://www.iseriesnetwork.com/article.cfm?ID=14800 
 
c. IBM's free QRYIFSLIB utility outputs information such as file size, 
owner, group, etc. to outfile QRYIFSLIB in library QGPL and sums the 
directory size. You can download QRYIFSLIB and other ISF Tools 
included in the save file at 
ftp://testcase.boulder.ibm.com/as400/fromibm/ApiSamples/ifstool.savf . 
 
d. IBM's QSRSRV program prints a listing showing sizes of all files 
appearing in all the subdirectories of a specified directory along 
with totals at the end of the listing. To learn more about QSRSRV, 
read this IBM Knowledgebase item:
http://www-1.ibm.com/support/docview.wss?uid=nas193dec1bba489cfcc86256dc0006370f4&rs=110
 
e. Club Tech Programming Tips editor Scott Klement posted an RPG IV 
program in 2001 that emulates the QSH ls command, which outputs a list 
showing sizes of all files appearing in all the subdirectories of a 
specified directory. You can find the source for that program, as well 
as a discussion of the ls command, here:
http://archive.midrange.com/midrange-l/200105/msg00445.html
 
Thanks to Bill Roehmer for suggesting the SpaceMonger utility.
 
3. LATEST V5R1M0 ISERIES ACCESS SERVICE PACK PTF AVAILABLE
In late November, IBM released Service Pack PTFs for V5R1M0 iSeries 
Access for Windows. Here is where you can download the service packs:
 
V5R1M0 readme and files:
ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r1m0/servicepack/si10376/
 
Server PTFs
In addition to installing the iSeries Access for Windows Service Pack 
PTF, all servers should stay current on the latest Cumulative PTF 
Package, HIPER Group PTF, and Database Group PTF. Read the about the 
latest updates at
http://www-1.ibm.com/servers/eserver/iseries/access/servernotes.html .
 
**********************************************************************
The items below are premium content for iSeries Network Pro and Pro 
VIP members only.
**********************************************************************
 
4. PROGRAMMATICALLY DETERMINING KEYLOCK POSITION AND IPL LOAD SOURCE
A short program by Carsten Flensburg lets you determine the current 
front panel keylock position and IPL load source. This can be helpful 
if you're offsite (or if you're onsite and you're just too dang lazy 
to go and see ).
 
To learn more about the MI built-in function used in this utility, see 
the documentation at
http://publib.boulder.ibm.com/iseries/v5r1/ic2924/tstudio/tech_ref/mi/MATMATR.htm .
 
You can download the utility here:
http://www.iseriesnetwork.com/noderesources/code/clubtechcode/FrontPanelStatus.zip
 
The above source code was written by Carsten Flensburg. For questions 
regarding this tip, contact Carsten at mailto:flensburg@novasol.dk .
 
5. IMPLEMENTING AN ISERIES FILE UPLOAD FACILITY
IBM's Easy400 site has a new addition, FUPLOAD, which allows users to 
upload via HTTP any type of local PC file to a given IFS directory on 
the iSeries. All source code and instructions are available at
http://www-922.ibm.com/easy400h/fupload.htm .
 
**************** ABOUT ISERIES NETWORK NEWSLETTERS ***************
 
Club Tech iSeries Systems Management Newsletter and Club Tech 
Networking Tips Newsletter are published on alternate Wednesdays. Club 
Tech iSeries Programming Tips Newsletter is published on Thursdays. 
NEWS Wire Daily brings you daily iSeries industry news, tech tips, 
product news, and IBM announcements. Tech Observatory Newsletter is 
published every other Tuesday and pinpoints Internet resources for 
iSeries 400 professionals. All are *FREE OF CHARGE*!