informx语句文档.doc

chown -R tnms2:tnms2 TNMS_HOME/ 给目录及子目录赋值属组、属用户HPL导入例子：onpladm create job job01 -d /informix/gengjb/rel_duanzi_lianjie-1218 -D tnmsdb2 -t rel_duanzi_lianjie -flc -zD;onpladm run job job01 -fl -l back.logback.log是生成的日志；导入的过程会锁表，不能操作2、有很多限制，但速度较deluxe mode快3、导入后table 是read only ，需要执行0级备份：可以先修改onconfig中的备份路径为/dev/null；这样就不用备份，只修改read only标记bash-2.03$ ontape -s -L 0Archive to tape device /dev/null is complete如何查看物理内存的大小？SAM -; performance monitor -; system properties-; memory查看物理内存。/resource/informix/ids11/IDS1150FC8HPPA.tar HYPERLINK /resource/informix/ids11/IDS1150FC9HPPA.tar /resource/informix/ids11/IDS1150FC9HPPA.tar融海提供的informix下载地址查找文件语句：find / -name SystemErr.log find ./ -name *.hprofselect * from circuit where circuitnumber in(select circuitnumber from circuit group by circuitnumber having count(*)1) and rowid not in (select min(rowid) from circuit group by circuitnumber having count(*)1)查找全部重复记录delete from circuit where circuitnumber in(select circuitnumber from circuit group by circuitnumber having count(*)1) and rowid not in (select min(rowid) from circuit group by circuitnumber having count(*)1)删除表多于的重复记录,只留下rowid最小的记录锁表问题处理过程：方法一：informix 锁表???? 早晨来了，发现今天所有数据都没有上来，查看发现快照表里没有今天的数据，当我想load 昨天的数据出来时，报 245: Could not position within a file via an index. 的错误，informix 锁表问题。处理步骤：?? 1 在informix用户下找出锁表的用户：onstat -ks|grep HDR+X，输出的内容很多很多，10ad44850??????? 0??????????????? 1acf10c10??????? 10d214a70??????? HDR+X??? 160009b 784e801???? 0?? 10ad44d20??????? 0??????????????? 1acf10c10??????? 11d51dfa0??????? HDR+X??? 160009b 1c40301???? 0?? 10ad44e70??????? 0??????????????? 1acf10c10??????? 123c785d0??????? HDR+X??? 160009b 70bc201???? 0?? 10ad46840??????? 0??????????????? 1acf10c10??????? 1135969c0??????? HDR+X??? 400880?? 101da01 K- 1?? 10ad474f0??????? 0??????????????? 1acf10c10??????? 115efbe60??????? HDR+X??? 160009b 6df6301???? 0?? ???? 每列分别对应：Locks address????? wtlist????? owner????????? lklist???????????? type????????? tblsnum rowid key#