V8.2 Check if nonrecoverable load was done

janman

Is there a place in the catalog tables where I can get info about non
recoverable loads performed on the tables. I use list history command
to get the info about loads but it's not granular (nonrecoverable or
not) but I can get the table names.

Jul 26 '07 #1

janman

On Jul 26, 12:12 pm, janman <mjana...@hotmail.comwrote:

Is there a place in the catalog tables where I can get info about non
recoverable loads performed on the tables. I use list history command
to get the info about loads but it's not granular (nonrecoverable or
not) but I can get the table names.

Found from IBM tech that the info is not stored in the catalogs.

Only way is to use

db2 list history load all for db sample

Jul 31 '07 #2