Need to recreate tables/views in SYSTOOLSPACE

[former_member283840]

Guru's:

Thanks for all the help in the past.

We copied (db2snapshot) system A to system B.  All went well except for the tables in SYSTOOLSPACE.  They are not there, or at least ALL of them are not there.  The only ones that are there are: 'HMON_ATM_INFO, DB2LOOK_INFO, POLICY, HMON_COLLECTION.  There are a lot  more in system 'A'.  I tried using db2look to recreate the DDL but can't use -a -v  together so I can't get the inoperable tables.  Here is my command:

db2look -d P01 -e -a -v SYSTOOLS -o db2look.sql.

I know there's got to be a way but not using db2look.

Thanks,

Len.

[johannes_heinrich]

Hello Len,

you can use the DB2 routine SYSPROC.SYSINSTALLOBJECTS to recreate these objects manually. See

SYSINSTALLOBJECTS procedure

in the IBM information center corresponding to your DB2 version.

Regards,

Johannes

[Former Member]

Hi Len,

I'm not too clear about what exactly has been done to get into this situation, but tables in SYSTOOLSPACE should mostly be created by DB2 automatically when you activate certain functions.  For example the HMON* tables are Health Monitor, which is in fact deprecated in later versions.

     db2look -d SID -z schemaname -e

...will give you all the table and view DDL in a schema.

Regards,

Jeremy