Why are no BIND statements generated when executing the 'Bind for Selective Maintenance'.

Document ID : KB000039484
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:  

The CA Products 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?

 

 

Answer: 

 

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?
 

 

Additional Information: 

 

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’ of the ‘CA Products for DB2 for z/OS Post-Install Tailoring’ panels.

 

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.