Informix

Expand all | Collapse all

Could I force drop the database?

  • 1.  Could I force drop the database?

    Posted 13 days ago
    Hello All,
    I would like to ask for advice on Informix error message.
    A specific database of the instance has fallen into an inaccessible state.

    Below is the result of running the oncheck -cc command and dbaccess.
    Fortunately, it is an unused DB, so I want to know if it is possible to force drop.

    I googled the article about the FORCE_DB_DROP environment variable, but it does not seem to apply to the 11.70 version currently in use.
    How do I delete that database?

    Thanks,


    $ oncheck -cc tsdb

    Validating database tsdb
    ISAM error: illegal argument to ISAM function.

    $ dbaccess tsdb -

    211: Cannot read system catalog (systables).

    103: ISAM error: illegal key descriptor (too many parts or too long).

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Korea, Republic of
    ------------------------------


  • 2.  RE: Could I force drop the database?

    Posted 13 days ago
    SangGyu:

    Open an IBM support case and give the support engineer access to the system one way or another and they can patch the storage to make it go away. 

    Alternative:
    Unload all of the other databases, reinitialize the instance, rebuild it, reload the databases that you can salvage.

    If it were my system, I would do the latter whether support was able to make the offending database "go away" or not as the instance seems to be unstable.

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Could I force drop the database?

    Posted 13 days ago
    @Art Kagel
    Thanks for your reply.
    Since the system uses a closed network, it will be difficult to obtain remote support from IBM.
    This is an obsolete database and not an urgent issue, so I think it will need to be migrated to a new instance later.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Korea, Republic of
    ------------------------------



  • 4.  RE: Could I force drop the database?

    Posted 13 days ago
    Edited by Andreas Legner 13 days ago
    Hi SangGyu,

    any chance this is a UTF8 database and it either has been created with GL_USEGLU set and server now is running without or the other way round?


    Andreas

    ------------------------------
    Andreas Legner
    ------------------------------


  • 5.  RE: Could I force drop the database?

    Posted 13 days ago
    @Andreas
    Thank you for your interest.
    The database is created in the ko_kr.ksc locale.
    Therefore, it does not seem to be related to whether or not the GL_USEGLU environment variable is set.​​​

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Korea, Republic of
    ------------------------------