标签：Moving (Resetting) the sysadmin database to a new dbspace
Moving (Resetting) the sysadmin database to a new dbspace in IBM Informix Dynamic Server (IDS)

Question
How do you move the sysadmin database to a new dbspace?  
 
Answer

The sysadmin database is created in the root dbspace during database server initialization. This database is required for the Scheduler API and Remote Administration feature.

Use the SQL Administration API command RESET SYSADMIN to move the sysadmin database to a different dbspace. This command drops the sysadmin database from the root dbspace and recreates it in the specified dbspace.

本日志由 flyinweb 于 2011-02-26 10:47:37 发表到 数据库技术 中，目前已经被浏览 2609 次，评论 0 次；

作者添加了以下标签： Moving (Resetting) the sysadmin database to a new dbspace；

首页只显示了部分日志内容，要查看日志的全部内容请阅读全文；