i need ur help.
i want to have CPU utilization of last 24 hrs. for time being i want
to have result from 1 server.
select "AVG_%_Total_Processor_Time", "WRITETIME", "MAX_

I've been trying for 2 hours to install in silent mode a DB2 9 runtime
client.  Why didn't you make this process as simple as for the CLIENT
install ?
It is not the same setup command, you can download a setup from the support

How can I fix this so that it doesn't do essentially the same scan
twice, but it gives the same results (a single row where
IDENTITY_MODIFIER is either 'identityoverride' or '' and
ROWCHANGETIMESTAMP_MODIFIER is either 'rowchangetimestampoverride' or ''?

Working on a little shell script to remove specific records from a flat file.
I have scanned a one or two script books and googled for answers but have no
success. Can someone show me how I can do this. For example, how can I remove
the something like the following records from ...

DB2/400 seems not able to auto-rollback one of transactions while
dead-
lock occurred.
I called the procecure QSYS.CREATE_SQL_SAMPLE for creating sample

I have the following table SMV:
CREATE TABLE SMV(
SET_ID BIGINT   NOT NULL  GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1, CACHE 500, MINVALUE 1, MAXVALUE

DB2 UDB V8.2 on AIX.  Is there a db2 command/function to terminate a
single idle agents from the agent pool.  I could kill -9 the process
but I was wonder if there was a more graceful or appropriate way to do
this.  I did not see an API call like sqleEndCtx that could

We install DBv9.5 64-bit on a Linux server. While creating user tablespaces
(e.g., TS0004k regular) we find that DB2 control center does not allow us to
add the container location for the tablespace. DB2 automatically assigns a
location which happens to be the same path as the ...

Is it possible to use parameter markers like this:
1.) SELECT * FROM TABLE1 WHERE FIELD1 LIKE '%?%'
If I now set parameter 1 to '' (empty string) I don't get any rows back,
but if I run:

I created a table with only one char(1) column and inserted values
from 'A' to 'Z'.  After that I am executing "select * from tablename
where colname between '0' and 'z'. It gives me all the data except
'Z' (capital Z). As I am not getting 'Z', it makes me wonder how does

Is there a way to use either the REPLACE() or TRANSLATE() function to
change ascii nul characters (chr(0)) in a given table/column to a
different character?  I've tried what I think should work, but both
functions seem to get confused when they encounter the nul in the

Hello, I am running DB2 V8.2 on AIX.  I am looking for a way to get
the memory size of a specific db2 agent.  I have found the db2mtrk
tool that gives me a list of all the applications and heap sizes.
Also there is "DB2 Snapshot for Application" but I am looking for a

DB2 LUW 8.1
Colleagues:
It's my understanding that SELECT...INTO is not supported in UDFs. I'm
having problems, however, with (compound) variable assignments

Good Morning folks,
Our DB2 servers currently complains about the below error, "User
interrupt detected". I've been researching for quite long and I
haven't got any good explanation nor solution on this.

Hello, all.
DB2 v9.5.1 ESE, Windows 2003 Server 64-bit, 4 CPU (8 cores) each, DPF
environment.
There are 2 DPF instances on the same set of 5 computers.