| Author |
Message
|
| bdrummond |
 Posted: Thu May 26, 2005 1:42 am Post subject: Error when using mqsimigratetables command |
 |
|
Disciple
Joined: 06 May 2004
Posts: 164
|
Hi,
We are currently going through the process of migrating our 2.1 brokers to v5.
Everything seems to have gone successfully until we run the mqsimigratetables command.
Whether I quote the service user/password or not, I receive the following error message:
BIP8081 An exception was caught while processing the response message for the command, 'Unable to format an ImbException message for output, ImbException message number is BIP8069'.
The DB2 database was already at 8.2 and is up and running and all mqm/wmqi processes have been stopped.
Does anyone know what the problem could be..?
Thanks. |
|
| Back to top |
|
 |
| bdrummond |
| Posted: Wed Jun 01, 2005 1:11 am Post subject: |
|
|
Disciple
Joined: 06 May 2004
Posts: 164
|
| Has anyone had any trouble with the mqsimigratemsgflows command..? |
|
| Back to top |
|
|
| mqmatt |
| Posted: Wed Jun 01, 2005 3:45 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
Hi,
BIP8069 means that the command can't find the message catalogs; have you set up your profile correctly? (i.e. do LIBPATH and PATH contain references to the broker's lib and bin dirs respectively?)
From your second post, are you having problems with mqsimigratemsgflows too, or was that a typo?
-Matt |
|
| Back to top |
|
|
| bdrummond |
| Posted: Wed Jun 01, 2005 3:47 am Post subject: |
|
|
Disciple
Joined: 06 May 2004
Posts: 164
|
Thanks for that, I'll have a check.
Good spotting though, a complete typo in my second post.  |
|
| Back to top |
|
|
| bdrummond |
| Posted: Wed Jun 01, 2005 4:37 am Post subject: |
|
|
Disciple
Joined: 06 May 2004
Posts: 164
|
| mqmatt wrote: |
Hi,
BIP8069 means that the command can't find the message catalogs; have you set up your profile correctly? (i.e. do LIBPATH and PATH contain references to the broker's lib and bin dirs respectively?)
From your second post, are you having problems with mqsimigratemsgflows too, or was that a typo?
-Matt |
I have checked both the LIBPATH and PATH and everything seems to be correct and look similar to that of the sample profile.
Any other ideas..?  |
|
| Back to top |
|
|
| mqmatt |
| Posted: Wed Jun 01, 2005 6:09 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
Urgh, sounds like a PMR - sorry.
To give IBM a head start in problem diagnosis - they'll probably ask you to set MQSI_UTILITY_TRACE=debug, run the command again and send them the results of mqsireadlog/formatlog. So have that information handy if you can.
As a side point, do you actually need to do mqsimigratetables? If you're not using pub/sub or aggregations, it's normally easier just to create a new broker and build it up from your exported flows.
-Matt |
|
| Back to top |
|
|
| bdrummond |
| Posted: Wed Jun 01, 2005 6:13 am Post subject: |
|
|
Disciple
Joined: 06 May 2004
Posts: 164
|
Funny you should say that as I have created a PMR and sent the trace file to IBM.
We are only using the migrate tables command as we are trying to follow the migration instructions step by step.
But as you said, it looks like it's going to be easier to recreate the Brokers which shouldn't cause us too much pain.
Thanks for your help on this.  |
|
| Back to top |
|
|
| JT |
| Posted: Wed Jun 01, 2005 6:31 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| mqmatt wrote: |
| have you set up your profile correctly? |
As matt mentioned, you should also verify that the NLSPATH & LANG environment variables have the proper settings? |
|
| Back to top |
|
|
|
|
