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

The DB2Night Show #88: DB2 LUW 10 Real-Time Data Warehousing

June 26, 2012, 3:58 pm
Posted by Scott in DB2 LUW
Pat Bates

Special Guest: Pat Bates, WW Tech Sales, IBM

DB2 LUW 10.1 Real-Time Data Warehousing

100% of our audience learned something! Our special guest, Pat Bates, shared with our audience information about the new INGEST utility and adaptive compression in DB2 10.1. Pat's presentation is rich with examples, illustrations, and sample DDL and SQL commands. Watch and learn...

Show Host Scott Hayes Commentary

100% of our studio audience learned something! I think that pretty much says it all! We've now had five shows in a row where 100% learned something!

During the show, a question came up about when the INGEST utility ends and under what conditions. Pat researched this with the lead developer and provided these answers:

  • In one scenario, the sending process will continue to write to the pipe until it has no more data, then it will close the pipe. The ingest utility will then receive an EOF (the same as if it had reached the end of file input) and will exit appropriately.

  • In another scenario, the sending process might keep the pipe open indefinitely to write data as it becomes available. In this case, the ingest utility will just continue to read data from the pipe whenever it is written.

  • There is a config parameter PIPE_TIMEOUT that indicates the number of seconds that the ingest utility should wait for data on the pipe before timing out and exiting. The default is 600 seconds and can be set to any number. If set to zero, then it will wait indefinitely.

Please join us for #76, #89, and our Season #3 Finale #87. Visit and sign up!

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!

The Corporate Sponsor of The DB2Night Show:
DBI Software

During today's quick DBI commercial, we demonstrated how DBI makes it easy to analyze performance of multi-partition databases and see performance trends. If you have multiple partitions in your data warehouse, be sure to watch and then contact DBI!

DBI is offering a free Webinar "How to Improve Performance in Minutes!" on 29 June 2012 at 1pm CDT. Visit DBI Events for details and the registration link.

On 23 May 2012, DBI Announced new competitive performance tool pricing incentives. If you have IBM OPM or other performance tools, DBI invites you to trade-in, trade-up, and swap-out those tools while enjoying special license savings. Inquire with your DBI representative for qualifications and details.

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 #88 in WMV format, right click on the link below and choose "Save As..."
Episode #88, 26 June 2012, DB2 LUW 10.1 Real-Time Data Warehousing with INGEST and Adaptive Compression

MP4 Format

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

Bonus! PDF!

We don't usually share PDFs of our guest's presentations. However, Pat's presentation is full of terrific examples, so CLICK HERE for slide excerpts. As usual, be sure to watch the replays to gain full benefit from Pat's insights.

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:

Printer friendly