Subject: | |
From: | |
Reply To: | |
Date: | Tue, 2 Jan 2007 09:24:54 -0600 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hi all,
Last Friday eve (as luck would have it), we had a DB lock up
because an Auto Master synonym chain filled up. We did a verify of the
set's synonym path (on a copy of the DB), and just about every entry had
lots of secondaries - (only about 2% of the entries did not have a
secondary). The particular data value that finally filled up its
synonym chain is: 41378.25
After reading the IMAGE manual trying to determine what's
wrong, we can see that it may be a problem with the R4 data type for our
key value? I'm not a math wiz, and have never used real numbers data
types as keys before (heck, I don't ever recall using real number data
types for anything in IMAGE).
1) My questions are why does the R4 data type end up with so many
synonyms?
2) Would the same problem exist if the data type was an I4?
TIA, and Happy New Year!
<http://www.republictitle.com/>
Raymond Shahan
Computer Programmer
REPUBLIC TITLE OF TEXAS, INC. <http://www.republictitle.com/>
2701 W Plano Parkway
<http://maps.yahoo.com/maps_result?addr=2701+w+plano+parkway&csz=75075&c
ountry=us&new=1&name=&qty=>
Plano, TX 75075
direct 214.556.0202
main 972.578.8611
fax 972.424.5621
www.republictitle.com <http://www.republictitle.com/>
[log in to unmask]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|