Archive for February, 2010

Feb 27 2010

IC61980: TESCONN20.EXE, SHIPPED WITH THE DATASERVERCLIENET RETURNS AN ERROR MESSAGE FOR THE FACTORY LOOKUP

Published by db2dba under IBM DB2 Linux

tesconn20.exe, shipped with the Data Server Driver returns an error message for the factory lookup

No responses yet

Feb 27 2010

IC64056: OPTIMIZER ENHANCEMENT ON CONVERTING MULTIPLE COLUMNS REFERENCINGA SUBQUERY TO JOINS.

Published by db2dba under IBM DB2 Linux

This APAR is opened for enhancement to better handle converting the subqueries to joins when there are multiple columns

No responses yet

Feb 27 2010

IC63998: EXEC TIME, AVG EXECTIME, CPU TIME, AVG CPUTIME ARE NOT ACCURATE IN DB2TOP

Published by db2dba under IBM DB2 Linux

db2top doesn’t show correct value on EXEC TIME, AVG EXECTIME , CPU TIME. AVG CPUTIME.

No responses yet

Feb 25 2010

DB2 V9.5 db2sampl command on SUN Solaris 10 system chashes the instance

Published by db2dba under IBM DB2 Linux

Why does DB2 instance chrash when I execute the db2sampl command on a brand new installation of DB2? A crash occurred every time the db2sampl command was run.

No responses yet

Feb 24 2010

IC66552: POSSIBLE PANIC IN SQLDUNSETPUNC, PROBE:12991

Published by db2dba under IBM DB2 Linux

During a row fetch, a panic may occur and the db2diag.log indicates Severe error at

No responses yet

Feb 24 2010

IC65501: SNAPSHOTS COUNTS REMOTE CONNECTIONS AS LOCAL

Published by db2dba under IBM DB2 Linux

Snapshot displays remote connections as local connections.

No responses yet

Feb 24 2010

CURRENT TIMESTAMP function behaves differently between UNIX and Windows platforms.

Published by db2dba under IBM DB2 Linux

Why does CURRENT TIMESTAMP() function insert values ONLY up to milliseconds when used on Windows Platforms?

No responses yet

Feb 23 2010

JR31973: INSTANCE ABEND WHEN USING STATEMENT EVENT MONITOR AND INCORRECT PACKAGE SIZE LENGTH IS CONTAINED IN THE DRDA MESSAGE.

Published by db2dba under IBM DB2 Linux

When a statement event monitor is active and an incoming request to execute a statement contains an invalid package name length,

No responses yet

Feb 23 2010

IC66496: SAP:RELOAD OF DB2DSDRIVER.CFG DOES NOT LIKE LOWER CASE <ACR>

Published by db2dba under IBM DB2 Linux

“Sections other than ACR Affinity have been modified” is returned when trying to reload the db2dsdriver.cfg.

No responses yet

Feb 23 2010

IC64043: LOAD PERFORMANCE PROBLEM ON WINDOWS IF THE CPU PARALLELISM APPLIED IS GREATER THAN 1

Published by db2dba under IBM DB2 Linux

When load cpu_parallelism > 1 is applied on load on the Windows platform ( which is the default with a sufficiently sized

No responses yet

Next »