Can I Transfer the sysutils database to nonrootdbs

Hello everyone! My database env: OS: HP-UX 11.11 IDS: 10.0 FC8 BACKUP soft: EMC networker This instance run many years, use onbar 0 level backup every day, So the sysutils database space used % increase every day, and it use rootdbs, can I transfer it to another dbspaces? not: I use IDS onsmsync tool to clear the old data, but greater than 3 hours , it cannot respons.

Yes ... Modify the $INFORMIXDIR/etc/sysutils.sql ... in the create database sysutils ... add the location where you want the database ... then you can run the script through dbaccess ... This will drop the current sysutils database, and then create it... Caution, this script will drop the current sysutils database, so the data will be lost .. if you want the data you could export the database .. and then import it ... changing the location on the import ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "SHAN SEAN" <shanshl@qq.com> To: ids@iiug.org Date: 11/14/2010 10:08 PM Subject: Can I Transfer the sysutils database to nonrootdbs [21948] Sent by: ids-bounces@iiug.org Hello everyone! My database env: OS: HP-UX 11.11 IDS: 10.0 FC8 BACKUP soft: EMC networker This instance run many years, use onbar 0 level backup every day, So the sysutils database space used % increase every day, and it use rootdbs, can I transfer it to another dbspaces? not: I use IDS onsmsync tool to clear the old data, but greater than 3 hours , it cannot respons. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Oh, I see. Thanks Peter Logan very much! I'll try it later.^_^