I just installed DB2 Recovery Expert V2.1 on DB2 V8.1 for Solaris.
Just wondering how many people are using it and what their impressions
are about the tool.  I'm running into some problems and have had a hard
time finding any support resources for it.  

I am creating an application with VS 2005 using DB2 Express 9. Can
someone help me with the correct form to connect to the database????

In Oracle stored procedures, you can declare sub-procedures to help
modularize your code... i.e.
CREATE OR REPLACE  PROCEDURE myProcedure is
PROCEDURE b (field1 INTEGER,

In Oracle you can pass parameters to cursors i.e.
cursor myCursor(name_city varchar(50), population integer) is
  select * from cities
  where name = name_city and

I was wondering if anyone could advise me on this.
Right now I am setting up a DB2 UDB V8.2.3  database with UTF8
character set, which will work with a J2EE application running on
WebSphere Application Server.

In my SQL procedures in DB2 8.2, I current declare several cursors that
return select statements with > 10 columns in it.
As a result, assigning host variables becomes a coding mess, as I would
have to declare anywhere from 50-100 host variables just so I can

Guys may yu assist me am stuck. Am using v8.1 db2 database on Suse
Linux running on an IBM pSeries server. I am aware of the backup
utility in db2. I would like to back up the my db2 database to a tape
device. What is the command to effect this in linux? How is a tape

The database is currently in the circular logging mode (no log
archiving). I want to track the database transaction log switch history
in form of (switch-timestamp, active-log-sequence-number) to eventualy
assess on the database logging volume during the database operations

Is there a way to check the order in which SET INTEGRITY needs to be
applied? This would be for a script with a dynamic list of TABLEs.
B.

I've been searching this newsgroup for an answer to my question, and
the closest I've come asks my question, but in reverse ("How to figure
out the program from plan/package"). I've -- shall we say, inherited?
-- a COBOL program with very little documentation that I've recompiled

Is this a bug in Db2 on iSeries V5 R3?
The following query should work:
CREATE TABLE qtemp.t03 AS (
SELECT 1 AS foofoo_s

Is there a way to do ORDER BY with DESC inside a CASE statement? That
is, given more than one choice for an ORDER BY based on a CASE
statement, but only one of the choices will also use DESC (others rely
on the default of ASC).

I am wondering how to check for authorizations. I see DbAbmAuth in
SysCat.DbAuth to check for DbAbm priviliges. Is there a similar way to
check for SysAdm priviliges?
Also, SysCat.TabAuth has a GranteeType which can be a user or a group.

I met a problem when insert over 1000 records to db2 via servlet,
it show me the error message is "DB2 SQL error: SQLCODE: -911,
SQLSTATE: 40001, SQLERRMC: 68  DB2ConnectionCorrelator:
NF000001.D8B5.061208085417". Can anyone help?Thanks

i've setup my db to user logarchmeth1 option in db2 v8.2.
Is there any log to show when are archived the logs.
In the past, i used userexit and i had a log file with time of archive.
paul