RE: Preventative Maintenance For AS400

It should be mentioned that RCLSTG SELECT(*DBXREF) is used to fix very
specific database cross-reference table problems, it is NOT the
equivalent of a defrag or in any way a "preventative measure."

Some people used to recommend a full RCLSTG yearly or before upgrades to
clean up damaged objects, but my understanding is that this is rarely
required anymore.  As the documentation states "This can be a long
running command" so use it carefully. (Normally only when recommended by
Supportline.)

My advice on preventative measures is to be familiar with your
application and know which PTFs you need to stay current on, for example
the DB2 group PTFs or the Java group PTFs.

If performance is your goal look into work management, on an iSeries
performance involves more "tuning" than "preventative measures."  My #1
recommendation is to move your batch jobs out of the *BASE memory pool.
See:
http://www-912.ibm.com/s_dir/slkbase.nsf/1ac66549a21402188625680b0002037
e/9fa68bd7573e48af862565c2007d3d9b?OpenDocument&Highlight=0,batch,base

Every iSeries workload will be different and factors you may need to
consider in your decisions include the size of your machine(CPW), the
amount of memory, your number of interactive users, interactive vs.
batch workloads, whether you run Domino or WebSphere servers, etc.  Make
changes slowly and keep good statistics so that you know that your
changes are actually improving performance.

Regards,
 
Scott Ingvaldson
iSeries System Administrator
GuideOne Insurance Group


-----Original Message-----
date: Wed, 24 Aug 2005 15:16:19 -0400
from: "Hunt, Ryan" <Ryan.Hunt@xxxxxxxxxxxxx>
subject: Preventative Maintenance For AS400

 I am an NT native that admins an AS400 on the side.  I have done so for
several years now.  I am hoping other admins can share with me what
preventative measures should be used to protect the performance of the
system.

 

I am aware of "RCLSTG SELECT(*DBXREF)".  All suggestions are
appreciated. 

 

Thanks

 

Ryan