Cleaning B1 file ?

[Rag]

Hi, I'm new to the forum, and quite a newbie in progress administration.

We've got a problem with our database.
The .b1 as reached the max size of 2096Mo.
Our database is now stuck in "Starting database" and doesn't want to run.

Is there any way to clean the .B1, can I delete it and recreate it ?

Can someone help me, please ?

 

[vakpal]

I don't understand this problem because the Progress manage te Before Image file, and this is not a problem to the Progress.

But you can't delete it, just tuncate it
Example:
proutil dbname -C truncate bi

Are you sure the problem is a b1 file? Not a d1? A "D" file have a 2Gb limit also

 

[Rag]

Thanks for your reply.

I've just called the progress hot-line.
First part (and last part ?) of the solution has been to enlarge file size by the command : enablelargefiles

For the moment the system is working (b1 is growing and d1 are beeing modified) but the database cannot be used.

I'm waiting for the transactions to finish and I'll see what will happen ...
Don't now if the database integrity will be ok after that

 

[Rag]

Well, everything went fine.
Except that the transaction has been undone but it's not a problem.

See you next problem .

Will go in progress formation, I really need it :lol:

 

[vakpal]

What? Undone? :blue:
I have never been lose any transations, except the program is ****.

 

[Rag]

Well, I mean, the transaction which fulled the BI file didn't complete.
It was a cleaning of reports, a program with a bug somewhere.
All the reports are still in the database, so I guess the transaction has been undone.

 

[Ach]

Rag, just so you know, when the BI is truncated, it grows twice in size before getting truncated. So, it's best not to let the BI grow more than 900mb. Truncate it as soon as it reaches 900mb.

 

[Rag]

Ok, thanks.