Finally i was able to setup my replication process between two
databases .
For those who were not following my story , i was trying to setup a
replication between two databases on different linux server (RH 7.3)

I have a column which is the relative day number to give a treatment on.
For a particular patient, where I know the starting date, how do I show
the actual date for each relative day? the best I can see is:
SELECT ..., DATE(DAYS(start_date)+relative_days-1), ...

Trying to upgrade alternate FP9 to alternate FP9a on Red Hat Linux. After
running the following command:
./installAltFixPak -y
it says it was successful, but no new directory is created in /opt/IBM/db2

Hi All;
I am working on project; where I need to call a DB2 stored procedure
(also to be written in the project) which will update/insert some
records in the database. The number of rows to be intserted are decide

I have searched this group for answers and tried the responses.
I am trying to Use an full online backup from our production server and
apply it to our test server.  The Tablespaces in the productions server
are on the d drive and my test server has no d drive.

how do you move very large amounts of data from db2 to oracle?
Is backup and restore possible? What are the other methods practiced?
Thanks!

after a long hot (litteraly ... really hot in Paris today) harrowing
week , I'm a stuck on a minor/major issue (depends on the point of view
...) with db2 .
I'm trying to create a bufferpool with the following command :

I'm looking for a SQL syntax to put a variable name into the from clause.
Specifically I have a colume in a table that is table name, and I want
to use that result in the from clause in a select subquery
ideally I'd like:

right now, i can recover offline backups from version 6 or 7 to version
8. i want to keep my version 8 backups for next 7 years. does anyone
know how far in the future i will be able to recover my V8 backups.
will i be able to recover my V8 backups to say V12 in the future?

The dev center calls sqlj.DB2_UPDATEJARINFO
('JMARC.JMB','JMB','file:JMB.sqlj') to update the sqlj routine source.
I tried in CLP from the directory containing jar and sqlj files (Windows 8.2
FP9):

I am about to put a small-medium db2 database into production.  V8.2.
On IBM server running Win2003 Server.  Striped RAID array (5-0).
Uses stored procedures.
I wrote it all myself, but would like to review it with an expert

I have a Windows DPF (v8.2.2) environment.
2 Nodes
5 Partitions
Server1 - Cat (0) Data (1) Data (2)

I am surprised at how little info there is on this topic.  We converted
to DB2 v8.1.1.72 painlessly a few months ago.  For specific reasons, we
stayed on 32-bit.  Our OS is AIX 5.2 and our hardward is 64-bit P570
LPAR.

Group,
I'm learning DB2 as part of my internship and I've run into a really
weird problem. If I run a script as a file using the following command:
db2 -n -td@ -f audit.db2 +o -x -z audit.cvs

A customer of mine wishes to create a test instance with the exact same
data and schema as production (1TB EDW). What is common best practice
for this? DB2MOVE? Redirected Restore? Load from Cursor?
Thanks!