Question & Answer
Question
Is there any method to determine whether a rebind of SYSSTAT package is necessary?
Answer
With DB2 on Linux/Unix/Windows, this package is automatically bound to a database when it has been created, upgraded or a fixpack applied. However for DB2 for z/OS this would need to be manually performed after applying a fixpack to DB2 Connect.
IBM recommends rebinding the SYSSTAT packages located in @db2clist.lst (db2clist.bnd) to ensure it was bound from the most recent DB2 release and fixpack level. However, in some 24/7 customer environments, it may be necessary to schedule an outage because the bind process holds locks which impacts performance.
The SYSSTAT package is used to execute static SQL and downwards compatible with lower releases and fixpacks of DB2. SYSSTAT packages from older releases on the database server increase the chance when an application is using a newer release and fixpack of DB2 LUW on the client side ( e.g. v10.1/v10.5) it may look for additional sections and return an error such as SQL0525. There is no method to identify whether DB2 release xx Fixpack xx is looking for package section xxx in SYSSTAT.
A test environment can be setup to help mitigate this issue by installing the DB2 release and fixpack level used by the application and then calling a stored procedure on the DB2 database server from a CLI application (e.g. ODBC, .NET) which uses the the SYSSTAT package. However this is no guarantee since the official recommendation is to rebind db2clist.bnd.
For DB2 database servers on z/OS the query below can help determine which release and fixpack level SYSSTAT was bound from. This query is not available on DB2 for Linux/Unix/Windows. The example below indicates SYSSTAT was bound from a DB2 v9.7 FP9 client with IP address 192.168.47.100.
$ db2 "select name, collid, pdsname from sysibm.syspackage where
name='SYSSTAT' and collid='NULLID'"
NAME COLLID PDSNAME
-------- ---------- --------------
SYSSTAT NULLID SQL09079.::FFFF:192.168.47.100
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - Bind","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1;8.2;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21688155