DB2 Fix Pack blues


SAP reported a while back that they were withdrawing support for DB2 9.7 FP10 due to a defect reported by IBM, see Defect in DB2 BINSORT might cause misordered index in 9.7 FP10 or 10.5 FP5SAP.

We have installed the replacement 9.7.10SAP fix pack on some instances but not production.
Having just refreshed a QA instance from production I needed to verify if the post upgrade steps had been completed, which included applying the 9.7.10SAP fix pack.

$ db2 "select VERSIONNUMBER,VERSIONBUILDLEVEL from SYSIBM.SYSVERSIONS"

VERSIONNUMBER VERSIONBUILDLEVEL
------------- ------------------------------
      9070300 special_25542
      9071000 s141015

$ db2level
DB21085I  This instance or install (instance name, where applicable: "db2sid")
uses "64" bits and DB2 code release "SQL0907A" with level identifier
"080B0107".
Informational tokens are "DB2 v9.7.0.10", "special_34106", "IP23657_34106", and
Fix Pack "10".
Product is installed at "/db2/db2sid/db2.9.7_10SAP"

This confirmed my suspicion that db2updv97 had not been run - VERSIONBUILDLEVEL should match the output of db2level, in this case “special_34106”.

Comment on this article using form below. Requires email login only for authentication. HTML forbidden, Markdown only.