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
DB2 & UDB email list listserv db2-l LazyDBA home page