If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: How to Export DB2 databases from DB2 Client admin V7

Hi,

I was asked to migrate our WINDOWS clients from DB2 Client Admin V7 to DB2 Client Admin V9. Is there a way to export the databases that are configured on the clients into a file and then import it after i installed V9.

When i open Client Configuration Assistant, i can see all the DB2 Databases that are catalgued on the workstation. But when i press on EXPORT and then delete them all, and i press on IMPORT select the file, they are not coming back.

I've tried that too. When i do db2cfexp c:\db2exp.spf backup , the file is created. I copy the file on my other client on the c: drive. Then i type on my other computer: db2cfimp c:\db2exp.spf and when i go to Client Configuration Assistant there's no databases.

If i try the import manually in the Client Configuration Assistant, and i select my SPF file, i can only import the Client settings. I can't add a check box in front of Databases.

I suspect that the file format may have changed between versions 7 and 9. I guess you would need to recatalog databases manually, at least on one client machine. If you have many of those, export the settings using the v.9 configuration assistant.

Well, at first, i just want to try to export the databases settings on V7. Is there any reason why when i export it, with the command or the graphical interface i see nothing in the export file containing Databases informations. When i look around on the internet, every one that uses the db2cfexp command, it export the databases informations. All i get in my export file is this: