Thanks a lot guys.I am new to informix and have no idea about the system tables.
But I want to use sql query like "select * from sysmaster" which should return the database status.
I want to query informix database from SSIS (SQl server integration serives) tool or you can say from windows env.I am not using any tool to connect to informix rather its a third party informix database. I need to use some queries or may be some scripts. I am not sure of.
Thanks for the quick response. But i am still not sure if that is what i want.
I don't have to use "Informix ODBC" or any client. The requiement is to use the SQL queries.
I have some queries :-
1) Can you please provide me SQL queries like 'Select something from database' which returns the database status (if it is available, if it is undergoing backup etc)
2) What will happen if a database is undergoing backup and we try to connect to the database? Will the connection be available?
3) How can we check from SQL query "select ...." if database is undergoing backup?
In informix you have the "sysmaster" database and tables called "sys*" on your own database.
In the sysmaster , regular users have some limitations. If you don't have access for some table, use the "informix" user.
For information about status look the tables sysshmvals and sysshmhdr ,
to identify theirs structures read the file $INFORMIXDIR/etc/sysmaster.sql