How to Dump and Reload a db with one or more extents?

[moveIT]

I have following problem:
I had a db (2gb) with one extent (about 0,5gb). But I only wantet one db-file, so I created a new db and enabled the option "EnablelargeFiles" so that this db can get larger than 2gb. Than I dumped the db with the extent and loaded the data into the new db. Now it looks like that in the new db there is data missing. It seams to be some data out of the extent!
Can anyone help me? Did I something wrong?
I use Progress 9.1D07 with Windows XP.

 

[Casper]

Hi,

I don't get your numbers. You say you have a 2GB datbase with 1 extent which is 0,5 GB.

Do you have any particular reason to only want one extent? You obviously have more then 1: 1 .db file, 1 data extent, 2 ai extents (at the least) and 1 bi extent.

With only one extent you can only use 1 area, so no seperate index area (which is higly recommended) and no different rpb's to match your table specifics.


But ok, to the question:

To do a reload:

dump _user
dump df
dump sequence and values
dump data.

Create new database with one .db file (schema area), 2 ai files on seperate fielsystem, 1 bi file and 1 variable length extent (d1) in a different area then area 6 (say area 7 "data area").


Load the df
Load the _user
Load the sequence & values
Load the data.

Ofcourse enable large files, make sure the ulimit on your system is set to unlimited.

Check if no errors occur.

BTW: What makes you think you miss data?

HTH,

Casper.

 

[moveIT]

I found my mistake! Bevor I dumped the database I had to correct the path of it and here I used a wrong structure file where I forgot the extent. So the information about the extent was lost and the data not dumped! Aaarrrr!