We are using ODBC connection pooling with DB2 v 8.1 on Win 2000 v5
sp4.
Each time we get a connection, SQLConnect, we see the memory usage go
up, about 52K.  When we return the connection to the pool,

In DB2 V8.1.5, if one uses SET SCHEMA to a schema other than the default
schema, and subsequently issues a LIST TABLES command, it is still the
tables in the default schema that are shown. Is this the way the SET
SCHEMA command is supposed to work?

I have worked with Oracle and SAP over a number of years. I worked a
bit with DB2 and SAP, and I am expecting to do so in the future. I am
looking for a good book on tuning (For both OLTP and DSS, hopefully
for both Windows and Unix) UDB v8.x.

In need differences between Unix UDB DB2 v8 and z/OS DB2 v7.
Features which are supported in Unix UDB DB2 v8 and not supported in
z/OS DB2 v7 and vice-versa.
Any help on this would be of greate help.

Can anyone help me please ?
I want to export the LOB data into single file for each row. Is this
possible in verion 7.3 on Solaris?
I mean , all data in one file and for each row, there should be

Cluster Only supported in ESE?

Hi
does some one know how to monitor the temp space and point out which
application that has the highest usage of temp space
thanks

well, i can't remember being limited to 8 characters for something, except
in the good ole days of M$-dos.  now i find that DB2/390 has a 8 character
limit on tablespace names?!?!?!?!?
given that tables can be 18 (closer to industry norms), this is truly

Is there a way to get the day of the week from the DATE function or
any other function?
I need to know if a certain date is a Saturday or a Sunday.
I'm way under pressure here, so I appreciate if anyone replies fast,

I was unable to run the statement "CREATE GLOBAL TEMPORARY TABLE" on
unix version of DB2, it gave the follwing error
db2 => create global temporary table temp ( OGI_SYS_NR char(8) )
DB21034E  The command was processed as an SQL statement because it was

Looking at
http://www-306.ibm.com/software/data/db2/linux/validate/
it told us that db2 v8.1 is not validated yet for suse90 professional ed.
Do you have any experience regarding the stability of db2

We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

I am getting the following error when i am using query no in my sql
statement and compiling the stored proc. I am doing this on Unic UDB
DB2. Please let me know if i am mising something here.
---------------------------Error Message

I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¦) character to this:
ª. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions

I am new to DB2 and I am trying to implement a tool using DB2
Administrative (C API) API.My requirement is for the tool to query the
DB2 servers to get the list of databases in each of the servers.I
looked at API's like sqleatin(Attach),sqledosd (open database