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
