extent 不足导致数据无法写入处理过程

1、问题现象：

-bash-3.2$ dbaccess tnmsdb2 -

Database selected.

> load from /home/informix/yy insert into circuit;

  271: Could not insert new row into the table.   136: ISAM error: no more extents
  847: Error in load file line 37242.
Error in line 1
Near character position 48

2、处理步骤：

     2.1、检查设置extent大小

-bash-3.2$ dbschema -d tnmsdb2 -t circuit -ss|grep extent
  ) extent size 16 next size 16 lock mode row;

     2.2、备份表结构,vi进去修改extent大小

sed -e '/\/s/[0-9][0-9]*/16/g' file.cfg

-bash-3.2$ dbschema -d tnmsdb2 -t circuit -ss circuit.sql

     2.3、备份数据

>unload to circuit.data select * from circuit;

     2.3、dop库表

>dop table circuit;

     2.4、导入表结构

dbaccess tnmsdb2 circuit.data

     2.5、导入数据

>load from /home/informix/circuit.data insert into circuit;