Hola a todos
Tengo instalado db2 udb wse en su pc y necesito conectar a varios usuarios
utilizando el administration client, logro hacer la coneccion pero el
usuario administrador en forma remota no puede crear base de datos le da el

The db2fm process on our server is using 12 % cpu  even when no
applications are connected. Can i stop this process? Is this required
for db2 to function normally? we are on db2 v8.1 with logical
partitioning.

Hi Expert DBAs,
I am facing an issue with a query, can anyone help me through?
I have a Query:
UPDATE VMUS.MSG_MSTR a SET MSG_STA_ID =5

Can a View be used to avoid deadlocks?
I have a trigger that needs to select data from a row of a table that
may have been locked (possibly by the same execution thread that caused
the trigger to fire).  I can't set the Isolation level of the Trigger

                In Sybase, a timestamp column is automatically loaded
by the DB engine and its in some hex format. This is shown below
id          timestamp_value
----------- ------------------

Running DB2 v7 UDB ("DB2 v7.1.0.93", "n031208" and "WR21333") on Windows XP,
I am unable to find out why the "Build for Debug" option within Stored
Procedure Builder is not enabled on Java stored procedures.  It is enabled
for SQL stored procedures.

I am new to UDB and had some questions regarding the default value o
the configuration parameters .I have made changes to the defult value
of logretain & locklist .The locklist default value was very low (100
. Are there any such other parameters that have very low defaults ?

Is it possible to combine multiple rows returned from select statement
into one row?
SELECT NAME FROM TABLE1;
I want all names to be combined into one row seperated by commas.

I am working with my developer group to switch from the type 2 to the
type 4 (Universal Driver).
Our set up is:
Host Data Base - DB2 z/os v7.1 (mainframe).

Greetigs,
              I just came to know that MTK does not migrate "RULES"
object from Sybase.
Is this true? if yes, whats the workaround?

Quite suddenly, it seems, our DB does not recognize these functions:
UPPER
LOWER
LTRIM

Problem: java ResultSet cursor from SQL/PL stored-procedure is
FORWARD_ONLY.
Is it possible to have ResultSet cursors from SQL/PL procedures to
scroll forward and backwards? Perhaps I am missing something.

I had two TIME fields that i wanted to know the difference in between
them. I saw TIMESTAMPDIFF but nothing equivalent for TIME. Further, i
want HH:MM:SS format. So, i wrote this FUNCTION.
Is there a better way to do it?

one Windows administrator changed the servername (hostname) of one of
our database servers.
What changes do I have to to to get my databases connected?
The catalog statements have to be adjusted, I know.

I'm preparing to take the 700 test...I've studied hard and am almost ready.
I have one question: Are there any discount vouchers available for this
test? I haven't been able to find any at the normal sources. I certainly
wouldn't be averse to saving a few euro wherever I can.