The inside scoop on Db2 external tables

Session Number: 7255
Track: Virtual Event - Live
Session Type: Podium Presentation
Primary Presenter: James Sobieski [Fourth Millennium Technologies]
Time: Jul 23, 2020 (01:00 PM - 02:00 PM)

Session Code: 8683
Speaker Bio: James Sobieski is a Database expert having worked with DB2 for LUW since 1994 and IBM Operating Systems and Databases since 1979. He has extensive experience in Data Warehousing; design and planning as well as ETL and database performance and tuning. James is an IBM Gold Consultant and IBM Data Champion and consults internationally on Databases; Big Data; ETL and Master Data Management projects. He has worked at NASA and the IBM DB2 Toronto Lab’s benchmarking team.
Audience experience level: Beginner
Presentation Category: Select a Value
Presentation Platform: Select a Value
Audiences this presentation will apply to: Select a Value
Technical areas this presentation will apply to: Select a Value
Objective 1: Understand basic concepts about external tables and common use cases.
Objective 2: Learn techniques for using external tables to load data from flat files
Objective 3: Learn techniques for writing data to flat files via external tables.
Objective 4: Learn how to integrate external tables and federation to make flat file data available across multiple systems
Objective 5: Learn to research error conditions and how to debug problems encountered when using external tables.

Abstract:  External tables are Db2 table-objects that map to external flat files. You can use external tables inside Db2 to reference flat file data as if it were a Db2 table. Netezza has long had external tables and now the same functionality is rolling into Db2; starting with Db2 Warehouse and the IBM Integrated Analytics System (IIAS). In this presentation you will learn the types of external table objects you can create; how to read from them and load data into regular user tables. It will show examples of reading and writing external tables. The presentation will also discuss error conditions and how to research and debug errors encountered with external tables. When using external tables; log files are written. Learn where these files reside and what these log files can tell you.