drop a dbspace problem

Posted in 2008

Topics: Storage & Space Management, Server Administration

SHAN SEAN — Sun, 13 Apr 2008 09:07:01 — source: IIUG Forums & Mailing Lists

↪ replying to SHAN SEAN

Art S. Kagel (Oninit) — Sun, 13 Apr 2008 14:46:12 — source: IIUG Forums & Mailing Lists

SHAN SEAN wrote: > hi, everyone, I want drop a dbspace(it have 4 chunks) use onspaces, I create > some fragment index on it before, but I drop those index later, so I confirm > there is nothing on it, but when I user SMI query : > No problem. Every dbspace is created with a TABLESPACE TABLESPACE a pseudo table, really just a set of extents, to hold the partition header pages for table and index partitions living in that dbspace. These page addresses become the 'partnum's of these objects. Just use onspaces to drop the 3 extra chunks then the dbspace with it's primary chunk. Art S. Kagel Oninit > database sysmaster;> select dbinfo("DBSPACE", pe_partnum) dbspace, > dbsname[1,10], > tabname, > pe_offset start, > pe_size size > from sysptnext, outer systabnames > where pe_partnum = partnum > order by dbspace, start; > > I found that : > datadbs|datadbs|TBLSpace|4826310|50| > datadbs|datadbs|TBLSpace|4826480|50| > datadbs|datadbs|TBLSpace|4864360|100| > datadbs|datadbs|TBLSpace|4865086|50| > .... > what 're the TBLSpace, Can I drop the dbspaces yet? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > > >

↪ replying to Art S. Kagel (Oninit)

SHAN SEAN — Mon, 14 Apr 2008 02:07:06 — source: IIUG Forums & Mailing Lists

thanks Kagel， I 'll try that later. :-)

Glossary

dbspace