IBM Support

Steps to drop the sysmaster database

Question & Answer


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;

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.1;11.5;11.7;12.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21444237

Page Feedback