Interested to Buy Any Domain ? << Click Here >> for more details...
can we view the access paths created by dbrm ? how ? thx
- 2 Answers
- 7195 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shweta agarwal
access path can be viewed by specifying the EXPLAIN
Parameter in the bind JCL as YES..
synatx
EXPLAIN(YES).
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
How is deadlock resolved?
What is the clustering index in the db2 database?
How do you find the maximum value in a column in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is syscat in db2?
What is load utility in db2?
What is node in db2?
What is db2 optimizer?
What is database manager in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
List some fields from sqlca?
Is db2 a mainframe database?
Which is faster delete or truncate?
What is the default page size of buffer pools?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
