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.

Advertisements

Author: Srini

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