Binary dump Load issue:

[Mokash]

Hi All,

I have a created binary dump(.bd file) of one table. At the time of loading into databaseI get following message:
Loaded 1154 records. (6244)
Binary Load complete. (6256).

But when I enter into the database it shows zero record in it.

Progress Version:9.1D

Any help on this is highly appreciate.
Thanks in Advance.

 

[Casper]

Did you do an index rebuild during load? If not then you have to do that seperately.

casper.

 

[Mokash]

Thanks Casper,

After Index rebuilding problem is solved.

 

[Mokash]

Casper,

How can we rebuild index during load? By using idxbuild command I performed rebuilding please suggest me other way.

Thanks once again.

 

[RealHeavyDude]

You version of Progress is very, very, very old. AFAIK, building the indexes with the binary load was introduced into the product later. For sure the more recent versions of OpenEdge 10 (10.1c, 10.2a) will support it.

Regards, RealHeavyDude.

 

[Casper]

Index rebuild during binary load I think it is already supported in 9.1X as well. You can use the "build indexes" in the proutil load command with needed parameters (-TB, -TM, -T, -B, -SS etc...).

But on our databases in most cases it is quicker to do a binary load followed by an idxbuild then it is to do it simultoanos during the load. So YMMV on the total time needed.

Casper.

 

[Mokash]

Thanks a lot !!!!