CNDBA社区
[db2inst1@test01 tmp]$ db2 "import from T1.ixf of ixf insert into db2inst1.T1"
SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
"20221125", and time "165702".
SQL3153N The T record in the PC/IXF file has name "T1.ixf",
qualifier "", and source " ".
SQL3109N The utility is beginning to load data from file "T1.ixf".
SQL3306N An SQL error "-964" occurred while inserting a row into the table.
SQL0964C The transaction log for the database is full. SQLSTATE=57011
SQL3110N The utility has completed processing. "137635" rows were read from
the input file.
解决方法：
修改LOGFILSIZ、LOGPRIMARY、LOGSECOND后重新导入
#db2 "import from T1.ixf of ixf insert into db2inst1.T1"
SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
"20221125", and time "165702".
SQL3153N The T record in the PC/IXF file has name "T1.ixf",
qualifier "", and source " ".
SQL3109N The utility is beginning to load data from file "T1.ixf".
SQL3110N The utility has completed processing. "672117" rows were read from
the input file.
SQL3221W ...Begin COMMIT WORK. Input Record Count = "672117".
SQL3222W ...COMMIT of any database changes was successful.
SQL3149N "672117" rows were processed from the input file. "672117" rows
were successfully inserted into the table. "0" rows were rejected.
Number of rows read = 672117
Number of rows skipped = 0
Number of rows inserted = 672117
Number of rows updated = 0
Number of rows rejected = 0
Number of rows committed = 672117
版权声明：本文为博主原创文章，未经博主允许不得转载。
DB2
