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

Is there any command or tool for doing DB2 Catalogs reorg/check?

P: n/a
Hi there,

Is there any command or tool for doing DB2 Catalogs reorg/check to
keep the contents are correct?

If the contents within catalogs are incorrect due to unexpected
situations, is there a way to re-build them?
Thanks in advance,

Laurence

Jul 11 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
try the db2cfexp and db2cfimp commands

Knokmans
"Laurence" <wo**********@gmail.comwrote in message
news:11*********************@n60g2000hse.googlegro ups.com...
Hi there,

Is there any command or tool for doing DB2 Catalogs reorg/check to
keep the contents are correct?

If the contents within catalogs are incorrect due to unexpected
situations, is there a way to re-build them?
Thanks in advance,

Laurence

Jul 11 '07 #2

P: n/a
On 7 11 , 6 50 , "Knokmans" <knokm...@nospam.comwrote:
try the db2cfexp and db2cfimp commands

Knokmans

"Laurence" <worldwide...@gmail.comwrote in message

news:11*********************@n60g2000hse.googlegro ups.com...
Hi there,
Is there any command or tool for doing DB2 Catalogs reorg/check to
keep the contents are correct?
If the contents within catalogs are incorrect due to unexpected
situations, is there a way to re-build them?
Thanks in advance,
Laurence
It is my fault. I didn't describe that clearly.

Tthese commands only export/import the following info:

* Database information (including DCS and ODBC information)
* Node information
* Protocol information
* database manager configuration settings
* UDB registry settings
* Common ODBC/CLI settings.

It contains without contents of catalog tables/views.

Is it possible to reorg/check the contents of catalog tables/views?

Jul 12 '07 #3

P: n/a
Laurence wrote:
On 7 11 , 6 50 , "Knokmans" <knokm...@nospam.comwrote:
>try the db2cfexp and db2cfimp commands

Knokmans

"Laurence" <worldwide...@gmail.comwrote in message

news:11*********************@n60g2000hse.googlegr oups.com...
Hi there,
Is there any command or tool for doing DB2 Catalogs reorg/check to
keep the contents are correct?
If the contents within catalogs are incorrect due to unexpected
situations, is there a way to re-build them?
Thanks in advance,
Laurence

It is my fault. I didn't describe that clearly.

Tthese commands only export/import the following info:

* Database information (including DCS and ODBC information)
* Node information
* Protocol information
* database manager configuration settings
* UDB registry settings
* Common ODBC/CLI settings.

It contains without contents of catalog tables/views.

Is it possible to reorg/check the contents of catalog tables/views?
You can use the EXPORT command to export the content of the DB2 catalog.
And you may want to use the "db2look" utility if you would like to have
different representations or a SQL script to create the respective database
objects.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jul 12 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.