Can Alternate Fixpaks be used with DB2 Connect Enterprise Edition on AIX?
The same regular fixpack can be used on both UDB and Connect.
The website isn't quite clear.
Norm

How to Update multiple tables in a single SQL update  Statement?
Is there any way out?
vj.

Hallo allerseits
Ich habe diese Testversion Trial:   DB2 Universal Database (DB2 UDB
Enterprise Server Edition
Version 8.2 auf einem Windows Server 2003 installiert, habe die Sample-DB

i monitor my database with dbartisan and it shows 4 GB bufferpool heap
size
the size of all bufferpool is only 750MB. i do not understand how
dbartisan is showing 4 GB. is total size of bufferpool include

Normally I use the semicolon for statement delimiters in plain SQL
scripts (for DDL, simple DML etc.).
But inside SQL/PL I tend to use % or @ as statement delimiters. But
other people prefer other delimiters.

How can I list active users connected to database server in MS-DOS
shell environment. Is there any specific CLP command for this? We are
running DB2 ver 8.1.6.
Thanks in advance.

On the forum at ibm.software.db2.udb it was mentioned that one should run
db2updv8 after installing fixpack 9 (or 9a). But there is no mention of
db2updv8 in FP9a installation readme file. Anyone know what is going on?

I just installed db2 8.2.2 on a Pentium 4 machine with 1GB mem.
I used db2licm, and db2icrt -u db2fenc db2inst as root.
then I did a mkdir /data/opldb and chowned it to db2inst1:db2 with privs
775. both db2inst and db2fenc are in the primary group db2.

We tried to select column text from syscat.views from a V7 database with
a V8 client. We got
SQL0351N  An unsupported SQLTYPE was encountered in position "1" of the
output

All:
I see that that DMS tablespaces using raw devices have "File System
cache" enabled by *default*. My understanding is that file system cache
is applicable only for SMS.

UDB LUW (Windows) 8.1 FP9a
I issued a PRUNE HISTORY 20050819 AND DELETE and was surprised to see
that the archived log files were not physically deleted. The history
record of the 20050818 backup was correctly deleted from the history

Is there something like Extension Manager in Lotus Domino
for DB2 database? This means ability to add plugin to
database engine that will receive message when any command
is issued.

I get the following error when i compile the view given below.
@f3n11:/home/satish/views/> db2 -td@ -f sat.vw
DB21034E  The command was processed as an SQL statement because it was
not a

I have systems both on Windows and AIX. With DB2 ESE v8.1 fixpack 6a. On all
of these I get this message in the db2diag.log:
2005-08-18-03.20.09.609000+120 I3571H188          LEVEL: Error
PID     : 5832                 TID : 4184

Description
The maximum number of locks held during this transaction.
It's not true. :-( When I tried found longest transactions I see
next picture: