You can use dbschema utility to get the schema of a database and redirect the dbschema output to a file.
To get the complete syntax of dbschema just type “dbschema” from command prompt and press enter. 71 more words
1 month, 3 weeks ago
A checkpoint is a point in time in the log when a known and consistent state for the database system is established.
A checkpoint can occur in one of these situations: 41 more words
The below chart will be very handy :
The message file records the activities performed on Informix server instance such as starting, stoping etc.
There are 2 ways you can monitor the message file: 214 more words
The Informix database server has three principal modes of operation: Online, Quiescent and offline.
onmode –ky (or) onmode -k
Gracefully: 28 more words
The Informix database server has three principal modes of operation
ONLINE: Users can connect with the database server and perform all database activities. This is normal operating mode of the database server. 107 more words
Since, a single UNIX server can have multiple Informix instances running, follow the below steps to find out a particular instance status:
1.Login to UNIX (or windows) box using informix userid/password… 228 more words