the column "picture" in table emp_photo from sample db is defined as
blob(102400)
As a Blob type, the actual data should be stored separately from the
base table.

I'm following the instructions from "Up and Running With DB2 for
Linux".  I created these users/groups:
db2inst1:x:201:101::/home/db2inst1:/bin/bash
db2fenc1:x:202:102::/home/db2fenc1:/bin/bash

How can I create DSN to DB2 using IBM DB2 ODBC DRIVER

Is it possible to convert Windows DB2 databases to Linux DB2?
Is it extremely difficult if it's possible?
I have been shown a way to get it done but it's very ineffecient. This
involves exporting data to text files and running a few db2look SQL

   I am trying to install my copy of the DB2 Universal Workgroup
Server Edition on my Linux server (RedHat 9.0, kernel 2.4.20-6) and it
will not let me past the db2setup because of a Java error (which
doesn't make sense since I have installed version 1.5 which works).  I

I have db2 Net search extender 8.2 installled on AIX 5.2 server with DB2 8.2
udb. Does anyone can tell me the command to unstall the db2 nse?
Thanks!
Lan

Hi All;
We have 2 open PMRs - one for AIX, one for DB2 relating to this
problem, but I thought I'd see if I could make any progress in the
group.

I'm trying to retrieve blob obect from DB2 database using
COM.ibm.db2.jdbc.net.DB2Driver driver.
When i' m trying to get Blob from result set (resultSet.getBlob(1)) i
got this exception:

Can someone tell me what this exception means:
[SQL0913] Row or object SEKVENCE in EXTLOG001 type *FILE in use
Alan

DB2 V8 FP 10 running Linux RedHat 4.0.
I have created a system temporary tablespace and now I want to delete
it. However:
[db2inst1@asset4 extra]$ db2 "drop tablespace reorg"

can anyone tell me if its possible to create tables and populate tables
using a script via notepad ?
cheers

   I am trying to install my copy of the DB2 Universal Workgroup
Server Edition on my Linux server (RedHat 9.0, kernel 2.4.20-6) and it
will not let me past the db2setup because of a Java error (which
doesn't make sense since I have installed version 1.5 which works).  I

DB21085I  Instance "SES" uses "32" bits and DB2 code release "SQL08022" with
level identifier "03030106".
Informational tokens are "DB2 v8.1.9.917", "OD_14086", "WR21350_14086", and
FixPak "9".

  Is it not valid to use concatenation in a WHERE ... LIKE clause?
 SELECT iam0.g_itemId
  FROM g2_ItemAttributesMap AS iam0,
       g2_ItemAttributesMap AS iam1

Is there any way to create a dynamic row limit like "fetch first ? rows
only" using the JDBC driver and a PreparedStatement?
Bernd