Db2 Online Training

IBM DB2 is a family of database server products developed by IBM. Browse through the contents of the program.

DB2 DATA Course Contents
Brief History of Db2
Different product types in DB2
Various editions of Db2
Detailed analysis of DB2 architecture
Demonstrate the ability to configure/manage DB2 servers, instances, and databases
Demonstrate the ability to obtain and modify registry variable information
Demonstrate the ability to obtain/modify database manager configuration information
Demonstrate the ability to obtain/modify database configuration information
Demonstrate the ability to schedule jobs
tools catalog
Task Manager
Administration Configuration (DAS)
Demonstrate the ability to use autonomic features
Automatic Maintenance
Self-Tuning Memory Manager
Utility throttling
Analysis Instance ana databse
Various Background process in db2
Demonstrate the ability to create a database and manipulate various DB2 objects
Create database
Create and discuss the characteristics of DMS, SMS, and AS table spaces
Describe the use of schemas
Demonstrate knowledge of partitioning capabilities
Range/table partitioning
XML indexes
XML data types
XML functions
New features in V9.7
enabling compression
index compression
automatic dictionary creation
replication support
compress XML and LOBs inline
temporary tables
Demonstrate the ability to create constraints on tables
Referential Integerity
Informational
Unique constraints/unique indexes/primary keys
NOT NULL
WITH DEFAULT
Check
Demonstrate the ability to create views WITH CHECK OPTION
LOCAL
CASCADE
Demonstrate the ability to use Admin views and SQL functions for monitoring
ADMIN_GET_INDEX_COMPRESS_INFO
Demonstrate the ability to use Work Load Manager
time spent metrics
new waterfall approach to set up
Demonstrate the ability to use additional auto-monitoring tools
Event monitoring
Demonstrate the ability to configure Health Monitor using the Health Center
Demonstrate the ability to identify the functions of Problem Determination Tools
db2pd
db2mtrk
db2diag command
Interpret the Notify log
Describe the various table space states
db2top
Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
EXPLAIN FROM SECTION
Demonstrate the ability to use the data movement utilities
Demonstrate the ability to use EXPORT utility to extract data from a table
Demonstrate the ability to use IMPORT utility to insert data into a table
Demonstrate the ability to use the LOAD utility to insert data into a table
Knowledge to identify when to use IMPORT vs. LOAD
DB2Move
DB2Look
Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
Demonstrate the ability to use the DB2 Advisor utility
db2advis utility
GUI
Describe the purpose of Data Studio Administrator (basic concepts � replacing existing DB2 tools)
Describe DB2 data integrity actions
transactions and logging
logging strategies
crash recovery
version recovery
roll forward recovery
Demonstrate the ability to perform database-level and table space level backup and recovery operations
BACKUP
RESTORE
ROLLFORWARD
RECOVER
Describe backing up with split mirroring
Demonstrate the ability to configure and manage HADR
automatic client re-route
Describe DB2 authentication
Describe DB2 authorizations and privileges
Describe the ability to set and remove user, group, and role authorities and privileges
Roles
GRANT
REVOKE
Demonstrate general knowledge of the Audit facility
Demonstrate knowledge of the DB2 Security Infrastructure
LBAC
Trusted contexts
LDAP
Plug-ins
Demonstrate the ability to configure database connectivity
steps required to setup connection pools
using DB2 DISCOVERY
Demonstrate knowledge federating communications
connection concentration
sysplex utilization
DB2COMM
automatic client re-route
Demonstrate knowledge of using JDBC/SQLJ connections with DB2
DB2 drivers
licensing
Contact us today at info@techflames.com or call us at +91-9100947004.