Problem(Abstract)
Attempt to migrate instance through db2imigr or checking database for migration through db2ckmig result in DBI1205E when using IBM DB2 for Linux- UNIX and Windows.
Symptom
The migration log will show the following error message:SQL...(more)
在这篇主要看一下BBED 工具的几个使用示例。 Althoughbbed can modify data in the data files of an open Oracle database, it isadvisable to shut down the database before making any changes. This avoids thecheckpoint process overwriting the changes ...(more)
1、相关解析:
APAR status
Closed as program error.
Error description
SQL22212N when performing tasks on a local database in the
Control Center.
The problem has been reported when creating a local database in
the Control Center but it can happen al...(more)
查看缓冲池1) 看所有buffer pool的总情况,用get snapshot for database on db_name
2) 看每个bufferpool的单独情况,用get snapshot for all bufferpool on db_name
2) 看每个tablespace使用buffer pool的情况, 用get snapshot for tablespaces on db_name查看缓冲池命中率...(more)