I am executing the following code below. When we execute this on our
TEST system (Redhat 4.0, DB2 V8.2 FP11) the rows are returned in order
of dollar_range_from. We just moved our Production system from V7.2
(Redhat 2.1) to a

For good and sufficient reasons I wish to insure that a primary key of
table 1 is not a primary key of table 2. The following does not work:
ALTER TABLE IS3.AUCTION_SUPER_CATEGORIES
    ADD CONSTRAINT code_not_fk

I have a db2 V. 8.1 Fix Pack 13 installed, and i have too much problem with
deadlock,  maibe depends becouse i have a direct remote connection with a
56k modem.
Someone know if depends to a particular parameter?

Hopefully someone will be able to help.
I have written a stored procedure in C++ called from a Java test
harness to validate the graphic data types in C++ and their use.
I have declared the vargraphic input parameters along the following

Is the LDAP security plugin available for all editions of DB2 v. 9 on LUW?
Or is it only available - say - for the enterprise edition?

can anyone tell me how to convert a comp-1 floating point number to a
decimal in REXX??

Hi. I'm running a DB2 8.2 install on a X86_64 SuSE install.
The tablespaces and logs are stored on a netapp filer through an NFS mount.
Now I came across this article:
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0509wright/

I ran the storage manager against a test database I have. One index
comes up with a red box next to it's name.
The cluster ratio shows as 1.
If I collect detailed statistics against the index, the red box

db2 v 8.2 on AIX 5.3
I will try to explain as brief as I can what it is I need.  I am
building a function that will be called multiple times where I will
need to return x amount of records each time for the same basic

Scratching my head on an issue that has been plaguing us ever since we
upgraded from version to version 8. Our db2diag file gets inundated
with messages that take the form:
MESSAGE : sqlriInvokeInvoker ignored because of prior condition, probe

Do db2 system catalog table require maintenance (reorg/runstat) ?
Thanks,
Sam

I am looking for comments on experience using a Load from Cursor
across multiple db's databases.
I have a multi-terrabyte database across many partitions that includes
a large table (1 Tb+).  The system also contains UTF-8 and LOB data.

I want to plan rearranging tables in our database according to
business areas. say all tables in business area A will be in seperate
tablespace or tablespaces. I am planning to monitor activity on tables
for a month by taking snapshots on tables and then i will see if this

AIX 5.3, DB2 UDB v 8.2
I was curious if there was a mechanism in HADR to switch the
HADR_REMOTE_HOST.  If a link or switch fails and there is an alternate
path is there a way to use the path?

This one's probably super easy and I'm just not finding the right
command/job:
I've already set up a scheduled backup job that dumps the contents of
my DB2 (ver 8.1) database to a folder on my hard drive nightly (it is