how can I use a function inside a function, for example I want to
select col1, col2 from table1 where locate(dayofweek(current
date),col3) =dayofweek(current date)
col3 is a field that contains a string like '12 4567', or

Can anyone post the procedure to split mirror steps for Veritas or
Legato or from any vendor? ,so that I can better it. I understand the
suspend i/o and initialization(db2inidb) , but need to understand this
more.

Folks,
I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?
I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this system.

Apparently I have a scope problem wrt t1.start_date in the second sub
select's sub select. The message is:
S0002--[IBM][CLI Driver][DB2/LINUX] SQL0204N "T1.START_DATE" is an
undefined name. SQLSTATE=42704

Running 8.1 w/FP5 on Windows 2000.  Everytime I try to create a stored
procedure, I get the following error saying that my database is
damaged:
DB21034E  The command was processed as an SQL statement because it was

I've tried this post on the listserv with little or no results.
Hopefully someone can clear this confusion up for me.
I've got a situation that has me somewhat befuddled.  I have three
tables all with approximately 600,000 records.  Here are some

I'm having a problem with the type 4 JDBC driver over DB2 v8.1 on
Linux.  We've recently begun to use Blobs to store documents in our
table structure.  Problem is: we're able to retrieve some (but not all)
such documents by invoking ResultSet.getBinaryStream() or, alternately,

Folks,
I've been exercising my mind recently about the complexities of implementing
a "currency" data type within DB2 to cope with multiple currencies.
A monetary value is often simply represented as a DECIMAL column : for

APAR fixes included in Fixpak 9a
APAR No. Abstract
-------- --------------------------------------------------
IY73104 SECURITY: DB2 SECURITY VULNERABILITY RELATED TO INCORRECT

Is there any documentation on the message format being sent to port 523
(DAS) and the returned replies?
We've got a problem with a tool that says that the DAS is not
responding, while the IBM tools says that the DAS is alive and well.

So I had my jdbc db28.2 fix pack 9 client running because I had taken
the jars from <DB2ROOT>/java folder from Enterprise Edition 8.2 fix
pack 9, db2java.zip, db2jcc.zip, and the license jar.  Using these
everything works.

the below list shows the top running queries in oracle on a database on
a single day. Can we do something similar in DB2 v8 where we get a list
of top 10 queries in execution time , or CPU utilisation or DISK I/O
every day. Setting up an event monitor is not feasible. Are there any

I have a new instalation that I am ironing out the wrinkles in.  In the
process I have had a few crashes and now my SQLlib\DB2 Dir is full of
.0 and .000 files.  What is the best way to clean up this Dir without
damaging anything permanatly?

  I have a stored procedure that does a lot of INSERT/UDATE to 3
tables. And When I call the stored procedure, I get a Transaction Log
Full error. When I want to do is turning off the transaction log on
those 3 tables that the stored procedure is using.

Is it possible to invoke JCL or CICS from a stored procedure?  I am
working on a integration project in which I need one system to invoke
another.  The plan is to write data into tables in DB2 and then call
existing programs to process the data.  We don't have CICS TS or