Subject | Max file size |
---|---|
Author | Bogdan Mugerli |
Post date | 2003-11-10T08:32:01Z |
Hi
We have a large datawarehouse database Firebird 1.03 running on WIN 2000
SERVER. (NTFS)
It is beeing filled every night from data of an old Cobol application.
It ran smooth for cca 5 month, then we noticed the differences between Cobol
data and data in our database.
Database is beeing updated thru triggers in the following way:
there a two tables - first collects all data from Cobol database ( date
from - date to)
the second is dimension table which is updated by triggers of the first
table.
All is done in single transaction
The problems began, so it seems, when we crossed the 4G limit.
Is it possible that crossing 4G limit is cousing the inconsistencies.
( we have 2 other installations with smaller databases that are running with
no problems)
Regards
Bogdan Mugerli
We have a large datawarehouse database Firebird 1.03 running on WIN 2000
SERVER. (NTFS)
It is beeing filled every night from data of an old Cobol application.
It ran smooth for cca 5 month, then we noticed the differences between Cobol
data and data in our database.
Database is beeing updated thru triggers in the following way:
there a two tables - first collects all data from Cobol database ( date
from - date to)
the second is dimension table which is updated by triggers of the first
table.
All is done in single transaction
The problems began, so it seems, when we crossed the 4G limit.
Is it possible that crossing 4G limit is cousing the inconsistencies.
( we have 2 other installations with smaller databases that are running with
no problems)
Regards
Bogdan Mugerli