Environment: db2v7 on aix. 32-bit instance.
When db2v7 writes to the transaction log files (not during archival,
but when flushing logbuf), does it use MMAP on the log file or regular
system calls?

xquery
for $y in
db2-fn:xmlcolumn('MYTABLE.DATAXML')/DataXML/MLData/Gr/LongDescription
return $y

I have a database instance from DB2 V2 under AIX 3.2.5.  I want to dump all the
tables in this database, but don't have a running DB2 V2 instance.  Assume I
have access to any number of 'modern' DB2 installations on AIX, and I don't care
about metadata like indexes--I just want ...

The 'maxconn' has been removed according to IBM documentation APAR JR18223.  
The question is how can the 'maxconn' be configured and what is the default
value? Is there a corresponding configuration parameter on the DB2 Server?
- PI

How do I find out when the table was modified?
When I look at syscat.tables it only lists creation time.

I have a problem with a cluster of two nodes (A - instance-owner node
and B - partition node).
Everything (db2start, db2stop, db2 get dbm cfg...) works perfectly until
I add the second node B in the db2nodes.cfg.

I am running a 9 node system using DB2 v8.2 on AIX v5.3. When listing
applications using Control Centre I often see one with status "Waiting
for remote node". A snapshot of the locks shows no lock waits. Any
ideas on how I can investigate this?

Hai all,
I have Db2 installed in a partition environment . There are 4 partitons
on which i created the instance. can any one tell me if i can create a
database on the required partitons ......

I'm just learning about embedded SQL, so be gentle...
My basic question is, if I use a fixed length host variable for a column
defined as VARCHAR, will trailing spaces be removed (or not) upon INSERT or
UPDATE of this column?  I tried it, and it appears they are *not* stripped.

How do we run stored procedures in DB2/UDB in a mainframe environment?
what are the steps necessary to do so?
Thanks,
kallis.

I'm pushing the introduction of the DB2 "Universal" JDBC driver, to be
used in a type 4 architecture and thus negate the need for a DB2 client
installation on the (client) application server.
Because the related application would then have a built-in dependency

how can I switch on client tracing with a c-programm connection from a
aix machine to a db2 running on another aix machine. The software works
fine but from time to time we loose the db2 connection to the db with
the follwing error message "sql30081n communications failure".

With self_tuning_mem set to ON, is there a way to get the actual settings
for the parameters that are set to automatic ?
Regards
Odd B Andersen

hi, not sure if db2 has a aggregate function to 'sum (concat)' a string
column in a group by?
i have a table like this:
myCategory, mySubCategory, myGroup, mySubGroup, myString

using 9.1 I'm trying to create a database in the instance 'bruno' but
receive following error code :
SQL1326N  The file or directory "/home/bruno/" cannot be accessed
Platform is Linux and I tried :