| Other DB2 Interview Questions |
|| Asked @
|How many Buffer pools are there in DB2 and what are they?
|what is check point and restart Logic ? why do we go for
|What is DCLGEN?
|What is an EXPLAIN in DB2.
How and what is the steps followed in EXPLAIN command. Can
all the queries be used in EXPLAIN command to check the
|wht displays the number of times a query modified ?
|How would one remove old reorg information from the DB2
|i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes?
|the dd name for ksds is dest1 and what is the dd name for
alternate index of ksds ?
a.dest b.dest1 c.dest1a d.dd1
|Is it possible to precompile if db2 goes down?
|What is correlation names?
|How does one bind 2 versions of a CICS transaction with the
same module name in two different CICS regions that share
the same DB2 subsystem?
|in GDG: is it poosible to copy records from a file which
utilizes some 100 cylinders to a gdg whose model is defined
as trk(1,0) and also it possible to copy 100 bytes file to
80 bytes file?
|For more DB2 Interview Questions Click Here |