Common Informix database operation commands

Oninit database start onmode-ky database close onstat-l view logical log usage ontape-c continuous backup logical log onstat-giof view the IO status of each chunk onstat-gmem view database memory onstat-d view database chunk usage ontape-s-L0 database level 0 backup

Oninit database start onmode-ky database close onstat-l view logical log usage ontape-c continuous backup logical log onstat-g iof view the I/O status of each chunk onstat-g mem View database memory usage onstat-d view database chunk usage ontape-s-L 0 database level 0 backup

Oninit startup
Onmode-ky database closed
Onstat-l view logical log usage
Ontape-c continuous backup logic log
Onstat-g iof view the I/O status of each chunk
Onstat-g mem view database memory
Onstat-d view database chunk usage
Ontape-s-L 0 database level 0 backup
Dbimport -D -I

Data Recovery (hard disk)
Dbexport -O Data backup (hard disk)
Update staistics (high) (low) database data sampling statistics
Ontape-r Data Recovery (TAPE)
Onstat-c Configuration
Onstat-database status information

Ps-ef | grep cmcld view MC/Service Guard Process
Cmviewcl view the running status of MC/Service Guard
Cmruncl [f] Starting a cluster
Cmhaltcl [-f] terminate a cluster
Cmrunnode node starts a node in the Cluster
Example: # cmrunnode HPK460-1
Cmhaltnode mode: terminate a node in the cluster.
Example: # cmhaltnode HPK460-1
Cmrunpkg-n node pkg run the pkg package on the node
Example: # cmrunpkg-n HPK460-1 pkg1
Cmhaltpkg-n node pkg stops running the pkg package on the node
Example: # cmhaltpkg-n HPK460-1 pkg1
Cmmodpkg-e-n node pkg allows pkg package to run on node nodes
Example: # cmmodpkg-e-n HPK460-1 pkg1
Cmmodpkg-d-n node pkg prohibits the running of the pkg package on the node
Example: # cmmodpkg-d-n HPK460-1 pkg1
The "-v" parameter can be attached to cm commands to display execution results in redundancy mode. The "-f" parameter indicates forcible execution and ignore error warnings.
Vgdispaly [-v] vg_name displays the activated volume group information
Example: # vgdispaly; # vgdisplay/dev/vgo2
Lvdisplay [-v] lv_path displays the activated logical volume information
Example: # lvdisplay/dev/vg02/rootdbs
Vgchange-a y vg_name
Example: # vgchange-a y/dev/vg02
Vgchange-a e vg_name
Example: # vgchange-a e/dev/vg02