Partial load during binary D/L

[SSuhaib]

Hi,
RedHat, Progress 9.1E.


After loading data using binary D/L method, in one of the biggest table, size of around 6.2gb, most of the records were found missing. There were no error messages either after load nor after index rebuild.

However, we deleted all the records again and did a D/L by dictionary and all the records were tallied.

Has any one had similiar experiances. What went wrong during binary D/L and/or is it noraml practice ( Iam sure it is not ).

Thanks in advance.

 

[TomBascom]

Were there errors in the log file?

The most obvious other possibility is that you do not have large files enabled, the .bd files were multi-volume (due to the 2GB file size constraint) and that you only loaded one of them. With 6GB of data in the table I would hazard a guess that roughly 25% to 30% of the data was loaded and the rest was missing?