I'm noticing a problem with a table on AS400. Basically I'm running a
select * and I'm getting back
Error: SQL0971 - Constraint DIVAPPPRDIV in check pending state.
(State:S1000, Native Code: FFFFFC35)

        I want to install db2 universal Database Personal Edition in
my Linux Fedora core 3. But the following error has occured.
When i gave the following command for install ----->
[root@brown pde813u1]# ./db2setup

we (our computing school) is searching a ODBC-Driver for Windows XP.
Is there any driver, which is free of charge?
(you know, nearly every school (at least here in Germany) has not
enough money for this "lesser" things...)

When i try to run a db2 command  from a window command shell other than
CLP, i get this error
DB21061E Command line environment not initialized
how can i solve this problem ?

I want to insert a row into an ITEM table if certain SKUs are inserted.
There are two triggers where each looks for a particular SKU and inserts the
appropriate matching row in the same table.  However when a record is
inserted, the following error message occurs:

I have a SAP demo version of db2 running on linux.  I want to connect
to it using a windows client, rather than use the CL query tool on
Linux.
What do I need on the windows side to connect to it?  Also, do I need

Is there a way to calculate size of a table without runnig statistics
to use NPAGES info. In my case there are a few very large tables in the
same tablespace with very outdated stats, so LIST TABLESPACE SHOW
DETAIL won't help.

I installed the admin client on my WebSphere box. I am now attempting
to connect to my DB2 server (on another box). I have been able to find
the DB2 server, instance and needed databases. These auto-register
themselves in the admin client. However, when I try to connect to the

I am posting this here, just in case anyone may need this.
Step 1:
CREATE SEQUENCE ID_SEQ
START WITH 1050000

I'm going crazy trying to write a working merge-statement. Why doesn't
the following work:
       MERGE INTO utSystem.t_Filter_Results AS Res
      USING (SELECT 9 as clubid, 50 as filterid, ID as MemberID

    When i was trying to install db2 database in the Linux, then the
following error had occured. Can anyone help me?
/media/cdrom/pde813u1/db2/linux/install/db2jinst: line 131:  4733
Segmentation fault      $JAVA_PATH/$JAVA_INTERPRETER $JAVA_OPTIONS -cp

i saw some code typing 'EXEC SQL COMMIT' after a cursor fetch .
isn't it just a share lock while fetching ?

We've been using the perl DBD::DB2 driver on Perl version 5.8.0
(aix_thread_multi) for a project we're working on without any problems
until now.
We've been using DBD::DB2 version 0.78 on DB2 Version 8.1 (the db2 cli

DB2 WSE LUW 8.1 Fixpak 5
Red Hat AS 2.1
Has anyone ever seen a db2diag.log indicate that a trap file
was written, but it is *not* written?