导出表结构
dbschema -d loan -t business_history business_history.sql
本来准备采用二进制方式导入导出
onunload -t business_history loan:business_history
onload -t /home/db/informix/install/loan/business_history -d loandbs loan:business_history
但两个磁盘的底层块大小不一致,不能成功
只能采用文本格式导入,先进入dbaccess,单独对表进行导出
然后使用,最好将导出的数据分割
dbload -d loan -c bus.ctl -l buserr.log -n 1000000
其中bus.ctl内容为下面,12指的列宽,使用dbaccess查看表状态对应着number of columns:
file "business_history.txt" delimiter "|" 12;
insert into business_history;