I would like to get the logical and physical reads for every sql statement
executed.
Thatfore, I used the command "db2 get snapshot for dynamic sql on
<mydatabase>". There, I could see the logical and physical reads from

Is there something equivalent to Oracle's
SELECT DBMS_LOB.GETLENGTH(COLUMN_NAME) FROM FOO
where COLUMN_NAME is a CLOB in table FOO
returning an integer with a count of the number of

If anyone is interested in getting DB2 data directly into Microsoft
Excel then take a look at www.synola.com it does just what you'd
expect...

Hi to all ng
I 'm a non expert  user og db2 and i made a program that it connect to db2
and after goes to a table, verify that exists a value and after return
success or not.

I was under the impression that the primary key had to be a unique
index. Since I usually create my primary indices before my primary keys,
in order to get the indices in the same schema as their tables, it is
possible , by error, to create such an index without the unique

Has anyone tried installing DB2 in an FSIOP/IxS Cad in an iSeries?
Thanks,
John

I am trying to enable a database for use with aiv extender.The problem is
that when i try to execute:
enable database for db2image i get the following error:
db2ext => enable database for db2image

I have installed db2 connect personal edition 7.1 on my desktop (win2k
pro) from where i need to access Mainframe db2. I have created a dsn
using Client Configuration assistant but i am getting the following
error

I've tried to get some information on apar GG04517 (FP9) related to sending
mails, but the search on the DB2 support site did not send back the link.
Besides, if you declare an email adress using your Internet Provider in the
Task Center/Contact, and press the Test button, DB2 tells ...

Hi All;
I am having trouble with a very simple SQL stored procedure. I have
written several that are running with no problems. This one is leaving
me scratching my head. I suspect I'm missing something very simple and

I am having my first experience using BLOB as a row in a table. I am
using it to insert graphics for labels we print. I have no problem
inserting into and select from the table. The graphic is being stored
correctly.

I restored my DB2 journals from a primary AS/400 to a backup AS/400 and want
to replay the journals for recovery purposes, I discovered that the chain
link was broken jumping from one receiver to the other, is there a quick and
easy way not to break the link? Also, does it have ...

The following seems to be a bug. The execution returns rows 1,2. It
should return 1,1. In fact, if I run the code within a stored procedure
alone (not in a trigger), the loop doesn't overwrite the value of y
(works well).

I'm new to DB2 ...
The following statement results in a SQL1585N message :
"A system temporary table space with sufficient page size does not
exist"

I've got a whole load of data that I've been logging to record
different search terms used on a website.  This all resides in a
varchar(50) column.  Contents will be something like:
toaster