Oninit cdi / Archive
Talk to an expert →

sysadmin database v11.50

Posted in 2008

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