TMA-DB2-ZOS-2.1.8
Secure application access by using package controls
Description
The BIND options, ENABLE and DISABLE determine the connection types for a specific plan or package. It is recommended that you use these options to control the connection types for applications. Restricting applications to use approved connection types prevents unauthorized access.
How it is checked
Audit method: Manual review
This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.
1. Issue the following SQL statement to determine the approved connection types for a specific package or a plan. SELECT PKS.SYSTEM, PKS.ENABLE, PKS.CNAME FROM SYSIBM.SYSPACKAGE PK, SYSIBM.SYSPKSYSTEM PKS WHERE PK.COLLID = PKS.COLLID AND PK.NAME = PKS.NAME; SELECT PLS.SYSTEM, PLS.ENABLE, PLS.CNAME FROM SYSIBM.SYSPLAN PL, SYSIBM.SYSPLSYSTEM PLS WHERE PL.NAME = PLS.NAME; 2. Review the output.
How it is fixed
Fix method: Guidance or infrastructure patch
Issue the BIND PACKAGE / BIND PLAN / REBIND PACKAGE / REBIND PLAN command with the ENABLE and DISABLE option to specify an approved connection type based on the rules of your organization.
Properties
- Operating systems
- Any
- Tags
- db2-zospermissions
- Reference
- CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.1.8 Secure application access by using package controls