Re: rowid in temp table
we have had multiple items listed in DBSPACETEMP in the ONCONFIG for quite some time. It was the only thing I could think of that would have done this change. On Tuesday, September 25, 2012 10:29:13 AM UTC-5, Art S. Kagel wrote: > If you have DBSPACETEMP set to multiple temp dbspaces, either in the ONCONFIG file or overridden by the users' environment, the engine will fragment/partition temp tables across all of them and partitioned tables do not have rowids. Is it possible that the value in DBSPACETEMP was changed? > > > > 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 Tue, Sep 25, 2012 at 10:45 AM, <tom...@gmail.com> wrote: > > > hello, > > For some reason, we now see a -857 error (Rowids do not exist on table) > > when running a select rowid against a temp table. We are on version 11.7.FC5 on AIX 6.1 > > There were no config nor version changes but it worked fine on friday and then started getting the error on monday - any ideas? > > > > thanks > > tom > > _______________________________________________ > > Informix-list mailing list > > Inform...@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list
Or maybe the DBSPACETEMP environment var for this app changed. Otherwise, I dunno. 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 Tue, Sep 25, 2012 at 2:01 PM, <tomcaml@gmail.com> wrote: > we have had multiple items listed in DBSPACETEMP in the ONCONFIG for quite > some time. It was the only thing I could think of that would have done this > change. > > > > > On Tuesday, September 25, 2012 10:29:13 AM UTC-5, Art S. Kagel wrote: > > If you have DBSPACETEMP set to multiple temp dbspaces, either in the > ONCONFIG file or overridden by the users' environment, the engine will > fragment/partition temp tables across all of them and partitioned tables do > not have rowids. Is it possible that the value in DBSPACETEMP was changed? > > > > > > > > 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 Tue, Sep 25, 2012 at 10:45 AM, <tom...@gmail.com> wrote: > > > > > > hello, > > > > For some reason, we now see a -857 error (Rowids do not exist on table) > > > > when running a select rowid against a temp table. We are on version > 11.7.FC5 on AIX 6.1 > > > > There were no config nor version changes but it worked fine on friday > and then started getting the error on monday - any ideas? > > > > > > > > thanks > > > > tom > > > > _______________________________________________ > > > > Informix-list mailing list > > > > Inform...@iiug.org > > > > http://www.iiug.org/mailman/listinfo/informix-list > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >