All about DB2 V10 UDB Fundamentals

DB2 UDB Table spaces

  1. System Temporary table space: Work area for Joins and Sorts
  2. Catalog table space: Catalog tables with meta data
  3. User temporary table space: Declare Global Temporary Tables
  4. User table space: User defined tables

DB2 UDB Products

  1. DB2- Express- C: free
  2. DB2 Express and DB2 Work Group
  3. DB2 Enterprise server
  4. DB2 Advanced Enterprise Server

New in DB2 10:

  • You can install the IBM® DB2 pureScale Feature while installing DB2 Enterprise Server Edition, DB2 Workgroup Server Edition, and DB2 Advanced Enterprise Server Edition.
  • You can now install IBM Data Studio from the DB2 Launchpad.

DB2 has APIs for REXX, PL/I, COBOL, RPG, FORTRAN, C++, C, Delphi, .NET CLI, Java, Python, Perl, PHP, Ruby, and many other programming languages. DB2 also supports integration into the Eclipse and Visual Studio integrated development environments.

Sources

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.