I have a java store procedure with 12 parameters including the
Resultset.While building it gives me the following error
IBM][CLI Driver][DB2/NT] SQL0449N  The statement defining routine
"DB2ADMIN.TEST" contains an invalidly formatted library/function

How I can determine the correct "bufferpool hit ratio" with "block-based
buffer pools".
With the formula
  ( 1 - float ( pool_data_p_reads + pool_index_p_reads ) / float (

I need to build a table mapping error codes to error messages.
I know that sqlcamessage get retrieve them one at a time but am
wondering whether ther are all centrally located in some file or table
that I could use on the client and/or server.

I'm a developer who will be using DB2 in the near future and would
like to know what DB2 I should be downloading.  Below are the 4
downloads that are available off of the IBM website.  Whats the
differences between each of the downloads?  Do you have a link (url)

Out of sheer curiousity ( Hi Eric! ;-) I installed DBD::DB2 but cannot
get it to work with some of the DB2 commands.  I can select count(*) but
cannot "list tablespaces".  I have ssh'd into the box as db2inst1
not as root or any "su - dbinst1".  Any ideas?  If I go into DB2

I would like to create certain views to make my user's life easier. Does
the manual mean to imply (at least I inferred) that views can not be
based on JOINed tables? The following SQL statement cause the system to
respond with:

Hello!  The issue I am having is that when I export a decimal column
out of DB2 UDB 8.1.5 I get a "+" and leading zeros to round out the
field (see example below).  I have a quick and dirty perl one-liner to
fix this, but even after scouring the export documentation and

I performed a Cold start and now my replication database tablespace is in a
load pending state.  How do I resolve this issue?  The table that the load
hung on was called TAGHIS, I tried performing a load from the appropriate
file in the <DBNAME> ...

I have seen two DB2 V7 installation CDs for AIX, one for AIX V 4.x and the
other for AIX V5.x  
Anyone can throw light on what is basically   different ?

hi, i am trying do create a database from backup on db2 udb v8.1 win
ESE, but it gives me error
SQL0970N  The system attempted to write to a read-only file.
Explanation:

I have just built a new machine with two 3.06GHz Intel Xeon processors
with hyperthreading. I have 4 Gigabytes RAM installed. I am now running
Red Hat Enterprise Linux 3 ES. I am still using DB2 V6.1 on my old dual
550MHz Pentium III machine running Red Hat Linux 7.3, but ...

People, Ive been struggling with this simple issue for days. How am I
able to select a list of common dates that exists in a larger list of
dates by using a subquery to specify a predicate ? That may sound
completely wrong.

Hi..
      SQL0060W  The "COBOL" precompiler is in progress.
 39   SQL0062W  Starting INCLUDE of file "C:\Program
                Files\SQLLIB\INCLUDE\COBOL_A\JCSD006.sqb".

We are building a DB2/Linux environment that will be accessed from a
windows based application server environment.  I am looking for a way
to get LDAP on the Linux boxes to talk to Active Directory.  This is
not one of my areas of expertise, but I have to believe it can be

On Linux, using the db2cc, is the db2cc supposed to hang or freeze-up when you create an index?
Altering tables doesn't really work does it?