Environtment: DB2 UDB ESE v8.1, fixpack 6a on Windows2003 Server Enterprise
Edition. We bought a new server and have been using as a test environment
for the system until last weekend. Then we changed: the old production
environment became test, and the test environment became ...

Red Hat AS 2.1
DB2 WSE v8.1 FP5
Type 4 DB2 JDBC driver
Using java.sql.DatabaseMetaData and ResultSetMetaData,

We have a number of production servers that soneone has decided that
the DAS is not to be enabled. The rationale is that the developers
should not run "discover" and then start plugging around on the
production machines as they could possibly make a change or do

I'm try to launch db2Backup from Borland Delphi, but I obtain an
undocumented SQLCODE -1152.
Any idea?
My code is the next:

I am trying to connect our new Crystal Reports 10 software to the
mainframe
DB2 v7.1 and keep receiving the following error:
Query Engine Error:'42884;[IBM][CLI Driver][DB2] SQL0440N No

my colleagues are convinced that having more than an index or
two destroys performance on their batch runs.  could be.  i don't
have the data, and i'm wondering whether there might be some
publicly available.  haven't found such.

we have a database with one column CHAR(10), which contains numeric data
(10 digits).
(That was not my idea).
Now, I have to find out all rows, which do not have numeric data in this

I have a table with data like this
ID        Type
1            A
1            B

Hi @ll,
my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
Why this ???
Cu,

Contains a major blurp on SELECT FROM INSERT and some other hopefully
useful tricks.
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0411rielau/
Enjoy

I have a 4K page size table space, and it has just multiple tables. (I
need to know  as well if it's a single table in that tablespace, how
to handle.)
It has reached the maximum size of 64 GB and is full.

In a given instance if there are three databases is it possible to
have a unique port for each database? Even further is it possible to
have many unique ports assigned to each database.
What are the performance implications for having a unique port or

Hi, there's a db with 32 partitions. on the 22nd partition, all the index is
located on a dms device container. due to some man-made mistakes, the data
on the container is totally destroyed. then the access to the tables with
indexes all went wrong... how can I deal with it?

i'm trying to restore a backup that olriginaly was made from a server
(production). I want to get data into a new server(development).
Does somebody know about a guide to get some information?, i'm working
in windows advanced server (production) and db2 v. 8.1. the

I have a question about how nulls are handled in "IN" clauses.. I
understand the operation null = anyvalue is undefined. Please examine
the following example.
drop table one