Advanced Query Tuning with IBM Data Studio by Tony Andrews Do you make any New Year's resolutions? In case you don't have any Db2 related, we have a suggestion for you. What if you start the New Year with improving the performance of your SQL queries? Learn more about the advanced query tuning...
REXX-Library that contains scripts of presentation 'Tuning with Virtual Indexes - A Brute-Force-Approach' at IDUG 2015, Dublin. Please see presentation for details. For problems, questions or comments please contact me at rolf.drees@fiduciagad.de. Kind regards, Rolf Drees 30.11.2015...
vxgen.txt
Cutting SAP Down To (a Manageable) Size The DBA wouldn’t touch it as there are 83,000 tables in SAP. He was busy with other applications, and he had no time in dealing with a big package that was a mess. During development, there had been no DBA assigned to the project, and now it was time for...
This session discusses how to tune DB2 buffer pools using DB2 10, with some insight into future changes coming in DB2 11. We'll discuss the various techniques for managing DB2's deferred writes and how DB2 11 will enable you to more effectively protect your OLTP buffer hit ratios while DB2...
EU13F01.pdf
It seems to be a constant battle to ensure that DB2 applications are running at their optimum efficiency and speed, but what are the factors that affect this efficiency. This presentation looks briefly at those aspects of application coding, development and execution that have a bearing on the...
EU13F02.pdf
Although the DBA’s tuning efforts often result in both a decrease of CPU consumption and end user response times, the percption of DBA activities at the C-level sometimes is more of the kind “why didn’t they do that before?”. This presentation helps you to better understand the C-level...
EU13F06.pdf
For as long as I've been involved with IDUG, performance tuning has always been one of the most popular subject areas for conference presentations and technical articles. From the wide range of possible topics in this area, two perennial favourites are buffer pool tuning and indexing strategies....
1 Comment - no search term matches found in comments.
This presentation is about the description of the IO infrastructure; its performance and tuning in a Mainframe environment from a DB2 DBA point of view.
EU07B06.flv