Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jessica
A plan is an executable module containing the access path
logic produced by the DB2 optimizer. It can be composed of
one or more DBRMs and packages. Before a DB2 for z/OS
program (with static SQL) can be run, it must have a plan
associated with it.
Plans are created by the BIND command. The plan is stored in
the DB2 directory and accessed when its program is run.
Information about the plan is stored in the DB2 catalog.
| Is This Answer Correct ? | 88 Yes | 5 No |
Post New Answer View All Answers
What happens in bind step in a db2 program?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How many databases are there?
what is the role of the cursor in db2?
What is the role of union all and union
Outputs of explain are with matchcols = 0. What does this signify?
What is the role of data manager in the db2 database?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Which is faster delete or truncate?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Which components manage deadlocks in db2?
What is dclgen (declaration generator)?
What is the maximum size of varchar data type in db2?
When reorg is used?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
