Oninit cdi / Archive
Talk to an expert →

Re: Strange behaviour when using a view in 11.....

Posted in 2012

Topics: Storage & Space Management

STEVEN — — source: IIUG Forums & Mailing Lists

I am having the same issue on 11.70.FC4. I set the TEMPTAB_NOLOG to 1, I've bounced the server, I've dropped/recreated the views in question, and my rootdbs is still filling up.

↪ replying to STEVEN
Art Kagel — — source: IIUG Forums & Mailing Lists

Do you have temp dbspaces configured? Do you have both temp and non-temp dbspaces (other than rootdbs) listed in DBSPACETEMP? If not, try configuring temp dbspaces and listing both temp and normal dbspaces in DBSPACETEMP. Also make sure that your client environment isn't setting DBSPACETEMP differently from the setting in the ONCONFIG file since user environment settings override the server's default for those user sessions. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 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 Thu, Jun 7, 2012 at 12:14 PM, STEVEN MITTELSTAEDT < steven.mittelstaedt@gmail.com> wrote: > I am having the same issue on 11.70.FC4. I set the TEMPTAB_NOLOG to 1, I've > bounced the server, I've dropped/recreated the views in question, and my > rootdbs is still filling up. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba6e82b48585c104c1e4d031

↪ replying to Art Kagel
STEVEN — — source: IIUG Forums & Mailing Lists

Art, Thanks for the reply. Yes, I have temp spaces configured. I did not have a normal dbspace in my DBSPACETEMP list, only had temporary dbspaces. I added one, restarted informix, and rootdbs still filled. The client had nothing set for DBSPACETEMP. I even tried added the same DBSPACETEMP spaces as my onconfig to the client, still filled rootdbs.

↪ replying to STEVEN
Art Kagel — — source: IIUG Forums & Mailing Lists

Very odd. At this point with normal dbspace in DBSPACETEMP and TEMPTAB_NOLOG set, the only temp tables in rootdbs should be ones creates with an explicit IN clause. Art On Jun 7, 2012 2:50 PM, "STEVEN MITTELSTAEDT" < steven.mittelstaedt@gmail.com> wrote: > Art, Thanks for the reply. > > Yes, I have temp spaces configured. I did not have a normal dbspace in my > DBSPACETEMP list, only had temporary dbspaces. I added one, restarted > informix, and rootdbs still filled. > > The client had nothing set for DBSPACETEMP. I even tried added the same > DBSPACETEMP spaces as my onconfig to the client, still filled rootdbs. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae93406bb94cccd04c1e67cdf