rootdbs full

Posted in 2018

Summary

Sergio Peres (Informix 12.10.FC10, CentOS 7) had rootdbs 96% full, caused by a large sysadmin database. Erik Stahlhut advised moving sysadmin to a separate dbspace. Doug Lawry pointed to a sysadmin alert cleanup bug fix and execute function task('table repack shrink', 'ph_run') in sysadmin. Mark Scranton agreed on shrinking the tables.

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

Topics: Storage & Space Management, Versions, Editions & End-of-Life

SERGIO PERES — Tue, 11 Sep 2018 14:19:33 — source: IIUG Forums & Mailing Lists

Hi, I have rootdbs full with sysmaster, only 4% free. There is anything I can clean? Or I have to increase rootdbs size? Informix version 12.10.FC10, OS CentOS 7 Thanks for any help, SP

↪ replying to SERGIO PERES

SERGIO PERES — Tue, 11 Sep 2018 14:31:35 — source: IIUG Forums & Mailing Lists

It is sysadmin that is big, sorry for the mistake, but the question is how can I clean it? Thanks, SP

↪ replying to SERGIO PERES

ERIK STAHLHUT — Wed, 12 Sep 2018 11:51:59 — source: IIUG Forums & Mailing Lists

Hi Sergio, I would recommend to move sysadmin to a separate DBSpace. Cheers Erik

↪ replying to SERGIO PERES

DOUG LAWRY — Mon, 17 Sep 2018 11:50:20 — source: IIUG Forums & Mailing Lists

See also: https://www.oninitgroup.com/ids-11-sysadminalertcleanup-function-bug-fix You might then reclaim space with this SQL in the "sysadmin" database: execute function task("table repack shrink", "ph_run") Regards, Doug Lawry

↪ replying to DOUG LAWRY

MARK SCRANTON — Tue, 12 Mar 2019 22:19:20 — source: IIUG Forums & Mailing Lists

I agree with Mr. Lawry ... use shrink on the dbspace or better yet, since it's the rootdbs, shrink the tables in sysmaster. Thanks - Mark Scranton The Mark Scranton Group