Is there is a way in DB2 to update user id  Special register USER ?
Thank's in advance.

First off, let me just say that as someone with no DBA training
whatsoever, any help I can get with this issue will be very, very much
appreciated.
My company recently migrated our database from DB2 v7 to DB2 v9.  We

This should be simple, and the docs say so, but no...
1) I have an .hta file (VBScript), with a call to windoze shell
2) the shell call is to db2cmd, input from a file
3) the command file has a   db2 SELECT <blah>   command

when I run db2exfmt on DB2 9.1 I get this output:
    DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp.
1991, 2007
    Licensed Material - Program Property of IBM

Helpful folks,
We recently upgraded DB2 V7 to V8 on Windows 2003 Enterprise Edition.
The plan is to migrate to V9 as soon as possible. In anticipation of
that migration, IT management has decided that all our user desktop

i am getting error while executing the store procedure
db2 "CALL CRS.UPDATE_DEAD_RECORD2(')"
SQL0444N  Routine "*_RECORD2" (specific name "SQL080221165103852") is
implemented with code in library or path

  My database work has been largely with SQL Server, PostgreSQL and
Oracle, so when I have a DB2 question, I don't really know where to
turn. I could find the documentation for the current version of DB2 on
IBM's website, but I don't know if what's true for the current version

can somebody tell me if there is a mechanism in db2 which implements
a notify/listen for external db clients?
Postgres has such a mechanism where a client programm can connect to
the db and send a "listen <name>" sql command and then gets a message

In output of comand "db2pd -d <dbname> -tcbstats index", what's the
meaning of IID=0? Please advise. Thanks so much.
James

I have two tables, one is a list of activities, the other a list of
participants. I want to insert one record in the activities table and
then using its identity column as foreign key, I want to insert two or
more records into the participants table.

Friends:
In v8 or v9 LUW, if I were to write (in Java or C) my own user-defined
aggregate function, would I be able to use it in an OLAP windowing
clause as I could use, e.g., COUNT or SUM?

    We use DB2 8.2.4
I have noticed that on one of our sun solaris machines LOAD command don't
work. EXPORT and IMPORT commands works, but if I execute any LOAD - it never ends.
The same LOAD statements takes on another machines less then second.

I am a DB2 DBA on IBM Mainframe environment. I recently started
learning DB2 on Unix/Windows environment. Can any one answer the
following questions:
1. What is the qualifier that is used to identify tablespaces in DB2

You won't be able to bend an INSERT to a MERGE using a BEFORE trigger.
The only way I can think up to achieve what you want is to use an
INSTEAD OF trigger. Today these triggers are defined on VIEWs only.
So: CREATE VIEW T AS SELECT * FROM TBASE;

db2v9.1 fix pack 1 on sun solaris 2.10
every night we do an online backup on this system.  (db2 & netbackup)
last night netbackup had a problem and the process died on the netbackup side
before the db2 backup completed.  DB2 did not get the death notice and now it