| Author |
Message
|
| JohnSmith |
 Posted: Thu Apr 08, 2010 9:13 pm Post subject: command is not valid for databases that reside on DRDA hosts |
 |
|
Voyager
Joined: 17 Mar 2010
Posts: 86
|
Hi All,
I am using Derby database on windows for Message Broker development environment on my system. I have DB2 run time client installed on my machine. From the DB2 command window I connected to Derby database(created earlier) and try to list all the tables present in that database using the below mentioned command -
db2 => list tables but I am getting the below error while executing this command -
"The command is not valid for databases that reside on DRDA hosts"
What could be the reason for the same? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Apr 09, 2010 5:23 am Post subject: Re: command is not valid for databases that reside on DRDA h |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| JohnSmith wrote: |
| What could be the reason for the same? |
What is the reason for looking in the Derby database? There's nothing useful in there from a broker user perspective, and it's not a good place to store user data.
Both of these topics have previously been discussed. I'd also imagine that, if you have a DB2 client installed, there's a DB2 server someplace that would be a better place for your data. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| JohnSmith |
| Posted: Mon Apr 12, 2010 12:50 am Post subject: |
|
|
Voyager
Joined: 17 Mar 2010
Posts: 86
|
Hi Vitor,
Thanks for your reply. As you wrote :
| Quote: |
| What is the reason for looking in the Derby database? |
that is a design question but right now I am looking for why I am getting error while running the command. Anyway I installed SQuirrel SQL client and able to connect and issue commands to the derby database. |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Apr 12, 2010 6:41 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| JohnSmith wrote: |
| that is a design question |
Fair point. It's a design question that should be questioned for the reasons I allude to above.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| JohnSmith |
| Posted: Tue Apr 13, 2010 12:33 am Post subject: |
|
|
Voyager
Joined: 17 Mar 2010
Posts: 86
|
| Quote: |
| Fair point. It's a design question that should be questioned for the reasons I allude to above. |
to answer your question, If I install DB2 or Oracle client and connect to a Db2 server located somewhere and managed by an infrastructure team, I need to raise a service request even inserting some simple data which has SLA of 3 working days, that long I can not wait. 
And, If I go ahead in installing DB2 server or any other database on my development machine I would need 4 levels of management approval
so no choice my dear... |
|
| Back to top |
|
|
|
|
