| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Broker migration from ver 5.0 to 6.0 |
« View previous topic :: View next topic » |
| Author |
Message
|
| rsk33 |
 Posted: Sun Mar 01, 2009 7:52 am Post subject: Broker migration from ver 5.0 to 6.0 |
 |
|
Centurion
Joined: 21 Aug 2006
Posts: 141
|
Dears,
while migrating the broker from ver 5 to 6, i got db2 error and migration failed. can any one help.
C:\Program Files\IBM\MQSI\6.0>mqsimigratecomponents BBEAID01
BIP8849I: Broker 'BBEAID01' (Version 5.0) with Queue Manager 'BBEAID01' and Data
Source 'BBDVBR01' specified for migration.
BIP8755I: Copied value 'QueueManagerName' into the new location
BIP8755I: Copied value 'DataSourceName' into the new location
BIP8755I: Copied value 'DataSourceUserId' into the new location
BIP8755I: Copied value 'DataSourcePassword' into the new location
BIP8755I: Copied value 'LilPath' into the new location
BIP8755I: Copied value 'StatisticsMajorInterval' into the new location
BIP8762I: Copied registry value from 'HttpListenerPort' to HTTP value 'port'; se
t to '7080'
BIP8755I: Copied value 'MigrationNeeded' into the new location
BIP8755I: Copied value 'MQTrustedQueueManager' into the new location
BIP8755I: Copied value 'UserNameServerQueueManagerName' into the new location
BIP8755I: Copied value 'PubSubAccessControl' into the new location
BIP8755I: Copied value 'ConfigurationTimeout' into the new location
BIP8755I: Copied value 'ConfigurationDelayTimeout' into the new location
BIP8755I: Copied value 'BrokerUUID' into the new location
BIP8762I: Copied registry value from 'HttpListenerTraceLevel' to HTTP value 'tra
ceLevel'; set to 'none'
BIP8762I: Copied registry value from 'HttpListenerTraceSize' to HTTP value 'trac
eSize'; set to '4194304'
BIP8755I: Copied value 'AdminAgentPID' into the new location
BIP8766I: Copied value 'UserId' for DSN 'ODSDB' into the new location
BIP8766I: Copied value 'Password' for DSN 'ODSDB' into the new location
BIP8766I: Copied value 'UserId' for DSN 'ODSINT' into the new location
BIP8766I: Copied value 'Password' for DSN 'ODSINT' into the new location
BIP8766I: Copied value 'UserId' for DSN 'RTPS' into the new location
BIP8766I: Copied value 'Password' for DSN 'RTPS' into the new location
BIP8763I: Deleted value 'QueueManagerName' from the old location
BIP8763I: Deleted value 'DataSourceName' from the old location
BIP8763I: Deleted value 'DataSourceUserId' from the old location
BIP8763I: Deleted value 'DataSourcePassword' from the old location
BIP8763I: Deleted value 'LilPath' from the old location
BIP8763I: Deleted value 'StatisticsMajorInterval' from the old location
BIP8763I: Deleted value 'HttpListenerPort' from the old location
BIP8763I: Deleted value 'MigrationNeeded' from the old location
BIP8763I: Deleted value 'MQTrustedQueueManager' from the old location
BIP8763I: Deleted value 'UserNameServerQueueManagerName' from the old location
BIP8763I: Deleted value 'PubSubAccessControl' from the old location
BIP8763I: Deleted value 'ConfigurationTimeout' from the old location
BIP8763I: Deleted value 'ConfigurationDelayTimeout' from the old location
BIP8763I: Deleted value 'BrokerUUID' from the old location
BIP8763I: Deleted value 'HttpListenerTraceLevel' from the old location
BIP8763I: Deleted value 'HttpListenerTraceSize' from the old location
BIP8763I: Deleted value 'AdminAgentPID' from the old location
BIP8768I: Finished registry migration for component 'BBEAID01'.
BIP8654I: Moving filesystem artefacts from 'C:\Documents and Settings\All Users\
Application Data\IBM\MQSI' to 'C:\Documents and Settings\All Users\Application D
ata\IBM\MQSI'
BIP8670I: Database migration started
BIP8663I: Creating temporary new tables
BIP8664I: Migrating from existing tables to temporary new tables
BIP8665I: Dropping existing tables
BIP8666I: Creating new tables
BIP8667I: Copying all rows from temporary new tables to new tables
BIP8668I: Dropping temporary new tables
BIP8070E: Exception accessing database table executing SQL statement 'INSERT INT
O DEVWMQID.BROKERRESOURCES_ (BrokerUUID, ExecGroupUUID, ResourceType, ResourceNa
me, ResourceData) SELECT BrokerUUID, ExecGroupUUID, ResourceType, ResourceName,
ResourceData FROM DEVWMQID.BROKERRESOURCES': SQL state '-964'; exception 'ImbEx
ception'.
An SQL command has failed.
Ensure that the broker's database is available. Examine the exception and SQL s
tate code to determine and correct the cause of the error.
BIP8671E: Database migration failed
BIP8673E: Migration of broker 'BBEAID01' from version 5.0.0.4 to version 6.0.0.3
failed, see previous messages for reasons.
BIP8672W: Rolling back database changes
BIP8684W: Rolling back WebSphere MQ changes
WebSphere MQ queue manager running.
BIP8785I: Starting WebSphere MQ queue migration for component 'BBEAID01'.
BIP8788I: Deleted WebSphere MQ queue 'SYSTEM.BROKER.TIMEOUT.QUEUE'
BIP8788I: Deleted WebSphere MQ queue 'SYSTEM.BROKER.AGGR.REQUEST'
BIP8788I: Deleted WebSphere MQ queue 'SYSTEM.BROKER.AGGR.CONTROL'
BIP8788I: Deleted WebSphere MQ queue 'SYSTEM.BROKER.AGGR.REPLY'
BIP8788I: Deleted WebSphere MQ queue 'SYSTEM.BROKER.AGGR.TIMEOUT'
BIP8788I: Deleted WebSphere MQ queue 'SYSTEM.BROKER.AGGR.UNKNOWN'
BIP8789I: Finished WebSphere MQ queue migration for component 'BBEAID01'.
BIP8686W: Finished Rolling back WebSphere MQ changes
BIP8685W: Rolling back Registry changes
BIP8755I: Copied value 'QueueManagerName' into the new location
BIP8755I: Copied value 'DataSourceName' into the new location
BIP8755I: Copied value 'DataSourceUserId' into the new location
BIP8755I: Copied value 'DataSourcePassword' into the new location
BIP8755I: Copied value 'LilPath' into the new location
BIP8755I: Copied value 'StatisticsMajorInterval' into the new location
BIP8755I: Copied value 'MigrationNeeded' into the new location
BIP8755I: Copied value 'MQTrustedQueueManager' into the new location
BIP8755I: Copied value 'UserNameServerQueueManagerName' into the new location
BIP8755I: Copied value 'PubSubAccessControl' into the new location
BIP8755I: Copied value 'ConfigurationTimeout' into the new location
BIP8755I: Copied value 'ConfigurationDelayTimeout' into the new location
BIP8755I: Copied value 'BrokerUUID' into the new location
BIP8755I: Copied value 'AdminAgentPID' into the new location
BIP8767W: Found registry value 'FADLevel' that is not valid in the target versio
n; not copied.
BIP8766I: Copied value 'UserId' for DSN 'ODSDB' into the new location
BIP8766I: Copied value 'Password' for DSN 'ODSDB' into the new location
BIP8766I: Copied value 'UserId' for DSN 'ODSINT' into the new location
BIP8766I: Copied value 'Password' for DSN 'ODSINT' into the new location
BIP8766I: Copied value 'UserId' for DSN 'RTPS' into the new location
BIP8766I: Copied value 'Password' for DSN 'RTPS' into the new location
BIP8762I: Copied registry value from 'traceLevel' to HTTP value 'HttpListenerTra
ceLevel'; set to 'none'
BIP8762I: Copied registry value from 'traceSize' to HTTP value 'HttpListenerTrac
eSize'; set to '4194304'
BIP8762I: Copied registry value from 'port' to HTTP value 'HttpListenerPort'; se
t to '7080'
BIP8763I: Deleted value 'port' from the old location
BIP8763I: Deleted value 'traceLevel' from the old location
BIP8763I: Deleted value 'traceSize' from the old location
BIP8763I: Deleted value 'QueueManagerName' from the old location
BIP8763I: Deleted value 'DataSourceName' from the old location
BIP8763I: Deleted value 'DataSourceUserId' from the old location
BIP8763I: Deleted value 'DataSourcePassword' from the old location
BIP8763I: Deleted value 'LilPath' from the old location
BIP8763I: Deleted value 'StatisticsMajorInterval' from the old location
BIP8763I: Deleted value 'MigrationNeeded' from the old location
BIP8763I: Deleted value 'MQTrustedQueueManager' from the old location
BIP8763I: Deleted value 'UserNameServerQueueManagerName' from the old location
BIP8763I: Deleted value 'PubSubAccessControl' from the old location
BIP8763I: Deleted value 'ConfigurationTimeout' from the old location
BIP8763I: Deleted value 'ConfigurationDelayTimeout' from the old location
BIP8763I: Deleted value 'BrokerUUID' from the old location
BIP8763I: Deleted value 'AdminAgentPID' from the old location
BIP8763I: Deleted value 'FADLevel' from the old location
BIP8768I: Finished registry migration for component 'BBEAID01'.
BIP8654I: Moving filesystem artefacts from 'C:\Documents and Settings\All Users\
Application Data\IBM\MQSI' to 'C:\Documents and Settings\All Users\Application D
ata\IBM\MQSI'
BIP8687W: Finished Rolling back Registry changes
BIP8851S: Migration Failed
One of the migration steps failed, please see messages above for more details.
Regards |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sun Mar 01, 2009 9:18 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Quote: |
BIP8070E: Exception accessing database table executing SQL statement
'INSERT INTO DEVWMQID.BROKERRESOURCES_ (BrokerUUID, ExecGroupUUID, ResourceType, ResourceNa
me, ResourceData)
SELECT BrokerUUID, ExecGroupUUID, ResourceType, ResourceName,
ResourceData FROM DEVWMQID.BROKERRESOURCES':
SQL state '-964';
exception 'ImbException'.
An SQL command has failed.
Ensure that the broker's database is available.
Examine the exception and SQL state code to determine and correct the cause of the error.
BIP8671E: Database migration failed
BIP8673E: Migration of broker 'BBEAID01' from version 5.0.0.4 to version 6.0.0.3
failed, see previous messages for reasons.
BIP8672W: Rolling back database changes
BIP8684W: Rolling back WebSphere MQ changes
|
The exception seems quite clear. What was your question? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| rsk33 |
| Posted: Sun Mar 01, 2009 10:25 pm Post subject: |
|
|
Centurion
Joined: 21 Aug 2006
Posts: 141
|
Thanks for the reply..
I did not get the error code explanation (SQL state '-964' on the net.
I got from db2 log file. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Mar 01, 2009 11:17 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Thats funny as my google for
produces over 3000 hits.
I would suggest that you look in the system event log for other DB2 errors/warnings as well. I know where I would start looking.
Perhaps your V5 DB2 Broker Database was created with the OOTB parameters and you have applied a few fixpaks since and not look at the DB2 tuning?
For my 2p worth, I would never do the migration like this. I would create a clean DB2, WMQ & WBI configuration (scripted naturally). How else can you satisfy the Auditors when they say 'what happens when this system goes belly up?'. Are you seriously going to have to install, apply the fixpacks, configure & deploy V5 and then do the migration again and somehow you forgot to document some vital step that made it all work and your production system is down for days rather than an hour or so.
Unless, for some reason you have a few flows that you no longer have the source code to? but that is a separate can of worms...
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| 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
|
|
|
|
