I'm working on DB2 UDB 8.2 with Fixpack 10 on Windows 2000 Server.
The problem I'm facing is that I have created a table having BLOB type
column with NOT LOGGED option. (see script below)
CREATE TABLE ATTACHMENTS

In a DB2 server setup on Sun, the clients are using Developer 2000 as
frontend on the ODBC   connection.
A particular report is taking too long to execute. The snapshot shows
the following. The query seems to be generated by DB2, as none of the

Communications is being manually established from a Windows 2000 client
through a DB2 Connect gateway to a DB2 host system.
Which of the following does NOT have to be cataloged on the gateway?
A.The client

I hope I can get some help regarding this issue, which has been going
on for a while. I have a desktop user who is having problem running
"Stored Procedures". The DB2 Connect application works fine but when he
runs the stored procedure, he gets the following error message.

I have a DB2 UDB database on an AIX UNIX machine. I would like to know
the queries running against certain tables. There are some applications
outside of the database that do read and update these tables. Some have
incorrect isolation levels that end up locking the tables. How can I

DB2 V8 LUW FP 11.
My applications eventually takes a very long time to process simple
insert statements.
Here´s the output of a event monitor:

I'm confused about isolation level.. According to the devleoper of our
app (java, running java stored procedures) dont they have any
setTransactionIsolation in there code so the default should be CS but
.. running db2pd -app -dyn shows that RS is used .. Is it something

I want to know if it is possible to load(using the db2load API)  into a
remote database. By remote database i mean one that i have cataloged.
Any parameters that need to be changed ?
TIA

Hi people !!
I need some help about this error... I have a DB2 databese Version 8
with a Power Biulder application.
In my environment I have 3 databases and the application connect in a

8.1 FP11 on AIX 5.3.
The following DELETE is poorly performing and causing lock escalation
(and subsequent deadlock time-outs):
DELETE FROM submission_log

I am a little confused about the archive parameters work together. We
currently have LOGRETAIN=RECOVERY and LOGARCHMETH1=USEREXIT.
It appears that the logarchmeth1 can be set to DISK:<path>. Does this
mean that we can use DISK (rather than USEREXIT) and replace the <path>

Dear Friends
In db2, is it possible to put password security policy.
Like password must contain with all mixed characters (alphabets,
special characters, numerics) and password should not be same with

THIS ONLY HAPPENS WHILE QUERYING IN THE CONTROL CENTER. is there anyway
to get around this? the query works fine if I query from java for
example.
xquery

Is it possible to do an UPDATE of a table via LOAD command ?
Best regards,
       Kovi

I've created a SP witch returns a resultset.
When I'm calling from the query manager, everthing is fine. (result here:
AGREEMENT and STORNO)
When I'm calling from ODBC, the related cols are so called as the sourcename