Oninit cdi / Archive
Talk to an expert →

Which dbspace does a database occupy

Posted in 2017

Topics: Storage & Space Management

LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen

↪ replying to LARRY SORENSEN
Mike Walker — — source: IIUG Forums & Mailing Lists

To find out which dbspace a database was created in... If you have onmonitor (available on 11.50), then the easiest way is to use that and go to Status -> Databases. Otherwise, run the following SQL against the sysmaster database: select name[1,25], dbinfo("DBSPACE", partnum)::char(25) dbspace from sysdatabases order by 1; Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Monday, September 25, 2017 11:32 AM To: ids@iiug.org Subject: Which dbspace does a database occupy [39986] IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Mike Walker
Kern Doe — — 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. From: Mike Walker <mike@advancedatatools.com> To: ids@iiug.org Sent: Monday, September 25, 2017 1:40 PM Subject: RE: Which dbspace does a database occupy [39987] To find out which dbspace a database was created in... If you have onmonitor (available on 11.50), then the easiest way is to use that and go to Status -> Databases. Otherwise, run the following SQL against the sysmaster database: select name[1,25], dbinfo("DBSPACE", partnum)::char(25) dbspace from sysdatabases order by 1; Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Monday, September 25, 2017 11:32 AM To: ids@iiug.org Subject: Which dbspace does a database occupy [39986] IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Mike Walker
LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

Thank you. Larry Sorensen ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Mike Walker <mike@advancedatatools.com> Sent: Monday, September 25, 2017 11:39 AM To: ids@iiug.org Subject: RE: Which dbspace does a database occupy [39987] To find out which dbspace a database was created in... If you have onmonitor (available on 11.50), then the easiest way is to use that and go to Status -> Databases. Otherwise, run the following SQL against the sysmaster database: select name[1,25], dbinfo("DBSPACE", partnum)::char(25) dbspace from sysdatabases order by 1; Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Monday, September 25, 2017 11:32 AM To: ids@iiug.org Subject: Which dbspace does a database occupy [39986] IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Kern Doe
LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

Thank you all. Larry ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Kern Doe <kern_doe@yahoo.com> Sent: Monday, September 25, 2017 12:41 PM To: ids@iiug.org Subject: Re: Which dbspace does a database occupy [39988] 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. From: Mike Walker <mike@advancedatatools.com> To: ids@iiug.org Sent: Monday, September 25, 2017 1:40 PM Subject: RE: Which dbspace does a database occupy [39987] To find out which dbspace a database was created in... If you have onmonitor (available on 11.50), then the easiest way is to use that and go to Status -> Databases. Otherwise, run the following SQL against the sysmaster database: select name[1,25], dbinfo("DBSPACE", partnum)::char(25) dbspace from sysdatabases order by 1; Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Monday, September 25, 2017 11:32 AM To: ids@iiug.org Subject: Which dbspace does a database occupy [39986] IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary