I'm totally not familiar with DB2 databases, but for a project at wor
I need to synchronize a MS SQL database with a DB2 database. The MS SQ
server is (offcourse) on a Windows 2003 server, while the DB2 databas
is on a non-windows environment.

Can some one give pointers on how to perform database migration from
DB/400 to UDB on ISeries.
Specifically w.r.t to tables creation from Physcial files and Data
movement.

I'm not experienced in db2, but I have to write some rather complex
processing with stored procedures for db2 on as400.
The database consists of some twenty tables and is prepared in advance
so it does not change, while I run my procedures. I call the

I am using DB2 V8.2(German version) under Windows XP.
I would like to have that the results shown in "Abfrageergebnisse" (I don't
know which the equivalent in the English version is; something like "query
results"?) are shown in the precision they really have. For example, in a

Hi. I want to execute FUNC1 inside my stored Procedure PROC1.
CREATE PROCEDURE PROC1()
------------------------------------------------------------------------
-- SQL Stored Procedure

I have db2 UDB 8.2 installed on AIX 5.3 server. initially, my database seems
working fine with logretain on and userexit off. Then I installed db2 net
search extender 8.2 on top of it. In order to create text index, do I need to
set both logretain and userexit be off during the ...

maybe a stupid question, but I can't find an answer to it:
we have a web-based application system, where the texts of
the reply mails are held in a DB2 database (in varchar fields).
To input the texts via the db2 prompt is a pain, because of

Just stepping into the world of SQL/PL I try to create a table
function. It must be something stupid but I can't find what I'm doing
wrong.
The create statement is:

  I'm trying to catalog a java UDF, and do it as simply as possible.
  The UDF is in "c:\temp\myudf.class", and I would prefer to not have to copy the file into "sqllib\function".  But I'm unable to fet the CREATE FUNCTION statement to work.  Any time the path to the library ...

Here's the question:
How do you get DB2 to update a char(n) field with multiple spaces right
next to each other without having the additional spaces being omitted?
Here's the background:

Hi geeks
I have to transfer some blobs objects from one table to anothe
depending on certain condition. I am using a Stored procedure fo
this

I have been given the daunting task of sql query tuning. I am looking
for ways to get started with that. I am on DB2 UDB 8.2 (8.1 with Fixpak
8) on Windows. One point which I could think about starting from is the
db2 design advisor. However,  whenever I try to execute the db2advis

I wanted to know if someone has the book DB2 for Z/os version 8 DBA
certification Guide by Susan Lawson. If you don't want it anymore I
will appreciate to have it to pass my DB2 certification.
Thanks

I have used the Table Function SYSPROC.SNAPSHOT_APPL_INFO  in a Trigger
body, and  am having problems granting suitable permissions to allow it
to run for mere mortal users.
I have tried granting EXECUTE permissions to individual Users,Groups

Hi Experts,
I am working on DB2 UDB on AIX and I get following OSERR message in
db2diag.log when I drop database.
Well, the database can be dropped successfully, but the error message