I'm trying to setup DB2 on a Fedora Core (Linux) host, which has proven
rather complicated - seemingly because of Java being unable to run well on
Fedora (yet another example of "Java - write once, run nowhere"?).
Anyways, I have skipped db2setup and followed some other instructions ...

i have these errors in db2diag.log after db2dart, looks like index
error, but how do i know which index has problem ? please advice
       Index inspection phase start. Index obj: 4  In pool: 4
        Error: BPS check read error for pool page 262112, from object

After installing DB2 UDB 8.1 on AIX5L (5100-4) but I can't start the
controlcenter when entering #db2cc. I get this error:
[IBM][JDBC Driver] CLI0622E Error accessing JDBC Administration
service extensions

hi, recently i add license key for db2 udb v8.1 we are using, it said
the Number of entitled DB2 Connect users is 5, does that means only 5
users can connect to the server at the same time?

Hopefully I'm not the only one thinking of using these... :-)  It
looks like a nice way of mapping the OO/Java world to the relational
database world, and really cuts down on having to join so many tables
to get attributes of sub-types.

What are the equivalent of Oracle v$ and dba_ tables in DB2? I saw something
like syscat. tables. How do I find the whole list of syscat tables?

db27.2 fp 7 on AIX 5.2.
SELECT URG.USR_ID, URG.REGN_ID, RRT.ORIG_STN_CODE, RRT.DEST_STN_CODE
FROM   gfx.USR_REGN URG, gfx.REGN_ROUTE RRT
WHERE  RRT.REGN_ID = URG.REGN_ID

Hi, I am  developing a web application on DB2, and until now I used the
standard db2 administration tools given with the database distribution,
but IMHO this tools are terrific.
I would be pleased to know if exists a tool for DB2 like PL/SQL

hi, i am trying create another instance on db2 udb v8.1 ESE, what i
did is db2icrt test, and i also create a test database. since a port
number has assign to DB2 instance (which created by default), so how
am i specify the port number i try to connect when i want to create a

If your locale (or regional setting in Windows) is set to use a comma
decimal separator, is there a way to use a comma decimal separator for
inserts/updates?
(speaking of apps - CLI or JDBC)

Is there any documentation available for BMC Patrol for DB2 UDB
regards,
jag

hi, we are using db2 udb v8.1 on win 64 bit machine, i would like to
know if i have two same size of production database system running at
the same time, when i try to use configuration advisor to configure
how much of this server's memory you want the database manager to use

this question is about DB2 UDB V8 and its inplace reorganisation.
I want to check if a reorg has finished and especially if it has been
an online or offline reorg.
How can I find out using the following table function whether it was

I recently read a message requesting explanation about the message
concerning the number of "users" allowed in a particular db2
installation.  There was an answer, but I'm not sure if it's
generalizable.

I have the following query on a  table
db2 "select insertion_time, amplitude from sngl_burst where
insertion_time >= timestamp('20040325134520') and insertion_time <=
timestamp('20040325144520') and amplitude is not null fetch first 1000