DB2 FOR LUW / DB2FORLUW / 970 - DB2

The function: SYSPROC.SNAP_GET_DYN_SQL_V95 may fail with the 
error SQL0430N : 
 
$ db2 "select * from table(snap_get_dyn_sql_v95('',-1)) as 
snap_get_dyn_sql_v95" 
 
or 
 
$ db2 "export to SYSIBMADM.SNAPDYN_SQL_20120528_1.ixf of ixf 
select * from SYSIBMADM.SNAPDYN_SQL 
 
Returns : 
 
SQL0430N  User defined function "SYSPROC.SNAP_GET_DYN_SQL_V95" 
(specific name "SNAP_GET_DYN_SQL_V95") has abnormally 
terminated.  SQLSTATE=38503

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 9.                        * 
****************************************************************

N/A

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in version 9.7 Fixpack 9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC93056 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

14.05.2013
08.09.2014
08.09.2014

9.7.FP9