By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Thanks
CD
Oct 24 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

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

This discussion thread is closed

Replies have been disabled for this discussion.