By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

Exporting Client Configuration Assistant definitions from one computer to another

P: n/a
I've been building up a collection of DB2 database connections through
the Client Configuration Assistant.

What I've put together has become the "official list" of what we have,
and I need to export these so that the other people in the area can
pick up the list without having to go through the long manual process.

The Export feature does not export the whole set of information
(server, local name, comemnts, etc.) and selecting all the whole list
results in an empty file.

Has anyone had to do something similar and how did they get the
definitions out of the system and copied to other machines?

Thanks!

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
In article <11*********************@z14g2000cwz.googlegroups. com>,
bd******@sympatico.ca says...
I've been building up a collection of DB2 database connections through
the Client Configuration Assistant.

What I've put together has become the "official list" of what we have,
and I need to export these so that the other people in the area can
pick up the list without having to go through the long manual process.

The Export feature does not export the whole set of information
(server, local name, comemnts, etc.) and selecting all the whole list
results in an empty file.

Has anyone had to do something similar and how did they get the
definitions out of the system and copied to other machines?

Thanks!


I've used 'db2cfexp' and 'db2cfimp' from the command line without a
problem. I'm not sure it's available on every client.
Nov 12 '05 #2

P: n/a
This is the same output as with Clinet Configuration Assistant export.

What I need is the mapping from the DBAlias (eg, BARNEY01) to the
actual database
mybarney.db2inst.testdatabase (db2inst = 50791) to the acutal machine
information.

I can pull out the ODBC.INI and DB2CLI.INI files along with the
registry entries for LOCAL_MACHINE/..../ODBC.

What I can't find is the information that you see on the Properties
panel or when you go through the process of defining a new connection.

Thanks for the info so far...

Nov 12 '05 #3

P: n/a
In article <11**********************@g44g2000cwa.googlegroups .com>,
bd******@sympatico.ca says...
This is the same output as with Clinet Configuration Assistant export.

What I need is the mapping from the DBAlias (eg, BARNEY01) to the
actual database
mybarney.db2inst.testdatabase (db2inst = 50791) to the acutal machine
information.

I can pull out the ODBC.INI and DB2CLI.INI files along with the
registry entries for LOCAL_MACHINE/..../ODBC.

What I can't find is the information that you see on the Properties
panel or when you go through the process of defining a new connection.

Thanks for the info so far...

When using 'db2cfexp <your file> m' this info is exported to your file.
Did you try the 'm(aintain)' option?
Nov 12 '05 #4

P: n/a
I figured out how to get the DB2 connection detail information.

Under the C:\Program Files\SQLLIB\DB2 directoy are two subdirectories
SQLDBDIR and SQLNODIR. Copy them and all underlying files/directories
into a zip file.

Using regedit, export HKEY_LOCAL_MACHINE\SOFTWARE\ODBC into a file
and make copies of
ODBC.INI C:\Windows
DB2CLI.INI C:\Program Files\SQLLIB
If you copy them back into the appropriate directories on other system,
you're golden!

Considering that this is the thrid time that I've had to do this, I
have now created a document to cover everything.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.