473,224 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Problem with DB2 and Windows 2000

================================================== ==========
About DB2 Administration Tools Environment
================================================== ==========
DB2 administration tools level:
Product identifier SQL08015
Level identifier 02060106
Level DB2 v8.1.5.449
Build level s040212
PTF WR21334
================================================== ==========
Java development kit (JDK):
Level IBM Corporation 1.3.1
================================================== ==========

After installing the full DB2, we lost all our shared drives (novell)
we are running windows 2000. If we log off and back on the script to
connect to the shared drives exicutes without a problem... It only
happens when we come into the system cold.....
(I am posting this also on the windows news group)
Nov 12 '05 #1
3 2317
When you say "Shared drives" do you mean \\server\share access, which should
work for domain logons, or "net use x: \\server\share" and access via x:?

If you mean the second, I am amazed it ever worked on your system, as local
DOS device namespaces were not implemented until XP and 2003, and you're on
2000. On 2000, the DOS device namespace is global, but security is local to
the logon session. SP2 for 2000 changed the default behaviour to remove
global devices at logoff.

---

From the MS documentation:

Defining an MS-DOS Device Name
An MS-DOS device name is a junction that points to the path of an MS-DOS
device. These junctions comprise the MS-DOS device namespace. Call the
DefineDosDevice and SetVolumeMountPoint functions to create and modify these
junctions. DeleteVolumeMountPoint deletes a junction created by
SetVolumeMountPoint, and DefineDosDevice deletes junctions it creates.
After an MS-DOS device name is defined, it remains visible to all processes.
Before Windows 2000 SP2, a device name remained globally visible until
either explicitly removed or the system restarted. Security issues made
changes to this policy necessary in later versions of Windows.

Starting with Windows 2000 SP2, when a user that is logged in through an
interactive console session (that is, by running a console application on a
local machine), any drive letters defined by running a program that calls
DefineDosDevice are deleted when the interactive console user logs out.
Also, a security policy is implemented regulating the circumstances under
which drive letters can be deleted. This deletion policy is defined as
follows:
a.. If the user attempting the deletion is logged in as an Administrator,
or another account that belongs to the Administrator group, the user can
delete any drive letter.
b.. If the user attempting the deletion is not logged in as an
Administrator, and is logged in though the interactive console session, the
user can delete any drive letter except those created by other users logged
in as Administrators through logon sessions that are not the interactive
console session, such as background scheduled tasks or during system
startup.
c.. If the user attempting the deletion is not logged in as an
Administrator, and is logged in though a logon session that is not the
interactive console session, the user can delete only the drive letters that
he or she has created during the session.
This security fix does not affect Terminal Services sessions, because each
Terminal Services session defines its own MS-DOS Device namespace.

In Windows 2000 SP2 and earlier, calls to QueryDosDevice return all MS-DOS
devices that have been defined on the local machine.

In Windows XP, the policy changes defined in Windows 2000 SP2 were removed
and replaced with an architecture based on the following:
a.. All MS-DOS devices are identified by Windows through an authentication
ID. An authentication ID is the LUID (locally unique identifier) associated
with each logon session when created.
b.. The visibility of an MS-DOS device names is categorized as global or
local, and is defined as such by its inclusion in the Global MS-DOS Device
and Local MS-DOS Device namespaces. The contents of MS-DOS devices in the
Global namespace can be accessed by all users, and the contents of MS-DOS
devices in the Local namespace can be accessed only by the user whose access
token contains the AuthenticationID associated with that Local MS-DOS device
namespace
Multiple Local MS-DOS Device namespaces and only one Global MS-DOS Device
namespace may exist at one time and on one machine.

Note that only processes running in the LocalSystem context can call
DefineDosDevice to create an MS-DOS device in the Global MS-DOS device
namespace. Also, the Local MS-DOS device namespace corresponding to a
specific AuthenticationID is deleted when the last reference to that
AuthenticationID is removed.

When your code queries an existing MS-DOS device name by calling
QueryDosDevice, it first searches the Local MS-DOS Device namespace. If it
is not found there, the function will then search the Global MS-DOS Device
namespace. When your code queries all existing MS-DOS device names through
this function, the list of names that are returned is dependent on whether
it is running in the LocalSystem context. If so, only the MS-DOS device
names included in the Global MS-DOS Device namespace will be returned. If
not, a concatenation of the device names in the Global and Local MS-DOS
Device namespaces will be returned. If a device name exists in both
namespaces, QueryDosDevice will return the entry in the Local MS-DOS Device
namespace. This also applies to the list of all MS-DOS device names returned
by GetLogicalDrives and GetLogicalDriveStrings.

Note that the following scenario may occur:

1.. User A, who is not running within the LocalSystem context, creates a
device name in the corresponding Local MS-DOS Device namespace, and that
device name does not exist in the Global MS-DOS Device namespace.
2.. User B, who is running within the LocalSystem context, creates the
same device name in the Global MS-DOS Device namespace.
In this scenario, User A will not have access to the device name in the
Global MS-DOS Device namespace until he or she removes or renames the device
name in his or her Local MS-DOS Device namespace. To reduce the likelihood
of this scenario occurring, MS-DOS drive letters should be allocated in the
Global MS-DOS Device namespace starting with C: and ending with Z:. This
sequence should be reversed for the allocation of MS-DOS drive letters in
the Local MS-DOS Device namespace.

If you are not running within the LocalSystem context, DefineDosDevice will
not allow you to define a device name in the Local MS-DOS Device namespace
if that device name already exists in your Local or Global MS-DOS Device
namespaces. Call QueryDosDevice before calling DefineDosDevice to determine
whether the device name you intend to define exists in your MS-DOS Device
namespaces.

"Steven Fox" <st********@dfas.mil> wrote in message
news:25**************************@posting.google.c om...
================================================== ==========
About DB2 Administration Tools Environment
================================================== ==========
DB2 administration tools level:
Product identifier SQL08015
Level identifier 02060106
Level DB2 v8.1.5.449
Build level s040212
PTF WR21334
================================================== ==========
Java development kit (JDK):
Level IBM Corporation 1.3.1
================================================== ==========

After installing the full DB2, we lost all our shared drives (novell)
we are running windows 2000. If we log off and back on the script to
connect to the shared drives exicutes without a problem... It only
happens when we come into the system cold.....
(I am posting this also on the windows news group)

Nov 12 '05 #2
Gut feeling :
novell login with drive allocations isn't finished before db2 starts.
e.g. drives are not present at the time db2 is referencing/looking for them.

PM

"Steven Fox" <st********@dfas.mil> a écrit dans le message de
news:25**************************@posting.google.c om...
================================================== ==========
About DB2 Administration Tools Environment
================================================== ==========
DB2 administration tools level:
Product identifier SQL08015
Level identifier 02060106
Level DB2 v8.1.5.449
Build level s040212
PTF WR21334
================================================== ==========
Java development kit (JDK):
Level IBM Corporation 1.3.1
================================================== ==========

After installing the full DB2, we lost all our shared drives (novell)
we are running windows 2000. If we log off and back on the script to
connect to the shared drives exicutes without a problem... It only
happens when we come into the system cold.....
(I am posting this also on the windows news group)

Nov 12 '05 #3
I doubt if it's even relevant when Novell drive mappings are finished, as
they running in a different logon session from DB2 and consequently are not
supposed to "work". WK2 SP2 closed the security loophole, WXP and W2K3 fixed
the problem by adding local namespaces (thus your X: and my X: are different
X:'s).
"PM (pm3iinc-nospam) CGO" <PM (pm3iinc-nospam)@cgocable.ca> wrote in message
news:E5*****************@charlie.risq.qc.ca...
Gut feeling :
novell login with drive allocations isn't finished before db2 starts.
e.g. drives are not present at the time db2 is referencing/looking for them.
PM

"Steven Fox" <st********@dfas.mil> a écrit dans le message de
news:25**************************@posting.google.c om...
================================================== ==========
About DB2 Administration Tools Environment
================================================== ==========
DB2 administration tools level:
Product identifier SQL08015
Level identifier 02060106
Level DB2 v8.1.5.449
Build level s040212
PTF WR21334
================================================== ==========
Java development kit (JDK):
Level IBM Corporation 1.3.1
================================================== ==========

After installing the full DB2, we lost all our shared drives (novell)
we are running windows 2000. If we log off and back on the script to
connect to the shared drives exicutes without a problem... It only
happens when we come into the system cold.....
(I am posting this also on the windows news group)


Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Wolfgang Kaml | last post by:
Hello All, I have been researching newsgroups and knowledgebase all morning and not found a solution that would solve the problem I have. I am having an ASP or ASPX web page that implement a...
1
by: Marino | last post by:
Hi all, I have a Windows 2003 server, which is also a terminal server for application, with sql 2000 installed. My company has developed an application that uses SQL 2000 as its database. The...
1
by: santhosh_176 | last post by:
:I Created a Pocket PC application for iPAQ 5450. Every thing went fine even installer creation. I could run the setup and install it into the actual device and worked fine. The application enables...
0
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
0
by: Ruth Craig | last post by:
We recently upgraded some of our department's machines from WINNT to Windows 2000. Up until this point, we were running Access 2000 on WINNT and had no problems with our databases. After the...
1
by: Badboy36 | last post by:
Hello user from googlegroups, i made a microsoft access database with front and backend. i created the backend in microsoft access97. for the frontend i made two versions (one for microsoft...
4
by: Benny | last post by:
Hello Experts, I have developed a windows application using vs.net 2002 with C#. The customers loves it and everything works fine on windows XP. However, when I deployed the application on a...
2
by: Vaap | last post by:
I did lot of googling to see if I can solve the SQL server not found problem while trying to run ASP.Net community starter kit from an XP machine to Windows 2003 server hosting SQL server 2000...
9
by: dotnetfellow | last post by:
The system has worked for two years. SQL Server 2000 runs on Windows 2000 Server "A". Another instance of SQL Server 2000 was moved from Windows 2000 Server "B" old to Windows 2003 Server "B"...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.