Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Location
    Bucks, UK
    Posts
    13

    Unanswered: Sysibmadm.snaputil_progress

    Hi
    I'm running DB2 V9.7 on AIX 6.1.
    I was hoping to use SYSIBMADM.SNAPUTIL_PROGRESS in conjuntion with list utilities to see how some long-running RUNSTATS are progressing. List Utilities shows it's still chugging along:
    db2 => list utilities ;
    ID = 73
    Type = RUNSTATS
    etc...

    but
    db2 => select * from SYSIBMADM.SNAPUTIL_PROGRESS;
    0 record(s) selected.

    Have I omitted to switch something on somewhere? I've got the defaults set in DBM CFG:
    $ db2 get dbm cfg | grep ON
    Transaction processor monitor name (TP_MON_NAME) =
    Buffer pool (DFT_MON_BUFPOOL) = ON
    Lock (DFT_MON_LOCK) = ON
    Sort (DFT_MON_SORT) = ON
    Statement (DFT_MON_STMT) = ON
    Table (DFT_MON_TABLE) = ON
    Timestamp (DFT_MON_TIMESTAMP) = ON
    Unit of work (DFT_MON_UOW) = ON

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    There really is no progress checking for RUNSTATS, that is why the view returns nothing.

    Andy

Posting Permissions

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