Where is the access path logic created by the DB2 Optimizer
stored?
Answer / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
| Is This Answer Correct ? | 4 Yes | 2 No |
What is the difference between drop table and delete table?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How can you compare table column after update and before update?
How to access db2 tables in mainframe?
What are the Isolation levels possible ?
what is Runstats? Whem will u choose to runatats?
Why might full image copies be faster to implement than an incremental image copy?
What is the use of dclgen in db2?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
wht is d/f between union and joins ?
how to resolve -811