Walter, > > If having each record in one page is better than having a record in two or > more pages then have sense for me that gbak keep each record in just one > page when rebuilding the database when it is doing a restore. > > Unless your record is bigger than a page, gbak will always restore each record on a single page. Remember, gbak never restores back versions or uncommitted versions. Each record in a restored database consists of a single version until your application starts messing with it.
Should you have records bigger than a page, choose a bigger page size. If your records are 16Kb, split them. Good luck, Ann [Non-text portions of this message have been removed]