Rebuilding sysadmin database manually

Question

How do you rebuild sysadmin database manually without having to restart IDS?

Answer

Run these steps to rebuild sysadmin database manually:

cd $INFORMIXDIR/etc/sysadmin;
dbaccess - db_uninstall.sql;
dbaccess - db_create.sql;
dbaccess sysadmin db_install.sql;
dbaccess sysadmin sch_tasks.sql;
dbaccess sysadmin sch_aus.sql;
dbaccess sysadmin sch_sqlcap.sql;
dbaccess sysadmin start.sql;


Note: db_uninstall.sql will correctly return errors 329/111 and 349 if the sysadmin database does not exist. Ignore these errors and continue.

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