I am designing DB2 database. I have some entities each has nearly 40-60
attributes. Each of these entity (table) have password, some other
information as high security attribute. So should i create new entity
which hold password data for all entity or should I place password data

I am doing an insert into a table with a generated key. How do I obtain
the generated key of the record I just inserted?

Please help me with this scenario:
Problem :
I have around 10 tables(having relationship with each other) and a data
asc file for each. i use import utility to load all the data one by one

I execute a query (against DB2 for iSeries), which, in its generic form
is as follows. This query runs just fine, executing in a couple of
seconds
SELECT V.FIELD01, V.FIELD02, V.FIELD03, V.FIELD04, V.FIELD05,

What happens if a nonrecoverable load is running when an online backup
is running? What would happen to the table and data if we have to use
that backup to restore the database?

I am trying to declare and cursor and thn load from that cursor into
another table. Since I have almost 4 million records, I cant do it
without the cursor which reduces the time by almost 1/10th.
I tried to create a sql statement for "load from cursor cur insert into

Im trying to extract db2 server current system timestamp from unix
shell script. So from shell script call the export command   " db2
export to curdate.txt of del modified by chardel' ' select current
timestamp from sysibm.sysdummy1".

On DB2 EEE v8.2 on Linux/Windows/Unix, is there any
catalog view that I can query with SQL to find tablespace-state?
The state is not visible via SYSCAT.TABLESPACES.
The state is visible by parsing the output of command "list

In MS-SQL there is a datatype called timestamp, which generates and
stores a value for each row whenever a row is updated and  is unique
throughout the database.
I am migrating from MS-SQL to DB2. So is there any equivalent to this

I have few questions,
1) I have DB2 8.2 ESE, with a db2 instance and a few databases.
Is it posiible to create and configure a federated server. what are
the things/steps required to do so.

Env: DB2 UDB 8.2, AIX 5.3
While trying to load data (73 Million rows, Medium size table uses 4K
tablespace) into a table using cursor it fails with "SQL0964C  The
transaction log for the database is full.  SQLSTATE=57011"

DB2 WSUE LUW v8.2 FP4 (aka v8.1 FP11)
RHEL AS 4
I am EXPORTing in IXF format from one schema and then LOADing into
another schema.

I have a very specific need to detect rollbacks within a certain table
in the database.
To do this I am actively monitoring the transaction log with a small
C++ program (using the API db2ReadLog).

Can I install the v8.2 FP4 (aka v8.1 FP11) LUW Admin client
on a Wix XP box that *also* has the v8.1 FP5 Admin client
installed?
Will both admin clients coexist on the same PC at the same

I'm trying to run the following code taken from
http://blogs.ittoolbox.com/database/technology/archives/006045.asp#
select substr(tablespace_name,1,30) as "Tablespace Name",
    case (tablespace_type)