Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: SYSPROC.SYSINSTALLOBJECTS usage

    Hello all,
    db2 10.1 wse onrhel 6

    I am working with procedure SYSPROC.SYSINSTALLOBJECTS

    I successfully executed proc.

    call SYSPROC.SYSINSTALLOBJECTS('EXPLAIN', 'D', CAST (NULL AS VARCHAR(128)), 'DB2INST1')

    and undertand tool - 'EXPLAIN'

    Can any body refer any URL / details for remaining tools name

    'AM' for creating activity monitor objects
    'DB2AC' for autonomous computing (health monitor)
    'STMG_DBSIZE_INFO' for storage management
    'OPT_PROFILES' for creating the optimization profile table
    'POLICY' for policy (tables and triggers)
    'EXPLAIN' for creating or migrating explain tables
    'ASP' for automatically generating statistics profiles

    Which table are associated with above tools ?

    thanks
    ssumit

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    look at the output of the following command:
    Code:
    db2 list tables for schema systools
    All these tables (except for EXPLAIN, which might be in any schema) sit there and have self-explanatory names.
    Regards,
    Mark.

Posting Permissions

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