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*!
|
