Task  :  Delete rows from one table and insert into another
CREATE TABLE Archive LIKE Inventory;
WITH del(Item, Quantity, InvDate)
 AS (SELECT Item, Quantity, InvDate FROM OLD TABLE  (

Recently read an article by Felix Lee: Setting up DB2 for UNIX and
Linux on NFS mounted file systems ( http://tinyurl.com/yuxbk3 ).
I was wondering why would anyone want to setup things like this. About
6 months beck, in my previous engagement, the system architect asked

Hi To all.
I would like to know please if there is a command that shows which DB2
products were installed on my machine.
Thanks for the help

I am getting the following error, while executing the simple insert
script on a few tables.
INSERT INTO <table_name>(<col1>) VALUES (1);
DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: =;FUNCTION

db2 ese v9.1.3, Windows XP.
Subj.
Why?
Sincerely,

I am not able to use a recursive query (BOM query) inside a trigger in
DB2 V7.2
Something like this:
CREATE TRIGGER my_trigger

I am tring to use db2Backup Api to make backups. If the backup I am
doing is ONLINE, as part of backup image I want include required log
files.
So I used the parameter iOptions as shown below.

INSERT INTO  deletetable
select * from old table
(
DELETE FROM existingtable

How so I connect to a database on a different machine.
For instance if I want to connect to the same machine I do
db2 connect to sample
If this database is on a different machine how do I do it.

I am looking at a lot of entries similar to the following in my
Windows 'Audit' Event viewer. They are all success events and not
failures.
The environment is:

Hello, all.
db2 v9.
Can I switch on debug_mode flag of sql stored procedure created
initially without keeping debug info without dropping / recreating it?

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a

Friends:
Anyone know how I can EXPLAIN a dynamic SQL statement that SELECTs
from DGTT's in a stored procedure?
I don't want to create permanent versions of the DGTTs and run an

Any one know how to audit select statement on specify table for db2
LUW v8 or v9  ?
have db2 tools or 3rd party tools can solve ?
Thanks.

When does DB2 go for an IS (Intent Share) lock?
IS mode is defined as a mode in which "The lock owner can read data in
the locked table, but cannot update this data. Other applications can
read or update the table."