From Volker Barth: Just to get a better understanding of the relation between max_identity and (GLOBAL) AUTOINCREMENT column defaults: The value in syscolumn.max_identity (or systabcol for SA 10 and above) contains the maximum value used for (global) autoincrement columns. AFAIK, it is only updated by a CHECKPOINT statement. When building a database with LOAD TABLE statements, each LOAD TABLE statement issues a checkpoint first, so this will automatically update max_identity for all already loaded tables. A regular database shutdown will also perform a checkpoint. Question: Are there other operations/statements that will update max_identity? |
So, to sum up Glenn's elaborate answer: No, max_identity is only updated by a (explicit or implicit) checkpoint. |
Wow, by incident I asked this question in the newsgroup before I tried here - and now I'm backported...Thanks, Glenn:)
...and that gives Glenn a "Student" badge. Ain't it funny:)