Does anyone know if we can do SELECTIVE unload/load data from/to a
Tablespace using Where condition on z/OS with IBM DB2 UNLOAD / LOAD
utility?
Thanks,

I want to test HADR in a windows environment. As default in DB2 there's
only a manual takover possible. Are there some scripts available how I
can automate this? I've found only some whitepapers with an automatic
takover with HACMP and TSA.

My data model has many tables in many hierarchies.
I believe that by using recursion, I can check for all invalid codes in
the working tables that do not exist in the code tables.
For example, I would like to check the EMPLOYEE table for state_codes

we want to build up a DB2- switchover cluster on 2 solaris machines,
where a db2-instance is switched from one server to another.
we have 2 machines (a,b) with OS solaris 5.9.
both machines habe local filesystems and filesystems in a SAN.

What is the recommended way to develop DB2 Mainframe application
without buying this expensive hardware/software ?  I'd like to develop
the software for a Mainframe customer.
Thanks,

setlimit configuration file clause, applies to each SQL, UOW or
connection. Only setlimit uowtime is specifically mentioned as elapsed
time since the start of UOW.

Hiya...
I'm trying to get db2 LUW 8.2.6 X86_64 working on a netapp.
We're running SLES 10.
The software and instance are created locally, but when I try to create

My company would like to buy a good product for our ibm db2's data
replication. Although we have a few in mind like the DataPropagator and
the WebSphere Replication Server, I would like your expert opinion on
the available db2 replication products, and of course, if you already

Hi. Just wanted to check if anyone has noticed a difference in error
logging between v8.1 and 8.2. In 8.1 if the machine is rebooted
abnormally with diaglevel as 3 there are no messages logged in the
db2diag log except for the dbmanager starting and stopping but in 8.2

So a friend an I inadvertanly came across this problem while diagnosing
another:
I have a table:
create table test.test (g_id int not null, g_width int, g_height int);

I use db2 v8.2 on AIX platform.
I have three databases using the same instance.
Whenever I stop and start my database for taking a full backup all my
three databases are disconnected.

how I can invoke the db2diag utility in a Windows environment?
in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only
db2diag.dll, and it seems there isn't the command line version; which is
the DB2 tool that uses this dll, in order to analyze the db2diag.log?

I have been trying to register some HL7 schemas into DB2-Express -C v9.
After invoking the following command:
complete xmlschema "datatypes-base";
it throws me the following error:

The documentation (Administrative API Reference, 8.2, PDF format) says
page 520:
"The rest of the record is dependent upon the record type and the table
descriptor record defined for the table."

Do someone know how to migrate/copy a Windows DB2 8.1 data base to DB2
8.1 database system on AIX 5.3. Found some migrate doc on the web but
these handle mirgrations across db systems.
Thx in adwance!!!