《4.数据库使用宝典》.pdf

数据库使用汇总 1 Informix 1.1 常用方法 1.1.1 启动和停止数据库 1.1.1.1oninit 初始化数据库 格式 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 重新启动数据库 1.1.1.2onmode 停止数据库 格式 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