CLI connection failed. SQL0902C. A system error (reasoncode="6029321")
occurred. Subsequent SQL statements cannot be processed.
SQLSTATE=58005.
Has anyone encountered the above error? We are trying to connect to a

I bound my package with EXPLAIN(YES), and it's got the following static
SQL in it:
EXEC SQL SELECT CARDF,  RECLENGTH
          INTO :CARDF,:RECLENGTH

DB2 WSE 8.1 FP5
Red Hat AS 2.1
I'm currently on 8.1 FP5 ("If it ain't broke, don't fix it..").
However, I'm looking at a change to the 2.6 kernel and an

I'm currently trying to update a dev DB2 server (running on SUSE 9) to
8.1 SP10 and once I'm completed and try to do db2start, I get this
error: db2start: error while loading shared libraries: libibmc++.so.1:
cannot open shared object file: No such file or directory

I am doing a purge process and trying to delete rows .Let me know how
efficiently I can handle the purge process because of the RI on the
tables.
TABLE A is a PARENT of  TABLE B, TABLE C, TABLE D.  I want to purge

Is it possible to combine (in DB2 UDB 8.1) a stored procedure and a
select statement? I mean something like this:
Select
    c.number,

I have gone through the snapshot API. I need to use it for finding
location of database files, tablespace containers etc on a remote
machine. These parameters are present in the response. However, for
getting only some paramters, I get a huge response, with many

i have the next for create one table into db2
CREATE TABLE "MYSQUEMA"."TABLADEMO"  (
   "ID" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (
     START WITH +0

DB2ers,
Our Windows application connects to any DB2 server using the ODBC
driver.
It seems there are two ODBC drivers that IBM provides - DB Connect and

Our DB2 Server processes used up host machine's whole memory. Without
getting the server down, how can we relieve the memory load.
CRM Users are getting error messages, I need something quick & dirty.
Thanks in advance...

Is there any way to select a row from a db2 table and send it.  Similar
to xp_sendmail on SQL Server.
Thanks
Ross

I have  background in SQL server and none in DB2 hence the question.
SQL Server has a bcp command - I am looking for an equivalent utility
in db2
I have a table called Employee(empid int ,fname varchar(20),lname

I am trying to do an offline backup of a 7.2 db. The problem is that
the backup is failing due to connections still being open to the db. I
found this command 'quiesce database immediate' but its only a  version
8 command ? Is there a version 7 equivalent ?

running on windows, I encounter following
db2start.
SQL6030N  START or STOP DATABASE MANAGER failed.  Reason code "13".
any ideas why db2start is failing ?

I've been having major problems installing Linux Runtime on slackware,
but i think im close.  My current problem is strange and I've searched
the net and found very little im getting the error when i try to run
db2icrt to create an instance: