hello, we are using db2 udb v8.1 on windows 64 bit, i am trying to
understand the error message , what does the full meaning? i know we
can increase the logfilsiz , logprimary, logseconday to help, but i
need to understand what is the right number to change. currently we

DB2 UDB 7.2 on AIX 5.2
I'm doing some benchmarking/performance testing and need, if possible,
to flush/empty the bufferpool(s).
I there a way to do this?

We have defined a NICKNAME to go to Mainframe table and when do a
SELECT * FROM NICKNAME from a version 8 client we get SQL0101N error.
The same select from V7 client works fine. The SELECT returns 5 rows.
From IBM support site,

I am using DB2 UDB ESE 8.1.5 on a win2000 server.
I tried to use the function IDENTITY_VAL_LOCAL to get the most
up-to-date record with following statement:
VALUES IDENTITY_VAL_LOCAL() INTO :IVAR

We have an AS/400 running DB2 v5r2m0.  I want to get a copy of DB2 for
my desktop, primarily to create queries that I will "pass-thru" to the
400 using MSAccess.  I believe the current version of DB2 is 8.1.
Will I have any problem with 8.1 talking to an older v5?

I can truncate a version8 table by using "import from /dev/null ... replace
into ..." when I use version8 client. But I failed to truncate the same
table by using the same way if I connect from a version 7.2 client.
In db2diag.log, I got the following information:

If you have both DB2 UDB v7.2 fixpack 11  & v8.1 (latest fixpack) servers
installed on different W2K machines. How these two databases talk? Would you
be able to catalog from V7.2 to v.8 & vice versa?
I heard about DRDA, is this a requirement for the two database servers to

I am trying to create a new db2instance using db2icrt command. It has
a parameter -u FENCED USER ID.
I want to use same FENCED USER ID as that of our existing
DB2INSTANCES.

One of my collegues tells me that Event Monitors can be used to
understand how much time the application has spent in the database, in
the application, for IO, CPU utilization etc.
I have 'googled' and read a few articles , but still not very clear .

I would like to know whether DB2 get a command like Sybase's sp_depends.
Given a table, how could I know which stored procedures depend on the table?
Thanks a lot
Jack

Hi.  I'm new to working with DB2j, but am looking for a reference manual
which will give me a list of available/recommended values for the
db2j.stream.error.logLeverityLevel parameter.
Thanks in advance.

well, talk about timely.  i'm tasked to implement a security feature,
and would rather do so in the database than the application code.  the
application is generally Oracle, but sometimes DB2.  Oracle has what
it calls package DBMS_RLS, which implements application ignorant

hi, i have a table created like this: CREATE TABLE "NJIPD   "."APVEN"
(
         "DTAARADATA" VARCHAR(2000) ,
         "ID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH +1

In Chip Irek's "A PRIMER ON USING DB2 WITH .NET" (www.15seconds.com),
he states that "...ODBC doesn't support DB2 stored procedures. So if
you are building an application heavily dependant on stored
procedures, you need to eliminate ODBC as your access method and

I am new to DB2.  Does someone have a sample DB2 script they can post
here?  All I want to do is execute a SQL query like this:
SELECT * FROM TABLE
Also, can someone post a sample AIX script that calls executes this