| Author |
Message
|
| Carl Bloy |
 Posted: Mon Apr 19, 2004 1:39 am Post subject: WMQI 2.1 Indexes on DB2 tables? |
 |
|
Acolyte
Joined: 16 Dec 2003
Posts: 69
Location: England
|
Hi,
We've started experiencing issues with deadlocks and timeouts in our test environment due to issues with DB2.
Our DBAs have looked at the databases and are concerned at the lack of Indexes on the tables. In their opinion 90% of our problems would be resolved with proper indexed tables.
I was hoping someone may be able to shed some light on the lack of indexes and any advice on creating our own indexes.
Regards
Carl |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Apr 19, 2004 10:53 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Are you talking about user database or broker database?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Carl Bloy |
| Posted: Mon Apr 19, 2004 11:15 pm Post subject: RE: WMQI 2.1 Indexes on DB2 tables? |
|
|
Acolyte
Joined: 16 Dec 2003
Posts: 69
Location: England
|
| Sorry i'm talking about Broker databases, we don't user user databases. |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Apr 20, 2004 9:58 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Can you give an example of Deadlock or timeout message. Are you saying that you get timeout message when trying to deploy someting to the broker?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| mgk |
| Posted: Wed Apr 21, 2004 12:15 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Your DBAs are correct. This has been fixed (adding indexes) in a later CSD, but I forget which CSD it went into. Ask your account rep to find out or raise a PMR (or just upgrade to a recent CSD)...
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| Carl Bloy |
| Posted: Wed Apr 21, 2004 1:51 am Post subject: RE: WMQI 2.1 Indexes on DB2 tables? |
|
|
Acolyte
Joined: 16 Dec 2003
Posts: 69
Location: England
|
Kirani,
The issues occurr mainly on staring WMQI, i believe we are geting 911 error messages.
mgk,
We do have a PMR open with IBM, but as yet they haven't mentioned it being fixed in a CSD. We'll look into this.
Many thanks for the responses
Carl. |
|
| Back to top |
|
|
|
|
