在导入单个大表的情况下,如何通过ingest提高并行性?
收起可以这样调调如下参数,看看是否有帮助:
db2 INGEST SET COMMIT_COUNT 3000
db2 INGEST SET NUM_FLUSHERS_PER_PARTITION 4
db2 INGEST SET NUM_FORMATTERS 4
db2 INGEST SET RETRY_COUNT 1
db2 INGEST SET RETRY_PERIOD 1
db2 INGEST SET MSG_BUF_COUNT 32
db2 INGEST SET ROW_ARRAY_COUNT 1000
db2 "ingest from pipe /data/table1.txt
format delimited 0x26
restart off
insert into table1"