互联网服务
db2 搬表出错 load表时报51027 急求解决办法
系统日切过程中 load表时报51027 各位大拿，帮忙给看看吧，日啊 系统运维真不是人干的啊declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSB...显示全部
系统日切过程中 load表时报51027 各位大拿，帮忙给看看吧，日啊 系统运维真不是人干的啊
declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE from tcbsusrb.tn_total_divide_normal
DB20000I The SQL command completed successfully.
load from mycursor of cursor method n(I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE) insert into tcbsusra.htn_total_divide_normal copy yes to /tcbsdatas/backup/loaddata/tcbsusra/
SQL1193I The utility is beginning to load data from the SQL statement "
select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PA...".
SQL3500W The utility is beginning the "LOAD" phase at time "05/15/2012
21:26:21.232454".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "29913" rows were read from
the input file.
SQL3519W Begin Load Consistency Point. Input record count = "29913".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "05/15/2012
21:26:21.645360".
SQL3500W The utility is beginning the "BUILD" phase at time "05/15/2012
21:26:21.645561".
SQL3213I The indexing mode is "INCREMENTAL".
SQL3515W The utility has finished the "BUILD" phase at time "05/15/2012
21:26:23.820693".
SQL3500W The utility is beginning the "DELETE" phase at time "05/15/2012
21:26:23.920173".
SQL3509W The utility has deleted "29913" rows from the table.
SQL3515W The utility has finished the "DELETE" phase at time "05/15/2012
21:26:25.910910".
Number of rows read = 29913
Number of rows skipped = 0
Number of rows loaded = 29913
Number of rows rejected = 0
Number of rows deleted = 29913
Number of rows committed = 29913
SET INTEGRITY FOR tcbsusra.Htn_total_divide_normal ALLOW NO ACCESS IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL3600N The IMMEDIATE CHECKED option of the SET INTEGRITY statement is not
valid since the table "TCBSUSRA.HTN_TOTAL_DIVIDE_NORMAL" is a user maintained
materialized query table or is not in the Set Integrity Pending state.
SQLSTATE=51027
declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE from tcbsusrb.tn_total_divide_trim
DB20000I The SQL command completed successfully.
load from mycursor of cursor method n(I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE) insert into tcbsusra.htn_total_divide_trim copy yes to /tcbsdatas/backup/loaddata/tcbsusra/
SQL1193I The utility is beginning to load data from the SQL statement "
select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PA...".
SQL3500W The utility is beginning the "LOAD" phase at time "05/15/2012
21:26:28.578504".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "0" rows were read from the
input file.
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "05/15/2012
21:26:28.952085".
SQL3500W The utility is beginning the "BUILD" phase at time "05/15/2012
21:26:28.952280".
SQL3213I The indexing mode is "INCREMENTAL".
SQL3515W The utility has finished the "BUILD" phase at time "05/15/2012
21:26:29.007402".
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
SET INTEGRITY FOR tcbsusra.Htn_total_divide_trim ALLOW NO ACCESS IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL3600N The IMMEDIATE CHECKED option of the SET INTEGRITY statement is not
valid since the table "TCBSUSRA.HTN_TOTAL_DIVIDE_TRIM" is a user maintained
materialized query table or is not in the Set Integrity Pending state.
SQLSTATE=51027
declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCT,I_PARTNO,F_AMT,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_TAXORGCODE,S_VOUNO,D_ACCEPT,S_BIZTYPE,I_OFMONTH,I_BATCHNUM,S_ASTFLAG,C_DATAFLAG,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE from tcbsusrb.tn_unshare_normal
DB20000I The SQL command completed successfully.
load from mycursor of cursor method n(I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCT,I_PARTNO,F_AMT,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_TAXORGCODE,S_VOUNO,D_ACCEPT,S_BIZTYPE,I_OFMONTH,I_BATCHNUM,S_ASTFLAG,C_DATAFLAG,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE) insert into tcbsusra.htn_unshare_normal copy yes to /tcbsdatas/backup/loaddata/tcbsusra/
SQL1193I The utility is beginning to load data from the SQL statement "
select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCT,I_PARTNO,F_AM...".
SQL3500W The utility is beginning the "LOAD" phase at time "05/15/2012
21:26:30.627129".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "161580" rows were read from
the input file.
SQL3519W Begin Load Consistency Point. Input record count = "161580".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "05/15/2012
21:26:31.767709".
SQL3500W The utility is beginning the "BUILD" phase at time "05/15/2012
21:26:31.767919".
SQL3213I The indexing mode is "INCREMENTAL".
SQL3515W The utility has finished the "BUILD" phase at time "05/15/2012
21:26:53.884519".
SQL3500W The utility is beginning the "DELETE" phase at time "05/15/2012
21:26:54.004686".
SQL3509W The utility has deleted "161580" rows from the table.
SQL3515W The utility has finished the "DELETE" phase at time "05/15/2012
21:27:08.900383".
Number of rows read = 161580
Number of rows skipped = 0
Number of rows loaded = 161580
Number of rows rejected = 0
Number of rows deleted = 161580
Number of rows committed = 161580
SET INTEGRITY FOR tcbsusra.Htn_unshare_normal ALLOW NO ACCESS IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL3600N The IMMEDIATE CHECKED option of the SET INTEGRITY statement is not
valid since the table "TCBSUSRA.HTN_UNSHARE_NORMAL" is a user maintained
materialized query table or is not in the Set Integrity Pending state.
SQLSTATE=51027收起
declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE from tcbsusrb.tn_total_divide_normal
DB20000I The SQL command completed successfully.
load from mycursor of cursor method n(I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE) insert into tcbsusra.htn_total_divide_normal copy yes to /tcbsdatas/backup/loaddata/tcbsusra/
SQL1193I The utility is beginning to load data from the SQL statement "
select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PA...".
SQL3500W The utility is beginning the "LOAD" phase at time "05/15/2012
21:26:21.232454".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "29913" rows were read from
the input file.
SQL3519W Begin Load Consistency Point. Input record count = "29913".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "05/15/2012
21:26:21.645360".
SQL3500W The utility is beginning the "BUILD" phase at time "05/15/2012
21:26:21.645561".
SQL3213I The indexing mode is "INCREMENTAL".
SQL3515W The utility has finished the "BUILD" phase at time "05/15/2012
21:26:23.820693".
SQL3500W The utility is beginning the "DELETE" phase at time "05/15/2012
21:26:23.920173".
SQL3509W The utility has deleted "29913" rows from the table.
SQL3515W The utility has finished the "DELETE" phase at time "05/15/2012
21:26:25.910910".
Number of rows read = 29913
Number of rows skipped = 0
Number of rows loaded = 29913
Number of rows rejected = 0
Number of rows deleted = 29913
Number of rows committed = 29913
SET INTEGRITY FOR tcbsusra.Htn_total_divide_normal ALLOW NO ACCESS IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL3600N The IMMEDIATE CHECKED option of the SET INTEGRITY statement is not
valid since the table "TCBSUSRA.HTN_TOTAL_DIVIDE_NORMAL" is a user maintained
materialized query table or is not in the Set Integrity Pending state.
SQLSTATE=51027
declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE from tcbsusrb.tn_total_divide_trim
DB20000I The SQL command completed successfully.
load from mycursor of cursor method n(I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PARTNO,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_TAXORGCODE,S_VOUNO,F_AMT,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_ASTFLAG,F_DIVIDERATIO,I_BATCHNUM,I_OFMONTH,S_BIZTYPE,C_DATAFLAG,S_REASONCODE,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE) insert into tcbsusra.htn_total_divide_trim copy yes to /tcbsdatas/backup/loaddata/tcbsusra/
SQL1193I The utility is beginning to load data from the SQL statement "
select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCEPT,D_ACCT,I_PA...".
SQL3500W The utility is beginning the "LOAD" phase at time "05/15/2012
21:26:28.578504".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "0" rows were read from the
input file.
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "05/15/2012
21:26:28.952085".
SQL3500W The utility is beginning the "BUILD" phase at time "05/15/2012
21:26:28.952280".
SQL3213I The indexing mode is "INCREMENTAL".
SQL3515W The utility has finished the "BUILD" phase at time "05/15/2012
21:26:29.007402".
Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
SET INTEGRITY FOR tcbsusra.Htn_total_divide_trim ALLOW NO ACCESS IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL3600N The IMMEDIATE CHECKED option of the SET INTEGRITY statement is not
valid since the table "TCBSUSRA.HTN_TOTAL_DIVIDE_TRIM" is a user maintained
materialized query table or is not in the Set Integrity Pending state.
SQLSTATE=51027
declare mycursor cursor for select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCT,I_PARTNO,F_AMT,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_TAXORGCODE,S_VOUNO,D_ACCEPT,S_BIZTYPE,I_OFMONTH,I_BATCHNUM,S_ASTFLAG,C_DATAFLAG,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE from tcbsusrb.tn_unshare_normal
DB20000I The SQL command completed successfully.
load from mycursor of cursor method n(I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCT,I_PARTNO,F_AMT,S_ROOTTRECODE,S_TRATRECODE,S_AFTTRECODE,S_BDGSBTCODE,C_BDGLEVEL,C_BDGKIND,S_TAXORGCODE,S_VOUNO,D_ACCEPT,S_BIZTYPE,I_OFMONTH,I_BATCHNUM,S_ASTFLAG,C_DATAFLAG,C_DATAATTRIB,C_DATAROOT,S_INPUTERID,S_CHECKERID,S_MAINCHECKERID,S_GRANTERID,TS_SYSUPDATE) insert into tcbsusra.htn_unshare_normal copy yes to /tcbsdatas/backup/loaddata/tcbsusra/
SQL1193I The utility is beginning to load data from the SQL statement "
select I_ENROLSRLNO,S_BOOKORGCODE,S_TRASRLNO,D_ACCT,I_PARTNO,F_AM...".
SQL3500W The utility is beginning the "LOAD" phase at time "05/15/2012
21:26:30.627129".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3110N The utility has completed processing. "161580" rows were read from
the input file.
SQL3519W Begin Load Consistency Point. Input record count = "161580".
SQL3520W Load Consistency Point was successful.
SQL3515W The utility has finished the "LOAD" phase at time "05/15/2012
21:26:31.767709".
SQL3500W The utility is beginning the "BUILD" phase at time "05/15/2012
21:26:31.767919".
SQL3213I The indexing mode is "INCREMENTAL".
SQL3515W The utility has finished the "BUILD" phase at time "05/15/2012
21:26:53.884519".
SQL3500W The utility is beginning the "DELETE" phase at time "05/15/2012
21:26:54.004686".
SQL3509W The utility has deleted "161580" rows from the table.
SQL3515W The utility has finished the "DELETE" phase at time "05/15/2012
21:27:08.900383".
Number of rows read = 161580
Number of rows skipped = 0
Number of rows loaded = 161580
Number of rows rejected = 0
Number of rows deleted = 161580
Number of rows committed = 161580
SET INTEGRITY FOR tcbsusra.Htn_unshare_normal ALLOW NO ACCESS IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL3600N The IMMEDIATE CHECKED option of the SET INTEGRITY statement is not
valid since the table "TCBSUSRA.HTN_UNSHARE_NORMAL" is a user maintained
materialized query table or is not in the Set Integrity Pending state.
SQLSTATE=51027收起