We are in the process of migrating from version 7, running on an OS/2
server to version 8.2, running on a Windows 2003 server.  I did not do
the install on the Windows server.  When I try to schedule a job, such
as backing up a database, and I save it as a task, it does not run.  If

I wanted to know if i always have to use
1..load from /dev/null/ of del  terminate into tablename nonrecoverable
or can i do something like
2...declare cur cursor for select * from tablename ...........( the

Just noticed something rather annoying after upgrading my test box (a
Linux server running DB2 UDB v8 for LUW) to fixpak 11 (for reference it
was previously on fixpak 7).
In the past I've relied heavily on the ability to start multiple

How can i find the load state of the table using SQL, i can do "load
query table tablename" but i cannot execute this as a sql statement.
What i want to do is, i m using a java stored priocedure to load a
table, now after loading, i want to make sure load completed

We are migrating an application that uses DB2 UDB 8.1.3 as its
database.  It's an old application and the code is missing as usual.
We are trying to find out the SQL the application is firing by
attaching a statement level event monitor to DB2 and looking at the

I have a table that I would like to partition. It has a column c1 which has
100 distinct values.
I was planning to partition the table on column c1 using a partioned index,
and then apply data partitioned secondary indexes on the table.

I know we can truncate a table in DB2 by first creating it with NOT
LOGGED INITIALLY option. and when we need to truncate it, run the
following command
alter table <table name> activate not logged initially with empty table

DB2 v7.2 EEE on AIX
I am trying to redistribute the data for a table that is skewed and
wondering if the output of db2gpmap is optimized or is it just
displaying the current information? I also read some where that LOAD

Can anyone explain in greater (and more comprehensive) detail what the
RESTART option does in the ALTER TABLE table ALTER COLUMN statement.
This is the description in Info Center:
RESTART or RESTART WITH numeric-constant

I am using DB2 Connect on AIX 5.3 to access DB2/400 data.  I can see
and return data from some libraries/tables as you would expect but when
I access some JD Edwards data (e.g. library.F0902) the columns are
being returned as HEX values.

Can a database be renamed?  
DB2 V8.1
AIX V5.2

DB2 V8.2 FP10 on Windows
I tested the following HADR scenario:
- a new tablespace on a new filesytem is created on the primary System
- the replay on standby fails because of lacking permissions

I am creating an index on a column which is 40% NULLS. The process seems
to run forever, though a count of the number of values runs in
milliseconds. This leads to the subject question: is there a way to
ignore those rows with nulls in index creation?

The following query runs very slowly compared to other queries on my
system. If I read the explain plan and its data correctly, it is due to
a table scan on animals caused by the join separated from the others by
space. There is an index on both dam_bhid and recip_bhid. I have ...

The following query gives a syntax error if the 't1' is omitted, even
though it is never referenced. Could someone explain wy to me?
select count(*)
  from ( select distinct birth_date