We have a multi-user Java application that can connect to either a
UniVerse database or a DB2 database on an AS400 through JDBC. The
program executes a SELECT ... FOR UPDATE statement. When connected to
the UniVerse database, if a second user runs the program, at the point

Need help to write a trigger according to the following business
requirement. This on DB2 UDB V8.2 / AIX 5.3
Whenever a 100th record is inserted into my 'ACCOUNT' table with a
particular 'BATCH_ID' I need to either update or insert a row onto

Can I get a little help?  Given a very simple table of events, with
their durations, I want to consolidate time periods for an event that
(1) touch each other or (2) overlap each other.
CREATE TABLE Events

I´m having some problem retrieving identity value from my newly
inserted row into a view.
I have two tables T1 and T2 which I define as following
CREATE TABLE T1

Working on a function that calls a stored procedure.
iResult =  Call GetEmployee (5, indate)
The stored procedure, GetEmployee has 3 parameters.  The first two
parameters are an integer and a date (IN parameters).  The third and

db2 8.1 FP11 on AIX 5.3.0.0 .
The db2diag.log is intermittently reporting EMFILE (24) "Too many open
files" errors. The culprit is always db2hmon. Sample db2diag.log
output follows:

¿¿¿¿¿¿Anybody knows this error??????
2007-03-23-11.08.12.484581   Instance:db2inst1   Node:000
PID:204782(db2agent (DB2XXX))   Appid:*LOCAL.db2inst1.070323232921
data_management  sqldmdpi   Probe:443   Database:DB2XXX

I try to construct a SQL code for a view to select a specific data
from a table, this query take the value of the filter from a text box
in a visual basic 6.0 form. my problem is when i DECLARE the variable
@AMP receive a error message that said "The Declare cursor SQL

Is there a DB2 equivalent of Informix.Extend function?
or please help me the best way to create one
Thanks
rick

This is probably not related to db2 but due to fabulous responses i
got earlier for my questions, i am convinced that this forum is full
of smart people.
Here is question:

I am having a problem getting DB2PE working.  I have DB2PE installed
on a Windows box and am trying to monitor databases on a Linux box.  I
getting an error about shared file systems between Windows and Linux.
I have the shared system setup with SAMBA.  Is there anything I can do

I am getting strange situation. These r the steps I have followed:
1. Created an EMPLOYEE table with around 14 fields & 688038 records.
(so a large table indeed).
2. Tried to delete all the rows in the table using the traditional

select 'YYY', substr(TABLESPACE_NAME,1, 18) as TABLESPACE_NAME,
      CURRENT DATE,
      int((TOTAL_PAGES * PAGE_SIZE)/(1024*1024)) as TOTAL,
      int((USED_PAGES * PAGE_SIZE)/(1024*1024))  as USED

I have certain questions for which I am not able to get any answers.
1. Can I manually rebalance a tablespace? The problem is that I have a
18 hr live production environment. If a tablespace gets full during
this time, I can use "BEGIN NEW STRIPE SET" option to add a container

While investigating deadlocks in an application I wrote a function to
check if there where any batchjobs running in parallell at the time of
the deadlocks. The check runs surprisingly fast, but If I narrow the
searchspace I start getting SQL0437W with reason code 3 "Optimizer ...