DB2

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

Decimal precision
Hi, I have a column defined as decimal(4,3). I get the following error when I try to insert "12.50000000000000" [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003 sqlstate = 22003 I even tried with "12.500" and "12.50" , but still get the same error. My point here is, it allows only one... 14 Aug 2006 14:43

Spilled sorts
Hi all, Outside of changing the SQL of the query or creating indexes, what can one do in order to prevent sort spills. Im thinking along the lines of the db cfg and dbm cfg files. Ill post the current setup we have of one database which is having problems with these: db2 get dbm cfg: Database manager con... 16 Aug 2006 14:52

SQL0338N
We have a user who is trying to generate a report from a db2 database. He is using a tool from a third party vendor, where he first designs the report and the tool then generates the SQL from the choices made by the user. When this report is generated in our test environment it works fine, but in the production env... 9 Aug 2006 08:52

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

sql standards
Do DB2 SQL statements run on MS SQL Server? What would be the best way to keep one version of the application source code which would work with both DB2 and SQL Server databases? rather than maintaining 2 diff. source codes of the same application. Would appreciate any advice. Thanks a lot. ... 8 Aug 2006 09:55

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

Trace,....
Hai everyone... Can anyone tell me how to analyze the output i got frm db2trc.... Regards... Kamal ... 11 Jul 2006 05:29

set current explain mode recommend indexes
hi, our db2advis is broken and i am trying to find other ways to get recommended indexes i tried using command "SET CURRENT EXPLAIN MODE RECOMMEND INDEXES" and it populated ADVISE_INDEXES table. new indexes recommended by this command does not have runstats on it. how can i evaluate new suggested indexes ? do ... 10 Jul 2006 18:16