DBSRFPR can be used to drop plans. In order to use this feature, add the following parameter (PARM=) to the execution statement in your JCL. following is the syntax diagram for using the PARM= parameter of DBSFRPR to drop plans:
►►─ PARM=' ─┬─ DROP PLAN=authid.sqlname ─┬─ ' ────────────────────────────────►◄ └─ DROP ALL PLAN=*.* ────────┘
Specify a drop command of either DROP or DROP ALL to indicate that you want a specified set of plans dropped from the MUF. Code DROP PLAN=authid.sqlname carefully to be certain you drop only the plans you want to drop. If you want every plan in your MUF dropped, use DROP ALL and PLAN=*.* (an asterisk followed by a period followed by another asterisk).
(Required.) Enter the authorization ID of object(s) to be dropped, or * (an asterisk) to drop all AUTHIDs of the specified entity type.
An existing AUTHID or * (the AUTHID may not exceed 18 characters.)
(No default)
(Required, if authid is specified.) Enter the name of a plan, or * (an asterisk). Specifying * will cause all entities of the specified AUTHID to be dropped. If * was specified as the AUTHID, then SQL name is treated as if * was specified.
The SQL name of an existing plan, or * (the name may not exceed 32 characters).
(No default)
|
Copyright © 2014 CA.
All rights reserved.
|
|