470,591 Members | 1,558 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

Express-C and Remote Desktop

Let's say that we have 2 users on Win XP PRO SP2 and they are both in
DB2ADMNS group:
USER1
USER2

When I login with USER1 to console I can normaly use database (connect,
select ...).
If I logout and login with USER2 I can still normaly use database as new
user.

But if I first login as USER1 and then use the option Fast user switching
to login USER2 then I cannot use the database with newly logged in USER2.
When I try to connect to db I always get an error : No start database
manager ...

It is also the same when using Remote Desktop.
If I login as user that is using console then you can work with db, but if
I login as different user then I always get an error.

I tried it on two different computers with Win XP PRO SP2 and the behaviour
is the same.

I tried it also on WIN 2000 Server and the database is working fine no
matter which user is logged in and how (console or Remote Desktop).
Is this happening only on Win XP SP2?
Machine OS : WIN XP Pro SP2

C:\>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09010" with
level identifier "02010107".
Informational tokens are "DB2 v9.1.0.356", "s060629", "NT32", and Fix Pack
"0".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name
"DB2COPY1".
C:\>db2 connect to TEST user USER2 using PASS2
SQL1032N No start database manager command was issued. SQLSTATE=57019

C:\>db2start
SQL1026N The database manager is already active.

C:\>db2stop
SQL1064N DB2STOP processing was successful.

C:\>db2start
SQL1063N DB2START processing was successful.

C:\>db2 connect to TEST user USER2 using PASS2
SQL1032N No start database manager command was issued. SQLSTATE=57019

What is going on?

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Oct 24 '06 #1
0 1361

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bootstrap Bill | last post: by
5 posts views Thread by RDV | last post: by
1 post views Thread by Darryl Kerkeslager | last post: by
10 posts views Thread by Bonj | last post: by
3 posts views Thread by msnews.microsoft.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.