Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Clearing system messages (autoclean doesn't work)

Questions
Tags
Users
Badges
Toby Rahilly
(26●2●1) Mar 16 '11, 1:53 a.m.
Hi,

The BF_MESSAGE_TRANSLATED table is currently taking 6GB of space, and build forge has become to slow be usable.

I have tried setting all the autoclean settings to 1 to no effect. Even after waiting a day (is this required?).

How can I clear out the system messages? Is it safe to manually clear the database tables? If so which ones should I clear?

I don't care about keeping any of the history.

I am using Build Forge 7.1.1.0.0.0125 with DB2 on Windows Xp sp3

Thanks for any help,
Toby

0 votes

2 answers
5,324 views
0 votes

2 answers

Permanent link
Robert haig
FORUM MODERATOR / JAZZ DEVELOPER (1.0k●1●6) Mar 16 '11, 2:00 p.m.
Hi,

The BF_MESSAGE_TRANSLATED table is currently taking 6GB of space, and build forge has become to slow be usable.

I have tried setting all the autoclean settings to 1 to no effect. Even after waiting a day (is this required?).

How can I clear out the system messages? Is it safe to manually clear the database tables? If so which ones should I clear?

I don't care about keeping any of the history.

I am using Build Forge 7.1.1.0.0.0125 with DB2 on Windows Xp sp3

Thanks for any help,
Toby


yes, that is a known issue that was fixed in one of the later 7.1.1.x releases.

there are 3 bf_messages tables that you should clean out if you want to clear these tables before you upgrade (which I highly recommend). Clean out bf_messages, bf_messages_translated, and bf_messagearg. Make sure you have enough transaction log space to do this before your start or it will fail and rollback. (speak with your DBA about that part)

then go look at https://jazz.net/downloads/rational-build-forge/releases/7.1.2.1 and investigate an upgrade.

0 votes

Permanent link
Toby Rahilly
(26●2●1) Mar 18 '11, 2:58 a.m.
Thanks! that worked well and now Build forge has good performance.

However after the upgrade to 7.1.2.1 I am experiencing a new problem when connecting from a remote machine. I have detailed the issue in a new thread here:

http://jazz.net/forums/viewtopic.php?p=52903

Thanks a ton,
Toby

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Mar 16 '11, 1:53 a.m.

Question was seen: 5,324 times

Last updated: Mar 16 '11, 1:53 a.m.

Confirmation Cancel Confirm