when specifying modifies sql data option ...
getting following error..
SQL0104N  An unexpected token "MODIFIES SQL DATA" was found following
"".

V7.1/390
logically, the answer should be NO.  the question: does the act of
creating a trigger on a table invalidate a SP which doesn't
reference the table?  or, more generally, at what level does a

everytime I try to create a new scheduled task, I get the following message:
SQL22283N Task "12"."0" does not exist in the Tools Catalog Database.
The scheduler cannot retrieve the task from the Tools Catalog Database. The
task might have been removed from the Tools Catalog Database ...

I'm needing to connect to this DB2 database from Oracle, and when I try to
connect, I get a message saying I'm using a UDB 8 client against a UDB
07.02.0007 database.  I've searched IBM's website for a while looking for a
version 7 client, and haven't found one.  I'm also confused ...

I have six hard drives (4 SCSI and 2 EIDE) on my main machine with parts
of a database on each drive. The main index is on one SCSI drive all to
itself. The main data are on the other three SCSI drives. Small relations
are on one EIDE drive, and the logfiles are on the other EIDE ...

I have just upgraded to DB2 V7 for OS/390. However, I get a message
everytime when I try to connect from Control Center but everything works fine.
[IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSPROC
.DSNUTILS " failed due to reason "00E7900C". SQLSTATE=55023

We are logging approx. 3 million records every day into a history
table.
Last week we ran into the 64 GB limit in UDB 8 so we recreated the
table with 8 k pagesize to get some breathingroom before we hit the

Folks,
 I am not sure what I am doing wrong, but We have an transaction that
 does some serious calculation on small chink of data over and over
 again.

I would be very thankful if anyone woul be able to tell me where I can
find information about the number of Windows users.
Thank You

I have been seing a weird problem with db2look tool in db2 8.2 on
Windows 2000 platform.
When i spool the DDL using db2look, it spools the DDL in the ascending
order of database objects Timestamp and not in the

I am try to create a store procedure in DB2 version 8.1 Personal Edition. I
new also new to DB2. I am getting the following error:
[IBM][CLI Driver][DB2/NT] SQL0204N  "MYDB.MYOPTIONS" is an undefined name.
LINE NUMBER=8.  SQLSTATE=42704

I have a question about tablespaces....
Does having Multiple tablespaces (ie..one for indexes, one for large
tables and one for smaller tables) realy help out performance
considering my containers are all on the same disks?

Where can i find information about db2 block structure? I want to know
how it stores rows into blocks , how it handles issues such as row
migration / chaining or etc.
Kind Regards,

First time posting -if this is not the correct forum, please let me
know.
For updating a LOB in Oracle (using JDBC), you need to lock the row. Is
it true in DB2? How Are LOBs implemented in DB2 - Do you have a locator

HP UX 11i, db2 v8.2
kernel parameters of HPUX such as shmmax had been changed to MEM*0.9, about
3.6g.
when I create a partitioned db(4 partitions)on the server, warning raised