i have these messages in db2diag.log, we are using db2 udb v8.1 ESE on
win64bit, what does it mean? is this error?
2004-03-29-14.11.02.480000   Instance:DB2   Node:000
PID:2852(db2syscs.exe)   TID:2596   Appid:none

hi, i have created two instance under db2 udb v8.1 ESE, one is DB2,
one is TEST, i thougth i need to use different port number for the
database existing on TEST instance, so i create one by doing set up
communication, then select tcp/ip, specify service name db2c_TEST,

Hi,
I have a little problem installing db2 8.1 fixpack 4 on our suse 8.2
Linux machine. After the installation of the fixpack 4 (the version
before installation was 8.1_ga ESE and it seems that no errors occur)

does anyone know where sqlm_header_info is define ?
It occurs in some ibm db2 util files eg evm.c , part of
a db2 event monitor log file example / util.
Thanks.

I have only just started using db2eve.exe (Windows db2 v6.1),
in order to see the sql statements clients are sending
to db2, but I really need to dump selected columns, with a filter,
into a text file.  

Helpful folks,
I am trying to increase bufferpool sizes on UDB V7.2 running on WinNT.
Can I simply use the values displayed on the task manager performance
tab to determine how much available memory I have to work with?

I have a table like this (containing millions of rows, but that's not
important here):
CREATE TABLE person (
 fullname varchar(60) NOT NULL PRIMARY KEY,

DB2 7.1.1, zOS/OS390, COBOL, JCL
I have pre-compiled/compiled/link edited and bound a simple DB2 program that
essentially reads a file and inserts recrods into a db2 table.
when I try to run the program I receive the sqlcode -991. I have looked up

we are using db2 udb v8.1 on win 64 bit with fp3  with type 4
db2jcc.jar driver.
i would like to switch to use app driver, while using jdbc, i can't
get pessimistic row  lock, here is the way i try, table have index on

I'm using Bryan Mills post located at
http://bryanmills.net:8086/archives/000099.html to connect PHP on my
Linux Server to an Access database located on my network.  I'm having no
problems installing UnixODBC and MDBTools.  I can get MDBTools to

To do a migration of my 7 databases from V7.2 to V8.1 Fp5, I used the
backup/Restore.
For 6 of my bases that occurred correctly.
But for one of them I have the following problem and the migration is not

Hi. As I posted earlier, I am trying to use an identity column in a table. I
want to retreive the value after an insert.
I am an ASP programmer and know little about DB2 on the iSeries. I have SQL
Server background. The correct answer to my question is undoubtedly RTFM.

Hi to all NG
I'm new user of db2, version 7.2 and I have this problem:
I'ld like to have a risult in day from a difference between two date.
How possible to solve this problem ?

Hi,,
when I cataloged database on the client side , through client configuration
asst , after cataloging it will show all these details. My question is , is
DB2 will store this information in any file ( some thing like DB2CLI.INI)

getting into a discussion here about using OR in a WHERE clause.  in
previous databases i've used, the advice, universally, is that
OR-ing a predicate was Evil:  forces at minimum an index scan, at
maximum (depending on data requested) a table scan.