Re: systables.version

Cheryl Kendricks (cherylk@prod1.jcdc.doleta.gov) wrote: : IF you select tabname,owner from systables where tabname like ' V%' : you will set a verions value in the owner table. Even though my .snfile : and dbaccess -V say I'm running 7.12UC2 this was my result: : tabname VERSION : owner 7.10D1 : I'm wondering if this is a BUG! or what! No, I don't think so. VERSION only matters when something changes between versions. For example, the addition of Key Value Locking, and the resulting change in the index structure, required indexes to be rebuilt -- OnLine used the VERSION in systables to trigger the rebuilding of the indexes when upgrading from pre-DSA to DSA. A change in the checkpoint structure from 7.10.UC1 to 7.10.UD1 required special handling to upgrade to 7.10.UD1 (all handled internally) and special handling (not handled internally) if you need to revert to 7.10.UC1 from 7.10.UD1. This is all triggered by VERSION. Since there are no significant changes that OnLine needs to be notified of from 7.10.UD1 to 7.12.UC1, it probably didn't update the VERSION. : On Thu, 15 Aug 1996, Bret Weinraub wrote: : } : } I don't understand your reply. Please clarify. Thanks Bret, you probably don't understand because this is a totally different issue. In answer to your question: : } On Thu, 15 Aug 1996, Cheryl Kendricks wrote: : } : } > On that note is it correct in version with the .snfile? : } > : } > On Tue, 13 Aug 1996, Bret Weinraub wrote: : } > : } > > Does anyone know what the systables.version attribute is used for? Version keeps track of different versions of the same table. For example, if you add a column to a table, it is now a different version; stored procedures may need to be re-optimized, and prepared statements may no longer run against the new table schema. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Oakland ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.