gbag,
You need to look at the Federated Database capabilities of UDB.
Look into Information Integrator. You cannot directly access two
UDB database is one Unit of work through UDB. II will allow you to define connections to
both databases and process against both.
You other option would be to export from one and import with the appropriate options
on the destination database.
jim...
-----Original Message-----
From: Goulet Dick
[mailto:db2udbdba-ezmlmshield-x15886215.[Email address protected]
Sent: Wednesday, July 28, 2004 10:47 AM
To: LazyDBA Discussion
Subject: RE: Communicating between two difft. databases on difft.
instances
If this was Oracle I'd suggest the COPY command.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: GBagalkot
[mailto:db2udbdba-ezmlmshield-x92932053.[Email address protected]
Sent: Tuesday, July 27, 2004 10:54 PM
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]
---------------------------------------------------------------------
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 message is for the sole use of the intended recipient. If you received this message in error please delete it and notify us. If this message was misdirected, CSFB does not waive any confidentiality or privilege. CSFB retains and monitors electronic communications sent through its network. Instructions transmitted over this system are not binding on CSFB until they are confirmed by us. Message transmission is not guaranteed to be secure.
==============================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page