Perl迁移日志
Perl迁移时,DSC将所有日志信息写入perlDSC.log文件。
DSC通过调用SQL来迁移Perl文件中的SQL脚本,因此支持以下SQL迁移日志:
- 活动日志
- 错误日志
- 成功读
- 成功写
日志级别
可以使用logging-level参数来配置perl迁移日志的记录级别。
日志记录
DSC将所有日志、告警和错误信息保存到log文件夹下的perlDSC.log文件中。日志文件包含执行迁移的用户、迁移的文件、时间戳等详细信息。
perlDSC.log的文件结构如下:
2018-07-08 13:35:10 INFO teradatacore.pm:1316 Extracting SQL contents from perl files started 2018-07-08 13:35:10 INFO teradatacore.pm:1329 Extracting SQL contents from perl files completed 2018-07-08 13:35:10 INFO teradatacore.pm:1331 Migrating SQL files 2018-07-08 13:35:12 INFO teradatacore.pm:1348 Migrating SQL files completed 2018-07-08 13:35:12 INFO teradatacore.pm:1349 Merging migrated SQL contents to perl files started 2018-07-08 13:35:12 INFO teradatacore.pm:1362 Merging migrated SQL contents to perl files completed 2018-07-08 13:35:12 INFO teradatacore.pm:1364 Perl file migration completed 2018-07-08 13:35:32 INFO teradatacore.pm:1316 Extracting SQL contents from perl files started 2018-07-08 13:35:58 ERROR teradatacore.pm:426 opendir ../../../../../perltest/ failed 2018-07-08 13:36:17 INFO teradatacore.pm:1316 Extracting SQL contents from perl files started 2018-07-08 13:38:21 INFO teradatacore.pm:1329 Extracting SQL contents from perl files completed 2018-07-08 13:38:21 INFO teradatacore.pm:1331 Migrating SQL files 2018-07-08 13:38:22 INFO teradatacore.pm:1348 Migrating SQL files completed 2018-07-08 13:38:22 INFO teradatacore.pm:1349 Merging migrated SQL contents to perl files started 2018-07-08 13:38:37 ERROR teradatacore.pm:1044 Directory ../../../../../perltest/ should have 700, but has 0 permission 2018-07-08 13:38:53 ERROR teradatacore.pm:1241 Another migration process is running on same folder, re-execute after the process has completed 2018-07-08 13:39:01 INFO teradatacore.pm:1316 Extracting SQL contents from perl files started 2018-07-08 13:39:51 INFO teradatacore.pm:1329 Extracting SQL contents from perl files completed 2018-07-08 13:39:51 INFO teradatacore.pm:1331 Migrating SQL files 2018-07-08 13:39:53 INFO teradatacore.pm:1348 Migrating SQL files completed 2018-07-08 13:39:54 INFO teradatacore.pm:1349 Merging migrated SQL contents to perl files started 2018-07-08 13:39:55 INFO teradatacore.pm:1362 Merging migrated SQL contents to perl files completed 2018-07-08 13:39:57 INFO teradatacore.pm:1364 Perl file migration completed