473,573 Members | 3,213 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 federation problem when reconnecting to a remote federated AS/400

My Windows DB2 Server 9.x is connected, via federation, to a remote AS/
400 system:
I created several nicknames to remote tables and I can query them.

Problem is, during the night, my remote AS/400 is rebooted and DB2
Server cannot connect back to it.

Is there any DB2 parameter I must set to reconnect automatically to
the remote federated AS/400.

Oct 24 '08 #1
1 2823
1) Is the AS/400 really being rebooted every night? If so, I would ask the
owner why they're doing that.

2) Ask the AS/400 owner if they can run this command: CHGDMMTCPA AUTOSTART(YES)
This will cause the server job that supports the DB2 Federation Connection to be
started each time that TCP/IP is started on the AS/400.
dif1754 wrote:
My Windows DB2 Server 9.x is connected, via federation, to a remote AS/
400 system:
I created several nicknames to remote tables and I can query them.

Problem is, during the night, my remote AS/400 is rebooted and DB2
Server cannot connect back to it.

Is there any DB2 parameter I must set to reconnect automatically to
the remote federated AS/400.

Kent Milligan
ISV Enablement - System i
km***@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)
Oct 24 '08 #2

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

Similar topics

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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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...

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.