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

• Interim Fix 14
• Fix pack 13
• Interim Fix 13
• Fix pack 12
• Interim Fix 12
• Fix pack 11
• Interim Fix 11
• Interim Fix 10
• Interim Fix 9
• Fix pack 10
• Interim Fix 8
• Interim Fix 7
• Fix pack 9
• Interim Fix 6
• Interim Fix 5
• Fix Pack 8
• Interim Fix 4
• Fix Pack 7
• Fix Pack 6
• Interim Fix 3
• Fix Pack 5
• Fix Pack 4
• Interim Fix 2
• Fix Pack 3
• Fix Pack 2
• Fix Pack 1
• Interim Fix 1

---

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 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

---

Fix Pack 13 (6.5.0.13 Build 2013-03-22)
Fix release date: 30 April 2013 Last modified: 2 May 2013 Status: Available Download information	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

APAR	Description
IC78023	TF connection string combined with SMA library shuts down server
IC78024	HSB primary server exits with segmentation violation (segv)
IC78025	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	Back to Top

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	Back to Top

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	Back to Top

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	Back to Top

=====================================
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	Back to Top

========================================
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	Back to Top

=====================================
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	Back to Top

===============================
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	Back to Top

===============================
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	Back to Top

==================================
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

• 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.