how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none
Answer Posted / nawal kishore
Partitions can be range from 1 to 4096
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is catalog database in db2?
What is host variable?
Is ibm db2 free?
What does db2 stand for?
What do you mean by storage group (stogroup)?
What is runstats utility 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 the reason behind not using select * in embedded sql programs?
What is check constraint. Explain with example.
What is the use of predicate?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is declare cursor?
What is the function of logging in the db2 database?
What is multi row fetch in db2?