Oninit cdi / Archive
Talk to an expert →

sysadmin database v11.50

Posted in 2008

Summary

Peter Logan asked whether the sysadmin database in IDS 11.50 can be moved out of the root dbspace, perhaps by dbexport and dbimport. Jean Sagi said an automated SQL admin API procedure exists. Peter later found the solution: run in sysadmin execute function task('reset sysadmin', 'new_dbspace'), where new_dbspace is the target dbspace name. Solved.

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

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion

Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

Just wondering if anyone has moved the sysadmin database out of the root dbspace ... If so, is it basically just and dbexport and dbimport? Thanks ..... Peter Logan Senior Database Administrator Phone: 616/878-8309

↪ replying to Peter_Logan@spartanstores.com
Jean Sagi — — source: IIUG Forums & Mailing Lists

There is an automated procedure using the sql api to do that... it's explained on developer works... (just don't remember the url :( ) J. 2008/12/3 Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> > Just wondering if anyone has moved the sysadmin database out of the root > dbspace ... If so, is it basically just and dbexport and dbimport? > > Thanks ..... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Jean Sagi
Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

Thanks ... I'll go find it .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Jean Sagi" <jeansagi.ifx@gmail.com> To: ids@iiug.org Date: 12/03/2008 08:29 AM Subject: Re: sysadmin database v11.50 [14202] There is an automated procedure using the sql api to do that... it's explained on developer works... (just don't remember the url :( ) J. 2008/12/3 Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> > Just wondering if anyone has moved the sysadmin database out of the root > dbspace ... If so, is it basically just and dbexport and dbimport? > > Thanks ..... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jean Sagi
Peter_Logan@spartanstores.com — — source: IIUG Forums & Mailing Lists

The following will do the trick ... dbaccess sysadmin execute function task("reset sysadmin", "new_dbspace"); new_dbspace = name of the new dbspace .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Jean Sagi" <jeansagi.ifx@gmail.com> To: ids@iiug.org Date: 12/03/2008 08:29 AM Subject: Re: sysadmin database v11.50 [14202] There is an automated procedure using the sql api to do that... it's explained on developer works... (just don't remember the url :( ) J. 2008/12/3 Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> > Just wondering if anyone has moved the sysadmin database out of the root > dbspace ... If so, is it basically just and dbexport and dbimport? > > Thanks ..... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary