Mention the location where the output received from explain statement is stored.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is reorg in DB2

3 Answers   Virtusa,


If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  


What is a bind card?

0 Answers  


Explain the contents that are a part of dclgen.

0 Answers  


what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,






how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


What is cursor in dbms?

0 Answers  


what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,


how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,


What are concurrency issues?

0 Answers  


what are extents?

5 Answers  


Categories