Archive for the ‘Uncategorized’ Category
Monday, January 25th, 2010
Step 1. Set DB2 registry variable as follows: DB2_RESOURCE_POLICY=/db2home/inst1/mydir/bindproc.txtStep 2: make sure the bindproc.txt has the following entry: (the following example binds two cores to the process)<RESOURCE_POLICY> <GLOBAL_RESOURCE_POLICY>
<METHOD>CPU</METHOD> <RESOURCE_BINDING> <RESOURCE>1</RESOURCE> </RESOURCE_BINDING> <RESOURCE_BINDING>
<RESOURCE>2</RESOURCE> </RESOURCE_BINDING> </GLOBAL_RESOURCE_POLICY></RESOURCE_POLICY>.pw.
Posted in Uncategorized | No Comments »
Thursday, January 21st, 2010
Buffer pool utilizationDavid J. Kline, and Gabor Wieser from IBM describes, in very simple terms, how bufferpools in DB2 should be designed. In their article on developerWorks, they described the following:The
most important reason to use more than one user table space is to
manage buffer utilization. A table space can only ...
Posted in Uncategorized | No Comments »
Tuesday, January 12th, 2010
IBM DB2 9.5 Performance and Scalability on RHEL5 with NFS and FCP Using NetApp FAS or IBM N series Storage Systemhttp://media.netapp.com/documents/tr-3775.pdfTopics include: HARDWARE AND SOFTWARE SETTINGS SERVER STORAGE LINUX KERNEL PARAMETERCONFIGURATION AND TUNING LINUX NFS CONFIGURATION AND TUNING LINUX FCP CONFIGURATION AND TUNING DB2 CONFIGURATIONDB2 PERFORMANCE AND SCALABILITY OVER NFS AND FCP LINUX NFS ...
Posted in Uncategorized | No Comments »
Tuesday, January 12th, 2010
Scale large OLTP workload with DB2 9 for System z on LinuxSimple and effective tuning paper (about 9 pages) by IBMhttp://download.boulder.ibm.com/ibmdl/pub/software/dw/linux390/perf/ZSW03028-USEN-00.pdfkey topics include:Environmental SetupServer softwareLinux Kernel tunablesI/O schedulerDatabase ImplementationAsynchronous I/ODirect I/OWorkload DescriptionResults.pw.
Posted in Uncategorized | No Comments »
Tuesday, January 12th, 2010
Database System Performance Best Pract=
ices on UNIX, Windows and LinuxThe paper published by IBM and found he=
re http://www.ibm.com/developerworks/data/bestpractices/systemperformance/?S=
_TACT=3D105AGX11&S_CMP=3DLP. The key area covered an=
d are at the heart of performance tuning include the following:=
The first step: configuring for good performanceHardware =
configurationAIX configurationSolaris and HP-UX configura=
tionLinux configurationDB2 Data Partitioning Feature=
Choice of ...
Posted in Uncategorized | No Comments »
Tuesday, January 12th, 2010
The following are performance benchmark Web pages from major DBMS and hardware vendors:Microsoft SQL Server 2008. Example of performance highlight and resource page http://www.microsoft.com/sqlserver/2008/en/us/performance-scale.aspx (includes overview, plus links to benchmark results, papers, and more)Oracle. Benchmark result pageshttp://www.oracle.com/solutions/performance_scalability/index.htmlMicrosoft SQL Server 2008. Benchmark result pages http://www.microsoft.com/sqlserver/2008/en/us/benchmarks.aspxMicrosoft SQL Server 2005. Benchmark result pages ...
Posted in Uncategorized | No Comments »
Thursday, December 10th, 2009
SQL Server 2008 TuningFor an OLTP workload, start with the following advanced SQL Server 2008tuning recommendations. Some are from Microsoft, others are just good practices. Run these as queries in the Microsoft SQL Server Management Studio UI:USE masterEXEC sp_configure 'show advanced options', 1RECONFIGURE WITH OVERRIDE(the above must be run first ...
Posted in Uncategorized | No Comments »
Wednesday, December 9th, 2009
bash-3.00# db2start05/15/2007 15:01:59 0 0 SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.SQL1063N DB2START processing was successful.look into db2diag.log:2007-05-15-15.01.58.846394-420 E92034A447 LEVEL: ErrorPID : 405708 TID : 1 PROC : db2sysc 0INSTANCE: db2inst1 NODE :
000FUNCTION: DB2 UDB, common communication, ...
Posted in Uncategorized | No Comments »
Monday, December 7th, 2009
An excellent tuning paper on IBM's developerWo=
rks on the topic of Servlet Caching:Servlet caching=0A=0A WebSphere Application Server=E2=80=99s DynaCache pro=
vides a general in-memory=0A caching service ...
Posted in Uncategorized | No Comments »
Wednesday, December 2nd, 2009
An article on IBM's developerWorks web sites shows some tips on tuningmessage-driven beans. In particular, a simple math model was given as follows:"We can build a simple mathematical model of the behaviour of concurrent MDB usage:
If we expect a transaction under normal circumstances to take t seconds to complete, and ...
Posted in Uncategorized | No Comments »