Journal Compression

Chris Kelleher

Chris Kelleher

Administrator
Staff member
As time goes on, monthly journal compressions are taking longer and longer.
This is primarily the case with the SF Dist Journal. Granted, we continue to
increase the number of trx's in the journal, but the compression/posting is
beginning to cause problems for other users and their system performance.

We are running Symix 4.0, on a Unix box (AIX). Has anyone come up with a
time-efficient way to post/compress journals at M/E? This morning, the SF
journal took 2 hours to print/compress/post. The printout was about 2000 pages
(sent to a file).

Does anyone have any great ideas to make this go faster?

TIA

Pattee Bender
Uniform Color Company
 
When was the last time you reindexed the db ? Also did you see a change in
the "scatter Factor" of dbanalys ?

I would try a Crash Recovery since the compress may very use the tmp-sum
table that may be be wafully huge if users did not exit "gracefully" ...

Eric.
 
You must log in or register to reply here.
Back
Top