How Plan is created while executing the query using SPUFI?
Answer Posted / guest
Plan is already created during the installation of the DB2I
tools.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are db2 objects?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How is deadlock resolved?
Is db2 a mainframe?
What is a db2 tablespace?
Name the lockable units in DB2?
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 would you find out the total number of rows in a db2 table?
What is the max length of sqlca?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Is db2 a programming language?
What is the information associated with sysibm.syslinks table?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is coalesce in db2?
Define data page.