Source/Production system: AIX 5.2, DB2 8.2
I have a full backup of sample db taken on 05/01/2006(logs included in
backups)
I have a tablespace backup of userspace1 taken  on 05/03/2006(logs

Hello, everybody.
I've noticed very strange DB2 behaviour in a stored procedure
parameters handling, and it looks like a bug for me. Consider stored
procedure defined as:

DB2 LUW V8 FP 11.
How do I monitor the progress of a "reorg indexes all" command ? I can
use SNAPSHOT_TBREORG when I reorg the table, but not the indexes.
According to http://tinyurl.com/nn2j3, there doesn´t seem to be a

i have one procedure which contains lots of logics in it. (which is one
of the largest procedure in my application)
i have 5 application(or agent) which access this procedure.
when i am accessing a particular code in it all the applications

I am seeing this problem where we have an MDC table organized by time
dimension id.
There are currently 1301 total rows within the table, and 350 distinct
time ids avg'ing out to 3.8 rows per time id.

I have added primary key to my table using the 'ALTER TABLE' statement.
Now, is it mandatory for me to use the 'CREATE UNIQUE INDEX' on primary
key columns in order to enforce the primary key constraint?
I have a vague idea that unique indexes are automatically created when we

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0109E  String data
right truncation. SQLSTATE=22001
    at
com.ibm.ejs.container.ContainerManagedBeanO.postCreate(ContainerManagedBeanO.java:500)

I created a table organized by date dimension. Any queries using the
clustered dimension have huge improvement in query run time. But the
queries doing a table scan table on average take 5 - 10 mins longer
than

How to restart sequence number once the data is imported/loaded into
the tables?
Please advise.
regards

Thanks in advance
Can you guys please help me in providing an SQL script that display the
database names and its status in a db2 instance..
I need to write a java program that displays this details

    How would i call  "runstats" within a stored procedure? Assuming the
procedure takes a table name as an input parameter.
    Thanks in advance.
Thanks,

I am trying to migrate SQL Server into DB2. In SQL Server there is code
like:
SET DATEFIRST 6
SELECT DATEPART(WEEK, '2006-01-31')

Hi, group.
I am currently trying to backup a db into a smbfs via the command:
db2 backup db <mydb> to /mnt/smb_disk compress
but I have the following error:

Server: DB2/SUN 8.1.6
Client: DB2 Connect Personal Edition (No 11)
<URL:ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak
/FP11_WR21365/FP11_WR21365_CONPE.exe>
Uninstalled old version, installed new version, and am now trying to

hi, i have a peculiar problem if i issue the db2start command in a
particular instance with name db2inst1 the whole box is rebooted. But,
there is no same problem with the other instance db2inst2. the
environment is version of db2 udb v8.1 with fixpack 6 on AIX 5.2, this