Hello everybody!!!
I am new to this Informix Database. Wanted some help from you all.

Here I am posting some of the queries.
(i) Command to check the Informix Database if it is Alive.
(ii) Command to check how many tables are there in the database.
(iii) Command to check the status of the databases.

Please help me out, if anybody has the answers and also if somebody knows any URL where I can able to find these answers, please do let me know.


Thanks In Advance,
N

i suppose you want to check the status of informix instance (not informix database)
(i),(iii) (ii) List all tables

Thanks for your reply!!!!!!

Yes, I want to check the status of informix instances.

But I am not able see the first answer.


Thanks,
Nabanita

To check the status of informix instance, run the below

onstat -

Nitin

Hey Thanks Nitin!!!!!!

If you have muliple instances,You can use
onstat -g dis to see the status of each instance

Regards
Mallik

Thanks A Lot Mallik!!!!!!!!!

)Hi guys

I need to do a dbexport and then a dbimport of the database I want to know the command for dbexport and dbimport , also what to know that does buffered and unbufferd means.

thanks

Guys I need the exact syntax for doing the following

i) dbexport

ii) dbimport

iii) what does buffered and unbuffered logging means

I don't wanna be arrogant, but I think that some people
don't se the purpose of this forum.
So please, don't ask questions that can be very easily answered by reading the relevant manual.

peace

Hi,

Lets use this forum in better way.Those questionns are really silly.U can get those in google and got many pdf's for that.

Mallik