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

The DB2Night Show #Z06: DB2 10 Tablespaces and Migration

June 13, 2011, 4:53 pm
Posted by Scott in DB2 z/OS

Special guest Susan Lawson, IBM DB2 GOLD Consultant, YL&A

What new tablespaces and options are available for DB2 z/OS V10?

In episode #Z06, special guest Susan Lawson, an IBM DB2 Gold Consultant and Owner Yevich Lawson & Associates, shared with us information about new tablespaces in DB2 z/OS V10, options, considerations, and some best practices. Remarkably, Susan offered all this free education from her hotel room in Croatia that overlooked the beach! What a sacrifice! 99% of our studio audience learned something! What did you miss? Watch the replay and find out!

Show Host Scott Hayes Commentary

Klaas had a family emergency, so I hosted this show in his absence. Susan has been a peer and a friend for a long time, and I found it refreshing to learn about DB2 for z/OS since I haven't worked with DB2 mainframe since about V4. I am thankful for everyone who is attending our DB2 z/OS shows in our studio audience - this gives me positive energy and I know it motivates our guests too. When Susan was having trouble connecting to the internet for this show, she almost gave up - but, when I told her the audience would be larger than an IDUG conference keynote session, her determination increased and she stayed with us instead of going to the beach with her friends! SO - thank you for being in our studio audiences! We appreciate you!

And, did you know, since starting The DB2Night Show in September of 2009, that we have never canceled a show? We respect and value your time.

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!

A message from our sponsor SoftBase

As corporate DB2 databases continue to grow, and companies strive to provide 24/7 data availability to their customers and business partners, far less time is available to run required batch processes each evening. Many companies are discovering that they no longer have sufficient time to complete their critical nightly batch processes. Today, the most common solution to this shrinking batch window problem is to purchase more powerful CPUs to speed up batch processing.

SoftBase’s Batch Analyzer™ provides a far more cost-effective and reliable solution to shorten your batch run times than purchasing expensive CPU upgrades. Batch Analyzer™ can examine thousands of production batch jobs that execute each evening and quickly identify expensive DB2 SQL statements, DB2 timeouts and deadlocks, and DB2 programs that might potentially ROLLBACK for extended lengths of time.

Batch Analyzer™

  • Allows developers to quickly locate their own batch job and SQL statement problems without requiring a DBA
  • Locates every bad batch SQL statement in seconds
  • Requires very low overhead-typically 1-3% of job
  • Finds all DB2 batch jobs encountering deadlocks or timeouts within seconds
  • Estimates job rollback time and identifies jobs with excessively long rollback time
  • Can be installed and begin collecting data in a few hours

A message from our sponsor KBCE

Have you ever attended a DB2 Symposium? The DB2 Symposium is a three day training event with one day seminars presented by industry leading consultants. The DB2 Symposium fills the gap between a conference and a multi-day training. The DB2 Symposium is unique because you can join us for 1, 2 or 3 days, depending on your needs and budget. If you follow us on twitter, you'll always have the latest information about our events. You can read all about it at

Does your staff need DB2 training? Would you like to benefit from a cost-effective training, tailored to the needs of your organization? If so, KBCE’s in-house training service can deliver a unique course for your organization. In-house training saves you time and money because our professional trainers come directly to you, ensuring there are no travel or accommodation costs incurred for your members of staff.

Read all about the benefits of in-house DB2 Training on our special in-house training page which includes all the benefits and a frequent asked questions section.

Get the Download Replay

To download a recorded replay of Episode #Z06, right click on the link below and choose "Save As..."
Episode Z06, 13 June 2011, DB2 10 Tablespaces with guest Susan Lawson

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

Printer friendly