Introduction DB2 LUW for experienced DBA’s

Thursday, 18 June, 2015 - 09:00 - 16:00
LUW Track
Cristian Molaro
This seminar is designed to leverage your database and IT skills into the world of DB2 for Linux, Unix, and Windows. Cristian will discuss the basis of how DB2 works, what you need to know to get started as best as possible, and what are the common mistakes to avoid. He will highlight the differences and similarities with other databases, and will show the best ways of getting more information. A pragmatic approach that focuses on helping you to become a proficient DB2 professional in a more efficient way. This presentation covers current DB2 releases
Are you a DB2 for z/OS, SQL Server, Oracle experienced user looking for a fast path into DB2? This day has been created for you! Cristian will teach you the major commands and differences with other databases
Introduction to DB2
  • What is DB2 for Linux, Unix, and Windows?
  • DB2 editions & DB2 licensing
  • DB2 LUW vs. DB2 for z/OS
The DB2 architecture
  • Instances and databases
  • Table Spaces
  • Tables, Indexes, and Large Objects
  • DB2 logging
  • Buffer Pools
  • Storage Groups / Automatic Storage
  • Partitioning
  • Compression
  • Table compression
The DB2 working environment
  • DB2 Command Line Processor (plus)
  • IBM Data Studio and other GUI tools
  • Application enablement
  • Default locking settings
  • Working with packages
  • SQLJ and pureSQL
  • Java development considerations
  • Explain
  • The DB2 Advisors
  • SQL for cross-platform development
The DB2 deployment options
  • High Availability (HADR) and PureScale
  • BLU for analytics
  • Interaction with DB2 z/OS and other databases
System topics
  • Installing, updating and upgrading DB2
  • IBM Data Server Clients and Driver Packages
  • Automatic Database Maintenance
  • Using database tools and utilities
  • Backup and recovery at a glance
  • Performance tools at a glance


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020