Please, can you help me about this error:
SQL1091C  The release number of the database is not valid.
SQLSTATE=08004
I connect to a db Version: 7, Release: 1 whit a database manager

v8.2.1
Try this (and any 3-d argument):
---
select locate('','string',5) from sysibm.sysdummy1;

We are trying to restore a backup that we took last night on a fresh
new Tape. The backup was successful but the restore is failing with the
following error:
db2 => restore db gpiecuk from /dev/rmt0

I am new to UDF's.
I tring write a function that send a char value. But I am not able to
make it work. Could someone help me with this.
Here is my C code.

OS: AIX 5L, DB2 UDB v8.2
the nicknames are created like this
create nickname <schema-name>.<tab-name>  for
<remote-db-name>.<remote-schema-name>.<remote-tabname>

I have to create an AFTER UPDATE trigger that needs to perform an
UPDATE on the same table.  I understand this is a recursive situation
and I'm wondering if there is a way to NOT go through all 16 levels of
recursion.  Ideally the UPDATE performed by the trigger would not cause

DB2 LUW 8.2.7 FP14 Red Hat AS2.1
(w/ thanks to Chris Eaton for the cool scripts)
I did this:
 create view DB2$MON_BP

Involved OS: AIX.
Involved DBMS: DB2 v8.1.1.96
User u1 can connect to DB d1 and run "LIST TABLES" without problem when
running from a terminal session. But when trying to work through SAS, he

I'm looking for the best jdbc driver to use in combination with DB2
Connect. If you have any suggestions please let me know.

Sorry if this is a FAQ.
On AIX 5.3, running DB2, storing data on a SAN with various RAIDs:
Are raw devices really relevant nowadays? What performance gains are to be
expected, all things equal?

I'm working on a project which needs 10 GB of foxpro database needed to
be migrated to DB2. Please suggest me some database migration strategy
or is there any tool which can import data from foxpro onto DB2?
Could anyone let me know which is the right place/site to

I'm gonna pull my hair in the coming days with these DB2 stored
procedures.
So the issue, let's assume a simple stored procedure like this :
CREATE PROCEDURE MYSCHEMA.PROCEDURE1 (  )

I had asked a question a few weeks ago about having problems at times
accessing DB2 Express-C 9.1, and getting "SQL1032N No start database manager
command was issued. SQLSTATE=57019" even when the database was in fact
started.

I need a way to list an instance's databases, in a way which is easy to
parse (I can't count on perl or similar scripting tools to be available
everywhere). I know of the 'db2 list database directory' command, but its
output doesn't qualify for "easy to parse" for me, when I simply ...

I would like to accomplish the following using a SQL UDF in db2.
1. Invoke a java class from within the UDF and call a method which
takes a parameter and returns a result.
2. the UDF performs an insert / update operation in a table using the