DB2 FOR LUW / DB2FORLUW / 970 - DB2

If you are using the pre-v97 version of the structure 
SQLB_TBSPQRY_DATA and calling sqlbftpq this can return the 
following error: 
 
SQL2032N  The "version id" parameter is not valid. 
SQLSTATE=22531 
 
This can be mis-leading as what this means is that the 
Tablespace lifeLSN value exceeds the size allocated for the 
target area.  In the pre-v97 structure we have a size of 6bytes 
for the lifeLSN.  However in v9.7 we can have a lifeLSN of 
8bytes.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If you are using the pre-v97 version of the structure        * 
* SQLB_TBSPQRY_DATA and calling sqlbftpq this can return the   * 
* following error:                                             * 
*                                                              * 
* SQL2032N  The "version id" parameter is not valid.           * 
* SQLSTATE=22531                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 Fixpack 6 or higher                      * 
****************************************************************

- Recompile application and make it use the v9.7 structure 
SQLB_TBSPQRY_DATA. 
- Using the MON_GET_TABLESPACE and the MON_GET_CONTAINER table 
functions instead.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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 v9.7 Fixpack 6 or higher

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84295 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.10.2011
13.06.2012
13.06.2012

9.7.FP6