Difference between DB2 Express and DB2 Express Lite?

bxst...@yahoo.co.uk

unread,

Aug 2, 2014, 10:49:41 AM8/2/14

to

A couple of month ago I found somewhere in Internet a DB2 Express "Lite" version of about 400MB.

What the difference to the "normal" DB2 Express-C from IBM download page?

The download package from IBM contains an "fp1" like

v10.5fp1_win_expc.exe

For what does "fp1" stand?

Do I need an additional license to use DB2 for small non-commercial usage?

Ben

CRPence

unread,

Aug 2, 2014, 2:34:03 PM8/2/14

to

On 02-Aug-2014 09:49 -0500, bxst...@yahoo.co.uk wrote:
> <<SNIP>>

> The download package from IBM contains an "fp1" like
> v10.5fp1_win_expc.exe
>

> For what does "fp1" stand? <<SNIP>>

Most likely the successive characters FP stand for FixPack, and the
digit(s) following are the numerical value as a designation of which FP
is included with that file; thus likely, the file includes the first
FixPack for the v10.5 feature.

--
Regards, Chuck

Mark A

unread,

Aug 4, 2014, 8:20:35 PM8/4/14

to

That is DB2 V10.5 Fixpack 1. All DB2 install files are cummlative, so it is the complete installation file
needed. DB2 Express-C (Community Support Only) has all the licensing you need in the installation,
and may be used for free for commercial or non-commerical purposes (not kidding). There are certain
functions missing from this edition, such as HADR and Table Partitioning.

Be aware that there is a different edition called DB2 Express that is a licensed product and must be
purchased.

bxst...@yahoo.co.uk

unread,

Aug 5, 2014, 6:12:17 AM8/5/14

to

Ok, thank you.

but just once more: Whats the difference to the 'lite' version?

And where can I download the lite version exactly?
It is not listed here:

http://www-01.ibm.com/software/data/db2/express-c/download.html

Ben

Mark A

unread,

Aug 5, 2014, 4:40:14 PM8/5/14

to

I have never heard of a "lite" version. Here are the DB2 editions for 10.5:

DB2 Express-C (free for any use whatsoever)
DB2 Express
DB2 Workgroup
DB2 Advanced Workgroup
DB2 Enterprise
DB2 Advanced Enterprise

Here is some additional info abou them:
http://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html?ca=drs

bxst...@yahoo.co.uk

unread,

Aug 6, 2014, 8:52:33 AM8/6/14

to

Ok, but why is the "Lite" version mentioned at some places e.g. here:

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/t0058712.html?lang=en

Mark A

unread,

Aug 6, 2014, 2:23:51 PM8/6/14

to

> Ok, but why is the "Lite" version mentioned at some places e.g. here:
>
> http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/
doc/t0058712.html?lang=en

I found the following explanation (Don't know if it is available for 10.5). Note that the DB2 engine is
the same, just doesn't have some add-on tools including in the download.:

The DB2 Express-C database server is downloaded worldwide, but broadband internet is not yet
universal. Because of this, we are releasing a light version of DB2 Express-C 9.7.2 for Windows. It's an
amazing 44% smaller than the full download.

Unlike the lighter download, the DB2 Express-C (full) includes the Control Center, Full Text Search,
Configuration Assistant, and the First Steps wizard. It also has support for non-English languages in its
user interface. However, if you don't need these features, you can grab the DB2 Express-C (light) for a
quicker download and a simpler installation.

For example, if you are setting up a DB2 database on a Windows server that you plan to administer
remotely with Data Studio, then the light version of DB2 Express-C is a great choice.