rowid in temp table

[tom...@gmail.com]

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

[Art Kagel]

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.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[tom...@gmail.com]

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.

[Art Kagel]

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.

[Art Kagel]

If you need a substitute for ROWID for temp tables, checkout the rownum() function I posted to my blog yesterday.  That should serve either while inserting the rows to the temp table or during the fetch back out.  If you need a guaranteed stable numbering, then I'd suggest using it when inserting the rows.

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:08 PM, Art Kagel <art....@gmail.com> wrote:

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, <tom...@gmail.com> wrote:

[tom...@gmail.com]

Thanks much, Art