Oninit cdi / Archive
Talk to an expert →

How to move/create sysadmin db out of rootdbs

Posted in 2013

Summary

O Khan asked how to move the sysadmin database out of rootdbs. Jacques Renaut pointed to an SQL admin API function for 11.70, noting it resets the database and loses task or sensor customisations. Khan asked about dbexport/dbimport instead, which was not answered. Art Kagel also pointed to the SQL API function for moving sysadmin.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion, Third-Party Tools & Monitoring

O KHAN — — source: IIUG Forums & Mailing Lists

Hi, I am using OAT (IBM Open Admin Tool for Informix), and i have seen that sysadmin database is created in the rootdbs which is consuming lots of space. So is there any possible way through which I can move the sysadmin database out of the rootdbs? Or i have to do the dbexport/dbimport? Thanks in advance. Regards, Khan

↪ replying to O KHAN
JACQUES — — source: IIUG Forums & Mailing Lists

Original post: Hi, I am using OAT (IBM Open Admin Tool for Informix), and i have seen that sysadmin database is created in the rootdbs which is consuming lots of space. So is there any possible way through which I can move the sysadmin database out of the rootdbs? Or i have to do the dbexport/dbimport? Thanks in advance. Regards, Khan Response: Well, assuming you have 11.70 you could do the following: http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.adref. doc%2Fids_sapi_070.htm Only thing is it "resets" the database and apparently you'd lose any task/sensor customization you may have done. Jacques Renaut IBM Informix Advanced Support APD Team

↪ replying to JACQUES
O KHAN — — source: IIUG Forums & Mailing Lists

Hi, If i wanted to avoid the resetting of database, then can i do it using the dbexport/dbimport as well or it will work or recommended? Thanks. Regards, Khan

↪ replying to O KHAN
Art Kagel — — source: IIUG Forums & Mailing Lists

There is an SQL API function to move the sysadmin database. See this link: http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.a dmin.doc/admin742.htm Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Aug 12, 2013 at 3:21 PM, O KHAN <theultimateboy@hotmail.com> wrote: > Hi, > > I am using OAT (IBM Open Admin Tool for Informix), and i have seen that > sysadmin database is created in the rootdbs which is consuming lots of > space. > > So is there any possible way through which I can move the sysadmin database > out of the rootdbs? > > Or i have to do the dbexport/dbimport? > > Thanks in advance. > > Regards, > Khan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3443860e69b04e3c58681

Glossary