V8.2 Check if nonrecoverable load was done

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

janman - 26 Jul 2007 18:12 GMT

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.

Reply to this Message

janman - 31 Jul 2007 23:12 GMT

> 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

Reply to this Message