informix如何更换调整逻辑日志文件

informix9.4 on linux 更换逻辑日志文件的操作记录

说明：

onconfig配置里面关于逻辑日志的配置只是用于oninit -i 初始化，DB运行起来后，就可以用onparams命令来

调整这些文件了，可以删除它们并增加新的文件。

主要过程就是：

1，启动数据库，切换到静默模式

2，用informix账号建立新的Log文件

3，已经备份了有\标志的log文件可以删除 4，onmode -l 切换log文件

5，切换到新增的文件后，进行 onmode -c 强制checkpoint 6，切换到Online状态即可。

至此，其实数据库就可以用了，如果进行一个level0备份，那么那些删除的Log文件就彻底没有了，不会出现在 onstat -l统计列表中。

实际操作如下：

------------------切换到静默--------------------- [informix@IDS94 ~]$ onmode -u

This will perform an IMMEDIATE SHUTDOWN - Do you wish to continue (y/n)? y

There are 0 user threads that will be killed. Do you wish to continue (y/n)? y

[informix@IDS94 ~]$ onstat - IBM Informix Dynamic Server Version 9.40.UC9 -- Quiescent -- Up 00:01:25 -- 28336 Kbytes

[informix@IDS94 ~]$

-------------------查看目前的Log状况------------- [informix@IDS94 ~]$ onstat -l IBM Informix Dynamic Server Version 9.40.UC9 -- Quiescent -- Up 00:01:31 -- 28336 Kbytes

Physical Logging

Buffer bufused bufsize numpages numwrits pages/io

P-1 0 16 0 0 0.00

phybegin physize phypos phyused %used 2:53 25000 22949 0 0.00

Logical Logging

Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 16 1 1 1 1.0 1.0 Subsystem numrecs Log Space used OLDRSAM 1 36

address number flags uniqid begin size used %used 44da12b0 3 U-B---- 1309 1:60263 25000 25000 100.00 44da12f8 7 U-B---- 1310 3:53 10000 10000 100.00 44da1340 8 U-B---- 1311 3:10053 10000 10000 100.00 44da1388 9 U-B---- 1312 3:20053 10000 10000 100.00 44da13d0 10 U-B---- 1313 3:30053 10000 10000 100.00 44da1418 11 U-B---- 1314 3:40053 10000 10000 100.00 44da1460 12 U-B---- 1315 3:50053 10000 10000 100.00 44da14a8 1 U-B---- 1316 3:60053 17500 17500 100.00 44da14f0 2 U---C-L 1317 3:77553 17500 13841 79.09 44da1538 4 U-B---- 1308 3:95053 17500 17500 100.00 10 active, 10 total

----------------------大部分文件都备份了，只有当前文件在用---------- --------------挑选一个大空间的chunk 建立10个新的Log文件------------- [informix@IDS94 ~]$ onstat -d IBM Informix Dynamic Server Version 9.40.UC9 -- Quiescent -- Up 00:01:38 -- 28336 Kbytes

Dbspaces

address number flags fchunk nchunks flags owner name 44c919c8 1 0x20001 1 1 N informix rootdbs 453cc1a0 2 0x60001 2 3 N B informix phydbs 453cc4e0 3 0x20001 3 1 N informix logdbs 453cc820 4 0x60001 4 3 N B informix datadbs 453ccb60 5 0x40001 5 1 N B informix idxdbs 453d0018 6 0x42001 6 1 N TB informix tempdbs 6 active, 2047 maximum

Chunks

address chunk/dbs offset size free bpages flags pathname 44c91d08 1 1 0 200000 172313 PO-- /opt/ids9.4/rawdbs/rootdbs

44da1580 2 2 0 500000 3 PO--

/opt/ids9.4/rawdbs/phydbs

44da1708 3 3 0 500000 387447 PO-- /opt/ids9.4/rawdbs/logdbs

44da1890 4 4 0 4750000 1 PO-B /opt/ids9.4/rawdbs/datadbs

44da1a18 5 5 0 1348575 566462 PO-B /opt/ids9.4/rawdbs/idxdbs

44da1ba0 6 6 0 1348575 1348522 PO-B /opt/ids9.4/rawdbs/tempdbs

44da1d28 7 4 4750100 10000 1 PO-B /opt/ids9.4/rawdbs/datadbs

44d91c30 8 2 500001 10000 1 PO-- /opt/ids9.4/rawdbs/phydbs

44d91db8 9 4 4760100 10000000 3865113 PO-B /opt/ids9.4/rawdbs/datadbs

453cc018 10 2 510001 9999995 7793816 PO-B /opt/ids9.4/rawdbs/phydbs 10 active, 32766 maximum

Expanded chunk capacity mode: enabled

[informix@IDS94 ~]$ onparams -a -d datadbs -s 200000 # KB为单位，建立200MB 和100MB的

Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 200000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 200000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 200000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 200000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 100000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 100000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 100000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 100000 Logical log successfully added.

[informix@IDS94 ~]$ onparams -a -d datadbs -s 100000 Logical log successfully added. [informix@IDS94 ~]$ onstat -d

IBM Informix Dynamic Server Version 9.40.UC9 -- Quiescent -- Up 00:03:21 -- 28336 Kbytes

Dbspaces

address number flags fchunk nchunks flags owner name 44c919c8 1 0x20001 1 1 N informix rootdbs 453cc1a0 2 0x60001 2 3 N B informix phydbs 453cc4e0 3 0x20001 3 1 N informix logdbs 453cc820 4 0x60001 4 3 N B informix datadbs 453ccb60 5 0x40001 5 1 N B informix idxdbs 453d0018 6 0x42001 6 1 N TB informix tempdbs 6 active, 2047 maximum

Chunks

address chunk/dbs offset size free bpages flags pathname 44c91d08 1 1 0 200000 172313 PO-- /opt/ids9.4/rawdbs/rootdbs

44da1580 2 2 0 500000 3 PO-- /opt/ids9.4/rawdbs/phydbs

44da1708 3 3 0 500000 387447 PO-- /opt/ids9.4/rawdbs/logdbs

44da1890 4 4 0 4750000 1 PO-B /opt/ids9.4/rawdbs/datadbs

44da1a18 5 5 0 1348575 566462 PO-B /opt/ids9.4/rawdbs/idxdbs

44da1ba0 6 6 0 1348575 1348522 PO-B /opt/ids9.4/rawdbs/tempdbs

44da1d28 7 4 4750100 10000 1 PO-B /opt/ids9.4/rawdbs/datadbs

44d91c30 8 2 500001 10000 1 PO-- /opt/ids9.4/rawdbs/phydbs

44d91db8 9 4 4760100 10000000 3115113 #空间已经分配 PO-B /opt/ids9.4/rawdbs/datadbs

453cc018 10 2 510001 9999995 7793816 PO-B /opt/ids9.4/rawdbs/phydbs 10 active, 32766 maximum

Expanded chunk capacity mode: enabled

------------------------新增的文件已经出现在列表中了---------------------------- [informix@IDS94 ~]$ onstat -l IBM Informix Dynamic Server Version 9.40.UC9 -- Quiescent -- Up 00:04:12 -- 28336 Kbytes