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

[Laurence]

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

[Knokmans]

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

[Laurence]

On 7 11 , 6 50 , "Knokmans" <[e-mail]:

try the db2cfexp and db2cfimp commands

Knokmans

"Laurence" <[e-mail] 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?

[Knut Stolze]

Laurence wrote:

On 7 11 , 6 50 , "Knokmans" <[e-mail]:

>try the db2cfexp and db2cfimp commands

Knokmans

"Laurence" <[e-mail] 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