aus_* tables in sysadmin

Posted in 2015

FRANK — Wed, 08 Jul 2015 23:34:08 — source: IIUG Forums & Mailing Lists

Folks, IDS12.10 FC4, Linux 6 I am testing a sound approach to reset sysadmin database. I found, initially, the following tables were in sysadmin database, aus_command aus_cmd_list aus_cmd_comp But, after I run the following to move the sysadmin, EXECUTE FUNCTION task("reset sysadmin","dbdw00"); The above three tables aus_* are NOT in sysadmin database anymore, they disappeared ! Any comments ? Thanks Frank --001a11474bac4bf5ce051a6593c8

↪ replying to FRANK

John Miller iii — Thu, 09 Jul 2015 05:06:44 — source: IIUG Forums & Mailing Lists

The tables starting with aus=5F* are created when automatic update statisti= cs runs. The next time the aus evaluator run they will be created. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 07/08/2015 04:34:09 PM: > From: "FRANK" <yunyaoqu@gmail.com> > To: ids@iiug.org > Date: 07/08/2015 07:36 PM > Subject: aus=5F* tables in sysadmin [35411] > Sent by: ids-bounces@iiug.org > > Folks, > > IDS12.10 FC4, Linux 6 > > I am testing a sound approach to reset sysadmin database. > > I found, initially, the following tables were in sysadmin database, > > aus=5Fcommand > aus=5Fcmd=5Flist > aus=5Fcmd=5Fcomp > > But, after I run the following to move the sysadmin, > > EXECUTE FUNCTION task("reset sysadmin","dbdw00");> > The above three tables aus=5F* are NOT in sysadmin database anymore, they > disappeared ! > > Any comments ? > > Thanks > Frank > > --001a11474bac4bf5ce051a6593c8 > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. >