Which DB2 catalog tables are used to produce a list of
table column by table for all tables in a database?
What else is there in the PLAN apart from the access path?
what is the soft code for deadlock ?
What is multi row fetch in db2?
What is the connection string to connect to the DB2 Database ?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
what needs to be done if a table is in copy pending / check pending status?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Give some example of statistics collected during RUNSTATS?
What are the various locking levels available?
Define declaration generator (dclgen).
What is the difference between Where and Having Clause
How do you do the EXPLAIN of a dynamic SQL statement?