Dropping Temporary Dbspaces
Hi! Can I drop a temporary dbspace without re-initializing the instance?
In reviewing the manual for IDS 7.3, on page 14-19 it states that one should
run oncheck -pe to examine if any logs or tables reside in the dbspace
before removing. When I run it, I get the following for the tempdbs I wish
to remove (it has only one chunk):
DBspace Usage Report: tempdbs2 Owner: informix Created: 12/10/1998
Chunk: 4 /usr/informix/chunks/tchk2a Size Used Free
1000000 1201 998799
Disk usage for Chunk 4 Start Length
------------------------------------------- --------- ---------
OTHER RESERVED Pages 0 2
CHUNK FREE LIST PAGE 2 1
TBLSPACE TBLSPACE 3 50
FREE 901 1176
TBLSPACE TBLSPACE 2077 50
FREE 2127 2400
TBLSPACE TBLSPACE 4527 50
FREE 4577 3920
TBLSPACE TBLSPACE 8497 50
FREE 8547 1600
TBLSPACE TBLSPACE 10147 50
FREE 10197 1600
TBLSPACE TBLSPACE 11797 50
FREE 11847 1600
TBLSPACE TBLSPACE 13447 50
FREE 13497 98650
This indicates to me that there are some temporary tables in the tempdbs.
On page 13-20 of the same manual it says that the tempdbs is re-initialized
everytime the server is initialized (I'm reading this to mean first-time
disk initialization as well as normal, non-destructive startup). So
presumably, if the instance is re-initialized, I could drop the dbspace
without problems in quiescent mode.
I'd like to setup a second instance on my production server that mirrors the
existing instance in terms of disk layout, but I used all the tempdbs chunks
for the first instance. So I'd like to drop one of the tempdbs's and
reassign the freed chunk to the second instance's tempdbs. However, if
possible, I'd like to do this without bringing down my first instance.
Thanks for your help.
Best regards,
<-- Making IT happen! -->
Edmund Nigel Gall
Senior Information Systems Specialist
Process Plant Services Limited
Atlantic Avenue, Point Lisas Industrial Estate
Point Lisas, Couva, Trinidad & Tobago, W.I.
Tel: (868) 636 2906 x 274 Fax: (868) 679 3770