f



db2 connection lost from my db2 client on window to aix server after some time

Hi,
I have encountered a very strange situation.
I just changed my laptop and installed db2 Administration client.
I run a db2 CLP ranning  statistic on 500 tables from my db2 command
window on my laptop and the
connection was disconnected after 30 minutes.
Is this for some set up on my new laptop?
George
Thanks,

0
zgh1970
4/24/2007 1:29:23 PM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

3 Replies
677 Views

Similar Articles

[PageSpeed] 16

On Apr 24, 8:29 am, zgh1970 <george.zh...@lombard.ca> wrote:
> Hi,
> I have encountered a very strange situation.
> I just changed my laptop and installed db2 Administration client.
> I run a db2 CLP ranning  statistic on 500 tables from my db2 command
> window on my laptop and the
> connection was disconnected after 30 minutes.
> Is this for some set up on my new laptop?
> George
> Thanks,

How often do the queries run? Could it be related to power management
on your laptop?

0
Ray
4/25/2007 2:18:38 PM
Hi, Ray,
In fact i found if the runstat lasts more than 1 minute and it will
failed.
I monitered it and power is ON.
But maybe TCPIP was lost.
I tested the same runstas from my home by VPN and it was OK.
I suspected that new laptop in my company's intranet has some
limitation.
How can I find the TPCIP and other setup of fire wall?
Thanks,
Ray wrote:
> On Apr 24, 8:29 am, zgh1970 <george.zh...@lombard.ca> wrote:
> > Hi,
> > I have encountered a very strange situation.
> > I just changed my laptop and installed db2 Administration client.
> > I run a db2 CLP ranning  statistic on 500 tables from my db2 command
> > window on my laptop and the
> > connection was disconnected after 30 minutes.
> > Is this for some set up on my new laptop?
> > George
> > Thanks,
>
> How often do the queries run? Could it be related to power management
> on your laptop?

0
zgh1970
4/26/2007 4:31:20 PM
On Apr 26, 11:31 am, zgh1970 <george.zh...@lombard.ca> wrote:
> Hi, Ray,
> In fact i found if the runstat lasts more than 1 minute and it will
> failed.
> I monitered it and power is ON.
> But maybe TCPIP was lost.
> I tested the same runstas from my home by VPN and it was OK.
> I suspected that new laptop in my company's intranet has some
> limitation.
> How can I find the TPCIP and other setup of fire wall?
> Thanks,
>
> Ray wrote:
> > On Apr 24, 8:29 am, zgh1970 <george.zh...@lombard.ca> wrote:
> > > Hi,
> > > I have encountered a very strange situation.
> > > I just changed my laptop and installed db2 Administration client.
> > > I run a db2 CLP ranning  statistic on 500 tables from my db2 command
> > > window on my laptop and the
> > > connection was disconnected after 30 minutes.
> > > Is this for some set up on my new laptop?
> > > George
> > > Thanks,
>
> > How often do the queries run? Could it be related to power management
> > on your laptop?

I don't know exactly where you find it but there should be a place
where you can tell the power management it can't power down the
network interface. I'd start there. Disconnecting after a minute of
inactivity is kind of radical.

0
Ray
4/27/2007 6:26:46 PM
Reply:

Similar Artilces:

connection to db2 database through db2 client on windows slows down intermittently
we are facing a problem here.We have two different IDs from which we connect to db2 database through Db2 client on windows. When I try connecting to database through one ID it establishes connectivity in 2-3 sec and when i try accessing connecting to same database through second ID it takes 5-6 minutes sometimes,although sometimes it hapens in seconds. When my colleagues try to access database through the second ID i tried with they get connected ie have connectivity in seconds. coonections are open to database . what might be the problem!any clue? we restart the database and then connection gets established. On 2 Aug 2006 08:59:55 -0700, zagri_as@yahoo.com <zagri_as@yahoo.com> wrote: > we restart the database and then connection gets established. Since the question is about connecting to DB2, have you asked in a more appropriate forum such as comp.databases.ibm-db2? You might get a different - better - response there. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ ...

Connect to IBM DB2 database without installing the DB2 client.
Hi, To connect to the DB2 Driver, from a remote machine. Do we requier DB2 client. Can't we connect by just having IBM DB2 driver which is just a single file (db2cli.dll). I am using vb application from Windows platform to connect to DB2 on Linux machine. Regards, Santosh SB wrote: > Hi, > > To connect to the DB2 Driver, from a remote machine. Do we requier DB2 > client. > Can't we connect by just having IBM DB2 driver which is just a single > file (db2cli.dll). > I am using vb application from Windows platform to connect to DB2 on > Linux machine. > It's imposiblle. The IBM DB2 ODBC Driver is not only db2cli.dll. Try to install DB2 Run Time Client Lite merge modules with your VB application under client workstation. Direct connecting to DB2 databases supported JDBC Type 4 Driver only. P.S. Sorry for my bad english :( With best regards, Dmitry. FYI: On Windows DB2 comes with db2iprune tool. With this utility you can reduce size of installation binaries, for example you can reduce your DB2 runtime client to include only the interfaces you need. The db2iprune tool is located in the \db2\windows\utilities\db2iprune directory on DB2 product installation image. So, if you are planning install DB2 client with/within your application you can combine the tool with the response file and perform quick batch installation. -- Artur Wronski ...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia ColdFusion MX for J2EE, other IBM DB2 Connect Enterprise Edition v8.2 17/Sep/2004 WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR 16 297 DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR 16 110 IBM DB2 UDB Enterprise Server Edition v8.2 16 053 Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029 Sybase:524953-454f57-4e53594-f55123-456rm4 Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4 DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5 Oracle:524953-454f57-4e53594-f55123-452o1s Informix:524953-454f57-4e53594-f55123-453x5w DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia ColdFusion MX for J2EE, other IBM DB2 Connect Enterprise Edition v8.2 17/Sep/2004 WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR 16 297 DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR 16 110 IBM DB2 UDB Enterprise Server Edition v8.2 16 053 Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029 Sybase:524953-454f57-4e53594-f55123-456rm4 Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4 DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5 Oracle:524953-454f57-4e53594-f55123-452o1s Informix:524953-454f57-4e53594-f55123-453x5w DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia ColdFusion MX for J2EE, other IBM DB2 Connect Enterprise Edition v8.2 17/Sep/2004 WEBSPHERE BUSINESS INTEGRATION CONNECT ADVANCED v4.2.2 - IBM CD NR 16 297 DW v1.2 DB2 UDB Enterprise Edition V7.2.10a - IBM Tivoli CD NR 16 110 IBM DB2 UDB Enterprise Server Edition v8.2 16 053 Peoplesoft Peopletools v8.45 - Peoplesoft [5 CDs] 16 029 Sybase:524953-454f57-4e53594-f55123-456rm4 Microsoft SQL Server:524953-454f57-4e53594-f55123-457py4 DB2 UDB for OS/390:524953-454f57-4e53594-f55123-45auo5 Oracle:524953-454f57-4e53594-f55123-452o1s Informix:524953-454f57-4e53594-f55123-453x5w DB2 UDB for Unix, NT:524953-454f57-4e53594-f55123-454yc...

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Expr
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Pe...

RE: connection to db2 database through db2 client on windows slows downintermittently
Sounds like a DNS problem. Scott MacKenzie - Dine' College ISD Phone/Voice Mail:=A0 928-724-6639 Email: scottm at dinecollege.edu -----Original Message----- From: informix-list-bounces@iiug.org = [mailto:informix-list-bounces@iiug.org] On Behalf Of zagri_as@yahoo.com Sent: Wednesday, August 02, 2006 9:35 AM To: informix-list@iiug.org Subject: connection to db2 database through db2 client on windows slows = downintermittently we are facing a problem here.We have two different IDs from which we connect to db2 database through Db2 client on windows. When I try connecting to database through one ID it establishes connectivity in 2-3 sec and when i try accessing connecting to same database through second ID it takes 5-6 minutes sometimes,although sometimes it hapens in seconds. When my colleagues try to access database through the second ID i tried with they get connected ie have connectivity in seconds. coonections are open to database . what might be the problem!any clue? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ...

how to use db2 connect server as a gateway to connect to mainframe db2 database
we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect server and client, so client could access the database through the connect server? like that: db2client <--> db2 connect server <--> db2 mainframe database IBM keeps talking about this structure but never mention about the configuration in all the manuals.:( thanks for help! jeffhan wrote: > we have os/400 db2 database at the backend. > i installed db2 v9 connect server on one windows server which is > locating the same network with database server. > > now how to i configure the connect server and client, so client could > access the database through the connect server? > > like that: > > db2client <--> db2 connect server <--> db2 mainframe database > > IBM keeps talking about this structure but never mention about the > configuration in all the manuals.:( > > thanks for help! Info-center: - "DB2 Connect server products: installation and configuration overview": http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.uprun.doc/doc/c0008452.htm - "Preparing DB2 Universal Database for iSeries for connections from DB2 Connect": http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.uprun.doc/doc/t0008234.htm - &qu...

DB2 Connectivity problem from a wndows client to DB2 AS/390 server
hi all, I have a DB2 connect PE ver 8.2 installed in my windows client which tries to connect to AS/390 Database Instance via CCA.It uses TCP/IP. While trying to connect the Server from the windows client SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.134.201". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQL...

How to create a federation server to db2/400 in a db2 udb AIX databases
Hi, All, We have a database on db2 udb aix. The database has federated server to db2 mainframe. Now We have already catalog database of db2/400 on the db2 UDB aix server. I tried to create new federation server for db2as/400. It seam has problem. 1. can the db2 mainframe and db/400 have the same wrapper? Our existing db2 mainframe uses the wrapper with library libdb2drda.a This wrapper is used by db2 mainframe 2. When i create a new federated server for db2/as400 with the same wrapper and try to create nicknmae under it,it showed the following error message: Error: SQL0204N "SYSIBM.SYSTABLES" is an undefined name. SQLSTATE=42704 (State:42704, Native Code: FFFFFF34) It seams I need to create a new wrapper for db2/400. What library I need to use? Thanks, On Mar 19, 2:35 pm, "zgh1970" <george.zh...@lombard.ca> wrote: > Hi, All, > We have a database on db2 udb aix. > The database has federated server to db2 mainframe. > Now We have already catalog database of db2/400 on the db2 UDB aix > server. > I tried to create new federation server for db2as/400. > It seam has problem. > 1. can the db2 mainframe and db/400 have the same wrapper? > Our existing db2 mainframe uses the wrapper with library libdb2drda.a > This wrapper is used by db2 mainframe > 2. When i create a new federated server for db2/as400 with the same > wrapper and try to create nicknmae under it,it showed the fo...

Difference between DB2 Client and DB2 Connect
What is the difference between DB2 Client and DB2 Connect? Our databases are DB2 8 on AIX and z/OS. Can we use DB2 Connect to connect to DB2 server on AIX and DB2 on z/OS? Thanks! -Jane Jane, >What is the difference between DB2 Client and DB2 Connect? DB2 Client is free client for DB2 Linux, Unix, Windows (LUV). DB2 Connect is chargeable client (can be also server), and (in addition to LUV connectivity) includes OS/400 and/or z/OS connectivity/license. So, you pay for only OS/400 or z/OS connectivity. >Our databases are DB2 8 on AIX and z/OS. Can we use DB2 C...

How connect fom DB2 client v7(XP) to DB2 v5 server(NT4)?
Hi! I have a server with old application on DB2.v5 V7 Client don't connect to v5 base. :( Application don't work on DB2v7,8. :(( And v5 client don't install on XP. :((( Anybody know how resolve this problem? Thanks. SY, Slava Get the application vendor to make modifications to get the application to work with DB2 V7, V8. Larry Edelstein Slava Garbuz wrote: > Hi! > > I have a server with old application on DB2.v5 > V7 Client don't connect to v5 base. :( > Application don't work on DB2v7,8. :(( > And v5 client don...

connection remote to DB2 database with the C/C++, with prohibition of installation DB2 client software.
I have write connection to remote database (DB2) with the aid C/C++, but i can not install DB2 client software (everything that will be wanted for connection i must place in application, possibly - i can add some libraries DLL in folder with application. Do there be possible ? Some simplest idea ?? Any source code ?? I will be very beholden for any/every assistance thank / salute ........ and i apologize for my english ann ebneci@tlen.pl wrote: > I have write connection to remote database (DB2) with the aid C/C++, > but i can not install DB2 client software (everything that will be > wanted for connection i must place in application, possibly - i can > add some libraries DLL in folder with application. > > Do there be possible ? > > Some simplest idea ?? Any source code ?? > > I will be very beholden for any/every assistance > > thank / salute ........ and i apologize for my english > > ann What a coincidence! I just finished answering this very same question in another forum. Hope you don't mind a "second hand" answer :-)... A couple of solutions spring to mind: There's the standalone DB2 CLI / ODBC driver (separate from the clients) which is documented in the InfoCenter [1] and available from the Application Development for DB2 page [2]. It weighs in at a positively slim 14Mb (well ... slim compared to the sumo-wrestler that is the standard client, anyway...

Migrating a Windows DB2 8.1 to DB2 8.1 database system on AIX 5.3
Do someone know how to migrate/copy a Windows DB2 8.1 data base to DB2 8.1 database system on AIX 5.3. Found some migrate doc on the web but these handle mirgrations across db systems. Thx in adwance!!! Ric wrote: > Do someone know how to migrate/copy a Windows DB2 8.1 data base to DB2 > 8.1 database system on AIX 5.3. Found some migrate doc on the web but > these handle mirgrations across db systems. > > Thx in adwance!!! Use db2look to extract the DDL, and then make changes to run on Windows (TS container file names and paths will need a change). Then use db2move (export and then load) to move the data. You cannont use backup and restore to move from DB2 Windows to DB2 UNIX. " Use db2look to extract the DDL, and then make changes to run on Windows (TS container file names and paths will need a change)." You mean "to run on UNIX" I suppose. Thx for the info but I am a DB2 dummy and it would be great to have it steps by steps. Are this the steps you was talking about (the database I want to move has the name TEST)?: 1. On Windows: D:\> db2look -d TEST -e -o TEST_Schema.ddl -l 2. Now modifying TS container file names and paths in "TEST_Schema.ddl" and copy "TEST_Schema.ddl" to AIX. 3. On AIX using db2inst1 user: - (/home/db2inst1) $ create a TESTDB - (/home/db2inst1) $ connect to TEST - (/home/db2inst1) $ db2 -tvf /depot/TEST/Schema/TEST_Schema.ddl 4. On AIX...

What's the DB2 connection string wihout DSN when use IBM DB2 OLE PROVIDER in windows environment?
What's the DB2 connection string wihout DSN when use IBM DB2 OLE PROVIDER in windows environment, such as ADO or Creation of Linked Server in MS SQL Server ? I searched for a long time to look for a connection string wihout DSN using IBM DB2 OLE PROVIDER in windows environment, but unfortunately, I found none. The DB2 connection string in http://www.connectionstring.com/ is wrong: Provider=IBMDADB2;Database=sample;HOSTNAME=db2host;PROTOCOL=TCPIP;PORT=50000;uid=myUserName;pwd=myPwd; I can't use it when use sp_addlinkedserver (the MS SQL Server Stored Procedure) which ne...

DB2 Connect vs. DB2 in an AIX environment
I have an application that uses IBM DB2 Universal Data Base Version 8.2 to update DB2 tables on a RS/6000 platform. I would like to change it to update DB2 tables on an IBM Mainframe using DB2 Connect. My question is whether this will be transparent to the application? Thanx, Joe Jadick <joejadick@yahoo.com> wrote in message news:1102553633.379127.245200@c13g2000cwb.googlegroups.com... > I have an application that uses IBM DB2 Universal Data Base Version 8.2 > to update DB2 tables on a RS/6000 platform. > > I would like to change it to update DB2 tables on ...

database migration from Windows DB2 to Linux DB2
We need to migrate a database (basically all the 300+ tables along with the data) from a Windows UDB instance to a Linux UDB instance. What is the best way of doing this ? Thanks "Murty" <adavi@comcast.net> wrote in message news:c4w7b.406960$Ho3.62540@sccrnsc03... > We need to migrate a database (basically all the 300+ tables along with the > data) from a Windows UDB instance > to a Linux UDB instance. What is the best way of doing this ? > > Thanks > Bad news is that you cannot use backup and restore of the database from Windows to Linux....

java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
Hi, I want to get connection to a DB2 database using the driver COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in the classpath. However I am getting the exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Conn.main(Conn.java:44) The code that I am using (with try/catch removed) is as follows: String url = "jdbc:db2:sample"; String driver = "COM.ibm.db2.jdbc.DB2XADataSource"; String dbuser = "db2u...

HELP
HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server -- I am experienced in ORACLE and a novice at DB2. What tools would be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to connect to a database on a remote box (either AIX or AS/400)? I have read that DB2 Connect appears to be the ticket for the Db2 server if it is on AS/400 or OS/390. What if it is on AIX? Does the same tool apply? All help is appreciated. hi, To connect to DB2 db on AIX from windows you will just be needing the db2 client and then you have to catalog ...

Re: IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit,
vvcd said: > IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 > bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite > Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express > Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM > Tivoli Workload Scheduler Virtualized Data Centers v8.2 [2 CDs], other > IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM [2 > CDs], other IBM WebSphere Business CDs (Windows, Linux) CDs, IBM > Integration Server v5.1 [2 CDs], IBM Telecom Toolkit for WebSphere > Studio V1.3.5, IBM Frame2000 V5.5, Peoplesoft Peopletools v8.45 [5 > CDs] for DB2 UDB for OS/390, and for DB2 UDB for Unix, Macromedia > ColdFusion MX V6.0.1 for IBM WebSphere Application Server, Macromedia > ColdFusion MX for J2EE, other What the heck, I'm sure IBM won't have a problem with a little copyright violation... >:o) > please send e-mail, ola2@mail.gr, astra35@mailbox.gr, Do they have internet access in Greek jails, I wonder... -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list ...

DB2 Load from Unix CLient to NT DB2 Server
Hi All, I've been trying to load from my Unix Client (7.2) to a Windows DB2 Server 7.2. Has anyone been able to achieve this? The error I get is "SQL3025N A parameter specifying a filename or path is not valid." even though the filename and paths are valid. Thanks in advance. Louise "Louise" <louise.haire@ascential.com> wrote in message news:249ba68b.0310092253.37919018@posting.google.com... > Hi All, > > I've been trying to load from my Unix Client (7.2) to a Windows DB2 > Server 7.2. Has anyone been able to achieve this? The...

Does DB2 Connect come with DB2?
Hi: I am confused. Some parts of IBM's web site lead me to believe that DB2 Connect is included in OS400/DB2, other parts of the web site show me how much DB2 Connect costs. Anyone know for sure? The reason I am asking is that I downloaded the DB2 Connect Personal Edition trial copy to test the connection from a Windows Server running Crystal Enterprise to our AS/400 DB2 database. Works great! Just want to know how much it will cost to implement. Thanks in advance. DB2 Connect is not included with any DB2/400 component. The DB2 Connect component is available as a sep...

Web resources about - db2 connection lost from my db2 client on window to aix server after some time - comp.databases.ibm-db2

Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.com
High-quality data, if not used properly, can still lead marketers to make bad decisions. Consider these common ways that numbers are used to ...

HTTP persistent connection - Wikipedia, the free encyclopedia
... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...

Alec Baldwin, Tommy Hilfiger and a Designer With a ‘Downton’ Connection
It was something of a British invasion at Michael’s today with plenty of posh folks (Majesty magazine EIC Ingrid Seward , the always dashing ...

French (Canadian) connection helps Coyotes snap 7-game skid
The Arizona Coyotes defeat the Florida Panthers 5-1 Saturday behind a dominate performance by the team's French-Canadian players.

Quantum Break requires Internet connection for streaming cut scenes on PC
Single-player game puts videos in cloud to save disc and hard drive space. The idea of requiring an Internet connection for single-player gaming ...

4G Connections Hit One Billion as Mobile Broadband Momentum Extends to the Developing World
The number of 4G mobile connections worldwide has surpassed the one billion mark and is on track to account for a third of all mobile connections ...

Zika virus-microcephaly connection hunted in Brazil - CNN.com
Is the Zika virus linked to microcephaly? The CDC and Brazilian health officials are leading the first-ever large scale investigation to find ...

Smart city tech shows complex connections between data and sensors
... MWC, Parkeon and Sierra Wireless announced that Sierra Wireless AirPrime HL Series embedded modules will be used to enable cellular connections ...

Van Jones And Jeffrey Lord Nearly End Up In A Fist Fight Over Trump's KKK Connections
CNN needs to fire Jeffrey Lord if they want to keep the name "News" in their name. His performance with Van Jones tonight was shameful. Utterly ...

Resources last updated: 3/6/2016 6:36:52 PM