AIX Tuning For DB2


 
Thread Tools Search this Thread
Operating Systems AIX AIX Tuning For DB2
# 1  
Old 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 Smilie
# 2  
Old 05-21-2010
One of the links in the pinned thread in this forum deals explicitly with performance tuning for database usage. I suggest you have a look at it.

I hope this helps.

bakunin
This User Gave Thanks to bakunin For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

IBM AIX I/O Performance Tuning

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

2. Programming

DB2 - Determine Cost Savings in USD - After performance Tuning

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

3. AIX

Network tuning parameters on 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

4. AIX

AIX 6.1 memory tuning

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

5. AIX

New to AIX tcpip tuning

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

6. AIX

AIX file system tuning

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

7. AIX

Tuning AIX for oracle

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

8. AIX

UNIX/AIX Performance Tuning = some basics please

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

9. AIX

How to do Performance monitoring and tuning in AIX

How to do Performance monitoring and tuning in AIX. (2 Replies)
Discussion started by: AIXlearner
2 Replies

10. UNIX for Advanced & Expert Users

Tuning AIX IO

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
Login or Register to Ask a Question