| Author |
Message
|
| sangminli |
 Posted: Wed Aug 27, 2008 7:17 pm Post subject: issue with backup broker db |
 |
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
i am trying to backup the broker database(in apatch derby) with DB2 CLP:
----------------------
db2 => connect to MQ643BDB user e502316 using AGE38y@@
Database Connection Information
Database server = Apache Derby CSS10020
SQL authorization ID = E502316
Local database alias = MQ643BDB
db2 => backup db MQ643BDB user e502316 using AGE38y@@ to C:\MQSIBackup
SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements:
Reason Code "0x124C"("021D")"".
-----------------------------
the db2 infocenter says:
124C The DRDA data stream for the request contains a syntax error.
has anyone ever met this issue before or could shed me some light?[/b] |
|
| Back to top |
|
 |
| sangminli |
| Posted: Wed Aug 27, 2008 11:57 pm Post subject: |
|
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
i just found the cause:
------------------------------------
db2 => connect to MQ643BDB user e502316 using AGE38y@@
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "127.0.0.1". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*".
SQLSTATE=08001
-----------------------
i tried 'db2set db2comm=tcpip', but it still shows me this error..
anyone could advise? |
|
| Back to top |
|
|
| sangminli |
| Posted: Thu Aug 28, 2008 12:09 am Post subject: |
|
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
| sangminli wrote: |
i just found the cause:
------------------------------------
db2 => connect to MQ643BDB user e502316 using AGE38y@@
SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "127.0.0.1". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*".
SQLSTATE=08001
-----------------------
i tried 'db2set db2comm=tcpip', but it still shows me this error..
anyone could advise? |
this is caused by the stops of db2 instance..
still, i am not able to backup the broker database..
-------------------
db2 => backup database MQ643BDB user e502316 using AGE38y@@ to C:\MQSIBackup
SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements:
Reason Code "0x124C"("021D")"". |
|
| Back to top |
|
|
| sangminli |
| Posted: Thu Aug 28, 2008 5:29 am Post subject: |
|
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
finally, i figured this out..
i got from the derby homepage that:
To back up a database, you can use the online backup utility. For information on this utility, see the Derby Server and Administration Guide.
then i checked the admin guide, and use the following cmds.
===========================
db2 => connect to MQ641BDB user e502316 using 8587220
Database Connection Information
Database server = Apache Derby CSS10020
SQL authorization ID = E502316
Local database alias = MQ641BDB
db2 => CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('c:/mybackups/2005-06-01')
Return Status = 0
========================
thanks god, they works!  |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 28, 2008 5:36 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You should not be using Derby for production environments.
You should not be using Derby for anything other than development environments...
Why do you need to back up Broker database for development environments? |
|
| Back to top |
|
|
| sangminli |
| Posted: Thu Aug 28, 2008 5:31 pm Post subject: |
|
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
| mqjeff wrote: |
You should not be using Derby for production environments.
You should not be using Derby for anything other than development environments...
Why do you need to back up Broker database for development environments? |
hi mqjeff, i am a newbie for wmb, so i just practise in the purpose of self-study..  |
|
| Back to top |
|
|
|
|
