Hi, I was wondering what if anything I should know about space usage on a Document Domain. It seems to be increasing rather rapidly. I know there was some discussion at some point about compacting the repository but it seems this is available only on the Security Domain.
Is there anything special about the Document Domain as far as freeing up space or cleaning up old documents? Is space utilization on the repository similar to that of the REP file? In other words if a REP file uses 5MB on a hard drive will it be similar in the repository?
In a message dated 98-07-17 09:50:33 EDT, you write:
Is there anything special about the Document Domain as far as freeing up
space or cleaning up old documents? Is space utilization on the repository similar to that of the REP file? In other words if a REP file uses 5MB on a hard drive will it be similar in the repository?
Thanks,
Greg Mills
Greg:
There were some comments about a document taking up the “most” space it had ever taken up. In other words, if a document is currently 1 meg but at one time was 5 meg then 5 meg of space is still allocated. I have not had time to investigate this myself. It may depend on the database used for the repository as well (some databases may be better at cleaning up fragments than others.)
As far as the second part of your question, I am assuming that the answer is “yes”. When BusObj sends a document to the repository it does not do any compression. It simply breaks the report up into “slices” and stores the binary data byte by byte.
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in '98!
I have run into a similar problem. I had a file that had about 16 report tabs in it in the repository. It took a while to open it so we decided to break that file down into pieces. I deleted 12 of the 16 tabs. Now there were only 4 tabs but it took the same amount of time to open it and the space on the repository remained the same. I asked BO about it and the guy I talked to said he had never heard of that problem. It was not an isolated example, but it is an odd thing!! Maria D. Carter
BusinessObjects Developer
(336) 279-2242 mcarter@gbncmail.ims.att.com
Greg:
There were some comments about a document taking up the “most” space it had
ever taken up. In other words, if a document is currently 1 meg but at one
time was 5 meg then 5 meg of space is still allocated. I have not had time to
investigate this myself. It may depend on the database used for the repository
as well (some databases may be better at cleaning up fragments than others.)
As far as the second part of your question, I am assuming that the answer is
“yes”. When BusObj sends a document to the repository it does not do any
compression. It simply breaks the report up into “slices” and stores the
binary data byte by byte.
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in '98!
First of all, our Document Domain space is also rapidly growing (per a very concerned DBA), I have not found a reliable way to reduce it - Any tips are appreciated.
A “quick and dirty” way to save space in the Document Domain, when sending the report to DAS, is to purge the data from the report first using the “View Data” purge function.
This will be effective providing the document has not been previously sent under the same ID. (I believe the other issues discussed on this
thread will be in effect if the document existed before).
Side benefit of purging: This process also greatly shortens the time it takes to send a large document to DAS.
Hi, I was wondering what if anything I should know about space usage on a Document Domain. It seems to be increasing rather rapidly. I know there was some discussion at some point about compacting the repository but it seems this is available only on the Security Domain.
Is there anything special about the Document Domain as far as freeing up space or cleaning up old documents? Is space utilization on the repository similar to that of the REP file? In other words if a REP file uses 5MB on a hard drive will it be similar in the repository?
Hi, I was wondering what if anything I should know about space usage on a Document Domain. It seems to be increasing rather rapidly. I know there was some discussion at some point about compacting the repository but it seems this is available only on the Security Domain.
Greg,
We too discovered that our document domain was eating up a lot of space on our repository. Our repository was built in version 4.0 whereas BO was at version 4.1.1. The BO engineer we were working with suggested we rebuild our repository from scratch (in version 4.1.1). As a side note, it’s important to purge the queue on Doc Agent frequently; we have ours set to purge all tasks after 5 days.
Also, BO users should frequently do a File, Retrieve from Document Agent Server, and retrieve or delete their documents.
Since we rebuilt the repository, we have not seen the space issue.
