Hello,

i need table name of sysmaster database for getting values of following items

--Sheared memory
--Check points and its duration
--Logical log
--Database status
--HDR and RSS Status

if there is any documentation of sysmaster database then also provide link of that document.

Thanks

You can use the native IDS onstat utility to get the information you need, here's a very good online resource:

Oninit:

the onstat guide can be found under "Utilities" (on the left margin) and then "Onstat Reference" (on the left margin). Wander around ... there's a lot of good info here.

i need to run some queries on that tables for getting required output

example is
get checkpoint duration time.

and query is,

select cp_time from SYSCHECKPOINT

same as above, i want to know current shared memory value etc

look the sysmaster.sql in $INFORMIXDIR/etc and the SQL reference manual...