Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    16

    Unanswered: DB2 V8 ZOS Load Trace

    Hi,

    I am not sure how cna I trace the last load happened on table.

    Actually I want to trace the data refresh happened from production to QA by which ID since 11/02/09.

    I tried searching in sysibm. sycopy table, all IC I have there are only with type F.

    Apart form there , if there is any other parameter I can look for , please let me know.

    I am using RC/Querry and UPdate tools only.

    Thanks & Regards
    Nee

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    You can view from SYSIBM.SYSCOPY catalog table to see when the last load happend on the tablespace. Look for type = S.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •