Recommended Resources
Abstract
How to rebuild sysmaster database?
Content
Steps to rebuild sysmaster database:
- 1. Make sure no one is connected to the database.
2. Bring the instance in single user mode.
- oninit -j
- For this:
- start dbaccess
connect to sysadmin database and run:
EXECUTE FUNCTION task("scheduler shutdown");
4. Run the script, buildsmi to rebuild the sysmaster
database.
- $INFORMIXDIR/etc/buildsmi
5. Once sysmaster database is built, you can restart the
scheduler. To do this, connect to sysadmin database and
- run the following SQL:
EXECUTE FUNCTION task("scheduler start");
If the sysmaster rebuild fails, you will see a file created in directory /tmp called, buildsmi.out
This file will not exist if the sysmaster database creation is successful.
To ensure further, check the sysmaster build date by running following SQL:
database sysmaster;
select * from sysdatabases where name = "sysmaster"
Related Information
[{"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":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21625996