What is meant by local DB2?
-
The DB2 application server in which the application's plan is bound is known as local DB2.
-
The DB2 application server in which the application's package is bound is known as local DB2.
-
The DB2 application server in which the application's load is bound is known as local DB2.
-
None of the Above
In DB2 terminology, the local DB2 is the application server where the application's plan is bound. A plan contains the bound SQL statements and access paths that the application will use. Package binding is a different concept related to DB2.
A "local DB2" refers to the DB2 subsystem where an application's package or plan has actually been bound — i.e., the DB2 system the application directly connects to and executes against, as opposed to a "remote" DB2 accessed indirectly (e.g., via DRDA). Binding the plan there is what makes that instance the application's local DB2.