Archive for January, 2010
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 »