Oninit cdi / Archive
Talk to an expert →

sysadmin:mon_users table too large

Posted in 2015

Topics: Storage & Space Management

SCOTT GALLUP — — source: IIUG Forums & Mailing Lists

I have an IDS 12.10.FC4W1WE server. I noticed that the sysadmin:mon_users table has been allocated 5.0GB of space which seems excessive given there are only 32445 rows in the table. How can I safely decrease the size of this table? The sysadmin database is in the rootdbs to add to the fun.

↪ replying to SCOTT GALLUP
Art Kagel — — source: IIUG Forums & Mailing Lists

Use the REPACK SHRINK functionality in the admin API. Art On Dec 7, 2015 4:26 PM, "SCOTT GALLUP" <scott.gallup@gmail.com> wrote: > I have an IDS 12.10.FC4W1WE server. I noticed that the sysadmin:mon_users > table has been allocated 5.0GB of space which seems excessive given there > are > only 32445 rows in the table. > How can I safely decrease the size of this table? > The sysadmin database is in the rootdbs to add to the fun. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b10cd45ab82940526558a81

↪ replying to Art Kagel
Paul Watson — — source: IIUG Forums & Mailing Lists

And move it out of ROOTDBS Cheers Paul > Use the REPACK SHRINK functionality in the admin API. > > Art > On Dec 7, 2015 4:26 PM, "SCOTT GALLUP" <scott.gallup@gmail.com> wrote: > >> I have an IDS 12.10.FC4W1WE server. I noticed that the >> sysadmin:mon_users >> table has been allocated 5.0GB of space which seems excessive given >> there >> are >> only 32445 rows in the table. >> How can I safely decrease the size of this table? >> The sysadmin database is in the rootdbs to add to the fun. >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --047d7b10cd45ab82940526558a81 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians

Glossary