My fellow team mates had some extra time on their hands so we decided to
 spice up DB2 with a grab-bag of compatibility features.
We wouldn't mind help validating the semantics match....
So for those of you blessed or cursed with a competitive DBMS here is a

I use db2 8.2.7 - and can't get the following SQL up to work:
$>db2 "select se.tag from ext.sesdr_server_ids se join adm.node no on se.tag
= no.tag where posstr (se.serial_number, no.name) > 0"
SQL0132N  A LIKE predicate or POSSTR scalar function is not valid because

I have a situation where an SQL View was created over several table -
and the library containing the SQL view is going to be refreshed.
When the refresh occurs we will lose the SQL view.
I do not know the syntax that was used to create the SQL View - and

I recently noticed the
'Database is consistant' parameter of the db cfg changed from Yes to
No, when I did a
'set integrity immediate unchecked' command. the integrity of the

I usually get stuck with one of two questions that keep coming up.
Perhaps some of you brilliant people can shed some light...
1. How to do use if statements in load commands (I usually need this
in the task center):

How much does it cost to take a certification exam for DB2?

Can anyone help me out with these two issues I seem to be having?
using the db2 driver for PHP (db2_xxxxxx) functions
1. If I forget, or for some reason db2_commit/db2_rollback doesn't get
executed.. my table becomes inaccessible. How do I set it to only lock

We have an environment where we have two databases with identical
structures. In practice we like to keep the data on one of them small
for performance reasons. We have been identifying records over a
certain age, extracting the data, inserting it into the secondary

DB2 8.2 on AIX 5.3.
Please could someone tell me how to permanently disable the default
DB2DETAILDEADLOCK event monitor (also, so that it does not restart
when the instance is recycled).

I have very little knowledge about creating Procedures/functions in
DB2.
When i tried to create the test function like
CREATE FUNCTION GET_TEST

I am very new to DB2, so please explain in somwhat detail.
How can i (can i ?) take the dump of a schema in DB2 like i can do in
Oracle?
Also, if i have to create a replica of a schema, i can use the

Is there a way to select the text description of a set of fields in a
table? I am looking for a result set like the following:
fieldName |  fieldDesc
------------------------------------------

GM,
I have couple of questions related to value compression feature in DB2
V8.2
[1] Any method to get the list of tables enabled/not enabled for value

I need to extract huge amount of data from a DB2 dabase periodically.
The extracted data needs to be exported to CSV format. I have thought
of writing a Java piece of code to connect to DB2 using JDBC and then
execute various queries.

I read that IBM DB2 Express-C database is FREE with no restrictions.
What type of licensing policy does it have in case I want to bundle it
with my .NET application (closed source)?