I've got a set of redundant marts that I'm trying to catalog on the
client side to allow us to do two things:
1. manually recatalog to point at either of the two fast marts
2. automatically failover to a third slow mart
The data marts are on db2 8.2.1, the client on db2 8.2.?
But I'm hitting a few roadblocks here - all suggestions are
appreciated. So, I've given our portal team (runs actuate) a pair of
scripts to switch the catalog entries between the two fast marts:
recatalog_to_pr imary.ksh:
#!/bin/ksh
db2 terminate
db2 catalog tcpip node server1 remote server1 server 60000
db2 uncatalog database rptmart
db2 catalog database rptmart as rptmart at node server1
db2 terminate
exit 0
recatalog_to_se condary.ksh:
#!/bin/ksh
db2 terminate
db2 catalog tcpip node server2 remote server2 server 60000
db2 uncatalog database rptmart
db2 catalog database rptmart as rptmart at node server2
db2 terminate
exit 0
Additionally, on the server side I've updated each server to point at
the other as an alternate (via client rerouting). These will
eventually point to the slow mart, but for right now they are pointing
to each other.
Database 1 entry for server1:
Database alias = RPTMART
Database name = RPTMART
Local database directory = /db2i2_home/db2i2
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname = server2
Alternate server port number = 60000
Database 1 entry for server2:
Database alias = RPTMART
Database name = RPTMART
Local database directory = /db2i2_home/db2i2
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname = server1
Alternate server port number = 60000
So, here's what I've seen regarding the manual recataloging:
1. when i've experimented with the recatalog scripts on one of our
other servers, it continued to connect to the wrong server. Bouncing
the instance helped - but I can't rely on that in production. Any
suggestions?
And here's what I've seen regarding the automatic client rerouting:
2. after connecting to one of these servers from the portal server its
local database directory does not show the alternate server. Should
it?
3. after I force a portal query on one server (resulting in a
SQL30081N) the actuate query fails, returning the SQL30081N, instead of
reconnecting to the alternate. Do I need to do anything else to get
the server alternates used by the client?
4. i'd prefer to configure client rerouting on the client side rather
than the server - so that I could have different clients reroute to
different failover servers (the clients have differing availability
requirements). It looks like the clients should support this, but the
online documentation seemed to indicate that rerouting info on the
client side was ignored. Is this true?
Thanks!
Ken 1 1625
I've got some progress on both of these issues:
1. client reroute - it appears to be working, it's just that it
reconnects to the original server, rather than to the alternate. I
assume that this is by design, and i'll have to actually shut down one
of the production servers to see if it failovers to the other. Or
accelerate getting that second test server set up.
2. recataloging - I've added a few lines of code to our cataloging
script to attempt to force the directory cache to be updated:
db2 update dbm cfg using dir_cache no immediate
db2 terminate
db2 connect to rptmart user kenfar
db2 update dbm cfg using dir_cache yes immediate
db2 terminate
and now it's working fine. But I've never had to do this before - am I
overlooking something really simple here?
Thanks,
Ken This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Matthew K Jensen |
last post by:
I've just come up with an idea to make a small-time record of web
pages linking to other web pages. I don't want to download every page
on the internet (I'll leave google to do that). I just want to know if
anyone has any suggestions on how to acquire just the links from a web
page using python. This is for a cataloging purpose. Is there some
library or script out there that I haven't heard of?
|
by: Jagdip Singh |
last post by:
Hi all,
I uninstalled db2 without dropping old instance. I have one database which i
want to access again through new db2 i installed.
I opted for fresh db2 directory while installing instead keeping old
directory.
I created new instance during installation of db2 which is different from
old one.
I tried catalog database for old database from new instance but did not able
to access database
|
by: Codex Twin |
last post by:
I am re-sending this in the hope that it might illicit a response. I have a
corporate client who forces their workstations to get the proxy server
details using an automatic proxy discovery script.
Unfortunately, the .NET Framework does not support automatic proxy discovery
scripts. See:
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;307220
The article above details that the way to workaround this is to edit the...
|
by: softwareengineer2006 |
last post by:
All Interview Questions And Answers
10000 Interview Questions And Answers(C,C++,JAVA,DOTNET,Oracle,SAP)
I have listed over 10000 interview questions asked
in interview/placement test papers for all companies between year
2000-2005
in my website
http://www.geocities.com/allinterviewquestion/
So please have a look and make use of it.
|
by: connectrajesh |
last post by:
INTERVIEWINFO.NET
http://www.interviewinfo.net
FREE WEB SITE AND SERVICE FOR JOB SEEKERS /FRESH GRADUATES
NO ADVERTISEMENT
| |
by: freepdfforjobs |
last post by:
Full eBook with 4000 C#, JAVA,.NET and SQL Server Interview questions
http://www.questpond.com/SampleInterviewQuestionBook.zip
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of
attending interviews. If you own a company best way to judge if the
candidate is worth of it.
http://www.questpond.com/InterviewRatingSheet.zip
|
by: Drew |
last post by:
I posted this to the asp.db group, but it doesn't look like there is much
activity on there, also I noticed that there are a bunch of posts on here
pertaining to database and asp. Sorry for cross-posting.
I am trying to build a "checklist", where a user can navigate to an ASP page
on the intranet which shows a list of "questions" that the user can check
off. I am trying to figure out how to do this so that it is scalable, but I
am...
|
by: Brad |
last post by:
Does anyone know of a method to reroute a web page to a file.
When someone comes to a web page, I would to reroute the output from a
web page to a file on our site.
The web page we are rerouting does not exist on our site and in some
instances is not a text web page but the output of a perl or some
other script.
Thanks,
Brad
|
by: GetgoodV |
last post by:
Hi all,
I wonder if anybody can help with a problem I have accessing (caaloging) databases on my network (drive V)
I have installed DB2 V8 on Windows XP: -
=========================================================
About DB2 Administration Tools Environment
=========================================================
DB2 administration tools level:
Product identifier SQL08020
Level identifier 03010106
|
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: 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,...
| |
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: 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...
|
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...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |