Why are no BIND statements generated when executing the Database Management for Db2'Bind for Selective Maintenance
Article ID: 39484
Updated On:
Products
Issue/Introduction
The Database Management for Db2 for z/OS Post Install Selective Maintenance bind is not generating any BIND statements
despite INLPKQRY reporting that there are packages to bind:
PACKAGES CHECKED = 120
PACKAGES TO BIND = 35
PACKAGES ALREADY BOUND = 85
Why are no BIND statements generated?
Cause
The GENRBIND processing determines the packages that need rebinding based on the products that have been selected:
1 - The INSIBIND Rexx exec is executed for a 'Selective Maintenance' bind.
2 - This in turn calls program INLPKQRY
3 - It is program INLPKQRY that determines which packages need binding using CDBASKL1 and SYSIBM.SYSPACKAGES. If the contokens differ then the package is identified as needs to bind.
4 - The results are reported in the 'PACKAGES CHECKED', 'PACKAGES TO BIND' and 'PACKAGES ALREADY BOUND' statistics in the output.
5 - INSIBIND then compares the list of packages identified as needs to bind to the products selected, as specified in PDTSEL in the INSSYSIN DD.
If an identified package is for a non-selected product, then it is removed from the list of packages to bind.
6 - This leaves only packages needed to bind for selected products.
So in this scenario INLPKQRY reports:
PACKAGES CHECKED = 120
PACKAGES TO BIND = 35
PACKAGES ALREADY BOUND = 85
The package statistics reported by INLPKQRY are for all packages regardless of which products have been selected.
This does not reflect the final number of Bind Package statements generated in the GENRBIND ISPFILE.
The result is that there are no packages that need binding for the products that have been selected.
Resolution
The presence of the PDTSEL card in the INSSYSIN DD is governed by the products that are selected on the ‘Product Selection List’ in the
‘Session and environmental options’ within Post Install.
If all products are selected, as would be the normal process, then the PDTSEL card is omitted from the INSSYSIN DD
options and the binds are generated for all products.
If a subset of the products has been selected, then the PDTSEL card is generated and includes a list of those products selected.
Binds will therefore only be generated for those products selected.
Feedback
