http://bestdb2articles.com Keeping you up-to-date! Tue, 09 Mar 2010 05:00:11 +0000 http://backend.userland.com/rss092 en When DB2_USE_IOCP is enabled, the instance may crash with the following error reported in the db2diag.log http://bestdb2articles.com/2010/03/iz54743-after-enabling-db2_use_iocp-db2-may-encounter-ealready-56-operation-already-in-process-error/ Net search extender returns CTE0190 error enabling database.   http://bestdb2articles.com/2010/03/cte0190-executable-program-cteadmsv-could-not-be-started/ Federated query having scalar correlated subquery predicate could return incorrect result. http://bestdb2articles.com/2010/03/ic66888-federated-query-having-scalar-correlated-subquery-predicate-could-return-incorrect-result/ If a Load into a table that resides in an SMS tablespace fails and the table is left in Load Pending state (ie. a Load http://bestdb2articles.com/2010/03/ic66894-backup-of-a-table-in-load_pending-state-in-sms-tablespace-may-fail-with-badpage-error-and-sql1655e/ If zOS client, when trying toresolve indoubt transactions, sends a non-existent UOWID to DB2 LUW server, the server doesn't http://bestdb2articles.com/2010/03/iz71034-when-trying-to-resolve-indoubt-transactions-zos-client-connected-to-db2-luw-server-gets-the-error-dsnl414e/ LOAD ABEND0C4 during DISCARD phase SYSREC RECFM VB, input record length exceeds LRECL size http://bestdb2articles.com/2010/03/pm05198-load-abends-0c4-10-during-discard-phase-sysrec-recfm-vb-input-record-length-exceeds-lrecl-size/ The LOGSECOND db cfg parameter is set to -1 but when looking at the db2pd output it shows 65535 which is incorrect. http://bestdb2articles.com/2010/03/ic65990-db2pd-shows-incorrect-values-for-logsecond-as-a-unsigned-integer/ The LOGSECOND db cfg parameter is set to -1 but when looking at the db2pd output it shows 65535 which is incorrect. http://bestdb2articles.com/2010/03/ic65991-db2pd-shows-incorrect-values-for-logsecond-as-a-unsigned-integer/ A small amount of memory is leaked in the DB2 server process on each call to a trusted/unfenced CLI routine. http://bestdb2articles.com/2010/03/ic66898-memory-leak-in-db2-when-calling-unfenced-cli-routines/ Problem: Customer starts db2 instance fine but getting error when trying to start TDS (Tivoli directory Server) thorugh http://bestdb2articles.com/2010/03/ic66807-cant-start-tds-tivoli-directory-server-service-via-windows-services/