MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Container size

Container size

« View previous topic :: View next topic »

Author

Message

koko

Posted: Tue Aug 09, 2005 9:02 am Post subject: Container size

Master

Joined: 26 Sep 2003
Posts: 206

I am seeing that one of the tables in WF Database called CONTAINER has some 7 million records in it. We thought that it should not be too big and worked with IBM to be told to go for a fix pack for WF ( as IBM thought the problem might be with clean up server )

Now the no.of records in that table is 11 million and the activity instance table is 7.5 million.

Is there any way for me to tell wether the fix pack solved our problem. In other words how do I know the cleanup server is really cleaning up stuff fine and my system is healthy?
_________________
Thanks

Koko

Ratan

Posted: Tue Aug 09, 2005 10:09 am Post subject:

Grand Master

Joined: 18 Jul 2002
Posts: 1245

Is your cleanup server running?
_________________
-Ratan

koko

Posted: Tue Aug 09, 2005 2:05 pm Post subject:

Master

Joined: 26 Sep 2003
Posts: 206

Yes. Its running every night from 12AM to 6 AM
_________________
Thanks

Koko

jmac

Posted: Tue Aug 09, 2005 4:16 pm Post subject:

Jedi Knight

Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC

Koko:

I think if you look in the Production Considerations PDF (one of the support pacs) you will see a database query you can do to see how many finished instances are in your database. I would run that to see if the problem is due to finished instances not being removed.
_________________
John McDonald
RETIRED

koko

Posted: Wed Aug 10, 2005 5:57 am Post subject:

Master

Joined: 26 Sep 2003
Posts: 206

Thanks Jmac.

I checked it and it is around 700.

I think cleanup server is running fine. Is there any doc to find what gets stored in the CONTAINER table and how its saved?
_________________
Thanks

Koko

jmac

Posted: Wed Aug 10, 2005 6:46 am Post subject:

Jedi Knight

Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC

koko wrote:

s there any doc to find what gets stored in the CONTAINER table and how its saved?

Not to my knowledge... I think you should continue to persue the PMR with IBM
_________________
John McDonald
RETIRED

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Container size

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP