| Author |
Message
|
| Jason_Mannering |
 Posted: Thu May 26, 2005 1:28 am Post subject: BIP8078E error when running mqsicreateconfigmgr command |
 |
|
Newbie
Joined: 24 Mar 2005
Posts: 8
Location: London
|
When running mqsicreateconfigmgr command on my standalone machine which I use for development I get the following error:
C:\Documents and Settings\Administrator>mqsicreateconfigmgr -i wbiadmin -a wbiadmin -q CONFIG -n CONFIG
AMQ8110: WebSphere MQ queue manager already exists.
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.
BIP8078E: A problem was encountered while attempting to create/delete the Configuration Manager.
The operation was not completed successfully.
Check messages in the system log for related errors and retry the operation. If the problem still occurs, contact your IBM support center.
Event log Text:
_______________
While attempting a database operation on the configuration repository, a SQL exception was caught by the Configuration Manager. This was because the database is not up and running. The database operation did not complete successfully. If this message was issued by the Configuration Manager, then it will continue if it is safe to do so. The exception text is: [IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 .
For more information on this error refer to the relevant documentation for the database manager you are using for the configuration repository
Event Log Data:
_______________
0000: 34 00 33 00 32 00 30 00 4.3.2.0.
0008: 00 00 43 00 6f 00 6e 00 ..C.o.n.
0010: 66 00 69 00 67 00 4d 00 f.i.g.M.
0018: 67 00 72 00 2e 00 6d 00 g.r...m.
0020: 71 00 73 00 69 00 63 00 q.s.i.c.
0028: 72 00 65 00 61 00 74 00 r.e.a.t.
0030: 65 00 63 00 6f 00 6e 00 e.c.o.n.
0038: 66 00 69 00 67 00 6d 00 f.i.g.m.
0040: 67 00 72 00 00 00 46 00 g.r...F.
0048: 3a 00 5c 00 62 00 75 00 :.\.b.u.
0050: 69 00 6c 00 64 00 5c 00 i.l.d.\.
0058: 53 00 35 00 30 00 30 00 S.5.0.0.
0060: 5f 00 50 00 5c 00 73 00 _.P.\.s.
0068: 72 00 63 00 5c 00 44 00 r.c.\.D.
0070: 61 00 74 00 61 00 46 00 a.t.a.F.
0078: 6c 00 6f 00 77 00 45 00 l.o.w.E.
0080: 6e 00 67 00 69 00 6e 00 n.g.i.n.
0088: 65 00 5c 00 4e 00 61 00 e.\.N.a.
0090: 74 00 69 00 76 00 65 00 t.i.v.e.
0098: 54 00 72 00 61 00 63 00 T.r.a.c.
00a0: 65 00 5c 00 49 00 6d 00 e.\.I.m.
00a8: 62 00 4e 00 61 00 74 00 b.N.a.t.
00b0: 69 00 76 00 65 00 54 00 i.v.e.T.
00b8: 72 00 61 00 63 00 65 00 r.a.c.e.
00c0: 2e 00 63 00 70 00 70 00 ..c.p.p.
00c8: 00 00 36 00 38 00 31 00 ..6.8.1.
00d0: 00 00 43 00 6f 00 6e 00 ..C.o.n.
00d8: 66 00 69 00 67 00 75 00 f.i.g.u.
00e0: 72 00 61 00 74 00 69 00 r.a.t.i.
00e8: 6f 00 6e 00 44 00 61 00 o.n.D.a.
00f0: 74 00 61 00 2e 00 69 00 t.a...i.
00f8: 6e 00 69 00 74 00 69 00 n.i.t.i.
0100: 61 00 6c 00 69 00 7a 00 a.l.i.z.
0108: 65 00 00 00 43 00 6f 00 e...C.o.
0110: 6e 00 66 00 69 00 67 00 n.f.i.g.
0118: 4d 00 67 00 72 00 00 00 M.g.r...
0120: 43 00 6f 00 6e 00 66 00 C.o.n.f.
0128: 69 00 67 00 4d 00 67 00 i.g.M.g.
0130: 72 00 00 00 r...
System configuration:
_____________________
OS: Windows XP SP2
DB: DB2 UDB 8.2.1
WBIMB: 5.0 CSD 4
MQ: 5.3 CSD 10
When I try to connect to the database using the db2 command line or the ODBC test client the connection is successfull.
db2 => connect to CONFIG user wbiadmin using wbiadmin
Database Connection Information
Database server = DB2/NT 8.2.1
SQL authorization ID = WBIADMIN
Local database alias = CONFIG
db2 =>
When I try a manual restart of the DB2 Manager service it restarts succesfully.
2005-05-24-13.22.45.335000 Instance:DB2 Node:000
PID:5128(db2syscs.exe) TID:4940 Appid:none
base sys utilities DB2StartMain Probe:911
ADM7513W Database manager has started.
My "wbiadmin" user is a local computer and DB2 administrator as well as being listed in all the WBI and MQ security groups. I am also able to successfully run the mqsicreatebroker command using the "wbiadmin" username and password.
Any ideas? I am somewhat lost at this point. |
|
| Back to top |
|
 |
| sradiraju |
| Posted: Thu May 26, 2005 6:08 am Post subject: |
|
|
Apprentice
Joined: 08 Sep 2002
Posts: 34
Location: Chicago,IL
|
Hey Jason,
"No start database manager command was issued" this message usually comes when one of the DB2 service is not started. Could you check in the services if all the DB2 Services are started and try again.
Hope this helps.
Cheers,
Somesh |
|
| Back to top |
|
|
| Jason_Mannering |
| Posted: Thu May 26, 2005 6:32 am Post subject: |
|
|
Newbie
Joined: 24 Mar 2005
Posts: 8
Location: London
|
Somesh,
I have checked all the services and they all appear to be started
DB2 - DB2-0
DB2 Governer
DB2 Information Center Server
DB2 JDBC Applet Server
DB2 License Server
DB2 Remote Command Server
DB2 Security Server
DB2DAS - DB2DAS00
and I am not getting any DB2 error in my event log when I reboot my machine or after running the mqsicreateconfigmgr command.
I am beginning to think the mqsicreateconfigmgr command is trying to use a username and password other than the one I have specified as parameters when running the command.
Jason |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 26, 2005 6:37 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Is 'CONFIG' the name of the ODBC DSN, or the name of the DB2 database?
| infocenter wrote: |
-n DataBaseName
(Required) The name of the database that you created to hold the configuration repository tables. This database is the configuration repository for the whole broker domain, and contains configuration information for all resources, as well as data internal to the Configuration Manager.
This database must already exist. You do not need to create an ODBC connection for this database, because access is provided by JDBC.
|
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Jason_Mannering |
| Posted: Thu May 26, 2005 6:44 am Post subject: |
|
|
Newbie
Joined: 24 Mar 2005
Posts: 8
Location: London
|
It's ODBC name and DB name are both "CONFIG".
When I run the mqsicreateconfigmgr command with a DB name that does not exist it give me a "Database does not exist error". So it seems to find the databse when I use "CONFIG" as the DB name, but seems to think that it has not been started yet. |
|
| Back to top |
|
|
| JT |
| Posted: Thu May 26, 2005 7:03 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
See if you can obtain additional details by setting an ODBC trace: http://publib.boulder.ibm.com/infocenter/wbihelp/topic/com.ibm.etools.mft.doc/au14215_.htm#au14215_
Does the db2diag.log file have any information?
| Quote: |
| I am beginning to think the mqsicreateconfigmgr command is trying to use a username and password other than the one I have specified as parameters when running the command |
Although I don't believe that is the case, you can add the -u & -p paramaters to the mqsicreateconfigmgr command. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 26, 2005 7:16 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| JT wrote: |
| See if you can obtain additional details by setting an ODBC trace: |
That won't help here, I think. The ConfigMgr uses JDBC.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JT |
| Posted: Thu May 26, 2005 7:27 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| jefflowrey wrote: |
| JT wrote: |
| See if you can obtain additional details by setting an ODBC trace: |
That won't help here, I think. The ConfigMgr uses JDBC. |
 |
|
| Back to top |
|
|
| Saadat |
| Posted: Thu May 26, 2005 7:35 am Post subject: check the command |
|
|
Newbie
Joined: 16 May 2005
Posts: 5
Location: IBM Greenock, UK
|
I think you are missing the ID and password pair in the commnad
My commnad format:
---------------------------
MQSICREATECONFIGMGR -i brokerid -a password -q WBRK_QM -n WBRKCMDB -u brokerid -p password
Your commnad format:
---------------------------
mqsicreateconfigmgr -i wbiadmin -a wbiadmin -q CONFIG -n CONFIG |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 26, 2005 7:35 am Post subject: Re: check the command |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Saadat wrote: |
| I think you are missing the ID and password pair in the commnad |
It will/should use the broker service user if the db user is not specified.
It's worth a try, though.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Jason_Mannering |
| Posted: Thu May 26, 2005 7:44 am Post subject: |
|
|
Newbie
Joined: 24 Mar 2005
Posts: 8
Location: London
|
I have tried explcitly adding the DB username and password as follows:
mqsicreateconfigmgr -i wbiadmin -a wbiadmin -q CONFIG -n CONFIG -u wbiadmin -p wbiadmin
but this doesn't make any difference.
I think that if the error was due a bad user name and password then I would be getting an SQL30082N "User name and/or password invalid" error. |
|
| Back to top |
|
|
| JT |
| Posted: Thu May 26, 2005 8:36 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Did you........
| Quote: |
| When you create a DB2 database for the configuration repository, the default value for Database Heap Size is set to 600 (4 KB pages). WebSphere Business Integration Message Broker requires at least 900 pages, and you must modify this setting. If you create broker databases in DB2, you must make the same changes. |
|
|
| Back to top |
|
|
| Jason_Mannering |
| Posted: Thu May 26, 2005 8:49 am Post subject: |
|
|
Newbie
Joined: 24 Mar 2005
Posts: 8
Location: London
|
I have set the DBHEAP = 900 and have also set the APPLHEAPSZ = 1024 and the APPL_CTL_HEAP_SZ = 1024 as I have had trouble with before. I leave these I were to leave these set with the default values it does not make any difference.  |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Sun May 29, 2005 11:25 pm Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
I had to write all userids in uppercase to make it work.....
maybe that helps
_________________
Regards, Butcher |
|
| Back to top |
|
|
| Thripura Sundari |
| Posted: Fri Jul 08, 2005 6:51 am Post subject: bip8078e: DB2-DB-0 service not starting |
|
|
Acolyte
Joined: 13 Jun 2005
Posts: 57
Location: Bangalore, India
|
Hi all,
Well, Due to some problem, I had to install all the softwares again. I have CSD05 installed. when I give the create configuration manager command, I get the bip8078e error as Jason. But for me, not all the DB2 services are started. DB2 - DB2-0 is not starting and it says, service specifc error code 8000. Please help me.
Regards,
Thripura Sundari |
|
| Back to top |
|
|
|
|
