Fix list for IBM solidDB V6.5 and IBM solidDB Universal Cache V6.5

Product documentation


Abstract

This document provides a cumulative summary of fixes made in the solidDB and solidDB Universal Cache since the 6.5 General Availability (GA) release. It also contains links to APARs included in each fix.

Content




IBM solidDB and InfoSphere CDC for solidDB versions for fix packs and interim fixes
Fix solidDB server version InfoSphere CDC for solidDB version
Interim Fix 21 6.5.0.14 Build 2013-12-19 -
Interim Fix 20 6.5.0.14 Build 2013-12-16 -
Interim Fix 19 6.5.0.14 Build 2013-11-15 -
Interim Fix 18 6.5.0.14 Build 2013-09-19 -
Fix Pack 14 6.5.0.14 Build 2013-08-03 6.5.0.14
Interim Fix 17 6.5.0.13 Build 2013-08-04 -
Interim Fix 16 6.5.0.13 Build 2013-07-02 -
Interim Fix 15 6.5.0.13 Build 2013-05-30 -
Interim Fix 14 6.5.0.13 Build 2013-04-20 -
Fix Pack 13 6.5.0.13 Build 2013-03-22 -
Interim Fix 13 6.5.0.12 Build 2013-01-05 -
Fix Pack 12 6.5.0.12 Build 2012-12-14 -
Interim Fix 12 6.5.0.11 Build 2012-10-18 -
Fix Pack 11 6.5.0.11 Build 2012-09-25 6.5.0.11
Interim Fix 11 6.5.0.10 Build 2012-09-04 -
Interim Fix 10 6.5.0.10 Build 2012-08-24 -
Interim Fix 9 6.5.0.10 Build 2012-07-03 -
Fix Pack 10 6.5.0.10 Build 2012-06-02 -
Interim Fix 8 6.5.0.9 Build 2012-04-23 -
Interim Fix 7 6.5.0.9 Build 2012-03-22 -
Fix Pack 9 6.5.0.9 Build 2012-02-29 -
Interim Fix 6 6.5.0.8 Build 2012-02-04 -
Interim Fix 5 6.5.0.8 Build 2012-01-17 -
Fix Pack 8 6.5.0.8 Build 2011-12-02 -
Interim Fix 4 6.5.0.7 Build 2011-09-30 -
Fix Pack 7 6.5.0.7 Build 2011-08-24 -
Fix Pack 6 6.5.0.6 Build 2011-05-30 -
Interim Fix 3 6.5.0.5 Build 2011-04-02 -
Fix Pack 5 6.5.0.5 Build 2011-03-01 -
Fix Pack 4 6.5.0.4 Build 2011-01-20 6.5.0.4
Interim fix 2 6.5.0.3 Build 2010-12-01 -
Fix Pack 3 6.5.0.3 Build 2010-10-04 -
Fix Pack 2 6.5.0.2 Build 0033 -
Fix Pack 1 6.5.0.1 Build 0017 -
Interim fix 1 6.5.0.0 Build 0012 -
GA 6.5.0.0 Build 0010 6.5.0.0



Interim Fix 21 (6.5.0.14 Build 2013-12-19)
Fix release date: 20 December 2013
Last modified: 20 December 2013
Status: Available

Download information
APAR Description
IC98451 SOLIDDB UNIVERSAL CACHE FAILS TO START MIRRORING WITH INTERIM
FIX 20 DUE TO FAILING LIMIT STATEMENT IN SYS_LOG SYSTEM TABLE



Interim Fix 20 (6.5.0.14 Build 2013-12-16)
Fix release date: 20 December 2013
Last modified: 20 December 2013
Status: Available

Download information
APAR Description
IC98359 ISSUING SQL STATEMENT SELECT * FROM SYS_LOG LIMIT 10 CAUSES ABNORMAL EXIT
IC98319 SOLIDDB SQL INTERPRETER MAY ABNORMALLY TERMINATE IN CERTAIN CASES WHEN ALIAS NAMES ARE NOT USED FOR COLUMN NAMES
IC97979 MICROSOFT ODBC DRIVER MANAGER LEAKS MEMORY WHEN USING SOLIDDB ODBC DRIVER
IC98394 FAILED MERGE OPERATION MAY LEAD TO AN ERROR MESSAGE "(10086) DELETED ROW NOT FOUND"
IC98397 INCREMENTATION OF SPARSE SEQUENCE IS NOT FLUSHED TO LOG FILE IFTHE OPERATION IS DONE IN SELECT STATEMENT



Interim Fix 19 (6.5.0.14 Build 2013-11-15)
Fix release date: 19 November 2013
Last modified: 21 November 2013
Status: Available

Download information
APAR Description
IC97660 CONNECTIONS BLOCK DURING SLOW I/O OPERATIONS
IC97545 UNIVERSAL CACHE: SIGNIFICANT LOAD ON NON-SUBSCRIBED TABLES HALTS REPLICATION ON LOW VOLUME SUBSCRIPTIONS
IC97551 CREATING AND DROPPING A PROCEDURE FAILS WITH ERROR CODE 23007 OR 23005




Interim Fix 18 (6.5.0.14 Build 2013-09-19)
Fix release date: 23 September 2013
Last modified: 25 September 2013
Status: Available

Download information
APAR Description
IC95878 Shutdown issued via solcon causes 30 second wait in server
IC96149 solidDB terminates abnormally when using START AFTER COMMIT statement in XA transaction
IC96150 Message lock is not released properly if user is thrown out during message processing




Fix Pack 14 (6.5.0.14 Build 2013-09-03)
Fix release date: 6 September 2013
Last modified: 06 September 2013
Status: Available

Download information
APAR Description
IC95202 JDBC connections take too long to timeout during prolonged shutdown
IC95620 Universal Cache: Latency information for solidDB unreliable in Management Console monitoring view





Interim Fix 17 (6.5.0.13 Build 2013-08-04)
Fix release date: 19 August 2013
Last modified: 21 August 2013
Status: Available

Download information
APAR Description
IC94837 Advanced replication REFRESH replicates some UNICODE characters incorrectly
IC94842 Cannot connect to database during simultaneous checkpoint and large I/O operation
IC94846 solsql V6.5 does not reports native error code as in V4.5
IC94847 RPC compression (-z option) does not work in HotStandby setups
IC94953 Server throttles after large number of role switches with pmon HSB log freespace valuet at 30000






Interim Fix 16 (6.5.0.13 Build 2013-07-02)
Fix release date: 8 July 2013
Last modified: 9 July 2013
Status: Available

Download information
APAR Description
IC93131 Creating large index suspends database connection requests
IC93785 HSB secondary contains duplicate rows after update
IC93794 Fetching INTEGER into SQL_C_DOUBLE returns incorrect size





Interim Fix 15 (6.5.0.13 Build 2013-05-30)
Fix release date: 7 June 2013
Last modified: 7 June 2013
Status: Available

Download information
APAR Description
IC92371 Performance degradation due to frequent and slow merge operations
IC92286 HSB connect fails due to logpos mismatch





Interim Fix 14 (6.5.0.13 Build 2013-04-20)
Fix release date: 30 April 2013
Last modified: 2 May 2013
Status: Available

Download information
APAR Description
IC91521 soldd fails to export some unique indexes properly
IC91619 Checkpoint times out causing emergency shutdown



Fix Pack 13 (6.5.0.13 Build 2013-03-22)
Fix release date: 28 March 2013
Last modified: 28 March 2013
Status: Available

Download information
APAR Description
IC87426 Exporting and importing WVARCHAR data in UTF8 mode gives wrong results
IC89798 soldd generates incomplete or incorrect SQL script
IC89799 HAC parameter Ere.RequiredPingFailures is ineffective
IC91005 Read committed isolation with D-tables gives false concurrency control error
IC91006 Server deadlocks after a false checkpoint completion
IC91009 Performance counter 'Lock count' does not record all updates




Interim Fix 13 (6.5.0.12 Build 2013-01-05)
Fix release date: 8 January 2013
Last modified: 09 January 2013
Status: Available

Download information
APAR Description
IC89381 Concurrent inserts fail with unique constraint violation due to false lock conflicts



Fix Pack 12 (6.5.0.12 Build 2012-12-14)
Fix release date: 20 December 2012
Last modified: 20 December 2012
Status: Available

Download information
APAR Description
IC88796 PROCEDURE CALL WITH OMITTED PARAMETERS CAUSES SOLIDDB TO SHUTDOWN WITH UNHANDLED EXCEPTION
IC86506 SETQUERYTIMEOUT() UNIT IS MILLISECOND WITH SMA, SECOND WITH TCP



Interim Fix 12 (6.5.0.11 Build 2012-10-18)
Fix release date: 23 October 2012
Last modified: 24 October 2012
Status: Available

Download information
APAR Description
IC87112 HSB role switch does not complete while executing transactions with BLOBS
IC87303 Numeric values use DOUBLE PRECISION with SUM() type functions




Fix Pack 11 (6.5.0.11 Build 2012-09-25)
Fix release date: 1 October 2012
Last modified: 5 October 2012
Status: Available

Download information
APAR Description
IC87015 Running solidDB with pmondiff causes out of central memory error with with emergency shutdown
IC86382 Infosphere CDC for solidDB shuts down with solidDB transaction timeout error 10026
IC86752 solidDB shuts down abnormally with faulty memory reference during HSB role switch




Interim Fix 11 (6.5.0.10 Build 2012-09-04)
Fix release date: 11 September 2012
Last modified: 20 September 2012
Status: Available

Download information
APAR Description
IC86469 Client does not receive posted events when SMA is used





Interim Fix 10 (6.5.0.10 Build 2012-08-24)
Fix release date: 3 September July 2012
Last modified: 5 September 2012
Status: Available

Download information
APAR Description
IC85238 Hotstandby primary server terminates abnormally on HSB connect
IC86049 Memory leak in JDBC driver when using solidDB in HSB configuration
IC86052 DROP CATALOG CASCADE fails with Error 13139: Catalog does not exist
IC86061 Performance bottleneck in findcolumn() method (solidDB JDBC Driver)



Interim Fix 9 (6.5.0.10 Build 2012-07-03)
Fix release date: 6 July 2012
Last modified: 11 July 2012
Status: Available

Download information
APAR Description
IC83913 SELECT from a view returns illegal column name error
IC84621 solidDB process terminates at srv_task_execdirect after abnormal client disconnect
IC85054 Executing EXPLAIN PLAN statements with SQL.AuditTrailEnabled=yes causes assert 474@TAB0AUDIT.C
IC85238 HotStandby primary server terminates abnormally on 'hsb connect'





Fix Pack 10 (6.5.0.10 Build 2012-06-02)
Fix release date: 4 June 2012
Last modified: 4 June 2012
Status: Available

Download information
APAR Description
IC75741 Splitting of long solid.ini lines into separate lines can cause problems in applications
IC76525 Dynamic parameter change can change commented lines in solid.ini file
IC83070 Tables with both VARBINARY and WVARCHAR data cannot be exported and imported with 6.5 FP9
IC83296 HSB connect fails with error 14708 after netcopy




Interim Fix 8 (6.5.0.9 Build 2012-04-23)
Fix release date: 26 April 2012
Last modified: 15 May 2012
Status: Available

Download information
APAR Description
IC83298 Statement memory released only when connection is reused or disconnected
IC82343 Duplicate primary key values returned after node shutdown followed by HSB catchup
IC82470 The solidDB ODBC Driver does not detect HSB role switch after certain stored procedure calls




Interim Fix 7 (6.5.0.9 Build 2012-03-22)
Fix release date: 29 March 2012
Last modified: 4 April 2012
Status: Available

Download information
APAR Description
IC82470 solidDB ODBC Driver does not detect HSB role switch after certain stored procedure calls
IC80333 SELECT DATABASE_ENCRYPTION_LEVEL() always returns 0 whether encryption is set or not
IC81313 Query with a "NOT EXISTS" subquery takes long time to execute
IC81315 Query optimizer problem with nested queries in solidDB 6.5.0.8




Fix Pack 9 (6.5.0.9 Build 2012-02-29)
Fix release date: 1 March 2012
Last modified: 1 March 2012
Status: Available

Download information
APAR Description
IC81724 HAC shuts down at 835@HAC0HSBLISTENER.C after an unexpected error
IC81372 Re-creation of table fails with ERROR 10005: UNIQUE CONSTRAINT (SYS_KEY_KEYS_NAMESCHEMACATALOG) VIOLATION





Interim Fix 6 (6.5.0.8 Build 2012-02-04)
Fix release date: 9 February 2012
Last modified: 9 February 2012
Status: Available

Download information
APAR Description
IC81116 NOW() with subsecond precision does not work in Windows
IC81118 HSB connect returns error 14525 after upgrade to 6.5 FP8
IC81244 Redundant WHERE condition can cause abnormal shutdown
IC81245 Memory footprint growth with diskless HSB in 1-safe mode





Interim Fix 5 (6.5.0.8 Build 2012-01-17)
Fix release date: 19 January 2012
Last modified: 19 January 2012
Status: Available

Download information

APAR Description
IC80851 TF connectivity is not working for non-administrator users
IC79509 SELECT DISTINCT with a 'NOT EXISTS' subquery does not finish in 6.5 FP7
IC79861 SELECT query using ROWNUM condition with a subquery causes abnormal shutdown
IC80050 SQL clause with the escape character in LIKE condition can return wrong results with unique indexes and M-tables
IC80361 Changing General.BackupFlushInterval dynamically corrupts memory



Fix Pack 8 (6.5.0.8 Build 2011-12-02)
Fix release date: 5 December 2011
Last modified: 7 December 2011
Status: Available

Download information

APAR Description
IC77019 solidDB Speed Loader (solload) hangs after reaching max error count
IC79650 solidDB Export (solexp) V6.5 does not convert binary data to hexadecimal format as required by solload
IC79791 Illegal RPC sequence in ODBC driver terminates the connection
IC79838 Calling sqlbindparameter can cause client shutdown if buffer length parameter is zero
IC80046 MERGE JOIN using ORDER BY DESC produces incorrectly ordered result set
IC80074 Security: stack consumption vulnerability in solidDB executable
IC80075 Security: denial of service vulnerability in solidDB executable
IC80076 Security: denial of service vulnerability in solidDB executable




Interim Fix 4 (6.5.0.7 Build 2011-09-30)
Fix release date: 28 October 2011
Last modified: 7 November 2011
Status: Available

Download information
APAR Description
IC78838 solidDB V6.5 asserts on AIX with failure on MME1INDEX.C or vtrie_search_atmost during a delete operation
IC78840 Performance degradation with InfoSphere CDC replication: solidDB log reader space manager free space decreases over time




Fix Pack 7 (6.5.0.7 Build 2011-08-24)
Fix release date: 30 August 2011
Last modified: 8 September 2011
Status: Available

Download information
APAR Description
IC78023 TF connection string combined with SMA library shuts down server
IC78024 HSB primary server exits with segmentation violation (segv)
solidDB server shuts down with assertion failure at 778@DBE7CTR.C
IC78026 SQL outer join combined with a constant expression can cause a server segmentation violation
IC78028 Solidconnection.rollback() method throws null pointer exception if connection is already closed
IC78221 Using sequencer objects does not always release memory
IC78223 Duplicate primary key values can be inserted simultaneously from concurrent connections
IC78298 Calling stored procedures in solidDB through WebSphere/JDBC returns incorrect number of rows



Fix Pack 6 (6.5.0.6 Build 2011-05-30)
Fix release date: 30 May 2011
Last modified: 7 June 2011
Status: Available

Download information

APAR Description
IC76002 Compilation of ODBC applications fail in MS Visual Studio GUI with linker errors
IC76219 solidDB 6.5 FP4 crashes under heavy load due to assertion failure in ssthrunref()
IC76377 Administrator and SQL guides do not provide unit values for the output of ADMIN COMMAND 'info'
IC76379 solidDB V6.5 FP5 asserts on AIX with failure on MME1INDEX.C
IC76680 Missing sample data causes bad query execution plan in secondary server


Interim Fix 3 (6.5.0.5 Build 2011-04-02)
Fix release date: 20 April 2011
Last modified: 7 June 2011
Status: Available

Download information

APAR Description
IC74875 solidDB 6.5 FP4 crashes inside ssthrunref() on AIX
IC74979 Getcolumns returns incorrect results in V6.5 FP4/FP5
IC75089 Application is unable to establish JDBC connection due to too many existing connections
IC75125 When 'hsb connect' fails, primary can incorrectly end up in primary uncertain state
IC75421 ADMIN COMMAND 'par -t" causes the server to abort




Fix Pack 5 (6.5.0.5 Build 2011-03-01)
Fix release date: 1 March 2011
Last modified: 10 March 2011
Status: Available

Download information

APAR Description
IC74471 Cannot set large cachesize values dynamically with solidDB 6.5 FP4
IC74564 Solid accepts listening names with TCP port numbers that are outof range (for example, listen=tcp 70000 on RHEL)
IC74609 Quick shutdown triggered by OS reboot might cause abnormal termination of solidDB
IC74612 Performance problem with multiple table joins on solidDB 6.5 versions up to FP4.





Fix Pack 4 (6.5.0.4 Build 2011-01-20)
Fix release date: 21 January 2011
Last modified: 10 March 2011
Status: Available

Download information

=====================================
6.5.0.4 Build 2011-01-20 - Fix Pack 4
=====================================

BUGS FIXED..: PMR 20252,140,702; PMR 30387,140,702; PMR 20194,140,702;
            : PMR 69583,756,000; PMR 92688,344,000; PMR 20198,140,702;
            : PMR 07611,SGC,724; PMR 80606,130,702; PMR 53198,49R,000;
            : PMR 35819,211,788; PMR 58050,130,702; PMR 35819,211,788;
            : PMR 52048,000,672; + 3 others
PLATFORMS...: a5x64, hia64, l2x, l2x64, s0xi64, s0x64, w32, w64
RELEASE DATE: 2011-01-20

FIXES
-----

Fix ID: PMR 20252,140,702
Description: solsql startup option -xonlyresults does not work as expected

Fix ID: PMR 30387,140,702
Description: solcon 'backup' behavior differs in Windows and Linux
    environments

Fix ID: PMR 20194,140,702
Description: solidDB reports a foreign key constraint violation when parent
    row in M-table is updated

Fix ID: PMR 69583,756,000
Description: Diskless HotStandby server crashes at netcopy

Fix ID: None
Description: SQLDescribeCol incorrectly sets SQL_NO_NULLS flag instead of
    SQL_NULLABLE for columns produced by queries containing JOIN operation.

Fix ID: PMR 92688,344,000; PMR 20198,140,702
Description: Query takes a long time due to bad EXPLAIN PLAN

Fix ID: PMR 07611,SGC,724
Description: Statement execution does not stop even if client is terminated

Fix ID: PMR 80606,130,702
Description: Server hangs or takes too long to shut down after multiple
    login failures

Fix ID: PMR 53198,49R,000
Description: Repetitive calls to 'hsb connect' result in memory growth,
    causing server to fail with an 'out of central memory' error

Fix ID: PMR 35819,211,788
Description: SQL error code class values are documented incorrectly in
    Programmer Guide

Fix ID: PMR 58050,130,702
Description: ODBC C typedef is documented incorrectly in Programmer Guide
    (SQLINTEGER should correspond to 'int', not 'long int')

Fix ID: None
Description: Transactions committed after the last checkpoint are lost if
    relaxed durability is used

Fix ID: PMR 35819,211,788
Description: SQLExecute returns SQL_SUCCESS_WITH_INFO when SQL_ERROR is
    expected

Fix ID: None
Description: SQL function now(3) does not return timestamp with millisecond
    resolution

Fix ID: PMR 52048,000,672
Description: ODBC TC reprepared statement execution causes crash (prepinf
    == NULL)



Interim Fix 2 (6.5.0.3 Build 2010-12-01)
Fix release date: 1 December 2010
Last modified: 10 March 2011
Status: Available

Download information

========================================
6.5.0.3 Build 2010-12-01 - Interim Fix 2
========================================

BUGS FIXED..: PMR 30090,140,702; PMR 25094,077,649; PMR 07244,49R,000;
            : PMR 57968,130,702; PMR 14486,344,000; PMR 07424,SGC,724
            : + 3 others
PLATFORMS...: l2x, l2x64, w32, w64
RELEASE DATE: 2010-12-01

FIXES
-----

Fix ID: PMR 30090,140,702
Description: Conversion from 4.x to 6.x can cause B-tree index path errors,
    resulting in invalid data ranges in leaf pages. Fix can be applied by
    starting server with -xautofix startup option.

Fix ID: PMR 25094,077,649
Description: Redundant Widget definition in solidodbc3.h conflicts with X11
    definition, causing compilation error

Fix ID: PMR 07244,49R,000
Description: -xreorganize does not shrink the database properly

Fix ID: None
Description: HSB netcopy fails because final file flush takes too long to
    complete

Fix ID: PMR 57978,130,702
Description: Redundant ssstacltrace.c code in client library causes linking
    failure

Fix ID: PMR 57968,130,702
Description: Create table with a default value for varchar column fails if
    length of the default value exceeds 255 characters.

Fix ID: PMR 14486,344,000
Description: Conversion of V4.x database to V6.x fails due to bnode
    conversion problems

Fix ID: PMR 07424,SGC,724
Description: Referential key actions like ON DELETE CASCADE are not
    disabled during replica refresh, causing loss of data

Fix ID: PMR 30090,140,702
Description: Conversion of V4.x database to V6.x fails

Fix ID: None
Description: BatchUpdateException is not handled by switchover handling
    code

Fix ID: None
Description: JDBC driver with TF does not recover after second failover




Fix Pack 3 (6.5.0.3 Build 2010-10-04)
Fix release date: 4 October 2010
Last modified: 10 March 2011
Status: Available

Download information

=====================================
6.5.0.3 Build 2010-10-04 - Fix Pack 3
=====================================

BUGS FIXED..: PMR 35560,211,788; PMR 80562,130,702; PMR 70173,SGC,724;
            : PMR 00946,097,866; PMR 07393,SGC,724; PMR 54403,49R,000;
            : PMR 04455,999,000 + 7 others
PLATFORMS...: a5x64, hia64, l2x, l2x64, s0xi64, s0x64, w32, w64  
RELEASE DATE: 2010-10-04

*************************************************************************
NOTE: The build number format has changed from a consecutive build number
      (6.5.0.2 Build 0033) to the build date (6.5.0.3 Build 2010-10-04).
*************************************************************************

FIXES
-----

Fix ID: None
Description: Security vulnerability with modified login RPC message

Fix ID: None
Description: solsql crashes if startup command line contains a parameter
    marker

Fix ID: PMR 35560,211,788
Description: HotStandby server crashes due to defective logging routines
    that cause memory corruption

Fix ID: None
Description: solidDB relaxed logging performance enhancement when single
    disk is used for transaction log files and database files

Fix ID: PMR 80562,130,702
Description: SQLPutData() function fails to pass dynamic string parameter
    for numeric columns if data length exceeds column length (right
    truncation)

Fix ID: None
Description: Incorrect disconnect flag causes waiting connection to
    malfunction with TC/TF

Fix ID: None
Description: soldd does not export catalog and database objects if the
    catalog name contains a hyphen (-)

Fix ID: None
Description: EXPLAIN PLAN FOR syntax returns inconsistent results when run
    more than once for the same query.

Fix ID: PMR 70173,SGC,724
Description: Killing master during a publication refresh causes replica to
    lock the message name infinitely in the following refresh call

Fix ID: PMR 00946,097,866
Description: SQLDescribeParam returns 0 decimal digits for TIMESTAMP
    parameter type

Fix ID: PMR 07393,SGC,724
Description: solidDB stores large integer literals incorrectly when
    SQL.DecFloatPrecision16=Yes

Fix ID: PMR 54403,49R,000
Description: Secondary server does not output to solmsg.out that connection
    to the primary is broken

Fix ID: PMR 04455,999,000
Description: HotStandby.MaxLogSize defaults to 0 with a warning

Fix ID: None
Description: Diskless accelerator crashes when 'HSB netcopy' is issued




Fix Pack 2 (6.5.0.2 Build 0033)
Fix release date: 2 July 2010
Last modified: 10 March 2011
Status: Available

Download information

===============================
6.5.0.2 Build 0033 - Fix Pack 2
===============================

BUGS FIXED..: PMR 92688,344,000; PMR 20201,140,702; PMR 66956,077,649;
            : PMR 00943,097,866; PMR 20174,140,802; PMR 45630,999,649;
            : PMR 20191,140,702; PMR 04499,140,702; PMR 02926,999,000;
            : + 11 others
PLATFORMS...: a5x64, hia64, l2x, l2x64, s0xi64, s0x64, w32, w64
RELEASE DATE: 2010-07-02

FIXES
-----

Fix ID: None
Description: Creating a child process for a start-up script takes too long

Fix ID: None
Description: The documented factory value for client-side connection (RPC
    read) timeout varies - it is either 60 seconds (60 000 ms) or 0
    (infinite). Documentation updated to state 0 - infinite (operating
    system default applies).

Fix ID: PMR 92688,344,000
Description: Explicit explain plan for select stmt causes a crash if trace
    on estplans has also been turned on.

Fix ID: None
Description: Cannot reference a sequence in a procedure if the sequence has
    been droppped and recreated within the stored procedure

Fix ID: PMR 20201,140,702
Description: Unicode ODBC driver causes a crash when trying to connect with
    a wrong password

Fix ID: None
Description: New rval can be inserted into an empty page

Fix ID: PMR 66956,077,649
Description: Secondary server role change notifications are not delivered
    to TF ODBC clients.

Fix ID: None
Description: HSB secondary crash

Fix ID: None
Description: Date time function 'EXTRACT (date field FROM date_exp)' does
    not work correctly (syntax error)

Fix ID: PMR 00943,097,866
Description: Rounding errors when inserting multiple DECIMAL columns via
    ODBC in Unicode databases

Fix ID: PMR 20174,140,802
Description: No error message in solmsg.out when maximum number of external
    sorter files is reached

Fix ID: None
Description: ADMIN COMMAND 'status backup' output is incorrect

Fix ID: PMR 45630,999,649
Description: TF1 connections fail in the case of primary network connection
    or power failure

Fix ID: PMR 20191,140,702
Description: solsql -h does not display options -S<Schema name> and -
    C<catalog name

Fix ID: None
Description: ADMIN COMMAND 'perfmon -r' - output truncated

Fix ID: PMR 04499,140,702
Description: sequence.NEXT value is not returned when used in an INSERT
    INTO..SELECT statement

Fix ID: None
Description: Transaction started on primary keeps allocation transaction
    ids after switch to secondary

Fix ID: None
Description: Printouts of machine id information for JDBC connections do
    not contain IP address

Fix ID: PMR 02926,999,000
Description: Memory allocation failure due to too large BackupBlockSize
    value causes assertion

Fix ID: None
Description: When Secondary executor tries to insert duplicate value, the
    error is not handled properly.




Fix Pack 1 (6.5.0.1 Build 0017)
Fix release date: 7 April 2010
Last modified: 10 March 2011
Status: Available

Download information

===============================
6.5.0.1 Build 0017 - Fix Pack 1
===============================

BUGS FIXED..: PMR 04229,140,702; PMR 20172,140,702; PMR 35029,211,788;
            : PMR 08727,035,724; PMR 66956,077,649; PMR 20166,140,702;
            : PMR 07147,SGC,724; PMR 35015,211,788; PMR 07986,035,724;
            : PMR 07968,035,724; PMR 07033,SGC,724; PMR 64402,003,756;
            : PMR 79153,999,000 + 6 others
PLATFORMS...: a5x64, hia64, l2x, l2x64, s0xi64, s0x64, w32, w64
RELEASE DATE: 2010-04-07

FIXES
-----

Fix ID: None
Description: HSB secondary crashes

Fix ID: None
Description: Erroneous duplicate key violation reported

Fix ID: PMR 04229,140,702
Description: SQLConnect does not wait for SQL_ATTR_LOGIN_TIMEOUT to expire

Fix ID: None
Description: solexp goes down with an unhandled exception when giving an
    incomplete startup option (solexp -x)

Fix ID: None
Description: Foreign key cascading delete causes a duplicate delete error

Fix ID: None
Description: Ping test with command option -p1 does not output results into
    the soltrace.out file.

Fix ID: PMR 20172,140,702; 35029,211,788; 08727,035,724
Description: HSB checkpoint durable list grows.

Fix ID: PMR 35029,211,788
Description: Checkpoint causes delays in writing.

Fix ID: PMR 66956,077,649
Description: Erroneous TF1 exception on switch over (primary key constraint
    violation with Transaction Failover level CONNECTION)

Fix ID: PMR 20166,140,702
Description: solidDB ignores error in case open() system call fails.

Fix ID: PMR 07147,SGC,724
Description: Extra connects and disconnects in HSB secondary (SOLID Table
    Error 13093: Event SYS_EVENT_HSBSTATESWITCH does not exist)

Fix ID: PMR 35015,211,788
Description: solidDB Export (solexp) command option -x pwdfile does not
    work; error 'memory fault' returned.

Fix ID: None
Description: Checkpoint gets broken: illegal mme page address in page
    directory.

Fix ID: PMR 07986,035,724; PMR 07968,035,724
Description: solid_schema value specified within a JDBC connection string
    is lost if HSB is switched twice.

Fix ID: PMR 07033,SGC,724
Description: ODBC driver does not report a error or warning for data
    truncation on INSERT or UPDATE.

Fix ID: None
Description: Wrong result in SQL join or order query: SQL query estimator
    gives wrong ordering info for M-tables in some cases.

Fix ID: PMR 64402,003,756
Description: Splitting nodes during a checkpoint can cause the server to
    hang

Fix ID: PMR 79153,999,000
Description: With SMA, ADMIN COMMAND 'hsb status copy' always returns
    active after successful completion of ADMIN COMMAND 'hsb netcopy'.

Fix ID: None
Description: 'ADMIN COMMAND trace' output is incomplete; trace message is
    not included.




Interim Fix 1 (6.5.0.0 Build 0012)
Fix release date: 6 February 2010
Last modified: 10 March 2011
Status: Available

Download information

==================================
6.5.0.0 Build 0012 - Interim fix 1
==================================

BUGS FIXED..:     PMR 03973,140,702; PMR 07016,SGC,724; PMR 20161,140,702;
            :     PMR 20158,140,702; PMR 26621,49R,000; PMR 20151,140,702;
            :     PMR 20138,140,702; PMR 20140,140,702; PMR 03735,140,702;
            :     PMR 20142,140,702; PMR 00836,000,672; PMR 20131,140,702;
            :     PMR 01304,999,749 + 7 others
PLATFORMS...: w32, w64, a5x64, l2x, l2x64, s0x64, s0xi64
RELEASE DATE: 2010-02-06

FIXES
-----

Fix ID: PMR 03973,140,702; PMR 07016,SGC,724
Description: Numeric literal to SQL BINARY data type conversion semantics
    changed between version.

Fix ID: PMR 20161,140,702
Description: Server fails to start with a large IndexFile.CacheSize.

Fix ID: PMR 20163,140,702
Description: Access rights to solmsg.out file are stricter than active
    umask allows. solidDB creates solmsg.out with read/write enabled only
    for the owner, even if active umask setting allowed group or world
    access.

Fix ID: None
Description: solidDB chooses the wrong index for the execution of a query.

Fix ID: None
Description: Server crash.

Fix ID: PMR 20158,140,702
Description: SELECT statement causes a crash.

Fix ID: None
Description: HAC sample: wrong connect string in HSB status query

Fix ID: PMR 26621,49R,000
Description: Error message formatting error: error message was displayed
    when log file deletion had a formatting error.

Fix ID: None
Description: New SQL syntax introduced SET SEQUENCE <name> VALUE <bigint
    value> because sequence value could not be set through SQL; only
    procedure syntax EXEC SEQUENCE <name> SET VALUE was available.

Fix ID: None
Description: Stored procedure returns wrong error code in a deadlock
    situation. Instead of "SOLID Database Error 10031: Transaction detected
    a deadlock, transaction is rolled back" message, solidDB issues "SOLID
    SQL Error 0:".

Fix ID: None
Description: solidDB goes down with an unhandled exception, without assert
    message.

Fix ID: None
Description: TRUNCATE TABLE leaves temporary table as garbage if truncate
    fails to delete the table.

Fix ID: PMR 20151,140,702
Description: SQLDriverConnect does not handle login timeout properly.

Fix ID: PMR 20138,140,702
Description: SELECT MAX() returns wrong value when statement is re-
    executed.

Fix ID: PMR 20140,140,702
Description: In some cases server incorrectly outputs unrequested SQLInfo
    output.

Fix ID: PMR 56833,999,760
Description: RPC counter overflow: RPC counter mismatch on 64-bit systems
    when reaching the value 2^31.

Fix ID: None
Description: soldd exports sequence values incorrectly if the current value
    is greater than maximum allowed for INT.

Fix ID: PMR 03735,140,702
Description: HSB connection is handled incorrectly.

Fix ID: PMR 20142,140,702
Description: Specifying interface in listen string corrupts solid.ini: a
    listen string that listens on multiple interfaces using the same port
    number can cause solid.ini corruption.



Change history

  • 25 September 2013: Interim Fix 18 added.
  • 6 September 2013: Fix Pack 14 added.
  • 21 August: APAR IC94953 added to fixes included in Interim Fix 17.
  • 19 August: Interim Fix 17 added.
  • 9 July 2013: Interim Fix 16 added.
  • 7 June 2013: Interim Fix 15 added.
  • 2 May 2013: Interim Fix 14 added.
  • 28 March 2013: Fix Pack 13 added.
  • 9 January 2013: Interim Fix 13 added.
  • 20 December 2012: Fix Pack 12 added.
  • 24 October: Interim Fix 12 added.
  • 5 October 2012: APAR IC87015 added to fixes included in Fix Pack 11.
  • 2 October 2012: Fix Pack 11 added.
  • 20 September 2012: Interim Fix 11 added.
  • 5 September 2012: Interim Fix 10 added.
  • 11 July 2012: Interim Fix 9 added.
  • 4 June 2012: Fix Pack 10 added.
  • 15 May 2012: APAR IC83298 added to fixes included in Interim Fix 8.
  • 26 April 2012: Interim Fix 8 added.
  • 4 April 2012: Interim Fix 7 added.
  • 2 March 2012: Fix Pack 9 added.
  • 9 February 2012: Interim Fix 6 added.
  • 19 January 2012: Interim Fix 5 added.
  • 7 December 2011: Fix Pack 8 added.
  • 7 November 2011: Interim Fix 4 added.
  • 8 September 2011: APAR IC78025 added to fixes included in Fix Pack 7.
  • 30 August 2011: Fix Pack 7 added.
  • 8 June 2011: Fix Pack 6 added.
  • 10 March 2011: Created fix list page.

Related information

Fix packs by solidDB version
Release Notes V6.5

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM solidDB

Software version:

6.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

7021052

Modified date:

2013-12-20

Translate my page

Machine Translation

Content navigation