469,267 Members | 971 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

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.

Thanks
CD
Oct 24 '08 #1
1 2643
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.

Similar topics

2 posts views Thread by Lennart Jonsson | last post: by
14 posts views Thread by spencer | last post: by
8 posts views Thread by hikums | last post: by
3 posts views Thread by Baski | last post: by
5 posts views Thread by BobTheDataBaseBoy | last post: by
reply views Thread by vbace2 | last post: by
3 posts views Thread by Arun Srinivasan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.