Re: Temporary dbspace

Do you mean that if I create a dbspace and do not denote it as a temp dbspace, yet include it in my DBSPACETEMP in my profile and configuration the engine does not realize this as a TEMP DB space? There are 3 places to identify temp db space: On UNIX w/ AIX in the user's .profile variable DBTEMP In the Informix Configuration file variable DBSPACETEMP On the Informix Onmonitor Menu when you create the db space TEMP [ ] Well I set it on the first 2 and not the third, but by your statement Informix will not reconize this as a TEMP DBSPACE since I did not say Yes (Y) to the third option. Is this true? ------------------------------------------------------------------------- Cheryl Kendricks Internet: cherylk@spamis.jcdc.doleta.gov OR cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 27 Mar 1996, tolly brumbelow wrote: } pfinkel@cbnews.cb.att.com (paul.d.finkel) wrote: } } >I have created a temporary dbspace. It is referenced by the onconfig file } >parameter DBSPACETEMP. It was made larger recently because our reports } >explicitly create temp table using the "WITH NO LOG" option and the temp } >tables created by 2 specific reports can get pretty big. } } >It is being appropriately employed as I see temp tables being created and } >eventually destroyed. Its size: 67500 2K pages. } } >At this time it is down to "0" available pages free. How do I determine } >what process is using that space? Where is the overflow(if any) going? } >How do I free that space up for re-use? (Short of bringing down instance?) } >What temporary tables (names) are being created in that dbspace? This would } >lead me to understand which reports are using that space. } } >Please e-mail and post reply. } } >Thank you. } >-- } >Do unto others ... then split! } > MaryAnne Stasium } If the temp flag was not set on the creation of the dbspace sometimes } they will not free properly. If the users do not exit their programs } correctly informix could think the session that created the temp table } is still running therefore it will not free the space. } } -- } Tolly Brumbelow, Informix DBA } email:tolly.brumbelow@bridge.bellsouth.com } }