05-21-2010
AIX Tuning For DB2
Dear friends. can anybody suggest me what to be considered in order to achieve maximum performance of AIX on which DB2 will be installed
Thanks is advance
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi
I am trying to investigate a disk performance issue, and we are not seem to be hitting the right direction in our analysis.
This is a FC disk running on USP1000 HDS system. The application is an IO intensive application, but our opinion is that it is not performing due to perceived disk... (1 Reply)
Discussion started by: theerthan
1 Replies
2. AIX
How to do Performance monitoring and tuning in AIX. (2 Replies)
Discussion started by: AIXlearner
2 Replies
3. AIX
Hi all,
From Googling, I found that the basics used for troubleshooting UNIX/AIX performance issues are commands like vmstat, iostat and sar. I believe these are generic commands regardless of what UNIX flavour is in used, only difference being is the format of the output.
In a real case... (2 Replies)
Discussion started by: newbie_01
2 Replies
4. AIX
Dears i want to have a clear view about this tuning parameters and what they related to FS or Oracle , and how to figure the percentage of them .
maxperm%
maxclient%
v_pinshm = 1
lgpg_regions = 0
lpgp_size = 0 (3 Replies)
Discussion started by: thecobra151
3 Replies
5. AIX
how do i determine the percentage of the following befor i install oracle 11g
maxperm%
maxclient%
v_pinshm
lgpg_regions
lgpg_size (3 Replies)
Discussion started by: thecobra151
3 Replies
6. AIX
For some reason, my AIX 5.2 box has become slow in accepting telnet requests from others boxes. Windows, times out the connection, whereas, Unix it will wait for the AIX to display the login. I connect and it respawns back and says connected, but then sits and wait for what seems forever to get the... (5 Replies)
Discussion started by: mrmurdock
5 Replies
7. AIX
Greetings,
i'm wondering if there is a way to determine minimum memory requirement for AIX kernel and OS functions? We use memdetails script from perfpmr package to see actual memory allocation, for example like this:
===========================================================================... (5 Replies)
Discussion started by: dzodzo
5 Replies
8. AIX
Hi,
we've a gigabit Ethernet adapter. And we wanted to improve the performance by tuning network parameters. so' as per IBM info center,
http://publib.boulder.ibm.com/infocenter/aix/v7r1/index.jsp?topic=%2Fcom.ibm.aix.prftungd%2Fdoc%2Fprftungd%2Fnetw_opt.htm
we tried changing the tuning... (2 Replies)
Discussion started by: System Admin 77
2 Replies
9. Programming
Dear Team
Have this interesting question on how to determine cost savings(USD) based on performance tuning in Db2
I am using DB2 v10.5 . I worked on db2 procedure that loaded 20Million records in just 2 Mins.
ETL execution time reduced from 30 Mins to 2 Mins.
From 15 Hrs Monthly to 1... (2 Replies)
Discussion started by: Perlbaby
2 Replies
10. AIX
I have a IBM Power9 server coupled with a NVMe StorWize V7000 GEN3 storage, doing some benchmarks and noticing that single thread I/O (80% Read / 20% Write, common OLTP I/O profile) seems slow.
./xdisk -R0 -r80 -b 8k -M 1 -f /usr1/testing -t60 -OD -V
BS Proc AIO read% IO Flag IO/s ... (8 Replies)
Discussion started by: c3rb3rus
8 Replies
LEARN ABOUT PHP
db2_pclose
DB2_PCLOSE(3) 1 DB2_PCLOSE(3)
db2_pclose - Closes a persistent database connection
SYNOPSIS
bool db2_pclose (resource $resource)
DESCRIPTION
This function closes a DB2 client connection created with db2_pconnect(3) and returns the corresponding resources to the database server.
Note
This function is only available on i5/OS in response to i5/OS system administration requests.
If you have a persistent DB2 client connection created with db2_pconnect(3), you may use this function to close the connection. To avoid
substantial connection performance penalties, this function should only be used in rare cases when the persistent connection has become
unresponsive or the persistent connection will not be needed for a long period of time.
PARAMETERS
o $connection
- Specifies an active DB2 client connection.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Closing a persistent connection
The following example demonstrates a successful attempt to close a connection to an IBM DB2 i5/OS database.
<?php
$conn = db2_pconnect('', '', '');
$rc = db2_pclose($conn);
if ($rc) {
echo "Connection was successfully closed.";
}
?>
The above example will output:
Connection was successfully closed.
SEE ALSO
db2_close(3), db2_pconnect(3).
PHP Documentation Group DB2_PCLOSE(3)