We are running 6.5.1 on NT 4.0.
We are unable to compact dbs that are copied from a 5.0.12 server to a 6.5.1 server.
Compact runs and no errors are reported but 0% is recovered. The dbs we are trying to compact have a large white space % (sometimes 50%).
We have tried the -b switch at the console and that does help. Anyone else having the same problem?
Thanks, Bob
Subject: Compact problem on DB copied from R5 server…
When you copy them, what are you running against them initially? And are you running transaction logging?
I’d be curious to know what version ODS the copied databases are, if they’re truly R6 ODS they’ll be 43, 41 for the R5.
Also the -b switch/-B switch combos work in conjuction with Transaction Logging. The -b allows you to reuse whitespace (doesn’t reduce file size) without changing the Database’s unique ID that transaction logging would use to replay changes for restores. With the -B switch you’d run that every so often to reclaim the whitespace, reduce file size, but you’d want to run a backup after doing this.
Last think I can think of is the -c switch (copy style), but it seems to me that this was something we only did when first converting from R5 to R6 on the servers, ran this against all DBs with the server down.
Subject: RE: Compact problem on DB copied from R5 server…
Bill, thanks for your reply.We are not using transaction logging. The first couple times we tried this we just ran compact against them. They are ODS 43s. After we saw that compact was not doing anything against them we then tried new copies, then ran updall, fixup and that stuff still with no luck.
Because the file is coming from an R5 server to an R6 server I am going to give the -c switch a try.
We don’t know if this is related but any view that uses a view selection created using an ‘Easy’ formula with a form name in R5 will not work in R6. We get an error in the log that says something like, ‘The database must be compacted to support @AllChildren or @AllDescrendants in a formula’ even if no columns use those functions.
The only way we have found to fix it is by changing the simple formula to a formula. Going in and just saving the view in R6 does not fix it.
–Bob