473,854 Members | 1,664 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Howto refresh cataloged database?


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

Nov 15 '06 #1
3 44146
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
Nov 16 '06 #2
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
Nov 20 '06 #3
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
Nov 20 '06 #4

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

Similar topics

3
3512
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...
0
446
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
0
1598
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...
3
11798
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
3
3006
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
1
1722
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...
0
928
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...
1
1273
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?
4
11173
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...
0
9752
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11031
Oralloy
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...
0
10684
jinu1996
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...
0
10371
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9517
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7918
isladogs
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...
0
7082
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();...
2
4159
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3188
bsmnconsultancy
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...

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.