Steps to drop the sysmaster database

Technote (FAQ)

Question

Can the sysmaster database be dropped manually?

Cause

Although it is not recommended to drop the System Monitoring Interface for Informix, yet under some circumstances a need might exist to drop the sysmaster database.

Answer

Steps:

1. dbaccess sysmaster -
2. delete from systables where tabid > 99 and partnum < '0x100000';
3. delete from systables where tabname = 'sysdbspartn';
4. close database;
5. drop database sysmaster;

http://www-01.ibm.com/support/docview.wss?uid=swg21444237