Answer Posted / obularaju
1) Simple Tablespace
2) Segmented Tablespace
3) Partitioned tablespace
| Is This Answer Correct ? | 27 Yes | 5 No |
Post New Answer View All Answers
What is with ur in db2?
What is db2 bind?
How can record locking be achieved in those DB2 versions which do not support it?
Who uses db2?
Explain correlated sub-queries.
How to create db2 table in mainframe?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Give a brief description of db2 isolation levels?
What is a system catalog table in db2?
Comment whether the cursor is closed during commit or not.
Explain package in db2 and its advantages?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is an instance database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is dbrm in db2 database?