Techdocs Library > White papers > Optimizing Sybase Adaptive Server Enterprise (ASE) for IBM AIX

Document Author: Additional Author(s):	Peter H Barnett Stefan Karlsson, Sybase Mark Kusma, Sybase Dave Putz Sybase		Document ID:	WP101429
Doc. Organization:	Advanced Technical Sales		Document Revised:	02/27/2012
Product(s) covered:	AIX; AIX 5L; Communications Server IP; IBM eServer p5; IBM eServer pSeries

Abstract: This is a paper from IBM and Sybase to assist database administrators (DBAs) and UNIX system administrators (SAs) working together. This white paper helps these professionals achieve the best possible performance from the Sybase Adaptive Server Enterprise (ASE) on IBM Power Systems running in the IBM AIX operating environment. The focus of this white paper is on Sybase ASE 15.0.2 through ASE 15.5, running under AIX 5.3, 6.1, and 7.1 on the IBM POWER6 and IBM POWER7 processor-based servers. The recommendations of the original version of this white paper, published in March 2006, applied to IBM AIX 5L logical partitions (LPARs) with dedicated processors, memory, and devices. The 2009 revision of the paper also addressed all relevant aspects of IBM PowerVM including shared-processor LPARs (referred to as IBM Micro-Partitioning) and virtual I/O, features which are only available in the POWER 5, POWER6, and POWER7 processor-based servers with AIX 5.3 or later releases. The current revision of the white paper extends coverage to POWER7, enhancements to virtual I/O, and AIX 7.1 where relevant to ASE. Recent field and lab experience with POWER7 processor-based servers is applied to new or revised best practice recommendations. The recommendations apply to ASE Cluster Edition for AIX except where noted.

Classification:	Software	Category:	Performance
Solution(s):	ISV Applications	ISV(s):	Sybase
Platform(s):	IBM Power Systems; IBM System p Family
O/S:	AIX	Keywords:	Sybase, Sybase ASE, Adaptive Server Enterprise, ASE 15, AIX 5L, AIX 6.1, AIX 7.1, Power5, Power6, Power7, Power Systems, PowerVM, LPAR, database, dataserver, PowerHA, Micropartition, performance, tuning