hi, we are using db2 v8.2 Express on Windows, I try to import the rows
into a table which is being used ( maybe being read or write), and it
was kicked out because there is lock waiting. As our appliction design,
the lock should be a row lock, so whoever use the table should just

Can someone please help me with good and easy-to-use data archiving
tools for DB2 database?
Does anyone have previous experience with IBM DB2 Data Archive Expert
tool? Is this a widely used tool for archiving?

Hai Friends
Quite a long time back i ask these questions but everybody send me some
snapshot and functions names but i need select statements for the
following stuff pls help me in this

          I'm an amateur to DB2.I installed DB2 ESE trial edition on
my system.It was all going well and suddenly when i was trying to
create an instance, i faced a problem which i listed it below. i tried
my best to debug and could not solve,

I am looking for a way to find out if any modification has been made to
any rows within a range of rows since the last time I queried it(I have
this time). I also want to find out if any new records were added since
I queried the table the last time, if there has been a modification ...

Does DB2 8.2 Enterprise Edition support IPv6?
Thanks.

hi gurus,
I am kid at DB2 .problem is I am unable to insert values of time and
date datatype fields into tables .default date datatype is taking
4bytes lenght so I am unable to insert date value into it .Is there any

ich habe mit folgenden fehlermeldung zu kämpfen:
C:\>db2 select * from table(snapshot_table('Sample',-1)) as snap
SNAPSHOT_TIMESTAMP         ROWS_WRITTEN         ROWS_READ
OVERFLOW_AC

Hi to all ng
(sorry for my bad english)
I have a problem. in a "c" progam I write an dynamic sql that in run-time
give me an error sqlcode = -104 SQLSTATE[42601].

Can a distinct data type be altered?
Eg: Suppose 'Surrogate_Key' is defined as CHAR(1).
Can it be altered to CHAR(2)?
And will the changes be automatically propagated to all columns that use

Is there any provision in  DB2 to compare databases, something similar to
the diff operator in unix.
As I was not able to find any, i reverse engineered the databases into
ERwin and used the 'Complete Compare' feature of ERwin.

When running a job that inserts data into a particular table we are
seeing a significant number of direct writes against the tablespace
containing the table. This is the only
table in the tablespace and there are no other jobs running against the

UDB DB2 v8.2.1 for LUW.
Why this function can't be compiled?
---
CREATE FUNCTION MYLIKE(NM VARCHAR(128))

How to get table name from dynamic query ???

1. I defined a distinct data type 'Surrogate_Key' using the below
statement:
set current schema Myschema;
CREATE DISTINCT TYPE Surrogate_Key AS INTEGER WITH COMPARISONS;