assistance requested: query to find affected views?

Chris Hoelscher

assistance requested: query to find affected views?
in preparing to install fixes into our DB2 environments, we observed this

(***Action for PK33483:
To make this fix effective for a view, the ALTER view
REGENERATE statement must be used to regenerate the view after
application of this PTF, if the view meets the following

1. the view definition references multiple encoding scheme
2. the view definition references datetime data type as the
result of using the rules for result data types.).

did anyone who has applied this fix write such a query to proactively find
such views? or did you rather wait until someone got the error (
"unsupported date format") and then regenerate the view?
if someone did write query, I would be grateful to take a peek at it

thanks much ,
Chris Hoelscher
Senior (but sometimes I wonder) IDMS & DB2 Database Administrator
Humana Inc
[login to unmask email]

The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at