How Plan is created while executing the query using SPUFI?
Answers were Sorted based on User's Feedback
Answer / guest
Plan is already created during the installation of the DB2I
tools.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / arun chinnadurai
A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mangesh
No Plan is get created while executing the query using
SPUFI. SPUFI , QMF are only tools to check the correctness
of your query , i.e where ur query is correct or u have
coded anythig wrong .
Is This Answer Correct ? | 6 Yes | 7 No |
What is UNION,UNION ALL?
What is a LIKE table and how is it created?
Where is the access path logic created by the DB2 Optimizer stored?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
Are views updatable ?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
cobol-db2 runjcl please?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
How can you display the current date & current time ?
Which component is used to execute the sql statements?
What is a NULL value? What are the pros and cons of using NULLS?