-
编辑 删除
informix IDS版本介绍
informix dynamic server（ids） 版本含义介绍IBM Informix Dynamic Server Version 9.40.FC3W1 IBM Informix Dynamic Server Version 9.40.FC4 IBM Informix Dynamic Server Version 11.50.FC6DE IBM Informix Dynamic Server Version 11.50.FC6WE IBM Informix Dynamic Server Version 11.50.FC3 IBM Informix Dynamic Server Version 11.50.FC3 IBM IDS Express Edition (IDS-Express) 入门级版本IBM IDS Developer Edition (IDS-DE) 开发版IBM IDS Workgroup Edition (IDS-WGE) 工作组版IBM IDS Enterprise
-
编辑 删除
informix高性能导入导出数据HPL
--HPL high performance loader--The HPL consists of the onpload utility, ipload, and the onpload database.--onpload程序是核心；onpload数据库是配置库，ipload/onpladm都是调用onpload程序的工具--导入分两种模式高级deluxe和快速express模式；导出不分高级和快速。deluxe -flc / express -fl--deluxe模式导入数据，避免在express模式下的下面的错误Cannot perform express mode load with rowsize(=3910) > 2016 / Error occured at HPL failpoint: 16110--经测试：导入数据 11分钟导入160万条数据，速度是10000条/3秒--查看帮
-
编辑 删除
informix fragment 分片表的常见操作 ids9.40
1、创建分片表create table cell_fragment(id int,name varchar(10))FRAGMENT by EXPRESSION(id > 5 and id < 10) IN niosdbs,(id <= 5) IN tpddbs;2、生成测试数据insert into cell_fragment values(1,'1111');insert into cell_fragment values(4,'44');insert into cell_fragment values(8,'81111');insert into cell_fragment values(9,'91111');insert into cell_fragment values(2,'21111');insert into cell_fragment values(3,'31111');insert into cell_fragment values(10,'31111');insert into cell_fragment values(
-
编辑 删除
informix常用时间运算和操作方式
informix数据库中的时间运算select first 1 today,current,current -1 units year,current -1 units day,current -1 units hour,current -1 units minute,current -1 units second from systablesselect first 1 extend(current,year to day),extend(current,year to second),extend(current,year to year),extend(current,hour to second) from systablesselect first 1 extend(current,year to day), extend(current,year to day) - 1 units day,extend(current,year to second),extend(current,year to year),extend(current,hour to s
-
编辑 删除
informix添加删除chunk
touch /opt/informix/chunks/niosdbs_hxlchmod 660 chunks/niosdbs_hxl onspaces -a niosdbs -p /opt/informix/chunks/niosdbs_hxl -s 1000 -o 0onspaces -d niosdbs -p /opt/informix/chunks/niosdbs_hxl -o 0oncheck -pe niosdbs[@more@]
