467,209 Members | 1,373 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

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

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
  • viewed: 2630
Share:
3 Replies
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
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
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.

Similar topics

reply views Thread by Steve Whitlatch | last post: by
27 posts views Thread by Raquel | last post: by
7 posts views Thread by DB_2 | last post: by
3 posts views Thread by andy.standley@ecngroup.co.nz | last post: by
3 posts views Thread by jane | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.