Description
Seller-provided details for this listing.
IBM Db2 DBA Administration
Lesson 1: Installation and the DB2 Editions
Db2 products and product components
Installation
Lesson 2: The DB2 Environment
Creation of instance
Creation of database
Lesson 3: Tools
Db2 control center
Db2 task center
Db2 clp
Db2 diagnostics
Db2 snapshots
Db2 problem determination
Lesson 4: Architecture
Memory model
Buffer pools
Hard parsing
Soft parsing
Tips and techniques
Lesson 5: Connectivity
Establish client server connectivity
Lesson 6: Working with database objects
Creating table spaces
Creating tables
Creating users
Creating indexes,views,aliases
Lesson 7: Data movement
Export
Import
Load
Db2move
Lesson 8: Security
Authentication
Authorizations
Concurrency and locking
Lesson 9: Backup & Recovery
Hot backup
Cold backup
Types of hot backup (database level and table space level )
Recovery scenarios :-
Crash recovery
Version recovery
Roll forward recovery
Dropped table recovery and few more
Lesson 10: Maintenance
Reorg
Runstats
Reorgchk
Optimizer ,advisor and binding
Lesson 11 : Troubleshooting and guide lines on performance tuning
Analyzing errors using diagnostics and notification files
Approaching db2support [Raising a PMR with IBM ]
Some Imp advanced concepts specifically for DATA WARE HOUSING ENVIRONMENTS [OLAP]
Lesson 13 : Introduction to Partitioning features [Table,data and Database]
BCU [Balance configuration unit] E7100 architecture
ISAS [IBM smart analytics system ] E7700 architecture
Lesson 14 : Enhancement and advantages of using different version of DB2 V9 and V 10
Whats new
Db2 version 9.1
Db2 version 9.5
Db2 version 9.7
Db2 version 9.8
Db2 version 10
Courses Offerings
Abinitio
Android
AIX Administration
Business Analyst
Drop a mail [email protected] we will get in touch with u
http://www.futurepointtech.com/ibm-db2-dba-administration-training.html
Lesson 1: Installation and the DB2 Editions
Db2 products and product components
Installation
Lesson 2: The DB2 Environment
Creation of instance
Creation of database
Lesson 3: Tools
Db2 control center
Db2 task center
Db2 clp
Db2 diagnostics
Db2 snapshots
Db2 problem determination
Lesson 4: Architecture
Memory model
Buffer pools
Hard parsing
Soft parsing
Tips and techniques
Lesson 5: Connectivity
Establish client server connectivity
Lesson 6: Working with database objects
Creating table spaces
Creating tables
Creating users
Creating indexes,views,aliases
Lesson 7: Data movement
Export
Import
Load
Db2move
Lesson 8: Security
Authentication
Authorizations
Concurrency and locking
Lesson 9: Backup & Recovery
Hot backup
Cold backup
Types of hot backup (database level and table space level )
Recovery scenarios :-
Crash recovery
Version recovery
Roll forward recovery
Dropped table recovery and few more
Lesson 10: Maintenance
Reorg
Runstats
Reorgchk
Optimizer ,advisor and binding
Lesson 11 : Troubleshooting and guide lines on performance tuning
Analyzing errors using diagnostics and notification files
Approaching db2support [Raising a PMR with IBM ]
Some Imp advanced concepts specifically for DATA WARE HOUSING ENVIRONMENTS [OLAP]
Lesson 13 : Introduction to Partitioning features [Table,data and Database]
BCU [Balance configuration unit] E7100 architecture
ISAS [IBM smart analytics system ] E7700 architecture
Lesson 14 : Enhancement and advantages of using different version of DB2 V9 and V 10
Whats new
Db2 version 9.1
Db2 version 9.5
Db2 version 9.7
Db2 version 9.8
Db2 version 10
Courses Offerings
Abinitio
Android
AIX Administration
Business Analyst
Drop a mail [email protected] we will get in touch with u
http://www.futurepointtech.com/ibm-db2-dba-administration-training.html