When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
3 7455
Which component is responsible for db2 startup and shutdown?
How do we specify index to include or not during bind process.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Define db2 and its databases?
Differentiate between cs and rr isolation levels? Where do you specify them?
Explain in brief how does db2 determine what lock-size to use?
What does runstats do in db2?
What are the different types of base tables?
What is the advantage in De-normalizing tables in DB2?
Can you use max on a char column?
What are foreign keys in db2?
What is the physical storage length of timestamp data type?
What is bind package and plan in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is the purpose of rollback and commit?