http://www-912.ibm.com/a_dir/as4ptf.nsf/a18db68aae4a7d81862566ba005d145c/b8312eb0874232ff8625727b0057e44b?OpenDocument&Highlight=2,syspartitionstat
or
http://tinyurl.com/yoaved
Says:
PTF#:
SI24847 - i5/OS
Licensed Program: 5722SS1
APAR Fixed: View details for APAR SE26475
Release: 540
Cumulative Level: C7226540
IBM supplied database views are being added. These views are
used to return statistical information of existing database
objects. The column names and data in the views are a superset
of similar statistical views in DB2 for Linux, Unix, and
Windows.
Views:
QSYS2.SYSCOLUMNSTAT
QSYS2.SYSPARTITIONINDEXSTAT
QSYS2.SYSPARTITIONSTAT
QSYS2.SYSTABLEINDEXSTAT
QSYS2.SYSTABLESTAT
Functions:
QSYS2.COLUMN_STATISTICS
QSYS2.INDEX_PARTITION_STATISTICS
QSYS2.PARTITION_STATISTICS
In addition to the new statistical objects, this PTF also:
- redefines SYSIBM.SQLColPrivileges to be consistent with DB for
LUW, by returning table privileges.
- Add QSYS2.SQLGetAuth Function.
- Fix a problem where QSYS2 views were incorrectly referring to
Functions within SYSIBM.
Extended description of views:
SYSCOLUMNSTAT contains one row for every column in a table
partition or table member and one row for every combination of
columns from a statistics collection. If the table is a
distributed table, the partitions that reside on other database
nodes are not contained in this catalog view. They are contained
in the catalog views of the other database nodes.
SYSPARTITIONINDEXSTAT contains one row for every index built
over a table partition or table member. If the table is a
distributed table, the indexes over partitions that reside on
other database nodes are not contained in this catalog view.
They are contained in the catalog views of the other database
nodes.
SYSPARTITIONSTAT contains one row for every table partition or
table member. If the table is a distributed table, the
partitions that reside on other database nodes are not contained
in this catalog view. They are contained in the catalog views of
the other database nodes.
SYSTABLEINDEXSTAT contains one row for every index that has at
least one partition or member built over a table. If the index
is over more than one partition or member, the statistics
include all those partitions and members. If the table is a
distributed table, the partitions that reside on other database
nodes are not included. They are contained in the catalog views
of the other database nodes.
SYSTABLESTAT contains one row for every table that has at least
one partition or member. If the table has more than one
partition or member, the statistics include all partitions and
members. If the table is a distributed table, the partitions
that reside on other database nodes are not included. They are
contained in the catalog views of the other database nodes.
CORRECTION FOR APAR SE26475 :
-----------------------------
The new objects are created upon application of this ptf.
For IASP user's, create the objects by following these
directions:
SETASPGRP <iasp>
CHGJOB CCSID(37)
CALL QSYS/QSQSYSIBM
CIRCUMVENTION FOR APAR SE26475 :
--------------------------------
None.
Activation Instructions
None.
Special Instructions
None.
Rob Berendt
midrange.com
