您现在的位置是:首页 > 博文答疑 > DB2笔记系列 13 - DB2 LOG博文答疑
DB2笔记系列 13 - DB2 LOG
Leo2016-08-22【4】
简介DB2 COMMAND 查看log
-DISPLAY LOG
查看活动日志占用率指标
-ARCHIVE LOG
-TERM UTIL(*)
解决COPY和RECOVER 的ABEND S04E
I got the same error S04E while unloading the data from table, for the same reason duplicate utility...
So4e error means Duplicate utility id has been created. If your job abends in your run it creates a duplicate utility id. if you submit the same job again without terminating the duplicate utility id then you get so4e error.
It showed error msg "LOAD UTILITY WITH UTILID = IZLOAD1 ENDED IN PHASE = REPORT, WILL ATTEMPT TO RESTART(CURRENT)
DSNUGUTC - UTILITY 'LOAD' INCONSISTENT WITH LAST INVOCATION "
//TERM EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2F)
-TERM UTILITY(IZLOAD1)
/*
日志分为:
活动日志和归档日志。
活动日志是VSAM数据集:
当占用率达到100%时,会写到归档日志里。
归档日志是PS数据集:
也可以使用 COMMAND -ARCHIVE LOG 完成归档
LOG如上:有如下内容:
H/W RBA = 0000F7D35ADB 表示数据集起始位置的位移量: