Please see the following question:
AUTHENTICATION=SERVER_ENCRYPT allows DB2 to encrypt which of the
following?
A.data

I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:
"Exception occurred while debugging:

I have data for each week in a single table.  I need to export this data to
a separate flat file for each week.
Any ideas?
DB2 SQL Query export to flat files as a function of data on each record

I'm testing out db2 for a project I'm starting that requires proper xml
support and I can't seem to get both xml and spatial data to work well
in the same table.
Once having created a table containing both xml and spatial data fields

Hi, All
I have strange situation with table design for DB2 9.1 on Windows
I have 3 tables with same structure :
1 table - is MDC

We have installed DB2UDB 8.2 on a windows 2003 server. How can I
confirm the version of the JDBC driver that would have been installed
with this? I wasn;t sure if the JBDC driver would have a different
version/build then the DB version itself.

I am trying to figure out a single select statement from a table
function f(x) when the function's argument is fed from another result
set, like
SELECT ... FROM TABLE( f(x) ) a

Can I know how to know free disk space in Db2? Is there any built in
function that displays the free space, avilable space etc in DB2?
Pl help me
Regards

ich habe noch nicht viel Erfahrung mit der DB2.
Ich versuche jetzt von einem Client Rechner auf die DB2 auf dem Server
zuzugreifen.
Dazu habe ich mir den Run Time Client Lite geholt und den ODBC Treiber

Hello, everyone.
I have installed a DB2 ESE on a EM64T platform , and the OS is RedHat
AS4.
 Now I can't find the fixpack for this version.  In the IBM web, I

I'm attempting to connect to a DB2 database using perl DBD::DB2.   I'm
consistently getting the following error:
[IBM][CLI Driver] SQL1042C  An unexpected system error occurred.
SQLSTATE=58004

I have db2 v8.2.5 on AIX V5.3 with all the switches on
  Buffer pool                         (DFT_MON_BUFPOOL) = ON
  Lock                                   (DFT_MON_LOCK) = ON
  Sort                                   (DFT_MON_SORT) = ON

I am running a PreparedStatement query against a DB2 database on a mainframe
and it is returning EBCDIC strings to me. How can I get the query to return
ASCII strings?
Thanks

There's some user defined functions in a database that's being
migrated.
We can't just restore the database to the new server for a number of
reasons that I can't go into here.  However, I can't see how to get the

I am using nested resultsets to execute queries on two different
tables.
The code structure is:
stmt1 = conn.createStatement();