Ajit
The interrupt port is active and available basing on the following test I
did.
When I run the same query from Command center form the same box where I am
having COGNOS is returning immediately saying the query has been cancelled
and the agent stops working on the query. Where as the COGNOS is neither
returning nor canceling the query.
Kish
>From: "Vilas, Ajith (USPC.PCT.Hopewell)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: RE: DB2EUG: Data copy from Access to UDB database
>Date: Thu, 7 Jun 2001 09:11:18 -0400
>
>Kish,
> I was responding to a mail about the COGNOS and UDB. If I remember
>correctly, the problem was that even after you cancel the query from
>COGNOS it runs on the database. All TCP interrupt signals are send using
>the interrupt port. If this port is not available for DB2, you might
>experience these problems.
>Regards,
>Ajith
>
>-----Original Message-----
>From: kishore lingamallu [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 05, 2001 5:17 PM
>To: [EMAIL PROTECTED]
>Subject: RE: DB2EUG: Data copy from Access to UDB database
>
>
>
>
>Ajit
>
>I didn't get your suggesttion, what is "command/connect port number +1. ".
>Is this is the way to connect to access database command line? Are there
>any command line instructions avalilable for Access database and if so
>where can I find them?
>
>Kish
>
>
>
>
>
> >From: "Vilas, Ajith (USPC.PCT.Hopewell)"
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: RE: DB2EUG: Data copy from Access to UDB database
> >Date: Fri, 1 Jun 2001 14:13:05 -0400
> >
> >Kish,
> > Do you have the tcpip interrupt port defined properly for the datasource
>?. This has to be the command/connect port number +1.
> >Regards,
> >Ajith
> >
> >-----Original Message-----
> >From: kishore lingamallu [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, June 01, 2001 12:27 PM
> >To: [EMAIL PROTECTED]
> >Subject: Re: DB2EUG: Data copy from Access to UDB database
> >
> >
> >Hi
> >
> >We have a situation where I need to copy the data from Access tables and
> >import them in to UDB tables every day.
> >
> >Do any body have suggestions for implementing solution for this kind of
> >situation.
> >
> >Thanks
> >Kish
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >
> >=====
> >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> >For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
> >
> >
> >
> >=====
> >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> >For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
> >
>
> _____
>
>Get your FREE download of MSN Explorer at http://explorer.msn.com
><http://explorer.msn.com>
>
>
>
>
>===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
>
>
>
>=====
>To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod