Environment: DB2 V7 + FP 14 running Linux.
One of my systems is performing poorly. CPU is 100% busy.
I activated an Event Monitor and the prepared statements sent by
applications are taking very long to execute. I can see a bottleneck

I'm facing a bit puzzeling problem. I need to check the connection
status in an embedded SQL application, and my idea was adding a CLI
call: SQLGetConnectAttr().I'm using it in many CLI programs and
everything's fine.

This is probably a simple problem for most of you.. Let me know if you
have any pointers for me. I am new to DB2.
In my stored procedure I want to select records that match a range of
values.

running on AIX with DB2 v8.2.2
I ran across a problem with naming source files with similar names.
For instance, if I have these three files:
upd_startaccessingdb.sqc

getting the following error when executing an insert statement:
java.lang.IllegalArgumentException: Date/Time must be JDBC format
running on UDB 8.2 fix pack 10 using IBM type IV driver.
Query in JAVA program works successfully in old environment, converting

I have a field AMOUNT(Decimal 13,2) and when I check the length its
coming as 7.
     AMOUNT    LENGTH
         15.00           7

This is probably a simple problem for most of you.. Let me know if you
have any pointers for me. I am new to DB2.
In my stored procedure I want to select records that match a range of
values.

I have a field with decimal (13,2), and if the value is  like
13.20  ---> 00000000013.20
-13.20 --->  00000000-13.20
How can I Left pad those values??

We are on DB2 UDB 8.2.2 on AIX.  I know this question has been asked
many times on the ng but I am just not finding a real good answer.  I
need to be able to not only determine existing table data size and
index size but also estimate for the future.  I keep seeing info

We are looking for options of converting CICS screens to a GUI
application (.net, Java, etc.) to increase the usability of the
screens. We would like to keep the underlying logic and database DB2 on
OS390, but the presentation layer would be different.

I'm trying to do a file load with this statement:
LOAD FROM "/directory/datafile.txt" OF ASC MODIFIED BY NULLINDCHAR=Y
METHOD L (1 8, 13 20, 28 30, 39 89) NULL INDICATORS (4, 7, 8,0)  INSERT
INTO TMP_Table (EMPLOYEEID, MAJORID, SALESID, NAME) COPY NO INDEXING

as wat ive mentioned in the title.. im would like to know whether the a
particular record/table is being locked in my program. some of the
methods which i would like to develop are as below:
Lock(KEY, SQLCODE)

I am running a C++ application   that  performs  DML operation  a
particular table of a database.
I want to find out which the record that got updated  or inserted .  As
a DB2 user I dont have any DB2  DBA privilege   .

I have a blob column that is 4MB in length. I need to change it to
store a 3GIG binary.
1) What is the maximum size a BLOB column can support?
2) How do i alter the size of an existing BLOB column?

This one is for the UDB developers'
With the advancements that Apple computers have made in the last couple
of years,
will DB2 UDB be made available to run on a Apple computer.  If Apple