Helpful folks,
We have been having an intermittent and completely unreproducable
problem concerning user authentication on Windows 2000:
[IBM][CLI Driver] SQL1403N  The username and/or password supplied is

DB2/NT 8.1.6
In procedure (SQL) I declare GLOBAL TEMPORARY TABLE. Sometimes this
procedure is called twice a session and error creating table occure. I know,
I can create table on session begin. I think I can check in procedure

Hello all ...
hopefully without sounding too obtuse, we've run into a case where we
need to persist the contents of a view for performance reasons.  As I
understand it (and I don't really) Oracle has something called a

I understand the concept of catalog cache (memory allocated from the
dbheap to allow catalog lookups without the need to access disk each
time). But the DB2 catalog tablespace (SYSCATSPACE) is assigned a
buffer pool, which seems to perform the same function as catalog

I tried to compile Java stored procedures and I am getting this
message ..
SQL1131N  DARI (Stored Procedure) process has been terminated
abnormally.   SQLSTATE=38503

In a multi-database development (DB2V8.1.4/AIX) environment I want to
enable regular non-DBA database users (i.e. developers) to execute
some DBA commands including update some database configuration
parameters affecting application performance, like DFT_QUERYOPT, sort

my function is
CREATE FUNCTION BOD_SEQ_NEXT
   ()
   RETURNS NUMERIC(19)

DB2/NT 8.1.6
Stored procedure Proc1 (SQL) return result set.
How can I call Proc1 in Proc2(SQL) and scroll on Proc1 result set? "DECLARE
CURSOR FOR CALL..." don't work. Any other statement?

we are running a delphi  application with DB2 V8.01 which is causing
deadlocks when rows are being inserted into a table. Attaching the
Event Monitor Log (DEADLOCKS WITH DETAILS) here. From the log it looks
like the problem happens when 2 threads insert 1 record each in the

Folks
I run a process on both the windows and aix process. The process
consists of many steps most are about the same on both platforms.
However there is one delete statement that is taking forever on aix,

I would like to get information about the db2 paramater READLIMIT,
that was introduced in V7R1. I cannot find the location of a IBM
manula describing the option : who can help me ?
Thanks

I have the following sintax:
Select *
 From Inventory
Where PartId = Coalesce(v_PartId, PartId)

I have DB2 EEE 7.2  12 db partitions running on AIX 5.1ML5 P690( one
server). The AIX workload manager is on. I started the same peoplesoft
job on all 12 nodes at the same time. But some node(partition)
processing speed are much faster than the others. The fastest node

Folks,
I am calling a DB2 stored procedure through Perl using the DBI:ODBC
module. I am not sure if I can do this or not because I have been able
to connect to and also issue select statements using DBI:ODBC and also

i have the table create with append on option (append on the data to
the end of last page), so suppose the data order is by arrival
sequence. but when i query use select ... order by field1, if the
field1 is same, i couldn't get the right order of the other fields