Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
extracting db2 list node/db catalog entries
2,734 views
Skip to first unread message
peter sands
Jul 14, 2009, 1:39:24 PM7/14/09
to
Hello,
Shortly I will be migrating an instance to a new hardware box. The
instance I am moving has over 60 remote catalog entries in it.
Is there a quick way I can extract these node/db entries into a file
or some of script, that I can then run on the new box to re-catalog
the entries.
Shortly I will be migrating an instance to a new hardware box. The
instance I am moving has over 60 remote catalog entries in it.
Is there a quick way I can extract these node/db entries into a file
or some of script, that I can then run on the new box to re-catalog
the entries.
db2 9.5
thanks
Pete.
Jan M. Nelken
Jul 14, 2009, 3:37:41 PM7/14/09
to
Look up db2cfexp / db2cfimp commands.
db2cfexp filename maintain
can be used to transfer database catalog information to another machine (where
you would use db2cfimp filename) to import it.
Also - you can use db2 commands
list node directory
list database node directory
with db2 command using -r filename option to direct output to a filename, for
example:
db2 -r filename list db directory
Jan M. Nelken
Sawan
Jul 15, 2009, 12:37:47 PM7/15/09
to
If cataloging isn't must at the target system, then the you can use
db2dsdcfgfill utility to create the db2dsdriver.cfg file with all
entries from node/db directory.
Regards,
Sawan Gupta
0 new messages