Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Unanswered: Can't drop database

    Hi,
    I'm new to Informix, so please don't critizise me much.

    We have some large systems where Informix Dynamic Server runs. Once RAID where were some dbspaces fail and now we can't drop database which was on these loosed dbspaces. Here is the output:

    Code:
    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

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    only guess, but it seems, that only restore from backup, or advanced technical support can help.

  3. #3
    Join Date
    Feb 2009
    Posts
    51
    IDS version?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •