2.0

Table Of Contents
VMware, Inc. 75
Chapter 4 Installing and Configuring the ACE 2 Management Server
Becauselibodbcisasharedlibrarythatimplementsindustrystandard
ODBCAPIs,theACE2ManagementServerapplicationisnotsensitivetothe
particularversionofthe
unixODBCpackageinstalledonyourLinuxsystem,
butwerecommendthatyouupdatethepackagetothelatestversionreleased
foryourspecificLinuxdistribution.
TheDSNconfigurationfortheunixODBCpackageisstoredinthe/etc
directory(
/etc/unixODBCforSLES)onyoursystem(odbc.iniforDSNsand
odbcinst.inifordriverandgeneralODBCsystemconfiguration).Youcan
edittheseplaintextfilesmanually,oryoucaneditthemmoreconvenientlyby
usingthe
ODBCConfiggraphical(X11)utility.Youhavetobeloggedinasa
rootusertoaccesstheconfigurationfilesorruntheODBCConfigutility.
TheODBCConfigutilitymimicstheWindowsODBCDataSourcesControl
Panelplugin.WhenconfiguringaDSNforyourdatabaseconnection,ensure
thatyouareusingthecorrectODBCdriver(typically,
/usr/lib/libodbcpsql.so or,onSLES9,
/user/lib/unixODBC/libodbcpsql.so.2).Youalsomustconfigurethe
serveraddressandthedatabasenameintheDSNsettings.
Seehttp://www.unixodbc.org/foradditionalinformationaboutusing
unixODBC.
6Makeanoteofthedatabaseinformation:databaseDSN,username,andpassword.
Youneedtoenterthatinformationduringserversetup.
Performance Optimization Tips for External Database Use
Thefollowingtwosubsectionsprovidetipsforoptimizingserverperformance:
“EnsureThatthe ServerHasaSufficientNumberofDatabaseConnections”on
page75
“EnableDatabaseConnectionPoolingIfNotAlreadyEnabled”onpage77
Ensure That the Server Has a Sufficient Number of Database Connections
Fortheoptimalserverperformance,theACE2ManagementServerstartsmultiple
parallelthreads(onWindows)orprocesses(onLinux)listeningfortheincoming
connectionsfromtheclients.Ev eryclientconnectiontypicallyexecutesadatabase
transaction,soitneedstoopenadatabaseconnection.Itispossiblethatunderahigh
loadallavailablelisteningthreadsorprocesseswouldbeprocessingclientrequestsat
NOTEIfyouareusingtheACE2ManagementServerAppliance,seethe
informationaboutsettingupanODBCconnectiononpage77.