DB2

Error SQLCODE "-811", SQLSTATE "21000"
Our web programmer was looking in his application log an found the following error: 2006-08-31 16:33:35,129 ERROR org.hibernate.util.JDBCExceptionReporter - <[IBM][CLI Driver][DB2/6000] SQL0723N An error occurred in a triggered SQL statement in trigger "OLGCWEB.TBLPROPS_INS_TRG". Information returned for the er... 1 Sep 2006 09:04

Connecting to Stored Procedure from Crystal
I am trying to connect to a DB2 database using "iSeries Access ODBC Driver" from Crystal Reports. I am able to report on tables and queries but not stored procedures. I get the following error after I select the procedure and enter the parameter. Query Engine Error: '42000:[IBM][iSeries Access ODBC Driver] State... 15 Aug 2006 11:31

Reducing Pages HIGHWATER mark
Express C v9.1 I'm having a hell of a job trying to reduce the highwater mark for various tablespaces in Express C. DB2MART advises to reorg several tables with LONGLOBDATA and to disconnect, reconnect between each step, but the tablespace snapshot is still showing a highwater mark as follows. Total number ... 17 Aug 2006 02:35

SQLSTATE 38553
Hai everyone.... When i am trying to access the DB2 from Crystal reports 10.0 in windows Operating system it is giving me the following Error................ "Query Engine error: [IBM] [CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLTABLES' (specific name "TABLES") has returned an error SQLSTAT... 9 Aug 2006 08:52

DB2 Connection Problem
Our web application running on WebSphere hits the following two exceptions randomly (once or twice a day) while opening connection to db2. Does anyone has idea about the cause of the exception. We are using connection pool to connect to db2. Database product name : DB2/AIX64 Database product version : SQL08025 ... 31 Jul 2006 06:01

Weird message in db2diag.log
I have the following message in my db2diag.log file repeating every minute. Does anyone know what the error is ? 2006-07-10-10.27.08.921000-240 I95651H390 LEVEL: Error PID : 3228 TID : 3240 FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:10 DATA #1 : Sint... 10 Jul 2006 18:16

No remote connections available
I have db2 EES installed on linux . db2level DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08025" with level identifier "03060106". Informational tokens are "DB2 v8.1.2.112", "s060429", "MI00155", and FixPak "12". Product is installed at "/opt/IBM/db2/V8.1". I have db2inst1 instance da... 27 Jun 2006 13:11

I hope in Serge Rielau
Ciao a tutti ( Hi to all ) ( sorry for my bad english ) ! I have a problem with dynamic sql. I try to read all internet but I don't understand anything ! So I hope in Serge ( I love toronto in particular missaugua ) I write the error in my log file : " 2006.6.8 - 15:36.9 - [413] - INFO - --> Lo statment... 9 Jun 2006 10:58

SQL1224N - A database agent could not be started to service a request
Env : DB2 UDB 8.2, AIX 5.3, Ascential Datastage (DS) DS jobs are used to process the backend DB2 database. Sometimes DS job fails with the message APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a r... 27 Mar 2006 20:51

NULLID.SYSSN300
Can anyone please help me and explain: [24/03/06 11:22:28:212 EST] 3e70982f WSRdbDataSour I DSRA8203I: Database product name : OS2 [24/03/06 11:22:28:332 EST] 3e70982f WSRdbDataSour I DSRA8204I: Database product version : DB2 UDB 6.1 [24/03/06 11:22:28:332 EST] 3e70982f WSRdbDataSour I DSRA8205I: JDBC drive... 27 Mar 2006 01:28