RE: Preventative Maintenance For AS400 -- MIDRANGE-L

I recommend a RCLSTG after any abnormal termination of OS/400.  IBM says
that this is a wild recommendation.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com



                                                                           
             "Ingvaldson,                                                  
             Scott"                                                        
             <SIngvaldson@guid                                          To 
             eone.com>                 <midrange-l@xxxxxxxxxxxx>           
             Sent by:                                                   cc 
             midrange-l-bounce                                             
             s@xxxxxxxxxxxx                                        Subject 
                                       RE: Preventative Maintenance For    
                                       AS400                               
             08/25/2005 10:20                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.