| Author |
Message
|
| garyweik |
 Posted: Thu Jul 25, 2002 4:27 am Post subject: Exporting and Importing a Single Message Set |
 |
|
Apprentice
Joined: 28 Jun 2002
Posts: 30
Location: Miamisburg, Ohio
|
Is there a way to export a single Message Set from one Workspace to be imported into another workspace?
Thanks,
Gary Weik
 |
|
| Back to top |
|
 |
| stiffann |
| Posted: Thu Jul 25, 2002 6:40 am Post subject: |
|
|
Apprentice
Joined: 17 Mar 2002
Posts: 26
|
Hi,
if you have MQSI 2.0.2+, you will find a utility called mqsiimpexpmsgset in the [MQSIRoot]/bin directory. If not, you better upgrade 
You should find documentation for this utility in the Administration Guide.
Good Luck
Simon |
|
| Back to top |
|
|
| kwelch |
| Posted: Thu Jul 25, 2002 10:22 am Post subject: |
|
|
Master
Joined: 16 May 2001
Posts: 255
|
Gary,
Do you really just mean to go to another workspace. Because if that's all you want to do, you can open new workspace, go to the messageset tab, right click on it and choose add to workspace -> messageset and a list of all existing messagesets should appear. Choose the one you want .
If you are trying to go to another machine/environment then you would use the import/export command referenced below.
Karen |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jul 25, 2002 11:27 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
In earlier version of MQSI (2.0.1 and lower) you can use command mqsimrmimpexp to export/import msgset.
_________________
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 |
|
|
| garyweik |
| Posted: Thu Jul 25, 2002 12:24 pm Post subject: |
|
|
Apprentice
Joined: 28 Jun 2002
Posts: 30
Location: Miamisburg, Ohio
|
OK, I tried the following:
C:\>mqsiimpexpmsgset -e -n MQSIMRDB -u DB2USER -p DB2PASSWORD -s MESSAGESETNAME -l 1 -f FILENAME
and got:
BIP8180E: The message repository database MQSIMRDB has not been initialized correctly.
It is not possible to access the message repository because the database MQSIMRDB has not been properly initialized.
This error is most probably a result of a setup inconsistency. You must delete your Configuration Manager (using the mqsideleteconfigmgr command with the -n and -m options) and then recreate your Configuration Manager (using the mqsicreateconfigmgr command with the -n and -m options).
Well, I did what it told me to do and tried the mqsiimpexpmsgset command again and I got the same error message!
Watch:
<< Stopped All MQSERIES Services >>
C:\>MQSIDELETECONFIGMGR -n -m
MQSeries queue manager 'MQSIQMGR' started.
BIP8071I: Successful command completion.
C:\>mqsicreateconfigmgr -i MQSIUSER -a MQSIPASSWORD -q MQSIQMGR -n MQSICMDB -u DB2USER -p DB2PASSWORD -m MQSIMRDB
AMQ8110: MQSeries queue manager already exists.
MQSeries queue manager running.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
BIP8071I: Successful command completion.
Any ideas?
Thanks,
Gary
|
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jul 25, 2002 12:39 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
well .. by specifying mqsideleteconfigmgr command with -n and -m options you just deleted all message flows and Message sets from your configuration and message repository.
You should have tried restarting your database manager. Did you see anything logged into DB2 log files?
_________________
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 |
|
|
| Nyusser |
| Posted: Fri Jul 26, 2002 2:14 am Post subject: |
|
|
Apprentice
Joined: 02 Jul 2002
Posts: 48
|
I have also received the message BIP8180E several times on different systems - restarting didn't help, but the solution (at least in my case) is even simpler. Try these (when you get your system back together):
1. Put userid and password in different cases: lower case / upper case. This helps on some systems.
2. On some systems you are able to export/import only with db2admin user and on other only with mqsiuid/wmqiuid user (depends on the installation?). You should try both/each to see which works. In different CASES (see 1) of couse.
It seems that if the user id/password combination is not completely wrong, mqsiimpexpmsgset reports BIP8180E instead of authority problem... |
|
| Back to top |
|
|
| philip.baker |
| Posted: Fri Jul 26, 2002 7:21 am Post subject: |
|
|
Voyager
Joined: 21 Mar 2002
Posts: 77
Location: Baker Systems Consulting, Inc. - Tampa
|
Gary,
If you have not done so already, try running the mqsiimpexpmsgset command from within a DB2 comand window. (Accessed via Start -> Programs -> DB2 for Windows -> Command Window.)
Regards,
Phil |
|
| Back to top |
|
|
| tchagan |
| Posted: Fri Jul 26, 2002 8:06 am Post subject: |
|
|
Apprentice
Joined: 10 Feb 2002
Posts: 31
|
Hi,
the message
BIP8180E: The message repository database MQSIMRDB has not been initialized correctly
usually occurs when trying to import or export to the repository using a user id other than that which was used when the repository was created. Find out what user id (schema) the repository is under using db2 control centre and then use that user id and password to run the import/export command.
Terry |
|
| Back to top |
|
|
|
|
