bash-2.05$ id
uid=102(informix) gid=0(root)
bash-2.05$ oncheck -cc
    Validating syssyntable for database sysmaster
WARNING:No syssyntable records found.
    Validating syssyntable for database sysutils
WARNING:No syssyntable records found.
    Validating syssyntable for database sysuser
WARNING:No syssyntable records found.
    Validating database krer_real
ISAM error:  illegal argument to ISAM function.

bash-2.05$ date
Wed Mar 18 15:56:36 MSK 2009
bash-2.05$ oncheck -cI sysmaster

Validating indexes for sysmaster:informix.syssequences...
                Index ssq_seqid
                Index ssq_tabid

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.flags_text...
                Index flags_text_ix1
                  Index  fragment in DBspace rootdbs

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.smi_build_status...

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.sysaudit...
                Index sysaudit_ix1

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.sysextspaces...
                Index sysextspace_ix1

Index sysextspace_ix1 is bad.  OK to repair it? y

bash-2.05$ date
Wed Mar 18 15:56:50 MSK 2009
bash-2.05$ oncheck -cI sysmaster
Validating indexes for sysmaster:informix.syssequences...
                Index ssq_seqid
                Index ssq_tabid

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.flags_text...
                Index flags_text_ix1
                  Index  fragment in DBspace rootdbs

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.smi_build_status...

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.sysaudit...
                Index sysaudit_ix1

WARNING: index check requires a s-lock on tables whose lock level is page.

Validating indexes for sysmaster:informix.sysextspaces...
                Index sysextspace_ix1

Index sysextspace_ix1 is bad.  OK to repair it? y

bash-2.05$ 



select * from sysdatabases:

name		partnum	owner		created	is_logging	is_buff_log	is_ansi	is_nls	flags
krerdbl2	11534944	kreradm	20.11.2008	1		0		0		1		4113

drop database krerdbl2:

---------------------------
Server Studio for Informix
---------------------------
Error (-311): Cannot open system catalog (systables).
ISAM error: TBLspace does not exist