472,988 Members | 2,600 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

V9 runtime client setup problems

Helpful folks,

We recently upgraded DB2 V7 to V8 on Windows 2003 Enterprise Edition.
The plan is to migrate to V9 as soon as possible. In anticipation of
that migration, IT management has decided that all our user desktop
workstations (a few hundred) should be upgraded to the V9 runtime
client before we migrate the server to V9. This upgrade process will
be automated using a response file.

Our authentication model is set to CLIENT at the server, such that
authentication takes place on each user desktop when they login. (I
know this is badness, but we can't change it yet.) The DB2 Security
Service, which runs on each workstation provides this functionality.
The V9 client install process does not support installing over a V7
client, so I must uninstall the V7 client, then install the V9 client.

However, when I attempt to install the V9 runtime client on a "clean"
box, nothing I try will install the DB2 Security Service. I've tried
toggling just about every parameter in the response file, but to no
avail. A DB2 Management Service appears, but not the security service.
Does anyone know how to get the V9 runtime client setup program to
install the security service? And why in the world does the setup
program for a runtime client install an instance of DB2 on a client

Any help or suggestions would be greatly appreciated.

Jul 10 '08 #1
2 2784
Scav wrote:
And why in the world does the setup
program for a runtime client install an instance of DB2 on a client
Common misconception. An instance is *NOT* a server. It is an
*environment*. It is an environment under which applications may run DB2
applications. It just so happens that one of the biggest and most
pervasive DB2 applications might just be the DB2 server itself.

This environment tells applications where to load DB2 libraries (DLLs on
Windows), and tells DB2 where to find its own configuration, both for
reading and for updating. This configuration includes local databases for
the server, and remote nodes and databases for client applications. This
allows applications to simply connect to "mydb" and not care whether the
database named "mydb" is local or remote, or even if it's on a mainframe,
or if it's anything else supported by the DB2 Client (I think it includes
Informix and maybe even Cloudscape, but can't recall offhand for sure).
The client configuration, which exists even in the servers, will handle
that abstraction.

So why are there instances? To be able to have multiple such configurations
on a single machine. Not quite so useful on single-user machines, but
still can be useful when you want to better isolate two apps such that they
don't accidentally connect to the wrong database by having more than one
database cataloged. Or if you're just testing your app - you can have your
production configuration in one instance, and a test configuration in
another, both with the same database name cataloged, but connecting to
different databases at the other end (either different nodes, or different
real database names, or both) - you just have to switch between instances
when you go to test, and back when you need to work with the production

Not everyone needs them, but those who do can find it invaluable.
Jul 10 '08 #2
Hello, Sean:

Did some v91 RTCL install testing myself. Both "DB2 Management
Service (copyName)" and "DB2 Security Server (copyName)" services were
created after the DB2 Runtime Client was installed, even in a Compact
install where only the core component was installed.
Thus, please try the v91 runtime Client install on a clean machine

By the way, also checked the V9.5 DB2 products. The "DB2 Security
Server" service is no longer available in v95, even in the server
products (eg. ESE). Thus, it will not be created by the db2 install,
ESE or RTCL. This would be a design decision in v95. Which version
DB2 did you test? FYI, DB2 9 means v9.1.

Regarding to the v7 to v9 migration you are going to do, since the
directly migration from v7 to v91 (or v95) is not supported, there are
two options you can choose:
(1). 2 steps migration:
1). Migrate v7 db2 to v8
2). Then, migrate v8 db2 to v91 or v95
The good thing for this option is the v91 db2 will be configured
in the same (or similar) way when the migration install is completed
(2). This is what you said earlier, to uninstall v7 db2, and then
install the new version DB2 (v91 or v95).
You can export/import the configuration, or configure it
manually after the v9 db2 is installed.


.. I believe there should be some request to remove it in the v95ga
Jul 11 '08 #3

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

Similar topics

by: Jae | last post by:
I've been having major problems installing Linux Runtime on slackware, but i think im close. My current problem is strange and I've searched the net and found very little im getting the error when...
by: MLH | last post by:
I am concerned. I have recently moved to A97 from Access 2.0 where I rolled out runtime apps with the ADT. Now, the Office Pro Developer's Edition with Access 97 is what I'm using. I find some...
by: summerwind | last post by:
I have distributed my app to a few users without problems (Not too many anyway) using the packaging wizard. I now have a problem that it causing me a great deal of concern. My client has no MS...
by: Owen Jenkins | last post by:
I have an Access application that is being used by 150+ clients. I develop in 97, convert to 2000 and distribute as a 97 or 2000 mde, or 97 runtime. This limits me to 97 functions. My clients may...
by: ruvi | last post by:
I am getting runtime error 3021 - Either EOF or BOF is true or the current record has been deleted..... I have 2 combo boxes in a form- One for the client and the other for the project. When the...
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require...
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many...
by: SMcK | last post by:
I have a PDA-based (Syware Visual CE) database which I need to sync to an Access database. The Access database contains three tables: 1 is the data itself, 2 is a linked table that prefills...
by: Jean-Marc Blaise | last post by:
Hi, I've been trying for 2 hours to install in silent mode a DB2 9 runtime client. Why didn't you make this process as simple as for the CLIENT install ? It is not the same setup command, you...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

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.