Skip to Content
0
Nov 13, 2013 at 03:42 PM

Need to recreate tables/views in SYSTOOLSPACE

418 Views

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.