Re: Which dbspace does a database occupy

Posted in 2017

Topics: Installation, Setup & Upgrades, Storage & Space Management

MICHAEL HOFFMAN — Mon, 02 Oct 2017 17:21:04 — source: IIUG Forums & Mailing Lists

> This good tool "onmonitor" seems to go away in 12.10 (in basic > installation?).Simple script is the best way but the problem is we don't > usually walk around remembering the syntax.How about oncheck -pe? > Let's go GreenThis email contains 100% recycled electrons. oncheck -pe will show which dbspaces each table in a database occupies, but ittakes a bit to figure out which dbspace the database was actually created in.

↪ replying to MICHAEL HOFFMAN

Kern Doe — Mon, 02 Oct 2017 19:17:44 — source: IIUG Forums & Mailing Lists

That is true! Sorry besides 1) onmonitor 2) the script 3) memorize the sql syntax 4) lastly, oncheck -peI do not know any other ways. Let's go GreenThis email contains 100% recycled electrons. From: MICHAEL HOFFMAN <offdisc@gmail.com> To: ids@iiug.org Sent: Monday, October 2, 2017 1:21 PM Subject: Re: Which dbspace does a database occupy [40008] > This good tool "onmonitor" seems to go away in 12.10 (in basic > installation?).Simple script is the best way but the problem is we don't > usually walk around remembering the syntax.How about oncheck -pe? > Let's go GreenThis email contains 100% recycled electrons. oncheck -pe will show which dbspaces each table in a database occupies, but ittakes a bit to figure out which dbspace the database was actually created in. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

dbspace