(Ember Crooks) In both OLTP and DSS database environments, DBAs can use information stored in the package cache to find problematic SQL statements either before or after they begin to negatively impact performance.
Tag: IBM
Statement-Level Monitoring: Part 1
(Frank Petersen) I have two big loves in my life, but right now I’ll share only the second one: the accounting information provided by IBM DB2. Many application performance problems can be solved by looking into accounting reports. If you want to get a better position inside your organization, you s
IBM InfoSphere Optim Test Data Management solution, Part 2: Using a column map procedure
(Shilpa Jaganmohan, William Steinagle, Ethan Vogel and Lynn Pate) Learn how to pass parameters within a script to mask data, and how to modify the output process report to include information about the masking process. Specifying parameters within a script gives you more flexibility in determining w
InfoSphere Data Replication for DB2 for z/OS and WebSphere Message Queue for z/OS: Performance Lessons
(Miao Zheng, Ning Jiang Bin, Song Xiao Yu, Serge Bourbonnais and Yi Jin) Understanding the impact of workload and database characteristics on the performance of both DB2, MQ, and the replication process is useful for achieving optimal performance.
Best practices for DB2 pureScale performance and monitoring
(Serge Boivin) Download the slides and transcript for this webcast at the DB2 Best Practices portal: https://ibm.biz/BdxMvG
The DB2Night Show #97: DB2 LUW 10.1 Cool Features No One is Talking About
(Scott Hayes) 100% of our studio audience learned something! IBM marketing has drilled Adaptive Compression, Temporal Tables, Zigzag joins and more into our heads.
DB2 for z/OS: An Interesting ‘Flip Side’ to Native SQL Procedures
(Robert Catterall) I heard the other day from a DB2 for z/OS DBA who communicated to me an interesting story. His organization had recently gotten into development and deployment of native SQL procedures on the mainframe DB2 platform.
DB2 Web Query Tutorials Building Dashboards and Compound Documents
(Bedoya Hernando) IBM DB2 Web Query for i offers a set of modernized tools for a more robust, extensible and productive reporting solution than the popular Query for System i (also known as Query/400) tool.
IBM Cognos Proven Practices: Performance Tips when using Cross JoinQueries against a TM1 Datasource
The purpose of this document is to provide performance guidance when querying large datasets from a TM1 Datasource.
Re-defining (Dropping and Adding) Foreign Keys
(Ember Crooks) Have you ever had to alter foreign keys in a way not supported by mere alteration? Dropping and re-creating all of them can be quite a chore, but a little SQL can make it easier. In this post, I’m sharing my experience and SQL in hopes of helping others who have to do the same thing.