Filter
Top Products
22 DB2 Manager User Guide
StorageTek Proprietary
The following is an example of how to specify the PPT entry in the
appropriate SCHEDxx member of SYS1.PARMLIB:
PPT PGMNAME(OTDBP200)
NOSWAP
KEY(7)
SYST
e. Update FLPA or MLPA definitions.
The DB2 Manager SQL intercept module OTDBP300 from the distribution
LPA library must be installed in the FLPA or MLPA. There are no functional
considerations for DB2 Manager between installation of this module in the
FLPA or MLPA, and consequently the choice may be left to the system
programmer responsible for the administration of the system on which the
installation is being performed.
Using the FLPA will eliminate paging for execution of module OTDBP300, but
will reduce the total amount of real storage available for system use by about
2k bytes. If the amount of real storage available is limited, allow the above
module to be paged as normal by installing it in the MLPA.
To install in the FLPA, perform the following tasks:
• Add module OTDBP300 to member IEAFIXxx in SYS1.PARMLIB.
OTDBP300 is on the distributed DB2 Manager LPA library – this library
should be specified in the INCLUDE parameter as the location of the
required module, or the module copied to another library which already
has an entry in the SYS1.PARMLIB member.
• Add the NOPROT option to the FIX parameter in the IEASYSxx member
in SYS1.PARMLIB, as follows:
FIX = (xx,NOPROT)
To install in the MLPA, perform the following tasks:
• Add module OTDBP300 to member IEALPAxx in SYS1.PARMLIB.
OTDBP300 is on the distributed DB2 Manager LPA library – this library
should be specified in the INCLUDE parameter as the location of the
required module, or the module copied to another library which already
has an entry in the SYS1.PARMLIB member.
• Add the NOPROT option to the MLPA parameter in the IEASYSxx
member in SYS1.PARMLIB, as follows:
MLPA = (xx,NOPROT)