Monday, June 17, 2013

1 DB2 Demo application and DB2 Server Driver package

IBM publish the application “DB2demo” for user to experience and test the DB2 features.  The application can be download from here .

SQL features

  • Referential integrity
  • Domains and constraints
  • Triggers
  • Recursive SQL
  • Outer joins

Advanced object-relational features

  • Large object support (BLOBs)
  • User-defined types
  • User-defined functions
  • Table functions
  • Row-types and typed tables
  • Reference types
  • SQL PL stored procedure language

XML support

  • SQL/XML functions
  • XML data type
  • XQuery language extensions

Business intelligence features

  • Star schema support
  • Multi-dimensional analysis
  • Dynamic bitmap indexes
  • Automatic summary tables
  • Compression
  • Table partitioning

Installation is very simple , just basic step by step like any other application.


The application does have db2 client dependence, If you don’t have db2 client install, you will get the error “File not found db2cli”


To fix this error, we need to install db2 client.

DB2 Client

There are various db2 client available .

  • IBM Data Server Driver Package
  • IBM Data Server Driver for JDBC and SQLJ
  • IBM Data Server Driver for ODBC and CLI
  • IBM Data Server Runtime Client
  • IBM Data Server Client

Because I only need the db2cli capability, I decide to choice the smaller footprint “IBM Data Server Driver Package” .  The package can be download from this link. The db2demo is 32-bit application,therefore the 32-bit db2 client is required.






Configure the db2 server client

Compare to RUNTIME client, There are 2 major short for the IBM Data Server Driver Package :

  1. NO DB2 cmd
  2. Can not catalog the database.

In order for db2 to know where is the database, we have to update the db2dsdriver.cfg.

The path of the db2dsdriver.cfg is in the C:\ProgramData\IBM\DB2\IBMDBCL1\cfg , Here is my sample of the configuration file.

      <dsn alias="db2inst97" name="SAMPLE" host="" port="50001"/>
      <!-- Long aliases are supported -->
      <database name="SAMPLE" host="" port="50001">

Start DB2demo

The db2demo works properly after the db2dsdriver.cfg is set.







  1. CBD oil sublingual drops are one of the most popular and versatile forms of CBD. Easy to use and control, simply put the preferred number of CBD drops under your tongue. Finding the right amount for you is a personal journey, depending on your preferences. Many people find that starting low and increasing the strength allows them to find what works for them.



SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates