What does PLAN parameter refers?
-
PLAN Name in which the DB2 program has to be bound
-
Collection name in to which the program has to be bound
-
Database Name
-
Dataset in which the DB2 program resides
To answer this question, the user needs to have knowledge of DB2 and the process of binding a program.
The PLAN parameter in DB2 refers to the plan name in which the DB2 program has to be bound.
Option A is correct because the PLAN parameter specifies the name of the plan to which the program should be bound during the BIND process.
Option B is incorrect because the collection name refers to a set of related objects in DB2, and it is not related to the PLAN parameter.
Option C is incorrect because the database name refers to the name of the database in which the tables and other objects used by the program are located, and it is not related to the PLAN parameter.
Option D is incorrect because the dataset refers to the physical location of the program code, and it is not related to the PLAN parameter.
Therefore, the correct answer is:
The Answer is: A. PLAN Name in which the DB2 program has to be bound
The PLAN parameter refers to the DB2 plan name that the program is bound into. In DB2 for z/OS, a program's SQL statements are precompiled and bound into an application plan (or, in newer setups, a package within a collection); the PLAN parameter on the DB2 attach/run JCL or command tells DB2 which bound plan to use at execution time. It is not the collection name (that's for package binding), not the database name, and not a dataset name — those are separate, distinct concepts in DB2's bind/execution model.