Could I force drop the database?
SangGyu Jeong could not access or drop a database on 11.70 (oncheck ISAM error, dbaccess errors 211 and 103), and FORCE_DB_DROP did not seem to apply. Art Kagel advised an IBM support case or unloading, reinitialising and reloading the other databases; Andreas Legner asked about GL_USEGLU, but the locale was ko_kr.ksc. SangGyu planned a later migration. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 tsdbValidating 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
------------------------------
#Informix
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 ------------------------------
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 ------------------------------ #Informix
@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 ------------------------------
@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 ------------------------------