Post Install task Report on Obsolete PTDB Objects returning QI514E PREPARE statement TS_TAB failed SQL-805 for package INSDRPRT
Article ID: 266581
Updated On:
Products
Issue/Introduction
Executing new Database Management for Db2 for z/OS r20 Post Install Db2 task
option, Report on Obsolete PTDB Objects (Recommended) ssid0005, introduced by
PTF LU10079 is returning the following:
QI514E PREPARE statement TS_TAB failed: SQLCODE = -805
DSNT408I SQLCODE = -805, ERROR: PACKAGE NAME ssidxxxx..INSDRPRT.1BA7F-
E89199F9D7B NOT FOUND IN PLAN GEN1xxxx. REASON 03
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -251 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF05' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
INFORMATION
Resolution
Verify the Db2 Bind requirements documented within PTF LU10079 have been
completed prior to execution of the Report on Obsolete PTDB Objects ssid0005 task:
+----------------------------------------------------------------------+
| Db2 Common Components Version 20.0 |
+----------+-----------------------------------------------------------+
|SEQUENCE | After Apply |
+----------+-----------------------------------------------------------+
|PURPOSE | Bind Plans and Packages |
+----------+-----------------------------------------------------------+
|USERS | |
|AFFECTED | All Users |
+----------+-----------------------------------------------------------+
|KNOWLEDGE | |
|REQUIRED | Db2 Tools Post Install Customization |
+----------+-----------------------------------------------------------+
|ACCESS | 1. Db2 Tools Post Install |
|REQUIRED | 2. BIND, SYSADM or SYSCNTL on Db2 subsystem. |
+----------+-----------------------------------------------------------+
| | |
+----------+-----------------------------------------------------------+
**************************
* STEPS TO PERFORM *
**************************
Bind Control Cards have changed as part of this maintenances. After
this maintenance is applied, Bind Control cards must be regenerated for
all installed product plans and packages.
Refer to the Installing documentation for the Database Management
Solutions for Db2 for z/OS on https://techdocs.broadcom.com for more
information about performing the task in the following step.
1. Using the newly generated Bind Control Cards, a Bind Replace must
be performed on the plans and packages for all installed products.
IMPORTANT!
If SYSVIEW for Db2 is installed and the IFI-PLAN operational
parameter is not used, stop the data collectors first to allow the
BIND to complete successfully without contention with the plans being
used by the data collectors.
Additional Information
Feedback
