IDS 9.4 DBSPACETEMP versus /tmp
Hi everyone. Kind of a sanity check question of you don't mind. I have a situation where I have an IDS 9.4 database that has a tempdbs dataspace that is not big enough to handle some sort intensive queries. According to what I am reading by simply changing the ONCONFIG parm DBSPACETEMP from pointing to the tempdbs to simply commenting out DBSPACETEMP that will result in the temp/sort data being written to the /tmp . Is that true? Is there any harm this change could cause aside from perhaps using up all of /tmp? Thanks unix is aix 5.2
Hi Will, try setting the variables DBTEMP and PSORT_DBTEMP pointing to a filesystem where you have a lot of free space Jacques Lapeire -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of WILL LANDSTROM Sent: woensdag 18 juni 2008 15:15 To: ids@iiug.org Subject: IDS 9.4 DBSPACETEMP versus /tmp [12447] Hi everyone. Kind of a sanity check question of you don't mind. I have a situation where I have an IDS 9.4 database that has a tempdbs dataspace that is not big enough to handle some sort intensive queries. According to what I am reading by simply changing the ONCONFIG parm DBSPACETEMP from pointing to the tempdbs to simply commenting out DBSPACETEMP that will result in the temp/sort data being written to the /tmp . Is that true? Is there any harm this change could cause aside from perhaps using up all of /tmp? Thanks unix is aix 5.2 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
Better, set PDQPRIORITY to something other than zero, set PSORT_NPROCS > 1 and PSORT_DBTEMP to a list of filesystems to use for sort-work files. Art On Wed, Jun 18, 2008 at 9:14 AM, WILL LANDSTROM <willlandstrom@yahoo.com> wrote: > Hi everyone. Kind of a sanity check question of you don't mind. I have a > situation where I have an IDS 9.4 database that has a tempdbs dataspace > that > is not big enough to handle some sort intensive queries. According to what > I > am reading by simply changing the ONCONFIG parm DBSPACETEMP from pointing > to > the tempdbs to simply commenting out DBSPACETEMP that will result in the > temp/sort data being written to the /tmp . Is that true? Is there any harm > this change could cause aside from perhaps using up all of /tmp? > > Thanks > > unix is aix 5.2 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.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, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.