CREATE TABLE

显示全部楼层 · 2005-10-30 17:05:33

建表的时候报错
db2 "create table yan (aaa char(2)) indatasp"
DB21034EThe command was processed as an SQL statement because it was not a
valid Command Line Processor command.During SQL processing it returned:
SQL0903NCOMMIT statement failed, transaction rolled back.Reason code: "2".
SQLSTATE=40504

重起了以后有这些报错

Crash Recovery is needed.

2003-07-13-16.29.17.798052 Instance:db2inst1 Node:000
PID:1138802(db2agent (TW06BIDW) 0) TID:1 Appid:*N0.db2inst1.000013082913
recovery managersqlpresr Probe:410 Database:BIDW

Crash recovery started. LowtranLSN 0000000FA659129F MinbuffLSN 0000000FA659129F

2003-07-13-16.29.17.897749 Instance:db2inst1 Node:000
PID:1138802(db2agent (TW06BIDW) 0) TID:1 Appid:*N0.db2inst1.000013082913
recovery managersqlprecm Probe:125 Database:BIDW

Using parallel recovery with 3 agents 6 QSets 42 queues and 32 chunks

2003-07-13-16.29.18.414219 Instance:db2inst1 Node:000
PID:1138802(db2agent (TW06BIDW) 0) TID:1 Appid:*N0.db2inst1.000013082913
recovery managersqlprecm Probe:400 Database:BIDW

DIA2051W Forward phase of crash recovery has completed.Next LSN is
"0000000FA6595CCF".

2003-07-13-16.29.40.702814 Instance:db2inst1 Node:001
PID:1318978(db2agntp (TW06BIDW) 1) TID:1 Appid:*N0.db2inst1.000013082913
recovery managersqlpresr Probe:410 Database:BIDW

Crash recovery started. LowtranLSN 0000000D8C430674 MinbuffLSN 0000000D8C430674

2003-07-13-16.29.40.784379 Instance:db2inst1 Node:001
PID:1318978(db2agntp (TW06BIDW) 1) TID:1 Appid:*N0.db2inst1.000013082913
recovery managersqlprecm Probe:125 Database:BIDW

Using parallel recovery with 3 agents 5 QSets 35 queues and 32 chunks

2003-07-13-16.29.40.903390 Instance:db2inst1 Node:001
PID:1318978(db2agntp (TW06BIDW) 1) TID:1 Appid:*N0.db2inst1.000013082913
recovery managersqlprecm Probe:400 Database:BIDW

DIA2051W Forward phase of crash recovery has completed.Next LSN is
"0000000D8C432030".

2003-07-13-17.57.00.572567 Instance:db2inst1 Node:000
PID:1245232(db2agent (TW06BIDW) 0) TID:1 Appid:*N0.db2inst1.080233093924
config/installsqlfGetDbCfg Probe:10 Database:BIDW

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFC0F".

2003-07-13-18.14.05.208641 Instance:db2inst1 Node:000
PID:1245232(db2agent (instance) 0) TID:1 Appid:GAC8034E.IB0F.063383103329
base sys utilitiessqleattach_agent Probe:60

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81360012".

2003-07-13-18.29.11.148213 Instance:db2inst1 Node:000
PID:1138802(db2agent (TW06BIDW) 0) TID:1 Appid:*N0.db2inst1.080E13102407
buffer pool servicessqlbQryPoolCont Probe:1300 Database:BIDW