Answer Posted / s
Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do I add a column to an existing table in db2?
How to create backup table in db2?
What does db2 mean?
can we view the access paths created by dbrm ? how ? thx
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is netezza database?
What does a deadlock mean in DB2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are the benefits of using the db2 database?
How does coalesce work?
How will you return the number of records in table?
How can record locking be achieved in those DB2 versions which do not support it?
What is an instance database?