Hi, list.
I don't want that my users uses windows security to logon on db2
database.
I want my db2 server to ask user for userid and password to access my

It's larger than 9999. What does the 4 refer to? Thanks.

Can someone assist in decoding the values returned from the snapshot
statement table function ?
Specifically, I am looking to relate the numerical values of
stmt_operation column to a literal.

My company is making the switch to DB2 from Oracle. I have been working
with Oracle for the last 10 years or so and still very very new to DB2.
One question that has come up recently within our team is the location
of the software. It appears that at a minimum there has to be a link ...

Do DB2 SQL statements run on MS SQL Server?
What would be the best way to keep one version of the application
source code which would work with both DB2 and SQL Server databases?
rather than maintaining 2  diff. source codes of the same application.

Hai everyone..........
                     I have installed DB2 ESE on a LINUX
box................. Everything was working fine from DB2
prompt......... i am able to open the control center tooo..... but when

I got an error like this below. I already have a tablespace using 32K
pagesize.
The message below also says:
"If such a table space

we're new to DB2 (using Express-C on Windows). We'd like to monitor the
SQL that Hibernate (a Java ORM) generates, along with query params. It
was quite simple to do so with MySQL, but we haven't found a way to do
that with DB2.

We have a DB2 version 7 fixpack 14 installed on Windows 200 at a customer
site that is crashing at regular intervals.Everything was working fine for
over many years, now since about one month, these crashes have been cropping
up. What is really strange is, the crashes occur on ...

I am suppose to look into the possibility of using alphablox to build
reporting application. There is a specific question. Can I build
reports and display reports only using Alphablox without using any
report engine???  Is it possible to design the report layouts in

I am getting -805 on SYSLH packages and I have already increase the
CLIPKG to 30. I am still getting -805.
Is there any db or dbm cfg setting that could cause DB2 to use new
SYSLH packages ?

I have a DB2 UDB V8.2 (FP10) running on AIX.   I have 3 application
server (AIX) connecting to the DB2 Server using JDBC. I have the
catalog the database as remote databases on the application server.
After running the application for a while, I got -805 on

Anyone here has seen any materials on comparing DB2 CM versus Domino
Doc Server? Can you please point me?
If any of you have worked on both products, can you please spend few
minutes comparing one versus another?

The following query does a table scan, it is only selecting 10% of
tab1's data. It has a clustered index on dt column (not-MDC) and
cluster ratio is 93%
Card of tab1 - 1175070690

Hi list.
This is my 1st time using db2.
I've installed clientaccess.
Now, when I try do connect with db2 server using a simple delphi7 app