DB2 Version 5 Features

 <  Day Day Up  >  

DB2 V5 was first announced by IBM as V4.2. However, late in 1996 IBM changed plans and switched from a point release to a full-fledged new version. DB2 V5, generally available since June 1997, offers the following features.

Database Administration Features

LARGE tables (up to 254 partitions; approx. 1TB).

Multiple stored procedure address spaces.

Table renaming.

ASCII server support.

Native TCP/IP.

DCE security.

DDL-based support rows per page (up to 255).

Workstation GUI install.

Utility Features

Online REORG .

LOAD and REORG improvements.

COPY with thresholds.

RUNSTATS using sampling.

Programming Features

CASE expressions.

Stored procedure results sets.

Temporary tables.

RRSAF.

Call Level Interface (ODBC).

NULLIF function.

STRIP function.

Visual EXPLAIN .

Temporary tables.

Performance Features

Optimization changes.

Skip partition scanning.

Changes to stage 1 and indexable predicates.

SQL caching.

Persistent dynamic BIND .

Query Sysplex parallelism.

Partition locking.

Data sharing improvements.

DB2 Catalog Impact

Communications Database moved to the DB2 Catalog Database.

8 new or renamed tables.

31 tables have one or more new or changed columns .

65 total new columns.

59 total revised columns.

 <  Day Day Up  >  


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net