Cloud Overview
- Cloud & On-Prem Difference
- Azure Cloud Introduction
- Implementation of Database and Advantages of Database Use in Cloud Environment.
Overview of DB2 on Linux, UNIX and Windows
- DB2 family products overview (LUW, Mainframe, iSeries)
- DB2 LUW product editions (Express-c to PureScale to InfoSphere)
- DB2 product features and functions
- DB2 client connectivity options (Data Studio, Data Server Client)
Command Line Processor (CLP) and GUI usage
- Introduction to DB2 CLP environment
- Non-interactive mode
- Interactive mode
- db2 command line options
- Client connectivity from Data Studio
The DB2 Database Manager Instance
- About DB2 Instance
- Database Manager Instance overview
- DB2 instance creation pre-requisites
- Create and Drop an instance
- Starting and Stopping an instance
- list and modify DBM configuration
- db2set command
- db2 history command
Creating databases and data placement
- Database creation pre-requisites
- Database storage requirements
- Table spaces overview
- Storage management overview (SMS, DMS, Automatic)
- Default Table spaces
- CREATE DATABASE command
- List DB configuration parameters
- Modify DB configuration parameters
- Database directories and files introduction
- System catalog tables and views
- Containers, extents, pages overview
- CREATE TABLESPACE syntax
- Storage groups overview
- CREATE STOGROUP syntax
- Assigning a tablespace to a storage group
- Introduction to db2pd command
- ALTER TABLESPACE, ALTER STOGROUP
- DB2 LIST DB DIRECTORY
- DB2 LIST NODE DIRECTORY
- Activate and deactivate a database
Creating database objects
- DB2 object hierarchy
- CREATE SCHEMA
- CREATE TABLE, VIEW
- CREATE ALIAS, INDEX, TRIGGER
- creation of temporary tables
- Creation of temporal tables
- Table partitioning
- Referential Integrity
- Keys, Constraints
- db2look CLI command
- Authorization & Authentication
Moving data
- IMPORT versus LOAD
- Offline versus online load
- LOAD QUERY TABLE
- DB2 LIST UTILITIES
- Pending states (Load, backup, set integrity)
- EXPORT command
- db2move cli command
- ADMIN_MOV_TABLE procedure
Backup and recovery
- Transactional logging (Circular, Archival)
- Configure database logs
- Backup utility options
- Recovery utility options
- ROLLFORWARD
- DB2 RECOVER DATABASE
- ONLINE versus OFFLINE backup
Database Maintenance, Monitoring and Problem Determination
- RUNSTATS utility
- REORGCHK utility
- REORG Utility
- DB2 List commands
- db2pd - Monitory and troubleshoot DB2
- MON_GET_TABLE function
- CREATE EVENT MONITOR
- DB2 Optimizer
- DB2 EXPLAIN
- db2diag.log diagnostic log
- db2trc command to obtain trace
- db2fodc: collect diagnostic data for system hang
- db2advis: Analyze workload
Locking and concurrency
- Importance of locking
- Table lock modes
- Row lock modes
- Lock mode compatibility
- Isolation levels
- LOCK TABLE statement
- Lock escalation, wait, and timeout
- Deadlocks and detection/li>
Security
- Authentication versus Authorization
- SYSADM, SYSCTRL, SYSMAINT, SYSMON
- DBADM, SECADM, ACCESSCTRL
- DB2 security privilege hierarchies
- Grant and Revoke privileges
Log Management
- Database seeds
- Log sequence numbers
- db2ckbkp -l command
- logfilsiz, logbufsz
- Logprimary and Logsecond
- db2pd to check logging activity
- Log Archive processing
- Log retrieval processing
- MAX_LOG configuration parameter
Performance Tuning
- Analyze SQL statements
- Create an access plan graph
- db2exfmt tool
- db2expln tool
- Using Indexes for performance
- Index usage statistics using db2pd
- MON_GET_INDEX
- MON_CONNECTION_SUMMARY view
- Clustering indexes
- db2advis command
Advanced Monitoring
- GET SNAPSHOT command
- In-memory metrics
- Monitoring table functions
- Administrative views, functions
- Monitoring performance with SQL
- Monitor heath with SQL
High Availability with DB2 Database products
- High Availability options in DB2
- DR options in DB2
- High Availability Disaster Recovery (HADR)
- High Availability through Log Shipping
- Log mirroring
- High Availability through suspended I/O and online split mirror support
Cloud DBA Topics for Oracle Database
