Suppose computer PC1 is my database server in which DB2 is running. I
have an application running in computer PC2. The application PC2 will
connect to DB2 in PC2.
How can my application in PC2 get the list of database in PC1? If I

Anyone else out there a regular DB2 and vim user? A while back, Lennart
pointed me in the direction of an interesting database extension plugin
for vim (dbext.vim [1]). I took it for a spin, but couldn't get it
working properly under Linux (it looked as though it would /probably/

I have two tables, CUSTOMER.ACCOUNTS and CUSTOMER.RELATIONSHIPS, as
follows:
CREATE TABLE "CUSTOMER"."ACCOUNTS"  (
         "ACCOUNT_ID" DECIMAL(12,0) NOT NULL GENERATED ALWAYS AS IDENTITY (  

I know it is possible to develop ODBC program on Windows. Just install
DB2 Client, then using Windows ODBC manager to configure.
But, is it possible to develop ODBC program on AIX? Just only install
DB2 Client, too? And, how to configure? I can't find any ODBC manager

I'd like to know whether it is possible to restore backups created on
a production machine, running DB2 9.1 on Windows, using DMS table
space containers, onto a developer's machine, also running DB2 9.1 or
9.5 on Windows in a way that does not require the use of DMS table

Is there a way to reset the auto generated id for this table. Drop
table and recreating does not work.

Am facing an issue. Am using DB2 UDB EE v8.2 on AIX platform. I have
taken the offline backup of a db( say SAMPLE ) on AIX platform. Now I
want to restore the same on Linux platform. In fact on any other
platform like Win<->UNIX / Win<->LInux / Win<->AIX etc. I have heard

I am using following query as example:
WITH T1(C1) AS
(VALUES('FRI'),
      ('MON'),

I found this problem on ORACLE board.
2 input TABLES:
Items
Id  ItemName

Recently, one of our application servers is moaning about its handles.
(no more handles available).
I'm guessing it has to do with some bug in our software where it does
not release handles properly and every x thousand queries, one available

is it possible to define such a trigger on a table that once the table
is X megabyte, or the has over 10000 records, the table is purged?
thanks a lot

Hi  everybody?
here is 2 CASE EXAMPLES:
WITH CASE_SUB(A,B) AS
(VALUES('z','1'),

On a remote system I got a stored procedure named MY_STORED_PROCEDURE.
However there is a problem because I am not sure of the interface of
it (number of
parameters and types of them). I have googled, read documentation but

Can i drop a cloumn from a table in DB2 for Z/OS?

I am truing to concstruct something like this:
SELECT id, name, role,
   CASE
       WHEN role = 1 THEN SELECT item1, item2, item3 FROM table1