I'm working with several stored procedures processing a large volume of
data. After monitoring their execution using Quest's Spotlight
functionality I noticed a fair number of overflow accesses against
system tables such as SYSTABLES. I also observe page reorgs for the

Hi. I've been struggling with a query, so I'm hoping that I can explain
it in understandable terms.
Given the tables PARENT (id, foo, bar) and CHILD (id, type, parent_id),
I would like to select a result (foo, bar, type) where there's "SELECT

I have a question regarding the behaviour of sql with OR and fetch
first 1 rows only :
I have a table with data :
ACNO           NAME                TELNO                    CITY

That is correct (native xml support)
I used parameter markers and it did work.  I inserted it as a string.
Is this the best way to do it? Or is there a better way.
Thank you for your help,

How do we convert the following Oracle query to DB2
INSERT INTO Table2 VALUES( (SELECT ?, Col1, Col2 FROM TABLE2))
The SELECT query could return multiple rows.
Thanks,

I have a situation that I can't explain. Boiled down to its essence, I
have a query of the form
SELECT A.COL1, A.COL2, B.COL1
FROM A

Hi every one,
   Is it possible to stop logging the info of a particular table after
it is beeing used for so many transactions .( NOTE : its columns are
not created with not logged option).

I'm interested to use the xml extenders if they allow me to
decompose/compose XML data using *only* configuration files
(dtd/dad/..) and SPs (dxxInsertXML/dxxRetrieveXML/..), *without* code
-or with the very minimum needed code if not avoidable (rpg or java)..

I have to write a sql query which does the following:
I get 2 dates as input parameters to my stored procedure -
EFF_DATE     (15th March, 2003) and
EXPIRY_DATE  (14th March, 2004)

Hai.....
                  I have a database............ i took an online
backup for tht.....
After tht mistakenly i dropped the database.......... now i dont have

Can you guys please help me in displaying the list of users in a DB2
instance? I need the user ID, privileges etc .. I use Db2 8.1.X under
windows environment..
Is it possible to know the last login date for a user?

We have been getting intermittent reports of slowdowns on our production
server from our users. Of course, by the time we look at it all appears
well.
We created a batch db2 job (on the server) that is just a connect and

2006-06-23-12.13.27.709127   Instance:db2inst1   Node:000
PID:3657742(db2agent (MCNVNET1) 0)   TID:1
Appid:GA010520.A60B.027D43131542
access plan manager  sqlra_cache_mem_please Probe:20

When executing my insert statement, I am receiving the error message
'string literal too long'. The field is an xml datatype and I am
inserting the xml as a string. Do I need to convert it to a clob? What
else might I need to do? Please advise.

Hi. I am kind of new to DB2 and to this newsgroup so please bear with
me..
My question is: IBM installation creates 250 4k bufferpools by default.
I want to increase this number to 1000, no problem, and I want to