By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,262 Members | 1,125 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,262 IT Pros & Developers. It's quick & easy.

Trouble connecting to databases from DB2 9 - Command Center

P: n/a
I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem connecting
to sample (or any other databases - local or remote), but if I try to
connect from Command Editor I'm not able to do that. There is no error
message, the Progress dialog just run and run without anything happening.

Is this a bug in DB2 9, or maybe some configuration issue on my part ?

I'm using Windows XP.

Regards
Odd B Andersen
Oct 23 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
How about posting the exact command you are entering?

Larry Edelstein

Odd Bjørn Andersen wrote:
I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem connecting
to sample (or any other databases - local or remote), but if I try to
connect from Command Editor I'm not able to do that. There is no error
message, the Progress dialog just run and run without anything happening.

Is this a bug in DB2 9, or maybe some configuration issue on my part ?

I'm using Windows XP.

Regards
Odd B Andersen

Oct 23 '06 #2

P: n/a
The command is just:
connect to sample user username using password

If I try the same from a command windows, like:
db2 connect to sample user username using password

the connect works fine. But not from the Command Editor. I have not been
able to work out what's happening.

regards
Odd B
..
"Larry" <la***@nospam.netwrote in message
news:WK**************@newsfe10.lga...
How about posting the exact command you are entering?

Larry Edelstein

Odd Bjørn Andersen wrote:
>I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem
connecting to sample (or any other databases - local or remote), but if I
try to connect from Command Editor I'm not able to do that. There is no
error message, the Progress dialog just run and run without anything
happening.

Is this a bug in DB2 9, or maybe some configuration issue on my part ?

I'm using Windows XP.

Regards
Odd B Andersen

Oct 24 '06 #3

P: n/a
What Type of Install did you do.... I have the same problem when I
install DB2 v9 with UDB v8.2. DB2v9 bacially it needed it's own
Database directory to connect to. I did not know if this was a problem
related to two different verison of DB2 on a Windows work station.
But since DB2v9 created another instance on my workstation it only made
since that I would need to catalog my old databases to that instance.

That task is very easy to do by exporing the UDBv8 database profiles
and importing them onto DB2v9. Remember you will need to change the
DB2INSTANCE= Parm with db2set when changing from UDBv8 to DB2v9.
Odd Bjørn Andersen wrote:
The command is just:
connect to sample user username using password

If I try the same from a command windows, like:
db2 connect to sample user username using password

the connect works fine. But not from the Command Editor. I have not been
able to work out what's happening.

regards
Odd B
.
"Larry" <la***@nospam.netwrote in message
news:WK**************@newsfe10.lga...
How about posting the exact command you are entering?

Larry Edelstein

Odd Bjørn Andersen wrote:
I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem
connecting to sample (or any other databases - local or remote), but if I
try to connect from Command Editor I'm not able to do that. There is no
error message, the Progress dialog just run and run without anything
happening.

Is this a bug in DB2 9, or maybe some configuration issue on my part ?

I'm using Windows XP.

Regards
Odd B Andersen
Oct 24 '06 #4

P: n/a
I did a clean install of Db2 9. That is, I had db2 8.2 installed, but
uninstalled that version before installing version 9. The parameter
DB2INSTANCE is set as an environment variable, and seemed not valid to set
with the db2set command, I had to use the OS command 'set'.

Regards
Odd B

"doug" <do*********@db2helpdesk.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
What Type of Install did you do.... I have the same problem when I
install DB2 v9 with UDB v8.2. DB2v9 bacially it needed it's own
Database directory to connect to. I did not know if this was a problem
related to two different verison of DB2 on a Windows work station.
But since DB2v9 created another instance on my workstation it only made
since that I would need to catalog my old databases to that instance.

That task is very easy to do by exporing the UDBv8 database profiles
and importing them onto DB2v9. Remember you will need to change the
DB2INSTANCE= Parm with db2set when changing from UDBv8 to DB2v9.
Odd Bjørn Andersen wrote:
The command is just:
connect to sample user username using password

If I try the same from a command windows, like:
db2 connect to sample user username using password

the connect works fine. But not from the Command Editor. I have not been
able to work out what's happening.

regards
Odd B
.
"Larry" <la***@nospam.netwrote in message
news:WK**************@newsfe10.lga...
How about posting the exact command you are entering?

Larry Edelstein

Odd Bjørn Andersen wrote:
I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem
connecting to sample (or any other databases - local or remote), but if
I
try to connect from Command Editor I'm not able to do that. There is no
error message, the Progress dialog just run and run without anything
happening.

Is this a bug in DB2 9, or maybe some configuration issue on my part ?

I'm using Windows XP.

Regards
Odd B Andersen

Oct 25 '06 #5

P: n/a
I have now solved this - sort of......

I had exported all configuration from a version 8.2 installation, and
imported this into my new version 9 installation. It seems that this was the
reason to my problems. After I uncataloged all the cataloged tcpip
nodes/databases, except the sample and toolsdb created dureinf/after
installation of version 9, I was able to connect to sample from Command
Editor.

But now I have encountered another problem. Concerning security and
authorizations..... I am not able to catalogue any nodes or databases on my
system. I get the message: " "OAND " does not have the authorization
to.....". I installed db2 on my system logged on as user <domain>\oand, and
somewhere during installation, asked for a username, I supplied the local
username db2admin which is the user I want to use exclusively for db2. But I
will always be logged on my system as the network user (<domain>\oand).

How can I assure that my network user is granted all the necessary
authorizations in db2. The user is now member of both the local
Administrators group and the sysadm group. But that is obviously not enough.
What other user rights is necessary ?

Regards
Odd B

"doug" <do*********@db2helpdesk.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
What Type of Install did you do.... I have the same problem when I
install DB2 v9 with UDB v8.2. DB2v9 bacially it needed it's own
Database directory to connect to. I did not know if this was a problem
related to two different verison of DB2 on a Windows work station.
But since DB2v9 created another instance on my workstation it only made
since that I would need to catalog my old databases to that instance.

That task is very easy to do by exporing the UDBv8 database profiles
and importing them onto DB2v9. Remember you will need to change the
DB2INSTANCE= Parm with db2set when changing from UDBv8 to DB2v9.
Odd Bjørn Andersen wrote:
The command is just:
connect to sample user username using password

If I try the same from a command windows, like:
db2 connect to sample user username using password

the connect works fine. But not from the Command Editor. I have not been
able to work out what's happening.

regards
Odd B
.
"Larry" <la***@nospam.netwrote in message
news:WK**************@newsfe10.lga...
How about posting the exact command you are entering?

Larry Edelstein

Odd Bjørn Andersen wrote:
I have installed DB2 9 Enterprise Edition on my laptop and created the
sample database. Now I'm having truble connecting to the database from
Command Editor. If I connect from Command Window it's no problem
connecting to sample (or any other databases - local or remote), but if
I
try to connect from Command Editor I'm not able to do that. There is no
error message, the Progress dialog just run and run without anything
happening.

Is this a bug in DB2 9, or maybe some configuration issue on my part ?

I'm using Windows XP.

Regards
Odd B Andersen

Oct 25 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.