× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.