confused -- db2 client configuration assistant (CCA) 
Author Message
 confused -- db2 client configuration assistant (CCA)

I apologize :( -- I have been posting tons of messages in this
newsgroup! But I am trying to set up a db2 client server configuration
and simply cannot seem to find the required information elsewhere!

Q.1. Where can I get the db2 CCA from? Can this be downloaded from the
IBM website?

Q.2. The CCA does not require that the DB2 application be installed on
each client machine, right?

Q.3. Can the same effect of the CCA be achieved by going to
start-settings-control panel-administrative tools - data sources on a
windows 2000 computer?

Thank you all -- again!



Mon, 18 Jul 2005 06:30:43 GMT
 confused -- db2 client configuration assistant (CCA)

See my thoughts below...

Quote:

> I apologize :( -- I have been posting tons of messages in this newsgroup! But I am trying to set
> up a db2 client server configuration and simply cannot seem to find the required information
> elsewhere!

> Q.1. Where can I get the db2 CCA from? Can this be downloaded from the IBM website

Assuming here you are on DB2 UDB V7.x, the Client Configuration Assistant is included with the DB2
Runtime Client if I recall correctly. You need to have the client code installed to have the CCA.

Quote:
> Q.2. The CCA does not require that the DB2 application be installed on each client machine, right?

Not really sure what you are asking. The Client Configuration Assistance assists you with
cataloguing your remote server to the client and for setting some related parameters. If you are not
going to have an application on a machine, why worry about the DB2 Client Configuration Assistant?

Quote:
> Q.3. Can the same effect of the CCA be achieved by going to start-settings-control
> panel-administrative tools - data sources on a windows 2000 computer?

Not 100% That will do the ODBC layer of the connection, but it will not update the DB2 database and
node directories. You can either do that through the DB2 CCA or through the Command Line Processor
of DB2 using the CATALOG commands.
--
Bob Harbus
Consulting I/T Specialist - IBM Software Services for Data Management - IBM Toronto Lab
IBM Certified Database Associate - DB2 Universal Database V8.1 Family
IBM Certified Database Administrator- DB2 Universal Database V8.1 for Linux, UNIX, and Windows


Mon, 18 Jul 2005 07:36:15 GMT
 confused -- db2 client configuration assistant (CCA)
The CCA is part of the DB2 client downloads from IBM. go to
www.software.ibm.com/data then find the support menu then the download
menu - eventually you will get to an FTP site where you can find the
clients.

The CCA requires (at minimum) the runtime client be installed on each
machine

in order to use the data sources tool - you must have the IBM DB2 ODBC
driver - which comes with the runtime client..

Regards,
Mike

Quote:
> I apologize :( -- I have been posting tons of messages in this
> newsgroup! But I am trying to set up a db2 client server configuration
> and simply cannot seem to find the required information elsewhere!

> Q.1. Where can I get the db2 CCA from? Can this be downloaded from the
> IBM website?

> Q.2. The CCA does not require that the DB2 application be installed on
> each client machine, right?

> Q.3. Can the same effect of the CCA be achieved by going to
> start-settings-control panel-administrative tools - data sources on a
> windows 2000 computer?

> Thank you all -- again!



Mon, 18 Jul 2005 09:07:11 GMT
 confused -- db2 client configuration assistant (CCA)
Thank you very much, but one more question -- when you say "but it
will not update the DB2 database and  node directories" -- this does
not apply to recordsets pulled from the database tables, right? Should
be able to update and insert records into tables using visual basic
and dsn name alone?

================================================================

Quote:

> See my thoughts below...


> > I apologize :( -- I have been posting tons of messages in this newsgroup! But I am trying to set
> > up a db2 client server configuration and simply cannot seem to find the required information
> > elsewhere!

> > Q.1. Where can I get the db2 CCA from? Can this be downloaded from the IBM website

> Assuming here you are on DB2 UDB V7.x, the Client Configuration Assistant is included with the DB2
> Runtime Client if I recall correctly. You need to have the client code installed to have the CCA.

> > Q.2. The CCA does not require that the DB2 application be installed on each client machine, right?

> Not really sure what you are asking. The Client Configuration Assistance assists you with
> cataloguing your remote server to the client and for setting some related parameters. If you are not
> going to have an application on a machine, why worry about the DB2 Client Configuration Assistant?

> > Q.3. Can the same effect of the CCA be achieved by going to start-settings-control
> > panel-administrative tools - data sources on a windows 2000 computer?

> Not 100% That will do the ODBC layer of the connection, but it will not update the DB2 database and
> node directories. You can either do that through the DB2 CCA or through the Command Line Processor
> of DB2 using the CATALOG commands.



Tue, 19 Jul 2005 00:51:28 GMT
 confused -- db2 client configuration assistant (CCA)
Hello:

What I meant was that using the ODBC interface through the Windows Control Panel to setup an ODBC data source
would not update the DB2 directories. I was not in any way referring to using the ODBC/CLI interface to access
database data. Once all data sources are setup and database directory and node directory properly setup I would
expect you would be able to use any ODBC compliant product to access the data ... I say "expect" as I am by no
means an ODBC expert nor an expert on the nuances of ODBC applications.
--
Bob Harbus
Consulting I/T Specialist - IBM Software Services for Data Management - IBM Toronto Lab
IBM Certified Database Associate - DB2 Universal Database V8.1 Family
IBM Certified Database Administrator- DB2 Universal Database V8.1 for Linux, UNIX, and Windows

Quote:

> Thank you very much, but one more question -- when you say "but it will not update the DB2 database and  node
> directories" -- this does not apply to recordsets pulled from the database tables, right? Should be able to
> update and insert records into tables using visual basic and dsn name alone?

> ================================================================


> > See my thoughts below...


> > > I apologize :( -- I have been posting tons of messages in this newsgroup! But I am trying to set
> > > up a db2 client server configuration and simply cannot seem to find the required information
> > > elsewhere!

> > > Q.1. Where can I get the db2 CCA from? Can this be downloaded from the IBM website

> > Assuming here you are on DB2 UDB V7.x, the Client Configuration Assistant is included with the DB2
> > Runtime Client if I recall correctly. You need to have the client code installed to have the CCA.

> > > Q.2. The CCA does not require that the DB2 application be installed on each client machine, right?

> > Not really sure what you are asking. The Client Configuration Assistance assists you with
> > cataloguing your remote server to the client and for setting some related parameters. If you are not
> > going to have an application on a machine, why worry about the DB2 Client Configuration Assistant?

> > > Q.3. Can the same effect of the CCA be achieved by going to start-settings-control
> > > panel-administrative tools - data sources on a windows 2000 computer?

> > Not 100% That will do the ODBC layer of the connection, but it will not update the DB2 database and
> > node directories. You can either do that through the DB2 CCA or through the Command Line Processor
> > of DB2 using the CATALOG commands.



Tue, 19 Jul 2005 01:36:32 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Thank YOU!!! -- db2 client configuration assistant (CCA)

2. DB2 Client Configuration Assistant on windows

3. SQL5001N In DB2 Client Configuration Assistant

4. questions on Client Configuration Assistant

5. Client Configuration Assistant and the AS400

6. Cannot add database in Client Configuration Assistant

7. where is client configuration assistant on Solaris ?

8. Solution: SQL10007N with Client Configuration Assistant

9. Client Configuration Assistant

10. Client Configuration Assistant on NT

11. DB2 Client Configuration on Solaris

12. Q: DB2 Client Configuration and db2cfexp/db2cfimp


 
Powered by phpBB® Forum Software