I'm new to DB2 from SQL Server, There's a problem with the syntax
below, is anyone able to see what the issue is? Do I have too many
semi colans?
CREATE TRIGGER AUDIT

I am a newbie to HADR and Admin of DB2 (I am websphere guy). My
question relates to DB2 logging. I've read that HADR does not allow
Infinite logging (-1). I am expecting my Database to grow 8-10GB's a
month without compression (about 260 Megs day).

I'm using DB2 Express-C V9 with FixPack2 on CentOS.
I have database created with territory PL.
I'm using it with WebApplication written in PHP, the pages are encoded in
UTF-8.

We are running into some problems with the execution of DB2 stored
procedures when their isolation level is set to:
set transaction isolation level  READ UNCOMMITTED, READ WRITE;
This is a web application running in JBoss 4.0.1 where a standard

this is my first post here and I'm totally new at DB2 databasesand all
related matters but I need help in connecting a DB2 database.
I need to import data from a DB2 database to a MSSQL 2000 server, the
original db was copied from a windowsxp machine on a usb memory stick.

OS Win XP Pro SP2
I had to uninstall my db2 V8 because of WAS Commerce Server 6.0.2
I created an account with admin rights
Now went I try to install db2 V8 via the commerce Whiz installer at

I am not sure how to deal with the following scenario.
Let's suppose:
A database SAMPLE is in archive log mode. All log files from
S0000000.LOG to S0000010.LOG are stored in one path, S0000008.LOG to

I have the following table :
<id , items> where each element in the items column is of the
following form
<item> i_1 </item> <item> i_2 </item>... <item> i_n </item>. I need to

After an upgrade to WebSphere/JDK environment (6.1/1.5) I am getting
following error on Hibernate objects. Unfortunately, I was not able to
find any info on ibm's web site about SQLCODE 4700.
Everything works fine from my local machine. Trouble starts when we

The installer tells it faild to config db2inst1, the db2setup.err is
as following:
/usr/share/themes/Clearlooks/gtk-2.0/gtkrc:60: Engine "clearlooks" is
unsupporte

Helpful folks,
I am having a problem getting Oracle's Transparent Gateway for DRDA
product to interface with DB2 UDB for LUW 8.1.14.
The Gateway product is running on Linux and using DRDA protocol to

I've got a complex Oracle-SQL-statement and I want to convert it to DB/
2:
INSERT INTO TBZL2000CSFLQ_AGG(
    Solve_Name,

Hi ppl,
            The requirement is to load a table from a dataset which
has data in comma separated format.The data in the PS file looks
something like this...

I create a new instance yesterday, now I cannot stop it, or perform
any instance level operation like setup db2comm using instance id.
The error message is "SQL1092N  does not have the authority to perform
the requested command". I check the authorization, the instance id

our comapny plans to deploy SYNC mode HADR in a new production
environment. I am doing the research. I have a question needs to be
clarified:
when network down, primary and standby databases won't be in PEER