I have recently run a rather large data import where the imported data i
pumped through some updatable views equipped with INSTEAD OF triggers. For
various reasons, the exact same data where imported into the exact same
table/view/trigger structures (but with slightly different ...

how can I enable (or disable) the autostart (upon server boot) for a DB2 V9
instance?
Setting the registry variable DB2AUTOSTART (to value YES) seems not to work
(it worked on V8), and I cannot find anything in the V9 info center about

on a server we have 5-6 instances. under every instance some db2fmp
processes are running continuously even no applications running. can
we kill those process? how to kill those process, if we can. i think
these are fenced mode processes.

Suppose a table like this:
CREATE TABLE TABLE_A
(COL_1 INT NOT NULL PRIMARY KEY,
COL_2 CHAR(1) NOT NULL);

How do I concatenate strings from a column into a single row?
Whats the logic to create the function in DB2.
Given is below.
Color

How can you identify type-1 indexes in DB2 version 8?

Does anybody now how to use the makefile under the samples directory in
SQLLIB? It's not a command, it's not a batch file, it's not REXX.
Lars L

Hi Friends,
can anybody help me in rewriting below query with the help of OLAP
functions. I never used OLAP functions , so need help in this regard.
SELECT C.UNIT, C.DT from tab1 C where C.DT = (SELECT MAX(C_ED.DT) FROM

I am on DB2 UDB V8.2
When I try to do a simple update with a "Fetch First" clause I get a
syntax error:
db2 "update exec_1 set lock = 100, level = 50 where level = 0 fetch

I have two tables both with a char(10) col. In table1, the column name is
cola and in table2, the column name is colb. Say cola contains values aaa,bbb,
ccccc,dddd,eeeeee and colb has values aaa,aaax,bbbx,ccccc,cccccx,cccccy,ddddy,
eeeeee,eeeeeex,eeeeeey,eeeeeez. I'm trying to write ...

For a couple of nights now I have observed that at 18:00 diag.log is flooded with this message:
2008-11-18-18.13.20.151992+060 E672850E578         LEVEL: Warning
PID     : 5102                 TID  : 183177832800 PROC : db2sysc 1
INSTANCE: thisinstance        NODE : 001          DB  ...

Here is my case :
CREATE  view v1 AS
 (SELECT 'E' as language,
         Field1,

I am attempting to create a trigger to keep track of changes to a
table, mainly about specific changes to the data in the table.  I had
hoped that triggers defined as for each row would actually run as each
row was deleted, but it appears that it is fired, once for each row,

Please see into the
http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.
etools.iseries.langref2.doc/rbafzmst280.htm
My question is - WHY I CANNOT USE
 VARCHAR_FORMAT(callofti, 'YYYY-MM-DD')

In 8.9 or do, set schema xxx, effectively prepended xxx to all dbnames
in the following statements. For the first time since we upgraded to
v9.5 I get 'DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704,
SQLERRMC=DB2INST1.LOCATIONS, DRIVER=3', which means to