| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| urgent help !!! BIP1510E error |
« View previous topic :: View next topic » |
| Author |
Message
|
| genestep |
 Posted: Sun Jun 16, 2002 11:17 pm Post subject: urgent help !!! BIP1510E error |
 |
|
Apprentice
Joined: 16 Apr 2002
Posts: 43
Location: France
|
Hi all,
I have a problem with deployment. I made a mistake : i tryed to deploy a message flow on a remote machin which didn't exist. Now i must use forced deployment to deploy flow on my development machin. Is is possible to cancel this deployment in config manager ???
Thanks for your answers
Philippe |
|
| Back to top |
|
 |
| TorpedoSTu |
| Posted: Mon Jun 17, 2002 3:19 am Post subject: |
|
|
Acolyte
Joined: 14 Nov 2001
Posts: 73
|
Phillppe, yes it is ... but only by using DB2 SQL against the Config Manager Database.
Here's a couple of db2 scripts which you can use at your own risk. I suggest that you back up the config manager database before doing so.
Regs
Stuart
This one removes a broker from the config manager database.
The '0a34%%' is the first 4 characters of the UUID of the broker.
DB2 CONNECT TO D1CFG USER d1wmqi USING d1wmqi
DB2 DELETE FROM D1WMQI.CBROKER WHERE CUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CCOLLECTIVE WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CCOLLECTIVECBROKER WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CDELETED WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CEG WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CEGCMSGFLOW WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CEGCMSGPROJECT WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CLOG WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CMSGFLOW WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CMSGPROJECT WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CNEIGHBOURS WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.COUTSTANDING WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CPROPERTIES WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CSUBSCRIBE WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CTOPIC WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CTOPICCTOPIC WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CTOPOLOGY WHERE CBROKERCUUID LIKE '0a34%%'
DB2 DELETE FROM D1WMQI.CCOLLECTIVE WHERE CBROKERCUUID LIKE '0a34%%'
This one removes a deploy for a broker
if "%1" == "" goto cmdHelp
if "%2" == "" goto cmdHelp
goto db2Commands
:cmdHelp
echo ***
echo *** usage : frbd UUID ConfigMgrDb [schema] [UserName] [Password]
echo *** Note a '%%' is appended to the supplied UUID for you
echo ***
goto end
:db2Commands
echo.
if "%4" == "" goto npwd
db2 connect to %2 user %4 using %5
if errorlevel 1 goto errorConnect
goto brdel
:npwd
db2 connect to %2
goto brdel
:brdel
if "%3" == "" goto noschema
echo *** Removing Broker %1 Deploy From Configuration Manager
DB2 "DELETE FROM D1WMQI.CBROKER WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CCOLLECTIVE WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CCOLLECTIVECBROKER WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CEG WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CEGCMSGFLOW WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CEGCMSGPROJECT WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CLOG WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CMSGFLOW WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CMSGPROJECT WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CNEIGHBOURS WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.COUTSTANDING WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM D1WMQI.CTOPOLOGY WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
goto end
:noschema
echo *** Removing Broker %1 Deploy From Configuration Manager
DB2 "DELETE FROM CBROKER WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CCOLLECTIVE WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CCOLLECTIVECBROKER WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CEG WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CEGCMSGFLOW WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CEGCMSGPROJECT WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CLOG WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CMSGFLOW WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CMSGPROJECT WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CNEIGHBOURS WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM COUTSTANDING WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
DB2 "DELETE FROM CTOPOLOGY WHERE CSECTION NOT IN ('SHARED','DEPLED','GENRAL','DEFINI') AND CBROKERCUUID LIKE '%1%%'"
if errorlevel 2 goto errorDelete
goto end
:errorDelete
echo.
echo +++++ Deletion FAILED!! Check the SQL Errors above +++++
echo.
goto end
:errorConnect
echo.
echo +++++ DB2 Connect FAILED!! Check the Supplied DBName, Uid and password +++++
echo.
:end |
|
| Back to top |
|
|
| genestep |
| Posted: Mon Jun 17, 2002 11:18 pm Post subject: |
|
|
Apprentice
Joined: 16 Apr 2002
Posts: 43
Location: France
|
Hi Stuart
Thanks for your script, it works perfectly (i just change in cmd file, the schema part in SQL scripts (%3 instead of D1WMQI.Table)
Thanks a lot !!!! 
Philippe |
|
| Back to top |
|
|
| asudhakar |
| Posted: Sat Jan 31, 2009 4:08 am Post subject: |
|
|
Centurion
Joined: 12 May 2007
Posts: 116
Location: Bangalore
|
| genestep wrote: |
Hi Stuart
Thanks for your script, it works perfectly (i just change in cmd file, the schema part in SQL scripts (%3 instead of D1WMQI.Table)
Thanks a lot !!!!
Philippe |
Hi,
In MB6.0,
Config Mgr will not support DB.
So.... how can we solove the problem (Prob : Not able to deploy bar file in broker)
_________________
WebSphere MQ, MB Support and Admin |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Jan 31, 2009 4:48 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| asudhakar wrote: |
| genestep wrote: |
Hi Stuart
Thanks for your script, it works perfectly (i just change in cmd file, the schema part in SQL scripts (%3 instead of D1WMQI.Table)
Thanks a lot !!!!
Philippe |
Hi,
In MB6.0,
Config Mgr will not support DB.
So.... how can we solove the problem (Prob : Not able to deploy bar file in broker) |
The config mgr proxy will help. You can also cancel a deployment to a broker using the toolkit. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
