Assuming the following setup:
Server1 running DB2 V8.2 with two databases DB_1 and DB_2:
db2 catalog db DB_1 as CURR_DB
Server2 DB2 runtime client:
db2 catalog tcpip node S1 remote Server1 ...
db2 catalog db CURR_DB at node S1
Now, if I do:
db2 uncatalog db CURR_DB
db2 catalog db DB_2 as CURR_DB
on Server_1, what does it take to get Server_2 to understand that it
should talk to DB_2 instead of DB_1? Forcing all applications does not
seem to help. So far the only way that seems failsafe is to stop/start
db2 on Server_1. This is rather unpractical, since there might be other
databases running in the same instance.
The whole setup is a development environment, and Server_2 is actually
a cluster of appservers. It would be nice if one could recatalog the
database in one place, instead of doing it on all appservers. Any
suggestions welcome.
Thanx in advance
/Lennart
3  44077 
Please try "db2 terminate " after you execute catalog and uncatalog
statement.
Cheers
Prakash Gautam
Lennart wrote:
Assuming the following setup:
Server1 running DB2 V8.2 with two databases DB_1 and DB_2:
db2 catalog db DB_1 as CURR_DB
Server2 DB2 runtime client:
db2 catalog tcpip node S1 remote Server1 ...
db2 catalog db CURR_DB at node S1
Now, if I do:
db2 uncatalog db CURR_DB
db2 catalog db DB_2 as CURR_DB
on Server_1, what does it take to get Server_2 to understand that it
should talk to DB_2 instead of DB_1? Forcing all applications does not
seem to help. So far the only way that seems failsafe is to stop/start
db2 on Server_1. This is rather unpractical, since there might be other
databases running in the same instance.
The whole setup is a development environment, and Server_2 is actually
a cluster of appservers. It would be nice if one could recatalog the
database in one place, instead of doing it on all appservers. Any
suggestions welcome.
Thanx in advance
/Lennart
Quote from some DB2 manual:
"If directory caching is enabled, database, node, and DCS directory
files are cached in memory. An application's directory cache is created
during its first directory lookup. Since the cache is only refreshed
when the application modifies any of the directory files, directory
changes made by other applications might not be effective until the
application has restarted.
To refresh the CLP's directory cache, use TERMINATE. To refresh DB2's
shared cache, stop (db2stop) and then restart (db2start) the database
manager. To refresh the directory cache for another application, stop
and then restart that application."
The real question is how to refresh DB2's shared cache without stopping
all databases running in the same instance. Any suggestions how to
achieve that?
/Fredrik
prakash wrote:
Please try "db2 terminate " after you execute catalog and uncatalog
statement.
Cheers
Prakash Gautam
Lennart wrote:
Assuming the following setup:
Server1 running DB2 V8.2 with two databases DB_1 and DB_2:
db2 catalog db DB_1 as CURR_DB
Server2 DB2 runtime client:
db2 catalog tcpip node S1 remote Server1 ...
db2 catalog db CURR_DB at node S1
Now, if I do:
db2 uncatalog db CURR_DB
db2 catalog db DB_2 as CURR_DB
on Server_1, what does it take to get Server_2 to understand that it
should talk to DB_2 instead of DB_1? Forcing all applications does not
seem to help. So far the only way that seems failsafe is to stop/start
db2 on Server_1. This is rather unpractical, since there might be other
databases running in the same instance.
The whole setup is a development environment, and Server_2 is actually
a cluster of appservers. It would be nice if one could recatalog the
database in one place, instead of doing it on all appservers. Any
suggestions welcome.
Thanx in advance
/Lennart
Quote from some DB2 manual:
"If directory caching is enabled, database, node, and DCS directory
files are cached in memory. An application's directory cache is created
during its first directory lookup. Since the cache is only refreshed
when the application modifies any of the directory files, directory
changes made by other applications might not be effective until the
application has restarted.
To refresh the CLP's directory cache, use TERMINATE. To refresh DB2's
shared cache, stop (db2stop) and then restart (db2start) the database
manager. To refresh the directory cache for another application, stop
and then restart that application."
The real question is how to refresh DB2's shared cache without stopping
all databases running in the same instance. Any suggestions how to
achieve that?
/Fredrik
prakash wrote:
Please try "db2 terminate " after you execute catalog and uncatalog
statement.
Cheers
Prakash Gautam
Lennart wrote:
Assuming the following setup:
Server1 running DB2 V8.2 with two databases DB_1 and DB_2:
db2 catalog db DB_1 as CURR_DB
Server2 DB2 runtime client:
db2 catalog tcpip node S1 remote Server1 ...
db2 catalog db CURR_DB at node S1
Now, if I do:
db2 uncatalog db CURR_DB
db2 catalog db DB_2 as CURR_DB
on Server_1, what does it take to get Server_2 to understand that it
should talk to DB_2 instead of DB_1? Forcing all applications does not
seem to help. So far the only way that seems failsafe is to stop/start
db2 on Server_1. This is rather unpractical, since there might be other
databases running in the same instance.
The whole setup is a development environment, and Server_2 is actually
a cluster of appservers. It would be nice if one could recatalog the
database in one place, instead of doing it on all appservers. Any
suggestions welcome.
Thanx in advance
/Lennart
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Vikrant |
last post by:
Friends,
Due an application (old) install program problem, Under AIX I could
only create DB2 instance, I could also catalog it. Its complex
application and I am not expert in creating full database for this
application, but I have desired DB2 backup (by db2 backup db command).
Can I do redirected restore (SET TABLESPACE CONTAINERS ....) only
when instance is created & cataloged , I am under the impression that
redirected restore is...
|
by: Klemens |
last post by:
Are there restrictions or special parameter to set on LDAP cataloged
Databases?
I have trouble with get snapshot statements while list applications
statements are successfull.
And I have trouble running apply with LDAP cataloged database as control
server.
Thanks
|
by: Tom Williams |
last post by:
Hi! I've got a Servlet running in a Tomcat 4.1.27 container that is
*somehow* able to connect to a DB2 database hosted on a Windows box
even thought that database is *not* cataloged on the Linux box Tomcat
is running on. Tomcat is configured to use the
COM.ibm.db2.jdbc.app.DB2Driver JDBC driver.
I thought the JDBC driver required all databases to be cataloged on
the machine the driver ran on. How am I able to connect to that
database...
|
by: Danny |
last post by:
HI
How can I refresh the main project window in code in ms access 2000
For example, I create a new table, but when I minimize the form, the table
is not there until I do F5 (refresh).
I do the db.TableDefs.Refresh, but I guess this is not applied to the
project window for tables
thanks
|
by: SS |
last post by:
Hi,
I don't want to refresh a web page to query and display database.
I want the page shows information immediately when database changes.
What kind of technology or method would be able to perform this action?
Sean
| | |
by: DraguVaso |
last post by:
Hi,
In my VB.NET-application I have an SqlDataAdapter with build in
Update-Commands, but during development from time to time the Table's in my
Database change. So I need to kind of rebuild the SqlDataAdapter's
update-Commands.
Is there an easy way to do this? The way I do it now is by the "configurin
Data Adapter", redoing the whole stuff, and afterwards changing the
Connection manually back to my orginal Connection. I guess there...
|
by: Dave Johnson |
last post by:
i am doing online cinema reservation project, and i have this problem in
the Reservation Process, i want the user to always experiance a Fresh
version of the Seats avaiable for him to book, the problem is divided
into 2 parts :
first how to make sure that the seats avaiable to him is the latest
uptodate of the database, as he opend the page and other users may had
made reservations and he is not allowed to reserve a seat that is
already...
|
by: Amzul |
last post by:
hello all
i use <meta http-equiv="refresh" content="300" /> in the head
but i notice that the pictures in the page are not refreshing
i have picturs *.png its graphs so i can tell nothing is changing only if i press F5 or refresh button
why? and how can i make the picture refresh use NO-CHACE?
|
by: Azvareth |
last post by:
Hi!
I'm new here but I need an answer to a question:
I have a form, this form has details about products to sell, in the form header I have added a button to import xmldata containing a collection of products and properties of it. The import is done with msXMLDOM...... I retreive all values and build a string that I post into the database with:
DoCmd.RunSQL "INSERT INTO tabProdukt .......
Problem 1.
how much I trial and error, I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
