DBSPACETEMP Parameter
Question: does the DBSPACETEMP onconfig parameter create temporary dbspaces automatically? Answer from several respondents: no — DBSPACETEMP is only a list of already-existing dbspaces; you must create them yourself with onspaces, using -t to flag them as temp spaces (otherwise unlogged temp tables land in rootdbs). Tips given: separate entries with colons (not spaces, since onconfig is space-delimited), consider including one regular dbspace for logged temp tables, and note the setting can also be overridden per session via SET ENVIRONMENT or a client variable; one poster said a restart is needed, another that onmode -wf/-wm works from 11.70. The original poster confirmed the answers helped.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
The DBSPACETEMP Parameter in onconfig file create automatically the temporally
dbspaces ? Or
They must be created with onspaces utility.
Thanks in advance.
The dbspaces must already exist, DBSPACETEMP is only the list of dbspaces
to be used.
On Fri, 22 Apr 2016 23:42 Jorge Valenzuela, <jorgervt@gmail.com> wrote:
> Hi,
> The DBSPACETEMP Parameter in onconfig file create automatically the
> temporally
> dbspaces ? Or
> They must be created with onspaces utility.
>
> Thanks in advance.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113f22c8c076f205311ad47f
Be sure to mark the new dbspaces you create for your DBSPACETEMP list as TEMP
space. Otherwise the engine will still create unlogged temp tables in your
rootdbs. I always have a regular dbspace in the list as well, just in case a
logged temp table is created inadvertently.
--EEM
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Ricardo Henriques
> Sent: Friday, April 22, 2016 18:03 PM
> To: ids@iiug.org
> Subject: Re: DBSPACETEMP Parameter [37022]
>
> The dbspaces must already exist, DBSPACETEMP is only the list of
> dbspaces to be used.
>
> On Fri, 22 Apr 2016 23:42 Jorge Valenzuela, <jorgervt@gmail.com> wrote:
>
> > Hi,
> > The DBSPACETEMP Parameter in onconfig file create automatically the
> > temporally dbspaces ? Or They must be created with onspaces utility.
> >
> > Thanks in advance.
> >
> >
> >
> >
> ***********************************************************************
> ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113f22c8c076f205311ad47f
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
Hi,
the Informix cannot create the TMPDBS from the list, because the location and
size are not declared here.
You have to create the dbspaces with onspaces and the -t flag to indicate a
temp usage.
After doing that, you have to list (colon separated) the dbspaces in the
onconfig.
Keep in mind, Informix only reads the parameters when starting, meaning you
have to bounce the engine
to make use of the temp spaces (same if you add one to an existing list, I
dont think it would
work with onmode -wf).
Our admins have been failing with a wrong entry in the past, the list was only
separated by spaces,
which did not work.
Marcus Haarmann
----- Ursprüngliche Mail -----
Von: "Everett Mills" <Everett.Mills@nationalbeef.com>
An: ids@iiug.org
Gesendet: Samstag, 23. April 2016 15:28:32
Betreff: RE: DBSPACETEMP Parameter [37024]
Be sure to mark the new dbspaces you create for your DBSPACETEMP list as TEMP
space. Otherwise the engine will still create unlogged temp tables in your
rootdbs. I always have a regular dbspace in the list as well, just in case a
logged temp table is created inadvertently.
--EEM
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Ricardo Henriques
> Sent: Friday, April 22, 2016 18:03 PM
> To: ids@iiug.org
> Subject: Re: DBSPACETEMP Parameter [37022]
>
> The dbspaces must already exist, DBSPACETEMP is only the list of
> dbspaces to be used.
>
> On Fri, 22 Apr 2016 23:42 Jorge Valenzuela, <jorgervt@gmail.com> wrote:
>
> > Hi,
> > The DBSPACETEMP Parameter in onconfig file create automatically the
> > temporally dbspaces ? Or They must be created with onspaces utility.
> >
> > Thanks in advance.
> >
> >
> >
> >
> ***********************************************************************
> ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113f22c8c076f205311ad47f
>
>
> ***********************************************************************
> ********
> Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I believe that since 11.70 it's possible to change it without bouncing the
engine using onmode - wf and even onmode - wm.
The onconfig is read in columns, the first one is the name and the second
the parameters of the configuration, being space used as the delimiter.
Hence, never use a space on parameters.
On Sat, 23 Apr 2016 16:19 Marcus Haarmann, <marcus.haarmann@midoco.de>
wrote:
> Hi,
>
> the Informix cannot create the TMPDBS from the list, because the location
> and
> size are not declared here.
>
> You have to create the dbspaces with onspaces and the -t flag to indicate a
> temp usage.
> After doing that, you have to list (colon separated) the dbspaces in the
> onconfig.
> Keep in mind, Informix only reads the parameters when starting, meaning you
> have to bounce the engine
> to make use of the temp spaces (same if you add one to an existing list, I
> dont think it would
> work with onmode -wf).
>
> Our admins have been failing with a wrong entry in the past, the list was
> only
> separated by spaces,
> which did not work.
>
> Marcus Haarmann
>
> ----- Ursprüngliche Mail -----
>
> Von: "Everett Mills" <Everett.Mills@nationalbeef.com>
> An: ids@iiug.org
> Gesendet: Samstag, 23. April 2016 15:28:32
> Betreff: RE: DBSPACETEMP Parameter [37024]
>
> Be sure to mark the new dbspaces you create for your DBSPACETEMP list as
> TEMP
> space. Otherwise the engine will still create unlogged temp tables in your
> rootdbs. I always have a regular dbspace in the list as well, just in case
> a
> logged temp table is created inadvertently.
>
> --EEM
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Ricardo Henriques
> > Sent: Friday, April 22, 2016 18:03 PM
> > To: ids@iiug.org
> > Subject: Re: DBSPACETEMP Parameter [37022]
> >
> > The dbspaces must already exist, DBSPACETEMP is only the list of
> > dbspaces to be used.
> >
> > On Fri, 22 Apr 2016 23:42 Jorge Valenzuela, <jorgervt@gmail.com> wrote:
> >
> > > Hi,
> > > The DBSPACETEMP Parameter in onconfig file create automatically the
> > > temporally dbspaces ? Or They must be created with onspaces utility.
> > >
> > > Thanks in advance.
> > >
> > >
> > >
> > >
> > ***********************************************************************
> > ********
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a113f22c8c076f205311ad47f
> >
> >
> > ***********************************************************************
> > ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113f1896b7a488053129dbcd
Thanks for all your answers,
Ithey wetr very useful to me.
Enviado desde mi iPhone
> El 23/04/2016, a las 9:59 a.m., Ricardo Henriques
<ricardoaireshenriques@gmail.com> escribió:
>
> I believe that since 11.70 it's possible to change it without bouncing the
> engine using onmode - wf and even onmode - wm.
>
> The onconfig is read in columns, the first one is the name and the second
> the parameters of the configuration, being space used as the delimiter.
> Hence, never use a space on parameters.
>
> On Sat, 23 Apr 2016 16:19 Marcus Haarmann, <marcus.haarmann@midoco.de>
> wrote:
>
>> Hi,
>>
>> the Informix cannot create the TMPDBS from the list, because the location
>> and
>> size are not declared here.
>>
>> You have to create the dbspaces with onspaces and the -t flag to indicate a
>> temp usage.
>> After doing that, you have to list (colon separated) the dbspaces in the
>> onconfig.
>> Keep in mind, Informix only reads the parameters when starting, meaning you
>> have to bounce the engine
>> to make use of the temp spaces (same if you add one to an existing list, I
>> dont think it would
>> work with onmode -wf).
>>
>> Our admins have been failing with a wrong entry in the past, the list was
>> only
>> separated by spaces,
>> which did not work.
>>
>> Marcus Haarmann
>>
>> ----- Ursprüngliche Mail -----
>>
>> Von: "Everett Mills" <Everett.Mills@nationalbeef.com>
>> An: ids@iiug.org
>> Gesendet: Samstag, 23. April 2016 15:28:32
>> Betreff: RE: DBSPACETEMP Parameter [37024]
>>
>> Be sure to mark the new dbspaces you create for your DBSPACETEMP list as
>> TEMP
>> space. Otherwise the engine will still create unlogged temp tables in your
>> rootdbs. I always have a regular dbspace in the list as well, just in case
>> a
>> logged temp table is created inadvertently.
>>
>> --EEM
>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>> Ricardo Henriques
>>> Sent: Friday, April 22, 2016 18:03 PM
>>> To: ids@iiug.org
>>> Subject: Re: DBSPACETEMP Parameter [37022]
>>>
>>> The dbspaces must already exist, DBSPACETEMP is only the list of
>>> dbspaces to be used.
>>>
>>>> On Fri, 22 Apr 2016 23:42 Jorge Valenzuela, <jorgervt@gmail.com> wrote:
>>>>
>>>> Hi,
>>>> The DBSPACETEMP Parameter in onconfig file create automatically the
>>>> temporally dbspaces ? Or They must be created with onspaces utility.
>>>>
>>>> Thanks in advance.
>>>>
>>>>
>>>>
>>>>
>>> ***********************************************************************
>>> ********
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>
>>>>
>>>
>>> --001a113f22c8c076f205311ad47f
>>>
>>>
>>> ***********************************************************************
>>> ********
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
> --001a113f1896b7a488053129dbcd
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
They must be created manually independent of DBSPACETEMP.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Fri, Apr 22, 2016 at 6:42 PM, Jorge Valenzuela <jorgervt@gmail.com>
wrote:
> Hi,
> The DBSPACETEMP Parameter in onconfig file create automatically the
> temporally
> dbspaces ? Or
> They must be created with onspaces utility.
>
> Thanks in advance.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0149c0c48096ea053144dcf5
To set this a bit more into perspective:
think of DBSPACETEMP onconfig param as the server wide default setting for =
which set out of your existing dbspaces to use for temp partition=20
activity, and for a setting that can be chosen dynamically on session=20
level, query by query using SET ENVIRONMENT SQL command if you wish so,=20
with a client environment variable to set client default.
Andreas
From: "Jorge Valenzuela" <jorgervt@gmail.com>
To: ids@iiug.org
Date: 23.04.2016 00:43
Subject: DBSPACETEMP Parameter [37021]
Sent by: ids-bounces@iiug.org
Hi,=20
The DBSPACETEMP Parameter in onconfig file create automatically the=20
temporally=20
dbspaces ? Or=20
They must be created with onspaces utility.=20
Thanks in advance.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20