Select Query--> Prepare to invoke the PREPARE SQL command. This command instructs DB2 to evaluate the query for the most efficient execution and then devise a plan for its execution.
The Prepare option is available for queries only in the SQL view.
The Set User Information dialog box opens after you select the PREPARE option. Type a valid user ID and password to prepare the query on the database.
During this operation:
If successful, an empty results set will be returned that shows all columns selected for the query.
Later, when you run the prepared query, the prepared plan will be executed instead of developing a plan at run time.