RE: DB2EUG: Data copy from Access to UDB database

[Vilas, Ajith (USPC.PCT.Hopewell)]

Kish,
Command Center is bound to the db2admin server running on the same server as the 
database and it has better control than  COGONS which is nothing but an ODBC 
application. I suggest you taking an ODBC/CLI trace for COGNOS and look for 
SQLCancel() ODBC call and its return code. To check the port availability, go to the 
server, look in the etc/services file and find the port number which is set as the 
SVCENAME port in DBM cfg and make sure the next port is not used by any other 
application (use netstat command).
Regards,
Ajith

-----Original Message-----
From: kishore lingamallu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 7:01 PM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: Data copy from Access to UDB database



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



=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod