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

Express-C and Remote Desktop

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.