i am using the fallowing command in db2cmd
db2 GET ROUTINE INTO procs/temp_table_demo.sar FROM SPECIFIC PROCEDURE
db2admin.temp_table_demo HIDE BODY@
but i got this error.

In 9.1 (Linux 64 bit) when a buffer pool is set to self-tuning, does this
imply that the blocked versus non-blocked aspect is also self-tuning?
If not, what is a good rule of thumb for a 64 bit system using the Linux
file system for containers for the tablespace using that buffer ...

Thanks to answer topic previous!!!!
I use this script to update one table
MERGE INTO EIS.CLI_HISTORY TXN
USING EIS.CLI_MAPING CLI

I'm after forgetting a password for a database user.
DB2 on linux client, server on zSeries. 8.1.5 is the version.
I can connect as user SYSADM, which has full authorisations.
What's the equivalent of ALTER USER SM1ADM IDENTIFIED BY PASSWORD for

Are there DDL triggers in DB2?
By DDL triggers I mean the triggers which can be fired on ALTER, DELETE,
DROP, GRANT and REVOKE commands.
Such triggers are there in Oracle and SQL Server. I was hoping that they

Hi Group,
I have a Primary key in my table. It's clear Primary key wont allow
duplicates, this primary key creates one index for retrival. Suppose if
my table is having a Unique index also. Then what is the exact

I have Julian date in format YYDDD in the load file.
A column in the table to be loaded has regular date format.
I am using IBM load utility. How can I convert data?
(In JCL before Load I can put some logic to modify Julian date field to

Why the recovery to time is greater than the current time?
---------------------------------------------------------------------------------------------------------------------
Last committed transaction             = 2006-08-23-22.09.40.000000
DB20000I  The ROLLFORWARD command ...

If you are new to the environment whats the best way to find out the
"id" which is placing a force with lock on a table XYZ for performing
load operation.
Thanks.

HI  please help me in this project!!!!!!!!
In this highly mechanized world this wish system should help people &
organizations to show that their caring & loving for others around
them. This in turn will help organizations build good relationship

can you share good resources for db2 UDB DBAs? Apart from google groups
and IBM documents, please share resorces for DBAs. THanks,

I am completely new to db2 (v8.2.2) and am trying to import an access db
into it. I have read the documation but no success,
Any ideas or help would be greatly apprectiated
regards

I want to write a program to connect DB2 by jdbc, and i do not want to
provide user name and passwords?
in IBM site, i find a sample:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.
udb.apdv.java.doc/doc/c0023797.htm

does anyone know why on the IBM download section of the UDB Support page
http://www-306.ibm.com/software/data/db2/udb/support/
FP 13, 11 and 10 are listed prominently, but not FP12.
We tried fixpak 11, found you couldn't uninstall it with Windows installer(that

I need some help....
I have XML files residing on the database server harddisk. I want to
load those files as CLOB into a table column. The table is defined like
this: