|
by: Lennart Jonsson |
last post by:
Hi, I'm trying to create a federated database, but I run into trouble when
about to "create server". Some info about the env where I try:
$ uname -a
Linux db2-00 2.4.21-9.ELsmp #1 SMP Thu Jan 8 17:08:56 EST 2004 i686 i686
i386 GNU/Linux
$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08015"
with level identifier "02060106".
|
by: spencer |
last post by:
My client is going through a large project to replace existing data
warehouse physical infastructure which is running DB2 8.1.6. In the
past we had a much more distributed environment where we had certain
portions of the data warehouse on a physically different server. We
utilized federation to allow the joining of tables on seperate
instances. We found that this worked ok in situations where the tables
were not that large say under...
|
by: hikums |
last post by:
By mistake, posted in informix group..Here it is now...
On Windows:
In db abc:
1. create wrapper drda
(LIBRARY LIBDB2DRDA.a not available in windows box)
2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA"
AUTHORIZATION xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' );
3. If the above steps are through, probably user mapping/nicknames are
|
by: Baski |
last post by:
Hi,
I have few questions,
1) I have DB2 8.2 ESE, with a db2 instance and a few databases.
Is it posiible to create and configure a federated server. what are
the things/steps required to do so.
For federation server should I have additional tool called Information
Integrator or can I do without it? Does the Wrapper to connect to
|
by: zgh1970 |
last post by:
Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix
server.
I tried to create new federation server for db2as/400.
It seam has problem.
1. can the db2 mainframe and db/400 have the same wrapper?
Our existing db2 mainframe uses the wrapper with library libdb2drda.a
This wrapper is used by db2 mainframe
|
|
by: BobTheDataBaseBoy |
last post by:
A client has 390/V7 and UDB/V8. It would be useful to use row_number()
when selecting from 390, but that's not supported. It occurs to me (I'm
not in CubeLand, and anyway we upgraded to V8 on z/OS) that federation
(on UDB/V8) might support functions on those 390/V7 tables. Is this
known?
thanks
|
by: vbace2 |
last post by:
Using DB2 v9.1 fixpak 2 (WSE with HADR feature) on Windows 2003 Servers
We are trying to set up HADR for two production databases. The two primary databases reside on two different servers. We would like to put the two standby databases on the same server. One of the databases (we will call it NICKNM) has tables federated from the other database (we will call it OTHER). I was able to set up HADR for these two databases so that the...
|
by: Arun Srinivasan |
last post by:
I have a query that has 5 predicates, scanning a table of 400+ million
rows and I have built indexes getting help from design advisor and
other tools. The cost of that query is really low. But I federated the
server and created a nickname for that table, and when I give the same
query against the nickname, it tries to fetch the whole table (cost
1.7 billion), and do the predicate evaluation in my smaller test box.
I did build indices in my...
|
by: biexplorer |
last post by:
Hi,
I am new to DB2.
We recently migrated from Oracle to DB2. And now, I want to setup what we call a DB link (in Oracle) in DB2.
I have done some research / read some posts in this forum already.
And I came to know that we need to setup federated access, create wrappers, create servers and then nicknames.
My question is:
I enabled federation using the command
|
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: 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: 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: 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
|
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...
|