Exploring IBM Informix
An introduction to informix commands, attached is a PDF copy with more commands at the end of page.
11/24/20231 min read
Useful IDS Commands
Stop IDS
onmode -yuk
Start IDS
oninit -v
Check status of IDS:
onstat -
Display last 20 lines of the console.log
onstat -m
Perform a Level 0 backup (this is a complete backup)
ontape -s -L 0 -d
Restore a Level 0 backup (Cold Restore - All dataspaces)
ontape -r
Restore a Level 0 backup (Warm Restore - Single dataspace)
ontape -r -D <dataspace>
Restore a Level 0 backup - known as a physical restore in HDR enviroments
ontape -p
On demand backup of logical logs
ontape -a
RSS Configuration
Primary Server
Add a RSS node to a primary server - adds it to the sysha database.
onmode -d add RSS [dbservername] [password]
Check status of RSS nodes on primary server:
onstat -g rss verbose
Remove a configured RSS node from sysha database on the primary server:
onmode -d delete RSS [dbservername]
Secondary Server
Connect the RSS node to the primary server
onmode -d RSS [dbservername] [password]
Convert the RSS node from Secondary to Standard (if the Primary has failed)
onmode -d standard