G
George Potemkin
Guest
Intro: Evolve Your Application with OpenEdge 12.1 www.progress.com/.../evolve-your-application-with-openedge-12-1 Limit on the Number of Unique Shared Sequences Increased The maximum number of unique shared sequences in an OpenEdge database has been increased to 32K regardless of block size. The maximum number of multi-tenant sequences is now 2000. Each sequence uses 8 bytes in a sequence block. It means that now db can have up to 16 sequence blocks (in 1K db). All sequence blocks belong to a chain that called NOCHN (bk_frchn 127). First block on the chain is still reported by mb_seqblk in Master Block. At db startup a broker does NOT load the sequence blocks into buffer pool. Promon/Activity: Buffer Cache screen shows two sequence blocks but the screen lies (so can we trust the values of the other fields added in 11.7?). The numbers of new messages in 12.1: from 19426 to 19512. But only two of them are related to the sequences: Cannot add any more multi-tenant sequences to the database. (19476) In fact a session silently crashed after loading 2431 sequences (1K db) or 2555 sequences (8K db). The load of 2300 sequences was successful and there were no system records with the sizes approaching 32K limit. Is it really dangerous to exceed the limit in 2000 sequences? Why I did not get the error 19476? Please increase -B to fix more sequence buffers in memory for enhanced sequence performance. (19493) What the enhanced sequence performance means? Under which conditions we can get the error 19493?
Continue reading...
Continue reading...