I want to write heartbeat monitoring script and connect to each of the
8 nodes of production from client machine and see if any of the nodes
can not be connected. is it possible to export DB2NODE from client and
then terminate and connect to be able to connect to individual

Has anyone seen a slowdown in durations of online DB2 backups on Linux
after applying SP1? The application of SP1 was my only change to the
environment.
I am running DPF V9.1 FP3a.  OS is SUSE Linux Enterprise Server 10

"MA_REMIT_DT" DATE NOT NULL WITH DEFAULT NULL
I was able to create the table with above data type. Whoa, isn't this
wrong according to the 'spirit' of the condition not null? Someone
says he doesnt need any nulls but gives default null!!

I am well aware of the deadlocking and how db2 handles it. Now, I have
this problem. I have to create a table from informatica's pre-sql
(this is because the table is a temp one, built on the fly, loaded,
transformed, and extracted from to be loaded into prod table (ofcourse

I am planning to run a web application with lots of concurrent
transactions against a db2 installation. Mostly I see oracle
doing this work, but I think there shouldn't problems with
db2? Please tell me your experiences or reference projects!

I am migrating the above and have regular tablespaces, what's the best
way to convert these tablespaces to large. I know you can achieve this
via an alter tablespace, is their any other way?

I am trying to move data away from the operational system to a remote
database (through federation). I tried to create a stored procedure
for this and with the help from Serge's SQL on Fire, I got to the
following as a concept. It just copies 100 records from one table to

What data standards should a database designer know about?
Some are so general they jump out at you --
ISO-8601  temproal dispaly formats.
ISO-3166  Country codes

I have a question and was hoping that someone might be able to shed
some light on it. We have an instance of DB2 9.5 FP2 running on our 64
bit AIX system. In order to enable concurrent IO, we disabled the file
system caching by altering every DMS tablespaces and disabling the

Footwear (paypal payment)( www.sneaker-shop08.com )
Paul Smith shoes
Jordan shoes
Bape shoes

T-Shirts
AFF T-shirt
ARMANI T-shirt  www.sneaker-shop08.com
BAPE T-shirt

discount Air max 95 shoes www.sneaker-shop08.com
wholesale Air Max 87 shoes
discount Air MAX LTD shoes
sell Air max 90 shoes

Hi I have a question about Multidimensional Clustering MDC.
Why MDC (Multidimensional Clustering) can only in DB2?

Hi...
I have a problem again about MDC.
How to determine the value of dimensions while creating a MDC table?

I am posting this again because it turned out the problem wasn't in the LOG
space (which incidentally also filled up), but in the TEMP space.
So, upon attaching a partition and then executing the SET INTEGRITY command
on a 42 GB table (SMS, indexes included in the size) the 35 GB ...