文档介绍:DB2 速查手册
1. MIGRATING DB2 4
Migrating DB2 Servers 4
Migration Steps for a DB2 Server on Windows 4
2. DB2 FixPack 安装(完整版) 6
DB2 fixpack 介绍 6
DB2 FixPack 下载 6
当前DB2版本 8
DB2 FixPack 安装 8
准备工作 8
DB2实例更新 10
3. TERMINATE, CONNECT RESET & DISCONNECT 12
4. each mand 13
5. client and server connectivity 14
6. system database directory & local database directory 15
7. The Relationship between the DB2 Directories 16
8. configure a connection using db2 discovery 18
9. Diagnose connection problems 18
10. 建表时表空间的分配使用方法 21
11. SQL语句监视器及SQL语句调优 23
12. 监控执行成本最高的SQL语句(执行大型表扫描操作) 26
13. 监控缓冲池命中率 26
14. 监控package cache 大小 27
15. 日志buffer 调优 28
16. Sortheap 和sheapthres 29
17. db2pd 实用程序显示的索引度量指标 33
18. 状态和CHECK_PENDING 查询 34
19. DB2 VISION EXPLAIN 教程 35
20. 实验:backup database后表空间的min recovery time 值是否发生改变 35
21. LOAD 实用程序概述 36
MIGRATING DB2
If you are still running an older version of DB2, and want to migrate to a new version of DB2,then you need to perform the following migration process:
• Migrate DB2 servers—Migrate DB2 instances (Linux and UNIX only) and migrate DB2 databases.
• Migrate DB2 clients—Migrate DB2 client instances to keep the configuration of your existing DB2 clients.
N O T E We will discuss the migration process for the DB2 server next. The term ¡§migrate¡§ monly used in the DB2 manuals to indicate an upgrade from one version of DB2 to another. We will follow this convention in this book, although, the term ¡§Upgrade¡§ would have been more appropriate.
Migrating DB2 Servers
Migrating DB2 servers involves upgrading your existing instances and databases so that they can run properly in DB2 9. If you are migrating from DB2 Version 8, then you can migrate directly to DB2 9. If you are migrating from DB2 Version 7 or earlier, you will need to migrate to DB2 Version 8 first, and then migrate to DB2 9.
N O T E The methodologies to migrate to DB2 9 or DB2 are exactly the same. We will discuss mi