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

flat screen monitor turned-on
flat screen monitor turned-on