View Printable Version

C16 - db2batch Tips and Tricks

Session Number: 2334
Track: DB2 LUW - I
Session Type: Podium Presentation
Primary Presenter: Paul Turpin [Consulting Database Administrator - BB&T]

Jefferson/Ross => Thu, May 07, 2015 (09:15 AM - 10:15 AM)

Speaker Bio: Paul Turpin is a consulting database administrator for a large financial institution, supporting SAP. He specializes in DB2 for LUW on large systems. He enjoys exploring new features and functionality in DB2. He has spoken at IDUG North America, IDUG Europe, SHARE, IBM’s Information on Demand conference, and several RUGs. Paul currently serves on the IDUG Board of Directors. He was one of IBM's inaugural Information Champions.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Database Resources, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Tools and Utilities
Objective 1: Important db2batch options
Objective 2: How to do a snapshot in db2batch
Objective 3: How to use with literal SQL queries
Objective 4: How to use with parameter marker queries
Objective 5: How to interpret db2batch output

Abstract:  db2batch is a very powerful tool, but not always easy to use. It is my favorite performance tool and I want to share my enthusiasm about it. db2batch captures actual timings and other metrics as the query you are testing is running. Some of those metrics are SQL execution timings, plus a number of metrics including CPU time, sort information (number of sorts, sort time, sort overflows), rows read, rows written, rows updated (and inserted and deleted), rows fetched and bufferpool usage details. In addition an explain can be captured at the time of execution. db2batch can work with SQL with literals or parameter markers.

This presentation will teach you how to use the numerous db2batch parameters. It will also show the difference in using db2batch with SQL with literals and SQL with parameter markers.

For questions or concerns about your event registration, please contact