Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #139: DB2 LUW db2batch command Tips and Advice

September 26, 2014, 10:05 pm
Posted by Scott in DB2 LUW
Paul Turpin on LinkedIn

Special Guest: Paul Turpin, Sr. DBA, BB&T Bank

Advanced "db2batch" command Tips and Techniques

98% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details his experiences, tips, and advice for using the IBM DB2 LUW "db2batch" command. There are many options to consider. By using the right options, you can Run and Explain your SQL, limit outputs, and choose various levels of performance details. Watch our replay to learn all the tricks...

Show Host Scott Hayes Commentary

Paul Turpin has been a friend for many years, and it has been a delight to watch him contribute to the DB2 community through IDUG and his local RUG. Inspired by his daughter, whenever Paul presents he brings along BONGO to be part of his audience!

Consider volunteering for IDUG in any capacity, or submit presentations to become a speaker - and get a free badge if accepted! The call for Presentations for IDUG NA 2015 Philadelphia is NOW OPEN! This presentation on DB2 LUW db2batch is EXCELLENT!.

I hope you enjoy this replay and learn great ideas from it. Because Paul is not an independent DB2 consultant or trainer (implying he does not make a living from his materials), he has graciously permitted us to share a PDF of his slides for handy reference. This does not mean, however, that you can skip the replays - to the contrary, Paul adds a lot of value in what he says! BONGO agrees!



Alexander Ashkenazi at Chrysler in Auburn Mills Michigan completed our survey after Episode #138 "Upgrading to DB2 V10.5 Best Practices!" and has won a $25 gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!

Did you attend IDUG in Phoenix?

Check out the 100's of uploaded pictures HERE and see if you can find your picture! If you took pictures, upload them!

A message from our sponsor:
DBI Software

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 30-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.

We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 7 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Get the Download Replays

WMV Format - approximately 62MB

To download a recorded replay of Episode #139 in WMV format, right click on the link below and choose "Save As..."
Episode #139, 26 September 2014, Advanced db2batch Tips and Advice with guest Paul Turpin!

MP4 Format - standard resolution - 99MB

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

BONUS!! PDF Handout!

We can't do this with all of our guests, but Paul has given permission for us to make a PDF handout of his presentation available. Don't skip the video replays! GET THE PDF!

Did you learn something from this show?

See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin

Share a great show with your friends and followers! Let's get this tweeted and retweeted like crazy to celebrate Paul's contributions to the DB2 LUW community!

Printer friendly