Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AIX performance issue
Operating Systems AIX AIX performance issue Post 302460696 by ithinksgreen on Thursday 7th of October 2010 10:44:30 AM
Old 10-07-2010
AIX performance issue
Hi Guys,

This is the situation I am in. Provide your views and input where should I start?

I have one P7 test server and a p520 production server. the job is taking pretty long on the P7 test server when compared to the P5 production server. below is the full detail.

Informix transaction activity and archive processing are taking
noticeably longer on the Power7 8233-E8B 12way/3.3GHz processor with
128GB of memory running AIX Version 6.1. The Informix LPAR in
question has 3 cores and 16GB of memory assigned. The system has been
fully configured to be virtualized with 3-4 LPARs and 2 x VIOS LPARS
supporting all I/O. The SAN storage consists of a 4Gbps Fibre
Channel SAN with an IBM SAN Volume Controller supporting an IBM
nSeries N5600 and an n6040 plus a fully populated DS4800. This is
the first time the customer has had any LPAR environments in their
data center. The systems were initially configured by 2 x IBM
Advanced Technical Support specialists due to the complexity of the
environment.

The current Informix environment and ATM processing application is
running on an IBM 8203-E4A model 520 with 4 x 4.2GHz processors, 8GB
of memory, and Version 5.3 of AIX, attached via fibre Channel to a
shared EMC CX3-40C Clariion storage unit. On the model 520, the
archive process is taking 25 minutes to archive 96GB of data while
still supporting user activity. But on the model 750 it is taking
around 45 minutes to complete. The archive process is a single
threaded process and, we believe, is not being able to take full
advantage of the additional processors and advanced architectural
design of the Power 7. This could be due to lack of proper tuning of
the OS or other undiscovered factors. The Informix environment and
the ATM application code are running the 32bit version of their code
on the model 520. But on the model 750, the Informix software is
running the 64bit version but the software vendor's application is
still running the 32bit version of the application.

Thank you.
 

10 More Discussions You Might Find Interesting

1. AIX

performance issue

We have a AIX v5.3 on a p5 system with a poor performing Ingres database. We added one CPU to the system to see if this would help. Now there are two CPU's. with sar and topas -P I see good results: CPU usage around 30% with topas I only see good results in the process output screen, the... (1 Reply)
Discussion started by: rein
1 Replies

2. UNIX for Advanced & Expert Users

performance issue

Hi, on a linux server I have the following : vmstat 2 10 procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id 0 4 0 675236 39836 206060 1617660 3 3 3 6 8 7 1 1 ... (1 Reply)
Discussion started by: big123456
1 Replies

3. Shell Programming and Scripting

performance issue

I want to read a file. is it good to use File I/O or shell script?? which one is the best option? (1 Reply)
Discussion started by: vishwaraj
1 Replies

4. AIX

Performance issue in expect library on AIX 5.3

Hi All, I am getting a performance issue in expect5.43.0 library on IBM AIX 5.3. When I have used exp_fexpectv call for pattern matching with the expect string, the execution latency of the call is approximately 200 ms. In that way, I am able to complete only 4 or 5 transactions per... (2 Replies)
Discussion started by: ravindra_maddal
2 Replies

5. AIX

Performance issue in AIX 5.3

Is there is any way to increase the CPU utilization of a Embedded SQL program in AIX 5.3 .. for performance purpose. (0 Replies)
Discussion started by: Gyanendra Awast
0 Replies

6. UNIX for Advanced & Expert Users

Performance issue!

In my C program i am using very large file(approx 400MB) to read parts of it frequently. But due to large file the performance of the program goes down very badly. It shows very high I/O usage and I/O wait time. My question is, What are the ways to optimize or tune I/O on linux or how i can get... (10 Replies)
Discussion started by: mavens
10 Replies

7. AIX

performance issue in AIX

Gurus, i have process that runs 5 times a day. it runs normally (takes about 1 hour) to complete in 3 runs but it is takes about ( 3 hrs to complete) two times So i need to figure out why it takes significanlty high time during those 2 runs. The process is a shell script that connect to... (2 Replies)
Discussion started by: mad_man12
2 Replies

8. Shell Programming and Scripting

Performance issue or something else?

Hi All, I have the following script which I use in Nagios to check the health of the applications, the problem with it is that the curl part ($TOTAL) does not return anything after running for 2-3 hrs, even though from command line the script runs fine but not from Nagios. There are 17... (1 Reply)
Discussion started by: jacki
1 Replies

9. UNIX for Dummies Questions & Answers

Performance issue

hi I am having a performance issue with the following requirement i have to create a permutation and combination on a set of three files such that each record in each file is picked and the output is redirected in a specific format but it is taking around 70 odd hours to prepare a combination... (7 Replies)
Discussion started by: mad_man12
7 Replies

10. AIX

Performance issue

Hi, We have 2 lpars on p6 blade. One of the lpar is having 3 core cpu with 5gb memory running sybase as database. An EOD process takes 25 min. to complete. Now we have an lpar on P7 server with entitled cpu capacity of 2 with 16 Gb memory and sybase as database. The EOD process which takes... (17 Replies)
Discussion started by: vjm
17 Replies

LEARN ABOUT PHP

ifx_connect

IFX_CONNECT(3)								 1							    IFX_CONNECT(3)

ifx_connect - Open Informix server connection

SYNOPSIS

       resource ifx_connect ([string  $database], [string  $userid], [string  $password])

DESCRIPTION

       ifx_connect(3) establishes a connection to an Informix server.

	In case a second call is made to ifx_connect(3) with the same arguments, no new link will be established, but instead, the link identifier
       of the already opened link will be returned.

	The link to the server will be closed as soon as the execution of the script ends,  unless  it's  closed  earlier  by  explicitly  calling
       ifx_close(3).

PARAMETERS

	All  of  the  arguments are optional, and if they're missing, defaults are taken from values supplied in php.ini (ifx.default_host for the
       host (Informix libraries will use INFORMIXSERVER environment value if not defined), ifx.default_user for user, ifx.default_password for the
       password (none if not defined).

	      o $database
		- The database name, as a string.

	      o $userid
		- The username, as a string.

	      o $password
		- The password, as a string.

RETURN VALUES

	Returns a connection identifier on success, or FALSE on error.

EXAMPLES

       Example #1

	      Connect to a Informix database

	      <?php
	      $conn_id = ifx_connect ("mydb@ol_srv1", "imyself", "mypassword");
	      ?>

SEE ALSO

       ifx_pconnect(3), ifx_close(3).

PHP Documentation Group 													    IFX_CONNECT(3)
All times are GMT -4. The time now is 04:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy