AS/400 performance Questions


Require the method and steps to decrease ASP and DASD utilization.
Hi, I am new to AS400 Admin. And one of the AS400 box has high ASP utilization. The Disk space report shows the user libraries and user directories occupy maximum space. Can anyone please elaborate the steps I need to perform inorder to reduce the ASP utilization of the system.Specifically for purging by using RCLSTG [...]

Answer Question   |  February 1, 2010  7:51 AM
AS/400 performance, ASP, ASP Utilization, DASD, V5R4M0
asked by:
145 pts.

AS/400 journaling
Does journalling process have an impact on the overall system performance?

Answer Question   |  January 13, 2010  1:11 PM
AS/400 journaling, AS/400 performance, V5R4
asked by:
1,150 pts.

Physical file over 600 000 000 records
Hi We have a Physical file which has more than 60 million records in it. In our application we search for the particular records based on 6 fields as a search criteria (web based) , search process are done in SQL Procedures. Even when i creatd a LF based on the mandatory search fields , we [...]

Answer Question   |  December 17, 2009  11:08 AM
AS/400 performance, Physical File, SQL
asked by:
10 pts.

Iam unable to view graph details of Performance data for more than one day.
I use GO PERFORM to view by graph of the cpu usage etc during the day.  Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days [...]

Answer Question   |  October 22, 2009  12:36 PM
AS/400 performance, OS/400
asked by:
1,160 pts.

Delete AS/400 folders and libraries
We have a as400 9406-170 Runs great. We use it internally for our erp system. We want to delete some functions and libraries we do not use to gain disk space. Please suggest a method.

Answer Question   |  February 14, 2012  2:06 PM
AS/400 administration, AS/400 Folders, AS/400 Library, AS/400 performance, AS/400 storage
asked by:
Shs
65 pts.

AS/400 batch jobs
if a batch job is consuming lot of process time , how to find out the reason for it while the job is running ?

Answer Question   |  August 4, 2009  12:55 PM
AS/400 batch jobs, AS/400 jobs, AS/400 performance
asked by:
5 pts.

Performance of iSeries network adapter?
For a certain project requirement we have a connection(jobs running) between a windows server and an iSeries box and everyday at 6:00 am the jobs start between them, need to find out the network adapter’s performance in specific. Is there a way to determine the performance of system and the network adapter from the jobs [...]

Answer Question   |  July 28, 2009  1:49 PM
AS/400 performance
asked by:
995 pts.

How can I find some AS400 Communication Utilization Statistics
Specifically, we just installed an additional 5706 card (1gb Dual Port Network Interface) onto our Production Partition (550) to increase remote port availability. We were running out of ports (TCP100D) and it was recommended we add aditional 5706 card. The card has been added and now management would like some sort of Communications utilization report. [...]

Answer Question   |  June 18, 2009  3:16 PM
5706 NIC, AS/400 communication, AS/400 performance, Network Interface Cards, NIC
asked by:
150 pts.

asp usage to 90%.. how can i check and bring asp use down
bring asp usage down.. how can i view the journal files and detached them….

Answer Question   |  July 15, 2009  3:59 PM
AS/400 ASP, AS/400 performance, ASP
asked by:
5 pts.

How can I print AS/400 Performance related information ?
I want to know which command can i use to print performance informaction like, disk read/write and % use, ethernet troughput ,Up time or number of hours since last IPL ? this is for our monitoring system.

Answer Question   |  May 5, 2009  3:08 PM
AS/400 performance, AS/400 printing, Printing AS/400 performance
asked by:
DNB
5 pts.

Any Good suggestion of Software Management Tool/Product?
I am looking for a tool/product in market which can check the AS/400 different software (from various vendors) usage. It will be great if it can also used for the inventory check of installed software. Any good suggestion? Thanks!

Answer Question   |  August 5, 2009  4:11 PM
AS/400 Management, AS/400 performance
asked by:
5 pts.

AS/400 administration
I am new in AS/400 Administration so I wanna learn more things. Please suggest me how I will be able to login on the system if my QSECOFR password lost. Also please suggest me the books which are available online to learn about LPAR,OS upgradation and AS/400 performance monitoring and resolving issues. Anticipating active co-operation [...]

Answer Question   |  April 6, 2009  12:46 PM
AS/400 Password Recovery, AS/400 performance, AS/400 training, AS/400 Troubleshooting, AS/400 upgrades, LPAR
asked by:
4,265 pts.

AS/400 load testing
Are you aware of any Load testing tools to test AS400(TCP/IP) applications? I want to Load test AS400 core banking applications..

Answer Question   |  March 24, 2009  10:38 AM
AS/400 Load Testing, AS/400 performance
asked by:
5 pts.

ASP
System ASP reached more than 90% need to reduce the ASP Percentage

Answer Question   |  March 11, 2009  4:40 PM
AS/400 ASP, AS/400 performance, ASP
asked by:
45 pts.

How to calculate the CPW for AS/400 system?
How can i calculate the CPW on AS400 system??? What is the procedure for it??? Pla guide me…

Answer Question   |  February 2, 2009  8:37 AM
AS/400 performance, Commercial Processing Workload, CPW measurement
asked by:
5 pts.

iSeries
How do I know why our as/400 is running very slow? do you an specific command besides DSPSYSSTS or WRKACTJOB. thanks

Answer Question   |  March 30, 2009  6:02 PM
AS/400 command functions, AS/400 performance, AS/400 system administration, DSPSYSSTS, WRKACTJOB
asked by:
100 pts.

File maintenance
Hi, I have a file with million records and a batch program scheduled in the night maintains it. But it’s found that the program is taking too much time for it’s completion.How can we control and complete the program execution within one hour programmatically? thanks

Answer Question   |  February 4, 2009  3:33 PM
AS/400 performance, RPG
asked by:
1,150 pts.

How do I disable the query timeout property?
I’m calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I’ve Reorg’d the files too. The message appears to be coming from the [...]

Answer Question   |  October 23, 2009  3:33 PM
AS/400 Client Access, AS/400 performance, AS/400 Query
asked by:
5 pts.

Setting run priority on prestart jobs
We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application’s queries can have a higher priority than another application’s queries? Since each application’s queries always use the same user ID, can [...]

Answer Question   |  January 6, 2009  3:07 PM
AS/400 Job Prioritization, AS/400 jobs, AS/400 performance, ODBC, QZDAINIT
asked by:
60 pts.

/E812SYS/ini/jde.ini
Hi friends, please help me !! How can I configure this file to a best performance on my system AS/400 ?. Have many situations about the CPU utilization in + or – 90% on the process jdenet_k. Thanks for all

Answer Question   |  January 28, 2009  1:33 PM
AS/400 performance, CPU Utilization, E812SYS/ini/jde.ini, jdenet_k
asked by:
440 pts.