db2  -t  -v  -f/home.../filename    >output_file-name
I have a java stored procedure..which has to run the above
command...not sure how i can run this command through java..
any suggestions are appreciated..

I have a table with the following attributes: Timestamp and a value.
I would like to calculate the percentage of how many values occuring
above a figurative threshold value between the hours of 6 and 10 AM?
Is there a function available for doing this in a sql statement?

I would like to have an attribute that would store an integer or float
range (say 6 to 10).   Is it possible to have both the lower and upper
limit specified in a single field?
Thanks

I look into snapshot (dynsnap) and see 2 different sql (diff in space
between name and bracket)
CALL schema.spname(?,?,?,?,?,?,?,?) ( NUM_EXECUTIONS 7759 )
CALL schema.spname (?,?,?,?,?,?,?,?) ( NUM_EXECUTIONS 12424 )

I just installed DNN and configured the web.config file to point to the
db. When I try to serve the page it downloads the file rather than open
it in the browser. I have gone over the setting in IIS but cannot find
what is wrong. Please advise.

In DB2 is it possible to start and stop a single database as it is done
in oracle, or only instances can be started and stopped??? When I try
to stop/start a database in the control center all the databases in the
instance gets stopped/started. The user with which I try to ...

Can you suggest any reference on analyzing db2expln results?
Regards,
Mehmet

Folks,
I need to create a batch file that will do the following -
Establish a DB2 instance
Connect to a certain database

I have a situation where i have multiple batch and the each batch are
sequence numbers. For each batch, the number should start with 1.
For example:
Col.no1     Col.no2

Does anyone out there have experience with using Db2 8.2 with a program
called MISys (also known as ACCPAC). I am having some problems with the
application running exteremly slow on workstations throughout my
office. One of the more accessed tables, which only has 3000 rows, take

I have a question about db2pd.  When using the -activestatements the
column -EffISO is the effective isolation level.  The value in this
column is an integer, not something easy like UR, CS, RS, or RR.  The
documentation update doesn't tell me what the translation is, can some

I have the following query which takes very long time to execute hence
can you please help to fine tune it as I'm new to DB2 World. Thanks
SELECT
    char(VEH_IDENT_NBR) as VEH_IDENT_NBR,

In Microsoft SQL I can run the following command:
insert into table execute proc1
to insert data into a table.
Is there a comparable way to do this in DB2?

Hi, no point in trying to be eloquent with a question like this.  If a
client met with me and told me of an application he wants to have
changed over to DB2 as a database backend, or perhaps it could be a new
application with well predicted volumes of transactions and data, is

I have a table, something similar to:
create table my_table (
   id char(32) not null primary key,
   num integer not null,