Data Center Strategies for the CIO
So have you upgraded to DB2 Version 8 yet? Either way, I hope you enjoy this new micro-quiz on
DB2 V8. It will both test your knowledge and provide additional resources you may find useful when
contemplating an upgrade or getting the most out of going to V8.
So are you using DB2 V8 yet? Or are you waiting? Let us know what your upgrade plans are by
clicking here.
 Table of
Contents |
When did 31-bit addressing come to
DB2?
SQL bytes
Major security improvements in DB2 V8
DB2 V8 is not for more "mature"
mainframes
Padded vs. non-padded indexes
| When did
31-bit adressing come to DB2? |
 Return to Table of
Contents |
When did 31-bit addressing come to DB2?
- A) 1979
- B) 1980
- C) 1981
- D) 1982
You can find the answer in this tip The benefits and
drawbacks of DB2 V8 by clicking here.
| SQL
bytes |
Return to Table of Contents |
In DB2 V8, SQL statements can be how long?
- A) Up to 32,765 bytes
- B) Up to 65,530 bytes
- C) Up to 262,120 bytes
- D) up to 2,097,152 bytes
The answer can be found
in this tip: Hot DB2 features
| Major
security improvements in DB2 V8 |
Return to Table of
Contents |
There are some major security improvements in DB2 V8. One of the biggest is
- A) Table level security
- B) Object level
- C) Row level security
- D) User level security
To find the answer, click here to see DB2 V8 = better security
| DB2 V8 is not
for more "mature" mainframes |
Return to Table of
Contents |
The latest release of DB2 is not for shops that are running more "mature" mainframes. Which of
these statements is true?
- A) z/OS v1.4 or higher is needed to run DB2 V8
- B) DB2 V8 will run on OS/390 but not all functionality will be available
- C) DB2 V8 will only run on zSeries machines running z/OS v1.3 or higher
- D) Trick question! IBM always makes DB2 run on all versions when unveiling a new release
You can find the answer here
in this tip What will be the impact of DB2 V8?
| Padded vs.
non-padded indexes |
Return to Table of
Contents |
What is the difference between a padded and non-padded index?
- A) Padded indexes has the same length so each column in an index has fixed length
- B) Padded indexes have extra space so data integrity is conserved
- C) Non-padded indexes allow for longer indexes
- D) Trick question! There is no such thing as a non-padded index
To find the answer, read this Q&A:
IBM fellow on DB2 V8 for zSeries
This was first published in November 2004