数据库使用汇总.doc

数据库使用汇总  Informix 常用方法 启动和停止数据库 oninit 初始化数据库 格式 oninit { -[ipsy] } 说明 -i Initialize disk space and shared memory, leave in on-line mode. -p Do not reclaim temporary tables. -s Initialize shared memory, leave in quiescent mode. -y Respond yes to all prompts oninit –iy 初始化数据库，执行该操作后，数据库被恢复到初始安装状态； oninit 重新启动数据库 onmode 停止数据库 格式 onmode -abcDdFklMmnOpQRrSsuyZz 说明 -a kbytes Increase shared memory segment size. -b version Revert Dynamic Server disk structures. -c [block | unblock] Do Checkpoint. Block or unblock server. -D max PDQ priority allowed -d {standard|{primary|secondary servername}} set DR server type -F Free unused memory segments -k Shutdown completely -e {on|off|enable|flush} configure or flush shared statement cache. -l Force to next logical log -M decision support memory in kbytes -m Go to multi-user on-line -n Set shared memory buffer cache to non-resident -O Override space down blocking a checkpoint -p +-# class Start up or remove virtual processors of a specific class -Q max # decision support queries -R Rebuild the /INFORMIXDIR/etc/.infos.DBSERVERNAME file -r Set shared memory buffer cache to resident -S max # decision support scans -s Shutdown to single user -u Shutdown and kill all attached sessions -W {STMT_CACHE_NOLIMIT {0|1} | STMT_CACHE_HITS #} Sets ssc parameters. -y Do not require confirmation -Z address heuristically complete specified transaction -z sid Kill specified session id onmode –ky 将数据库停止 onmode –u 停止数据库并强制中止所有的相关会话 onmode -z [session id] 杀掉数据库进程 SQL语句 DML SELECT 查询 SELECT select_list FROM tab_name|view_name WHERE condition GROUP BY column_name HAVING condition ORDER BY column_list INTO TEMP table_name select_list：选择表或* tab_name：表名称 view_name：视图名称。 condition：查询条件，可使用BETWEEN、IN、LIK