I have used the command
"GET ROUTINE INTO c:\Thiru\Dec31\locktrack.sar FROM PROCEDURE
xxxx.locktrack"
  It worked well. When i try to move the same to another server with

I need to increase the value of a Decimal(4) to Decimal(10)
I tried the following and it doesnt work.
ALTER TABLE xyz ALTER COLUMN PAGE SET DATA TYPE DECIMAL(10);

I attempt the following:
select * from my.table1
union
select * from remote.my.table1

Who are REXX routines named after ?

Hi friend,
 I want to do "DB2 UDB V8.1 for Linux, UNIX and Windows Advanced
Database Administration(704)" certification. Can i write this exam
directly or will have to write preceders such as 701 and so on? How

I wish to find out the restore method for database that have been
incrementally backed up and in the scenario where just the delta has
been backed up.
For example sake, let us assume the following 2 scenarios:

Sorry in advance if this is a stupid or newbie question, but I have
scoured all info source and cannot find the answer...
I want to implement a trigger (in db2 8.1) that will fire on the update
of ANY column or permutation of columns in that table. For example,

I was trying to connect to a remote AIX DB2 database from a Windows
2000 machine in two ways:
1) Use DB2 client in Windows to connect to the cataloged DB
I typed "db2 connect to mydb user myuser using mypassword" in the DB2

I've seen a thread a while ago about undroppable stored procedures on
LUW 7 and 8
up to 8.1.4. It's happend to me as well so I wonder if anybody has come
up with

Quick question - does anyone know of a good way to archive a blob?
Some background - Our application (Java Web Application) uses a DB2
table with a blob column of length 75000 to store some data.  The data
in this table needs to be in the system for approximately 60 days and

Hope this doesn't sound like an odd question: I'd like to learn some
more DB2, and would like any suggestions others might have in
configuring a laptop for this. I plan to load either SUSE 9 or RedHat
AS 3 on it (haven't decided yet) and download "DB2 Personal Developers

The sql
select TIMESTAMPDIFF(1,CHAR(TIMESTAMP('2001-09-29-11.25.42.483219') -
TIMESTAMP('2001-09-26-12.07.58.065497'))) from sysibm.sysdummy1
works in db2 8.1.2/RHEL 2.1

I have several user defined functions which are referenced in triggers
and views.  For software upgrades, I need to be able to drop the
triggers and views which reference these user defined functions, then
drop and recreate the user defined functions, then recreate all the

I am trying to register my UDF named 'myUDF.sql" (which has @ as its
command terminating character) with sample database
I am able to do so through the Linux shell prompt using the following
sequence of commands

After installing the drivers for V5R2, I reboot and then once logged in
I get this warning:
"Your service source directory (\\server\V5r1\Express\Install\Image),
has ISeries Access for Windows version V5R1MO. Your compuer has ISeries