I get the above error when issueing the 'db2start' command.
Found no info in the net that could help me. I have the V8.1 FP10 installed
on SLES 9 x86_64
Any tips?

When i try to update a varchar field the data is getting truncated
after it encounters '\x00' in between the data field:
Eg: data = "\x01\x02\x03\x00\x01\x02\x03".
 The data available in the field is truncated to "\x01\x02\x03".

Can you please let me know the procedure to reach db2 command prompt
from a cygwin window (hence without using Start-> Run -> db2cmd
method). I'm planning to write shell scripts which accesses DB2
database on windows platform hence I installed cygwin but I'm unable to

I have successfully designed a trigger to make sure a set of fields are
unique if not null. However it fails in one case: when the duplication
occurs among a set of rows being updated simultaneously. The trigger is
below. Can you suggest a way to improve it to eliminate the ...

I used the following query to retrieve the date in dd-mon-yyyy format.
db2 =>  SELECT RTRIM(CHAR(DAY(COVG_TYP_STRT_DT))) || '-' ||
RTRIM(MONTHNAME(COVG_TYP_STRT_DT)) || '-' ||
RTRIM(CHAR(YEAR(COVG_TYP_STRT_DT)))  FROM twd_coverage_type

I have the following data being returned:
ID       Region
----      ------------
1        northwest

I am trying to fetch data from db2 (express version) database b
calling stored procedure. I have tried to use both cursor and for loo
but still i am getting error.
--======Start procedure=============

        I recently had a hard drive crash, and was able to save the
        db2 database directory that had daily updates for the
        past three years.  I need to find out if anyone has been
        successful in reintroducing an old database to a

Hello, I'm looking for a method to check the utilization of index by
any SQL (Static and Dynamic) at the database level instead of
generating the access plan for each SQL.
I have inherited a database where index occupies more space than the

I have a database around 600GB and all tables were self-created by the
application. Hence, we have only one huge SMS tablespace where all the
tables are stored. To get better performance, we are planning to move
the tables to a DMS tablespace with multiple containers. There are LOTS

Hi guys!!
I am completely new to DB2 database adminsitration as i came from
Progress DBA background ....
Here i have Five DB2 instances running on different AIX servers.

I am trying to update a million rows in a table and doing this reading
from a file which has the  record pkids and constructing a
preparedstatemtn with that pkid and adding it to the batch...
count is the recordnumber read from the file...

HOW CAN THIS BE DONE IN JAVA??? THIS IS POSITIONED UPDATE
EXEC SQL  DECLARE C1 CURSOR FOR
                 SELECT *
                   FROM EMPLOYEE

DB2 LUW 8.1 FP11
Can't I overload SPs based on param types rather than
just number of params?
If I do:

I have a table with the following 2 Fields - one is the description
name and the second is its description to be stored in a table.
   description name              description
------------------------------          ------------------