John Lyle – IBM SVL
Abstract
The purpose of this presentation is to unveil some of the mysteries of the Db2 catalog and the migration process. The presentation will cover some basic catalog and directory information before moving into the mysteries of a catalog migration. Will cover data sharing/non-data sharing migration considerations, migration and install enhancements for Db2 13 and finish with information about the future direction of the Db2 catalog and migration process.
Speaker Bio
John Lyle has worked for IBM at the Silicon Valley Laboratory in the Db2 organization since 1985. Joining Db2 development in 1995, he has worked in the RDS area focusing mostly on the Db2 system catalog, migration and fallback and the data definitional language (DDL) areas as well as the index manager area. He has been the lead designer and implementer of the catalog and fallback changes since V5 and has worked on numerous other development items over the years. John was the lead designer for Db2 9’s Clone table function. In V8 – V11 John was the Utility lead for all of the ENFM changes that were made to the Db2 catalog and directory. In V12 John was a development leader and designer in the move to Db2’s new continuous development process and also the new Online Migration capabilities. In Db2 13, John was the lead designer in the changes to the migration process. John is currently working in Db2’s Provisioning-Deployment-Migration team as the team leader.