All about DB2 V10 UDB Fundamentals

imagesThere are various Table spaces available.

  • System Temporary table space: Work area for Joins and Sorts
  • Catalog table space: Catalog tables with meta data
  • User temporary table space: Declare Global Temporary Tables
  • User table space: User defined tables

DB2 Products

  1. DB2 Database Products:
  2. DB2- Express- C: free
  3. DB2 Express and DB2 Work Group
  4. DB2 Enterprise server
  5. 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.

Checkout more details here.


Author: Srini

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