The DB2Night Show #68: Problem Determination for SQL/PL, PL/SQL, & Triggers


Posted by Scott on January 27, 2012, 1:26 pm
in DB2 LUW ( The DB2Night Show)







Special Guest: Serge Rielau

STSM, IBM Canada



Destined for Top 25 of 2012!

Replays available in WMV and M4V formats!



96% of our audience learned something! Our special guest, Serge Rielau, Senior Technical Staff Member at IBM Canada, shared with our audience advanced techniques for problem determination in SQL/PL, PL/SQL, and triggers - complete with demonstrations! And, the source codes are available! If you use these capabilities of DB2 LUW, you must watch this show...








Special Guest: Serge Rielau

STSM, IBM Canada



Destined for Top 25 of 2012!

Replays available in WMV and M4V formats!



96% of our audience learned something! Our special guest, Serge Rielau, Senior Technical Staff Member at IBM Canada, shared with our audience advanced techniques for problem determination in SQL/PL, PL/SQL, and triggers - complete with demonstrations! And, the source codes are available! If you use these capabilities of DB2 LUW, you must watch this show...





Show Host Scott Hayes Commentary



Serge is brilliant. I could stop there, but I won't. At IDUG EMEA in Prague, I thought today's topic was one of the best presentations. The DB2 Community is fortunate to have access to this presentation and Serge's source code samples.


During the show, Serge referred to his two blogs:


  1. www.SQLTips4DB2.com
  2. www.Oracle2DB2Wiki.com

The source code samples can be downloaded from Serge's blogs. Download The DB2Night Show replay of this show and use it as a teaching guide while you work with Serge's tools.

2012 DB2's GOT TALENT


It's that time of year again! DB2's GOT TALENT is BACK! In 2012, the prizes are BIGGER! For our Contestants, DB2's GOT TALENT provides a great way to showcase your DB2 skills. For our studio audience and replay viewers, DB2's GOT TALENT provides a grand buffet of DB2 tips, tricks, and advice!


Get more information and get involved:




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! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!









Special Sponsored Advertisement:

Triton Consulting



A special offer for DB2Night Show viewers!


In conjunction with DBI, Triton Consulting offers a Remote DBA service to a worldwide audience. Remote DBA gives the reassurance of stable, secure management for all components of a client’s DB2 infrastructure. Utilising the DBI suite of products, DB2 experts at Triton Consulting proactively manage and monitor a client’s database.


Remote DBA is available during office hours or 24x7. It is often used by customers who have an existing DBA team but want additional back-up to provide full round the clock support – find out what our customers think - www.triton.co.uk/customer-stories/


The Offer


Remote DBA is usually sold on a 12 month contract but for DB2Night Show viewers we are offering a special 3-month contract which will allow you to try out Remote DBA to see if it’s a good fit for your organisation. Risk-free and cost effective, this is the perfect time to try Remote DBA.


Find out more about Remote DBA - www.triton.co.uk/db2-support


Contact us – info@triton.co.uk and mention "DBI OFFER"


Looking for more DB2 info? Visit www.triton.co.uk, follow @db2geek and @triton1, and join us on LinkedIn Triton DB2 User Network Group







The Corporate Sponsor of The DB2Night Show:

DBI Software




DBI is Your Trusted Partner

for Breakthrough DB2 Performance Solutions

that Deliver Invaluable Results

for Organizations having the most Demanding Requirements

and Discriminating Preferences


Our #1 Job is helping you look great!

Our #2 Job is giving you the documentation to prove it!



Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.



Get the Download Replays


WMV Format


To download a recorded replay of Episode #68 in WMV format, right click on
the link below and choose "Save As..."


Episode #68, 27 January 2012,
DB2 LUW Advanced Problem Determination for SQL/PL, PL/SQL, and Triggers with Serge Rielau, IBM


MP4 Format



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




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!


Share a great show with your friends and followers:


Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=325