Introduction to IBM DB2

DB2 family products overview (LUW, Mainframe, iSeries) DB2 LUW product editions DB2 product features and functions DB2 client connectivity options

The DB2 Database Manager Instance

About DB2 Instance Database Manager Instance overview Starting and Stopping an instance list and modify DBM configuration Db2set command Db2 history command DB2 instance creation pre-requisites Create and Drop an instance DB2 registry and environment variables

DB2 Fundamentals & IBM Data Studio Tool

Product Overview Editions & Features Licensing DB2 Fundamentals and Architecture Users Instances Buffer pools Security DB2 Client Storage Table spaces SQL and XQuery IBM Data Studio DSAC

Creating databases and data placement

Database creation pre-requisites Database storage requirements Table spaces overview Storage management overview (SMS, DMS, Automatic) Default Table spaces List DB configuration parameters Database directories and files introduction System catalog tables and views Containers, extents, pages overview Create Tablespace syntax Storage groups overview Assigning a tablespace to a storage group Introduction to db2pd command Alter Tablespace, Alter Stogroup DB2 List DB Directory Activate and deactivate a database

DB2 Security

Authentication versus Authorization SYSADM, SYSCTRL, SYSMAINT, SYSMON DB2 security privilege hierarchies Grant and Revoke privileges Trusted Context Label-Based Access Control (LBAC) ROLES

DB2 Backup and Recovery

Transactional logging (Circular, Archival) Configure database logs Backup utility options Recovery utility options Rollforward DB2 Recover Database Online versus Offline backup

Working with Databases and Object in DB2

Servers, Instances, and Databases Managing Instances Creating a DB2 Database Cataloging Database (Data) Objects

Installation and Configuration

Installation & Configuration (working with windows os) Database creation Instance creation Table space Creation Working with Buffer pool