Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.
| Is This Answer Correct ? | 23 Yes | 5 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How does coalesce work?
Which components manage deadlocks 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 is a db2 package?
Can there be more than one cursor open for any program?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are the prerogatives?
How to find the maximum value in a column in the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What types of tables are there in the db2 database?
What is the syntax for creating a table in the db2 database?
What are foreign keys in db2?
What is dpf in db2?
Give a brief description of db2 isolation levels?
