DBSPACETEMP fills up..what's used next?
Question: on IDS 11, when the dbspace listed in DBSPACETEMP runs out of space, what does the engine fall back on — rootdbs or the /tmp filesystem? The docs seemed contradictory. Replies: one poster said rootdbs in his experience; Art Kagel said rootdbs may be used but more likely you'll simply get "no more space" errors. A follow-up asked about requesting an enhancement to spill to /tmp; responses suggested instead enlarging temp space or fixing the queries consuming it, and hinted a better solution might come sooner. No definitive documented answer was given.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi everyone. Simple question here. For IDS 11 FC7 (I don't think the version matters much here but anyway).....if the dbspace which is specified as the temporary dbspace via the DBSPACETEMP parm runs out of space....what's used next? The manual seems to imply that the rootdbs is used by at other points it seems to imply the /tmp directory...could someone clear that up please? Thank you, Will
WILL LANDSTROM wrote: > Hi everyone. Simple question here. For IDS 11 FC7 (I don't think the version > matters much here but anyway).....if the dbspace which is specified as the > temporary dbspace via the DBSPACETEMP parm runs out of space....what's used > next? The manual seems to imply that the rootdbs is used by at other points it > seems to imply the /tmp directory...could someone clear that up please? Thank rootdbs, in my experience. -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Rootdb may be used, but more likely you will just get "No more space" errors. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Sep 5, 2010 at 10:20 AM, WILL LANDSTROM <willlandstrom@yahoo.com>wrote: > Hi everyone. Simple question here. For IDS 11 FC7 (I don't think the > version > matters much here but anyway).....if the dbspace which is specified as the > temporary dbspace via the DBSPACETEMP parm runs out of space....what's used > next? The manual seems to imply that the rootdbs is used by at other points > it > seems to imply the /tmp directory...could someone clear that up please? > Thank > you, Will > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e68ea0fad39a66048f86fb4c
This is a problem we probably all experience at some time. How does one go about getting an enhancement to the coe made for example if tempdb full up then use file system /tmp
Why not increase your temp space and/or fix the queries that are eating it all up? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x64 & IDS 11.50.FC6 Dont document the problem, fix it. Atli Björgvin Oddsson ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of KARL OLIVER [karl.oliver@maf.govt.nz] Sent: Monday, September 06, 2010 5:48 PM To: ids@iiug.org Subject: Re: DBSPACETEMP fills up..what's used next? [21182] This is a problem we probably all experience at some time. How does one go about getting an enhancement to the coe made for example if tempdb full up then use file system /tmp ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
A better enhancement to handle the situation than writing to /tmp may be closer at hand than waiting for a new feature to be approved. <wink> Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Sep 6, 2010 at 5:48 PM, KARL OLIVER <karl.oliver@maf.govt.nz> wrote: > This is a problem we probably all experience at some time. > How does one go about getting an enhancement to the coe made for example if > tempdb full up then use file system /tmp > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e644b84a70b373048fac2c7c