一、管理进程:
a、源端操作
d:\ggshome>ggsci
GGSCI>edit param mgr
1、建mgr服务
2、检查数据库是否是归档日志、是否开数据库的最小附加日志
To determine log retention parameters
1. Connect to the database.
db2 >connect to GGS user GGS using GGS
2. Get the database name.
db2 >list db directory
3. Get the database configuration for the database.
db2 >get db cfg for GGS
The correct configuration for GoldenGate is:
Log retain for recovery status = RECOVERY
User exit for logging status = YES
To set log retention parameters
1. Issue the following commands.
db2 >update db cfg for GGS using LOGRETAIN ON
db2 >update db cfg for GGS using USEREXIT ON
2. Make a full backup of the database by issuing the following commands.
BIN >db2stop force
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载