The DB2Night Show #134: DB2 LUW INGEST Utility with Mark Gillis, Triton


Posted by Scott on May 2, 2014, 12:17 pm
in DB2 LUW ( The DB2Night Show)







title="Mark Gillis on LinkedIn">
Mark Gillis, Triton

Special Guest: Mark Gillis, Triton



DB2 LUW INGEST Utility



18% of our audience was running DB2 LUW V10.5 in production and 45% of our audience was running V10.1 in production. The INGEST Utility became available in V10.1 as a client side utility, yet 0% of our audience today was using it. 86% of our audience indicated they learned something from Mark. In our post show survey, many attendees indicated they will now consider evaluating INGEST. Not only did Mark brilliantly introduce the INGEST utility overall, but he also showcased how INGEST can be cleverly and effectively used as an ETL tool. Watch our replay for details...








title="Mark Gillis on LinkedIn">
Mark Gillis, Triton

Special Guest: Mark Gillis, Triton



DB2 LUW INGEST Utility



18% of our audience was running DB2 LUW V10.5 in production and 45% of our audience was running V10.1 in production. The INGEST Utility became available in V10.1 as a client side utility, yet 0% of our audience today was using it. 86% of our audience indicated they learned something from Mark. In our post show survey, many attendees indicated they will now consider evaluating INGEST. Not only did Mark brilliantly introduce the INGEST utility overall, but he also showcased how INGEST can be cleverly and effectively used as an ETL tool. Watch our replay for details...





Show Host Scott Hayes Commentary



We ran some interesting polling questions today, so watch the replay for details. Mark Gillis did a fantastic job presenting on the INGEST Utility including how it can be creatively used as an ETL tool. His presentation is full of code examples that make a complete "cookbook" on using INGEST. He even included some Gotchas. You can learn more about Mark Gillis and find some of his most recent blogs by Clicking Here!


UPDATE 5 May 2014: Bob Harbus, IBM, contacted me with some licensing information for INGEST. INGEST is only available with Advanced Editions of DB2 (AESE and AWSE) plus Developer Edition (DE).


IMPORTANT NEWS: IDUG DISCOUNT CODE!


DBI Software and The DB2Night Show are proud to announce a special discount code that you can use to get 10% off your IDUG NA Phoenix registration: DB2GotTalent14. This code saves you $200 and matches the price for organizations sending three or more people! Any questions? icon_biggrin UPDATE: This code expires 8 MAY 2014 at 11:59PM ARIZONA time zone!


DBTA Readers Choice Awards



Database Trends and Applications is currently seeking YOUR votes in its first annual Readers Choice Awards. DBI's pureFeat™ Performance Management Suite for IBM DB2 LUW has been nominated in the category of Best Database Performance Management Tools and we'd sure appreciate your vote! Also, IBM technologies have been nominated in several categories and we're sure IBM would appreciate your votes as well. Polls close 21 May 2014. CLICK HERE to vote! Please!


Congratulations!



David Nilsen at CIGNA in Springfield MA completed our survey after Episode #133 "Why Low Cardinality Indexes (suck)" and has won a $25 Amazon.com gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!





A message from our sponsor:

Triton Consulting


DB2 Consultancy when you need it!



Consultancy on Demand from Triton Consulting is designed for customers who need varying levels of support and consultancy during the year. Our service gives you access to some of the most talented DB2 consultants in the industry including an IBM Gold Consultant and two IBM Champions.


So why not try us out with our CoD 20 offering and see what our DB2 experts can do for you! To learn more, visit: www.triton.co.uk/consultancy-on-demand/




Triton Consultancy on Demand Logo






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 title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">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?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI



Turn a Penny into a Dime with DBI at IDUG











The title="IDUG North America May 12-16, Save $200 off registration with Discount Code: DB2GotTalent14">
2014 IDUG DB2 Tech Conference in Phoenix, Arizona is the premier training event dedicated exclusively to
IBM’s industry-leading DB2 product family. The event includes a robust technical schedule, in-depth seminars,
networking opportunities and a vendor exhibition featuring the latest DB2 products.
And, don't miss
the DB2 LUW Top Gun Education Seminar
taught by href="http://ca.linkedin.com/pub/martin-hubel/0/181/697" target="NEW">Martin Hubel
and Scott Hayes!
Visit DBI Software in Booth #105, Experience the Magic of DBI, Get 10X title="Get 10X ROI with DBI, Guaranteed! Learn More!">ROI, and you could win a
title="See the Beats Pill Portable Speaker on Amazon.com">Beats Pill Portable Speaker! Enjoy magic tricks
performed by professional magician Frank Velasco!
target="NEW"
title="IDUG North America May 12-16, Save $200 off registration with Discount Code: DB2GotTalent14"> alt="IDUG North America May 12-16, Save $200 off registration with Discount Code: DB2GotTalent14" border="3">

Save $200 with Discount Code: DB2GotTalent14





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!




Get the Download Replays



WMV Format - approximately 42MB


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


Episode #134, 2 May 2014,
The DB2 LUW INGEST Utility Overview and ETL uses!



MP4 Format - standard resolution - 82MB



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! icon_biggrin


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=507