I have what is probably a strange question but is it possible to get a
tablespace out of a backup pending state if one does a load on a
recoverable database?  Also assuming this isn't possible would it be
possible to add a warning when it is run in a recoverable database

Hi, I'm new to DB2, currently working on Sybase. Is there a flat-text log
file where DB2 writes to at startup and when it wishes to log problems like
failed logins, expired passwords etc?
(The equivalent in Sybase is the Sybase errorlog.)

        I want to write a user defined function in the bd2 database
that will return somethings from database by the java like srote
procedure. Is it possible, if yes Please give me hints.
..Mamun

Hi - from my limited expereince in DB2, it appears that you can't
include a case statement in a group by clause - is this correct?
For example, my SQL looked like this:
SELECT CASE WHEN GROUP_CD<'00001' THEN 'ITS' ELSE 'NON' END AS TYPE,

I'm trying to set up a connection between a linux server and a DB2 on
mainframe.
I have a server where everything is working correctly and a second one
where the connection cannot be established.

I am switching from an Oracle enviornment to DB2.  We are currently
using the TOAD product with the Oracle DB to write queries, stored
procedures, view tables, view data, etc.  Can anyone suggest a similar
tool to use with DB2?  Does DB2 come with a good product (Oracle does

Overview
There are occasions when UDB Tables will have to be Dropped and
Re-Created.
For unaltered Stored Procedures, this should not necessitate a

I have a table with a clob column with 10 records and each record is
around 1MB.
I just want to know is there any way that i can export or send this
clob data of each record into separate file.

Is there a (set of) queries at the sql level that gives the same (or
similar) information as the command level db2level? I looked in the SQL
Reference and the Command Reference for a cross reference but didn't
find one.

Hi everybody !!
I am new in DB2 database word, and I am trying to install a DB2
Personal Edition in my notebook to study it, but I have some problems
during the installation.

Something is jacked on my local computer and I need to uninstall the
pavkages so that I can reload the DB2 tools.  However, the uninstall
error out, and I left without being able to reload the programs...
Any suggestions?

how to check if a table is exist then drop it if true, false to ignore
the SQL statement, for example,
drop table person if exist;

I have moved a database from the DB2 Windows Platform (Dev) to our
production AIX Server and am experiencing an issue:
The AIX platform is 5.3 and DB2 version 8.1 pixpack 9a (8.1.1.89)
There hardware is Power5 8 procs, 4 online and 8 GB of memory.

Created summary table data intially deferred refresh deferred that
contains a 3 table join with cardinality of the join about 4.5 million
rows. If I do not have an index on the summary table, and do a refresh
the amount of transaction logging is reasonable. But when an index is

  Folks,
  I'm trying to port a PostgreSQL application to DB2 LUW 8.2.2 (Win32, if
you must know).  I've searched the web and can't find any guide to migrating
from PostgreSQL to DB2, even on the IBM web site.