Pls. read this article...
http://www-106.ibm.com/developerworks/db2/library/techarticle/0206purnell/02
06purnell.html
Regards
Praveen
-----Original Message-----
From: GBagalkot
[mailto:db2udbdba-ezmlmshield-x92932053.[Email address protected]
Sent: 28 July 2004 03:54
To: LazyDBA Discussion
Subject: Communicating between two difft. databases on difft. instances
Hi,
I need some help in updating current table with the
info of another db on another instance.
I need to read some data from one DB [db1] and update
[and insert] another database [db2]. Both the
databases are on different systems [s1 and s2]. On
one of the systems I can see connect to both
databases, but not simultaneously.
Basically my requirement is something like this.
insert into [Email address protected] values (select * from [Email address
protected]
Can anybody point me how and where to start.
Thanks in advance
gbag.
--- GBagalkot
<db2udbdba-ezmlmshield-x13319136.[Email address protected]
wrote:
> Hi,
> I am getting the error as "maximum number of agents
> has been exceeded." When I looked into the list
> applications and counted on the no. of applications
> ,
> it is showing very less, [1/5]th of MAXAGENTS.
> The error message is as below. And all new client
> connections are being thrown out complaining the
> above
>
> reason. We have MAXAGENTS as 600 and no. of
> connections as 102. But I am seeing this error. oes
> 'list applications' really say how many agents are
> there [applications]. If not which command should I
> use to get the total no. of agents.
>
> Any help is greatly appreciated.
>
> Thanks in advance
> Girish
>
> 2004-06-16-21.31.27.839075 Instance:PKstdb2
> Node:000
> PID:30382(db2tcpcm 0) TID:1 Appid:none
> common communication sqlcctcpconnmgr_child
> Probe:125
>
> ADM7009E An error was encountered in the "TCPIP"
> protocol support. A possible cause is that the
> maximum number of agents has been exceeded.
>
> 2004-06-16-21.31.27.868989 Instance:PKstdb2
> Node:000
> PID:30382(db2tcpcm 0) TID:1 Appid:none
> common communication sqlcctcpconnmgr_child
> Probe:126
>
> Return code from sqleGetAgent =
> 0x0FFFFFFFFFFFA174 : 0xFFFFFB36
>
> 6
>
>
>
> __________________________________
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile
> phone.
> http://mobile.yahoo.com/maildemo
>
>
>
---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail:
> db2udbdba-[Email address protected]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]
This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page