Posted on 4/21/2015
@globomike | Special Guest: Michael Tiefenbacher Manager Business Services & Data Management Specialist at ids-SystemUsing and Optimizing DataStage and DB2100% of our audience learned something! DataStage is a very popular ETL tool that is used with IBM DB2 LUW. Michael offered some very valuable advice on how to maximize performance in DPF and non-DPF environments. Enjoy the replay ... |
Show Host Scott Hayes CommentaryMichael has a gift for explaining things in understandable ways. His IDUG presentations have always been excellent, and his appearance on our show continued his record of terrific presentations. Before today, I didn't know what DataStage was - I thought it was one of those evil applications that slow down databases! ha! But, after Michael's presentation, now I know what DataStage is and I have some good ideas on how to get ETLs done more quickly.
A message from our sponsor: DBI SoftwareDon't fast forward through today's educational commercial from DBI! Since today's topic was focused on ETL performance, DBI discussed data warehouse performance analysis and some index design considerations. When you want your ETLs to run faster, be sure to Contact DBI. | Visit DBI Software at IDUG Philadelphia Booth #108 and see magic tricks performed by professional magician Frank Velasco. 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. 8 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 GroupThe DB2Night Show has a LinkedIn Group. The "closed " group is open to any LinkedIn member. Join to receive LinkedIn group updates includingfuture shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group! Get the Download ReplaysWMV Format - approximately 59MBTo download a recorded replay of Episode #156 in WMV format, right click on the link below and choose "Save As... " Episode #156, 17 April 2015, Using and Optimizing DataStage and DB2 with Michael Tiefenbacher MP4 Format - standard resolution - appx 103MBHave 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! :icon_biggrin: Share a great show with your friends and followers! |