I want to copy the data of all tables from database A  to database B,
which are already defined and are
sitting on different aix servers.  Basically, this is a "refresh" of a
test db from its corresponding prod db.

If I create one of these using DECLARE (not cataloged) and insert and
then delete no more than 20 256-byte rows again and again, and if this
would replace several overlapping legacy SELECTs, will I see run-time
improvement ?

I would like some opinions about declaring UUID as PK in a database,
compared to identity or sequences:
*  portability issue, making db independancy ?
* performance issue, making higher resources ?

I have a script that looks like this:
I'm not getting the syntax for declaring a continue handler.
I have:
set path sysibm,sysfun,sysproc,sysibmadm@

Hello to everybody !
i've a big big problem !
i've a SSIS 2008 Project with as data source a AS/400 DB2 database, my
destination is a SQLServer 2008 database,

We are using db2 9.1 fixpak 6a and everey 30 seconds the following
message appears in the db2diag.log:
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmComputeMinSHEAPTHRES, probe:796

were there changes to the handling of ssl in 9.7 express-c?
i had a non-root installation of 9.5 data server runtime client in my home,
which i dropped during the upgrade to 9.7 data server runtime client.
that installation worked fine with a remote db server over ssl.

I have a need to bring some *ixf files over from mainframe to
distributed AIX (to load into UDB databases)
How do we ftp files from mainframe to Unix ?
thanks

With SQL Replication, is there a limit to the number of rows that
asntdiff will compare between the source and target?  I ran asntdiff
in one environment, and received the following message:
ASN4012I "AsnTDiff" : "ASN" : "Initial" : The program is comparing

Shortly I will be migrating an instance to a new hardware box. The
instance I am moving has over 60 remote catalog entries in it.
Is there a quick way I can extract these node/db entries into a file
or some of script, that I can then run on the new box to re-catalog

Hi Friends,
DB2: v8/v9
OS: AIX/Win XP/2000
(In fact DB2 version & OS type/version doesn't matter much in this

We are updating an old z/OS DB2 version 7 system to version 8
compatibility mode in the near future. We have discovered an
application which is currently using Data Joiner version 2.1.2
Does anyone have any experience with this combination or have any

When creating a table, you can use generated columns such
as ...GENERATED ALWAYS AS (UPPER(col_a))
However, when altering a table, you can't add in this type of
generated columns.  Is this correct?

Hallo:)
Does anyone know of a way to put a byte array into a BLOB column with
"normal"( not prepared) INSERT statement? I can convert a byte [] into
a '<hex-numbers>' -string and put it into INSERT-Statement. VALUE is

I was under the impression, after I took the IBM DB2 V9 transiton
course, that there was a way to use hints to force db2 to use an
index.  I believe this was via xml.  Could someone point me in the
right direction...  Thank soo much!!!