| Author |
Message
|
| uppugandla |
 Posted: Sun Jan 18, 2009 10:28 pm Post subject: How do I reduce the Worklfow rt_db Size |
 |
|
Newbie
Joined: 09 Dec 2008
Posts: 8
|
Hi,
I am using MQ Worklfow 3.5, now the problem is run time database has become 35 GB, We did not enable the Audit_trail also. we are running cleanup server weekly once. Is there any way to reduce the Database size. There are few folders in rt_db\db2\FMCDB\ in that "containr" is taking 19.1GB of space, "progact" folder is taking 9.71GB space.
1)Is there any way to reduce the size for these folders?
2)Is it safe to delete old data from the tables?
3)why is that "containr" folder is occupying 19 GB?
Thanks,
Ivar |
|
| Back to top |
|
 |
| hos |
| Posted: Sun Jan 18, 2009 11:40 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
you need to make sure that the cleanup interval is big enough to delete all
obsolete data. Once a week sounds not very much. Also make sure that your processes and workitems are modelled for deletion, i.e. avoid Never when you specify delete options.
1. The only way to reduce space consumption is to run the cleanup server.
2. No. Never update MQWF RT DB manually. You may corrupt the database.
3. I remember that there was a 'container leak' with cleanup. Apply the latest maintenance or migrate to MQWF 3.6 which is currently the only supported version. |
|
| Back to top |
|
|
| uppugandla |
| Posted: Mon Jan 19, 2009 1:07 am Post subject: |
|
|
Newbie
Joined: 09 Dec 2008
Posts: 8
|
Thanks for the quick reply,
After running the cleanup server number of rows in the tables are reduced a lot, but table space is not getting released. I. e. rt_db\db2\FMCDB\ folder size not reducing.
DB size remains same after running the cleanup server. Any clue about this?
Thanks,
Ivar |
|
| Back to top |
|
|
| uppugandla |
| Posted: Mon Jan 19, 2009 8:41 pm Post subject: |
|
|
Newbie
Joined: 09 Dec 2008
Posts: 8
|
HI,
Issue has been resolved, I have reorganized the DB, it resolved all the problems.
Thanks,
Ivar |
|
| Back to top |
|
|
| anveshita |
| Posted: Mon Jan 26, 2009 11:06 am Post subject: |
|
|
Master
Joined: 27 Sep 2004
Posts: 254
Location: Jambudweepam
|
Please read the MQ Workflow best practices guide.
In our production we used to have scheduled jobs to:
1. REPRRO REORG job scehduled to run every week
Clean up server was set to run every day midnight ( when our load was less)
beyond this, we made sure our auditing was turned down as we were using a custom built, vendor supplied auditing utility.
Hope this helps. |
|
| Back to top |
|
|
| tim@KIN |
| Posted: Tue Dec 29, 2009 2:56 am Post subject: |
|
|
Newbie
Joined: 26 Apr 2007
Posts: 9
|
I want to know how to reorg DB2
MQWF3.5
I get the message from MQWF Best Practice
| Quote: |
db2 select tabname, stats_time from syscat.tables where tabschema=”
FMC”
db2 select pkgname, LAST_ BIND_ TIME from syscat.packages where
pkgschema=” FMC”
db2 reorgchk update statistics on table all
db2 rebind <pkgname> (for all packages)
|
Can the command reduce the file size of rt_db? |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Dec 31, 2009 6:29 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I seriously doubt that this would have much effect on the RTDB size.
Are you purging your Audit table regularly? Do you keep Finished Instances and Workitems forever?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| tim@KIN |
| Posted: Wed Jan 06, 2010 6:11 pm Post subject: |
|
|
Newbie
Joined: 26 Apr 2007
Posts: 9
|
| jmac wrote: |
I seriously doubt that this would have much effect on the RTDB size.
Are you purging your Audit table regularly? Do you keep Finished Instances and Workitems forever? |
Thanks for the reply.
We have enable the clean up server every day for around 2 hr. and finished instance should removed. Aduit function disabled.
I have found soe function on fmczutil.
Is this a method to reorg the WF DB?
| Quote: |
fmczutil -y XXX
<user name & password>
s ... Select
<XXX>
r ... Runtime Database Commands Menu
o ... Optimize Database
f ... Optimize all MQ Workflow tables
<FMC user name and password>
r ... Run runstats and rebind for the selected tableset
---AND
o ... Run reorganization for the selected tableset
|
|
|
| Back to top |
|
|
| naitsab |
| Posted: Mon Jan 25, 2010 8:42 am Post subject: |
|
|
Newbie
Joined: 11 Sep 2009
Posts: 2
|
Hi,
you can use this command to reorganize the runtime db
fmczkcfg -y <WFCONF> -o:o -m:o -t:a -p:<DB2USER>:<DB2PASSWORD> |
|
| Back to top |
|
|
|
|
