致力于提升研发企业的持续创新能力
结盟众多企业“教练”， 共同设计、开发及提供人才培养解决方案，通过新颖多样的学习方式，针对性的定制化内容，助力企业全面提升竞争优势。
结盟众多企业“教练”， 共同设计、开发及提供人才培养解决方案，通过新颖多样的学习方式，针对性的定制化内容，助力企业全面提升竞争优势。
MingWei Xu
2 days
5200
This training forcus on DB2 database administration and performance monitor/tuning. Including database architecture, installation, performance monitor and tuning.
This class contains lots of real cases, it’s very userful for reference.
| Agenta | Training Arragement | |
|---|---|---|
| Day 1 |
Topic One：DB2 architecture 1、 DB2 overview 2、 DB2 architecture 3、 DB2 platform version and features Topic Two：DB2 Installation 1、 DB2 pre-intallation 2、 DB2 installation 3、 DB2 environment check. 4、 DB2 instance creation/start/stop/error check Topic Three：DB2 database/tablespace creation 1、 Database creation 2、 Tablespace creation/alter/list/drop 3、 Tablespace monitor: snapshot/list tablespace/db2pd/ Topic Four：DB2 database Administration 1、 Database monitor/check 2、 Database utilities: runstats/reorgchk/reorg/db2bind/db2rbind 3、 Database/tablespace backup/restore startegy 4、 Database logging management 5、 Database backup/restore/rollforward utilities |
|
| Day 2 |
Topic One：DB2 performance monitor and tuning 1、 Performance monitor/Tuning overview 2、 Performance monitor utilities: db2pd/snapshot/db2top.. 3、 Table index design and best practice 4、 Table compression best practice 5、 Real case sharing Topic Two：SQL statement best practice 1、 SQL development top10 tips 2、 SQL cases shareing Topci Three：SQL monitor and tuning 1、 Diagnose SQL issues 2、 How to read SQL statement access plan 3、 SQL statement optimization |
