DB2 information Management and IDSICC ( IBM Dassault Systemes
Competency center has the pleasure to announce to you the availability
of
the latest addition to IDSICC DB2 documents.

I created an ODBC connection to a DB2 instance running on Linux. Using
SQL 2000 DTS package,I can read data from DB2 and populate SQL tables.
However when I try to write to DB2 tables, I get the error:
The number of failing rows exceeds the maximum specified. [IBM][CLI

Every time I try to run visual explain in v9 Express C I am getting the
following error:
[IBM][CLI Driver][DB2/NT] SQL0104N  An unexpected token "WITH SNAPSHOT"
was found following "LAIN PLAN SELECTION ".  Expected tokens may

I'd like to add a new column to an existing table at a specific column
location...
Existing table definition:
MyTable(Col1, Col2, Col3)

 I have a nightly script that executes inplace reorgs allow write
access for several tables after a previous script does a large number
of delete operations.  It usually has been executing fine.  The other
night 3 of them failed due to the log file system filling up.   I

I have a dept table with following structure like
Column
-------------
DEPTNO

Connected to BD2 8.2 via JDBC, can we force an application off the
database?
We know we can use the snapshot functions to get a view over connected
users, that works find through a standard SQL call. Now I'd like to

I have a input file in the following format ,
1-4    5-8  9-10 11 12-14
------------------------------------
1000 +500 25    1  250

I am using DB2 V 8.2 on RHEL. I am able to access the database created
in the server from the server machine. but the clients connected to
this server are unable to catalog this database to their machines & are
unable to connect to this database. I am also not able to view the "Set

Is there a posibility to execute a SELECT statement from within a
Stored Procedure without INTO?
I'm getting error SQL0104N but don't know how to do it.
Any idea?

             I have got a requirement in my project where there is a
NAME column in a table which will contain double byte Japanese
characters .I have SORT results by this NAME column which contains
double byte chars. Pls let me know how do I achieve the sorting method

I have a peculiar problem. I have a query which returns multiple rows.
I want to perform some operations on the output row by row. For that, i
declared a cursor and fetching the rows. Now the problem is, that if
run the query on DB2 command, I am getting the output in 11 minutes and

I have a problem with that the db2fmp process are hung , with truss can
I see this :
/4:     nanosleep(0xFC4CFBF8, 0xFC4CFBF0)               = 0
/4:     semop(1441803, 0xFC4CFC78, 1)                   Err#11 EAGAIN

On a warehouse app, our Java clients [can] constantly load/insert rows
into the db. I would like to throttle these inserts (1.5 million rows per
hr) from the Java app, based on current 'busy state' of the server.
It would be nice if I can get the server CPU utilization (and other ...

i've installed db2 on my aix box with the following configuration
bash-3.00$ uname -a -v -r
AIX symibm10 2 5 00CE60AA4C00
bash-3.00$ oslevel