Performance issue....!

Hi all,

As most of you know, there is a few causes to have bad performance on AS400.

1- Poor CPU or Memory

2- Garbages in files(unnecessarily cumulated records or deleted records to
reorganise)

3- Some access(key order) that not exsist for some files.
----------------------------------------------------------

1- There is nothing to do number one; you will buy a new one or upgrade your
CPU and/or Memory. Decide it after an audit.

2- This issue needs a mapics backup and file reorganise together. It is
enough to do it four times in a year(more is up to you)!
You can collect disk information with RTVDSKINF command with no parm. Then
you can analyse QAEZDISK file in QUSRSYS siply by a query to find big files.
3- When you run a program or sql statement, AS400 seeks for a existing
access path for that file and use most near key sequence  is used to read
data. If it can not find one, creates a temporary access to that file. That
is the time you lost. According to the file size it can take an hour some
time. You can find the guilty by issuing the command for a spesific job or
for all jobs, STRDBMON!
You can easily collect data to an outfile by this command. Then you make a
query on that file. Select records only which include 'Y' in field INDEX
ADVISED(QQIDXA)! And look for key order to create in the field "Key columns
for the index advised"(QQIDXD). Then create this index by using "create
index" command in SQL command mode. You will see the result as a performance
jump.

According to me, IPLing is a very small part of the solution.

I wish you a creative work place without performance problems!

Regards

Mehmet Tufekcioglu
TEKLAS Kaucuk Sanayi(Turkiye)
IS Manager
+90 262 6484414(Direct tel)
+90 262 6417963(fax)
mtufekcioglu@xxxxxxxxxxxxx 




-----Original Message-----
From: mapics-l-request@xxxxxxxxxxxx
[mailto:mapics-l-request@xxxxxxxxxxxx]
Sent: Saturday, February 26, 2005 8:03 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 3, Issue 56


Send MAPICS-L mailing list submissions to
        mapics-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
        mapics-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        mapics-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."


Today's Topics:

   1. RE: Performance Issue (Dave Lauderdale)
   2. RE: Performance Issue (pennylancor@xxxxxxxxxxx)
   3. Hi All! (Dante Gomez)


----------------------------------------------------------------------

message: 1
date: Fri, 25 Feb 2005 16:33:54 -0600
from: "Dave Lauderdale" <DLAUDERDALE@xxxxxxxxxxx>
subject: RE: Performance Issue

We use a job schedule entry with the PWRDWNSYS command.  It runs every
Sunday at 4am.  The command we use is:
PWRDWNSYS OPTION(*IMMED) RESTART(*YES *FULL)

You can create the job schedule by entering the command WRKJOBSCDE and
pressing enter.  Press F6 to give it a name and establish the time and day
to run.  Where it says "command to run" enter PWRDWNSYS and press F4 to be
prompted for the various options.  Enter the frequency as *WEEKLY, the date
as *NONE, the day as *SUN, or whatever day you want, the time as 040000, or
whatever time you want it to run. You can press F10 to additional parameters
or press enter to take the defaults.  

We use job schedule entries for a lot of our recurring functions, using
commands, programs or CL programs in the "Command to run" area.

David

-----Original Message-----
From: Shawn Thobe [mailto:ShawnT@xxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Friday, February 25, 2005 2:02 PM
To: MAPICS-L@xxxxxxxxxxxx
Subject: Performance Issue


We are experiencing seveier performance issues with our system some for
obvious reasons (size of box).  I'm new to the 400 so no laughing, I
have never done and IPL on this server.  I was told by a tech at MAPICS
to do a monthly IPL  and do a recapture of space.  

 

Is this standard practice?  Will it improve performance?  We are looking
at cleaning up some files that have grown very large.  I'm assuming we
would do the recapture after cleaning these up.  Thanks for any
assistance.

 

Shawn Thobe

Supervisor - Information Systems

Fort Recovery Industries Inc.

419-375-4121

 

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



------------------------------

message: 2
date: Fri, 25 Feb 2005 23:00:04 +0000
from: pennylancor@xxxxxxxxxxx
subject: RE: Performance Issue

The iSeries has built-in functions to allow you to schedule power ups/downs.
Enter GO POWER on a command line and the Schedule Power Up/Down menu is
displayed.

-------------- Original message -------------- 

> We use a job schedule entry with the PWRDWNSYS command. It runs every
Sunday at 
> 4am. The command we use is: 
> PWRDWNSYS OPTION(*IMMED) RESTART(*YES *FULL) 
> 
> You can create the job schedule by entering the command WRKJOBSCDE and
pressing 
> enter. Press F6 to give it a name and establish the time and day to run.
Where 
> it says "command to run" enter PWRDWNSYS and press F4 to be prompted for
the 
> various options. Enter the frequency as *WEEKLY, the date as *NONE, the
day as 
> *SUN, or whatever day you want, the time as 040000, or whatever time you
want it 
> to run. You can press F10 to additional parameters or press enter to take
the 
> defaults. 
> 
> We use job schedule entries for a lot of our recurring functions, using 
> commands, programs or CL programs in the "Command to run" area. 
> 
> David 
> 
> -----Original Message----- 
> From: Shawn Thobe [mailto:ShawnT@xxxxxxxxxxxxxxxxxxxxxxxxxx] 
> Sent: Friday, February 25, 2005 2:02 PM 
> To: MAPICS-L@xxxxxxxxxxxx 
> Subject: Performance Issue 
> 
> 
> We are experiencing seveier performance issues with our system some for 
> obvious reasons (size of box). I'm new to the 400 so no laughing, I 
> have never done and IPL on this server. I was told by a tech at MAPICS 
> to do a monthly IPL and do a recapture of space. 
> 
> 
> 
> Is this standard practice? Will it improve performance? We are looking 
> at cleaning up some files that have grown very large. I'm assuming we 
> would do the recapture after cleaning these up. Thanks for any 
> assistance. 
> 
> 
> 
> Shawn Thobe 
> 
> Supervisor - Information Systems 
> 
> Fort Recovery Industries Inc. 
> 
> 419-375-4121 
> 
> 
> 
> _______________________________________________ 
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list 
> To post a message email: MAPICS-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
> or email: MAPICS-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/mapics-l. 
> 
> _______________________________________________ 
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list 
> To post a message email: MAPICS-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
> or email: MAPICS-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/mapics-l. 
> 

------------------------------

message: 3
date: Sat, 26 Feb 2005 11:14:47 -0500
from: "Dante Gomez" <dante.gomez@xxxxxxxxxxxxxxxx>
subject: Hi All!

Hi Experts and MAPICS afficionados!,
 
I was wondering if you would be able to help and help your previous
colleagues as well. Would you know someone in need of a job? Someone with
MAPICS background,
PLUSSES: Crystal Reports or even Frx.
 
It is for a job as a Data Analyst in Yonkers, NY.
 
IT IS A RIGHT-TO-HIRE JOB (CONTRACT-TO-PERM)
$60/hr permanent is 95k something.
 
If you are interested, please get in touch with me asap with your guy.
 
Cheers and Thanks All!
And thanks most of all to the good moderator!.
 
Dante
 
=============================
Dante Austria Gomez
Technosphere, Inc.
office: (201)384-7400
mobile: (201)450-1196
dante.gomez@xxxxxxxxxxxxxxxx
=============================




------------------------------

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



End of MAPICS-L Digest, Vol 3, Issue 56
***************************************