Salesforce

Warning message (13435) doesn't report on fixed extent of Type I Area when it is hitting rowid limit

« Go Back

Information

 
TitleWarning message (13435) doesn't report on fixed extent of Type I Area when it is hitting rowid limit
URL NameWarning-message-13435-doesn-t-report-on-fixed-extent-of-Type-I-area-when-it-is-hitting-rowid-limit
Article Number000187762
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: Database limits
Question/Problem Description
Warning message (13435) does not report on Type I fixed extents when the storage area when it is approaching the 32-bit rowid limit.
Warning message 13435 only appears when a variable extent extends into the MAXAREA 80% or 90% range 
Steps to Reproduce
Clarifying Information
Replication enabled target database raises the warning message (13435), but the source database doesn't
Source database has more fixed extents than the target database.

Using the current block hiwater value, new data is writing to the variable extent of the target database but fixed extents in the source database
Both the source and target databases are approaching the 32-bit database rowid limit.
Error MessageWarning message (13435): bkxtn: WARNING: Area: <areaNumber> extent <extentName> has reached the <percentage> percent threshold for block usage - current block hiwater <maxAreaBlock>. (13435).
Defect NumberDefect PSC00349091
Enhancement Number
Cause
The purpose of the 13435 message is to Warn the Database Administrator that a Type I Storage area is approaching the 32-bit rowId limit. 

Currently this message will only appear when a variable length extent has to be extended. All blocks in fixed extents are already included in the area, so there is no warning raised on them.
Resolution
None at this time.
Workaround
Use PROSTRCT STATISTICS reports to periodically monitor the High Water Mark for Storage Areas on all databases pre OpenEdge 10.1B and post 10.1B that do not use Type II Storage Areas.

Refer to Article When does the 2 billion rowid limit per Storage Area apply?   

Example:  The following Area has 37 GB remaining

  Database Block Usage for Area: <Area Name>

  Active blocks: 28099782 << Current High Water Mark = 214 GB
    Data blocks: 28099782
    Free blocks: 0
   Empty blocks: 74
   Total blocks: 28099856
  Extent blocks: 16
  Records/Block: 64 << MAXAREA 256 GB = (2^31-1)/64 * 8 K dblocksize
   Cluster size: 1    << Type I Storage Area
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:17 AM

Powered by