QSYS2.OBJECT_STATISTICS User Defined Table Function (UDTF)

In IBM® i 7.3, many new result columns were added to the QSYS2.OBJECT_STATISTICS() UDTF. By adding columns to this UDTF, any customer views which reference the UDTF are left in an unusable state.

An attempt to query the view when its in this unusable state will fail with SQL0443, preceded by CPF503E, CPF426A and MCH3601 failure messages.

Customers need to review their views to determine if they have any references to this UDTF. Any views that reference the UDTF need to be recreated after upgrading to IBM i 7.3.

To locate the views with this dependency, execute the following query:

SELECT VIEW_SCHEMA, VIEW_NAME, A.* FROM QSYS2.SYSVIEWDEP A
 WHERE OBJECT_TYPE = 'FUNCTION' AND OBJECT_NAME = 'OBJECT_STATISTICS' AND 
 OBJECT_SCHEMA = 'QSYS2' AND VIEW_SCHEMA NOT IN ('QSYS2', 'SYSIBMADM') ;

An easy way to recreate the view is to use System i® Navigator's Generate SQL feature, choosing the OR REPLACE option. After the SQL is generated, simply execute the statement.