Does anyone know the link to obtain the
tarball for db2 8.1 for solaris running
on AMD 64 bit ?
This is the entire db2 installation

        Can anyone let me know how can we know what is the last
committed transaction and which application committed it?
         what i found is like after we restore and rollforward it then
it is showing the last committed transaction.

I am using Db2 UDB v 8.2 on RHEL . I have performed a load operation on
a table. Now that tablespace has been switched into RESTORE PENDING
state. Now I can only read the data in the table. I can't modify the
data in the table as it is giving me an error saying "Tablespace Access

Chaps,
I'm starting to play with db2 V9.1 and  am writing a stored procedure
to manage accounting records from oiur RADIUS server.
I've got an XML aware table with an auto increment primary key, a few

Hi I am new in DB2, and I have some problems when I try run stored
procedures, and others statements. I made one stored procedure very
simple, but this show different messages.
I have followed the indications that have said me in answer to topics,

hai everybody,
 i want to know how to send an email notification from db2.
 I configured the smtp server also,but im not able to receive
mails.please help me how to solve this.

Folks
Is there way to encrypt a column (integer ) in a table in  IBM DB2/ in os390 system. If so can you tell me how to do that
Thanks

I have sucessfully created an  SQL SERVER LINKED SERVER to point to DB2
on Z/OS.
I have been successully able to copy most of the tables in the
database. However, I have a couple that have a dates outside of SQL

I'm writting a script that needs to deterimine the length of a char
value...its easy enough to put length ('my data value') which
evalulates to 13, but when I concatonate it, it says...
SQL0440N  No authorized routine named "||" of "FUNCTION" having

I'm looking for a way in SQL to find duplicate records in a single
table, that are the same based on 3 columns, regardless of what is in
the other columns in the duplicate records.  I would like to keep both
records (or it could be more than 2 as well) where duplicate records

Here's the scenario.
Take backup on production machine
Restore backup on development machine
OS and fixpak identical, but - and I suspect this has something to do

what is the command to list all existing schemas in a database? Is
there any command to list all the schemas under a instance as
database.schema ??
Please let me know. Thanks,

Hi All;
I have what I hope is a simple environmental problem. I have some SQL
that creates a VERY simple procedure. When the create is executed from
Quest (from a Windows client) - no problem. As soon as I go to the

Hi, and thanks in advance. I am reading documentation for
a JDBC driver which uses DRDA to talk to DB2, but seems
to imply that some DB2 installations/configurations might
make DRDA access optional.

I have varchar column which stores data in 8 char format 'yyyymmdd'. i
want to transfer data in date columns but before that i want to check
data is proper date or not.
like in sql server i have isdate function. i didnt seen any function