Re: Strange behaviour when using a view in 11.....
Steven reported that on 11.70.FC4 the rootdbs kept filling when using views despite TEMPTAB_NOLOG 1, a restart and recreated views. Art Kagel suggested configuring temp dbspaces and listing both temp and normal dbspaces in DBSPACETEMP, and checking client DBSPACETEMP overrides. Steven tried these and rootdbs still filled. Art found it very odd, noting only temp tables with an explicit IN clause should use rootdbs. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.
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
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.
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