I am new to DB2, My installation of DB does not include Development
center...
but i need to create stored procedures.
Geeks please help me how to create stored procedure and please step by

The following (skeleton) works fine when using AQT (win/xp, ODBC),
but throws a -407 when issued from green screen SPUFI.  The DB is 8.1.5
on z/OS.
update tableFoo

I have a table of over a billion records with the following fields referenced.
....client_cd, claim_thru_dt, claim_type_cd, claim_id, ma_paid_amt.  The
query used to produce the desired output is:
SELECT     CLIENT_CD, DATEPART(YEAR,CLAIM_THRU_DT) AS MOSYR,

Hello, I have a very simple script (or would you call it a batch
file?) with the following content:
connect to mydb2;
DROP TABLE staff_employee_address;

I am checking an existing DB2 installation on Red Hat Linux and I see
that root owns files in the db2 instance home directory.
Stuff like:
./sqllib/adm/db2chparm

Here is very intresting query,but it is not wirtten in DB2:
input table:
Task           Start                   Finish
Sleep   01-oct-04 19:00  02-Oct-04 07:00

is it possible to stop/start remote instance?
db2stop makes effect only with local instance
regards
S.

Im runnign various versions of DB2 on various UNIX platforms
(Solaris / AIX).
DB2 is generally eating up about 30% of memory on these systems (4Gb
of RAM, which equates to over a gig). i want to limit DB2s memory

I have a problem, I am getting SQL1042N  The SQL statement is not
supported. error when I try to create a MQT against a nickname. The
source db is db2 version 9.1 fixpack 4, same as the target db and so
the SQL is definitely supported and both are in windows 2003 server.

I would like to know what would be some performance goals for DBAs ? I can
think of customer satisfaction and database availability being some. What
else can I have as performance goals for my DBAs and more important what can
I have as some stretch goals ?

This query is supposed to count consecutive years from the current year
without OLAP.  
Input Table:
ID  DateCol