Fix list for IBM solidDB V7.0

Interim Fix 9

Interim Fix 8

Fix Pack 5

Interim Fix 7

Fix Pack 4

Interim Fix 6

Interim Fix 5

Fix Pack 3

Interim Fix 4

Interim Fix 3

Interim Fix 2

Fix Pack 2

Interim Fix 1

Fix Pack 1

---

IBM solidDB server and InfoSphre CDC for solidDB versions for fix packs and interim fixes

Fix	solidDB server version	InfoSphere CDC for solidDB version
Interim Fix 8	7.0.0.5 Build 2013-05-04	-
Interim Fix 8	7.0.0.5 Build 2013-04-21	-
Fix Pack 5	7.0.0.5 Build 2013-02-19	-
Interim Fix 7	7.0.0.4 Build 2012-12-23	-
Fix Pack 4	7.0.0.4 Build 2012-12-01	-
Interim Fix 6	7.0.0.3 Build 2012-10-03	-
Interim Fix 5	7.0.0.3 Build 2012-09-15	-
Fix Pack 3	7.0.0.3 Build 2012-08-23	-
Interim Fix 4	-	7.0.0.2 Build 2012-08-08
Interim Fix 3	7.0.0.2 Build 2012-06-28	-
Interim Fix 2	7.0.0.2 Build 2012-06-09	-
Fix Pack 2	7.0.0.2 Build 2012-04-20	-
Interim Fix 1	7.0.0.1 Build 2012-02-29	-
Fix Pack 1	7.0.0.1 Build 2012-01-28	-
GA	7.0.0.0 Build 2011-10-14	7.0.0.0 Build 2011-10-14

---

Interim Fix 9 (7.0.0.5 Build 2013-05-04)
Fix release date: 14 May 2013 Last modified: 16 May 2013 Status: Available Download information	Back to Top

APAR	Description
IC92078	LIBSOLODBC.SO linking problem causes abnormal shutdown of JRE

---

Interim Fix 8 (7.0.0.5 Build 2013-04-21)
Fix release date: 30 April 2013 Last modified: 02 May 2013 Status: Available Download information	Back to Top

APAR	Description
IC91004	solidDB Data Dictionary (soldd) generates incomplete or incorrect SQL script
IC91007	Server deadlocks after a false checkpoint completion
IC91008	Read committed isolation with D-tables gives false concurrency control error
IC91448	Exporting and importing WVARCHAR data in UTF8 mode gives wrong results
IC91818	solidDB Data Dictionary (soldd) fails to export some unique indexes properly

---

Fix Pack 5 (7.0.0.5 Build 2013-02-19)
Fix release date: 4 March 2013 Last modified: 04 March 2013 Status: Available Download information	Back to Top

APAR	Description
IC90206	Concurrent inserts fail with unique constraint violation due to false lock conflicts
IC90207	HAC parameter ERE.RequiredPingFailures is ineffective

---

Interim Fix 7 (7.0.0.4 Build 2012-12-23)
Fix release date: 2 January 2013 Last modified: 02 January 2013 Status: Available Download information	Back to Top

APAR	Description
IC89283	Latency issues with increased update loads

---

Fix Pack 4 (7.0.0.4 Build 2012-12-01)
Fix release date: 5 December 2012 Last modified: 10 April 2013 Status: Available Download information	Back to Top

APAR	Description
IC87223	Server sometimes terminates abnormally when using GSKIT for database encryption
IC88015	DELETE statement causes shutdown with unhandled exception when using incremental refreshes
IC88017	Numeric values use DOUBLE PRECISION with SUM() type functions
IC88018	solidDB 7.0.0.3 terminates abnormally if INSERT operation via SA interface causes primary key unique constraint violation
IC88795	Setquerytimeout() unit is millisecond with SMA, second with TCP
IC88797	Procedure call with omitted parameters causes solidDB to shut down with unhandled exception
IC88491	MESSAGE <NAME> FORWARD returns communication link failure 21308

---

Interim Fix 6 (7.0.0.3 Build 2012-10-03)
Fix release date: 9 October 2012 Last modified: 10 October 2012 Status: Available Download information	Back to Top

APAR	Description
IC87084	Running solidDB with pmondiff causes out of central memory error with emergency shutdown
IC87085	solidDB shuts down abnormally with faulty memory reference during HSB role switch

---

Interim Fix 5 (7.0.0.3 Build 2012-09-15)
Fix release date: 20 September 2012 Last modified: 21 September 2012 Status: Available Download information	Back to Top

APAR	Description
IC86625	solidDB terminates abnormally with 'out of cache blocks' on -xreorganize
IC86654	Diskless secondary server shuts down abnormally on netcopy

---

Fix Pack 3 (7.0.0.3 Build 2012-08-23)
Fix release date: 31 August 2012 Last modified: 03 September 2012 Status: Available Download information	Back to Top

APAR	Description
IC84901	solidDB terminates abnormally inside backup_writer_thr if backup failed with error 11001 (file write failure)
IC85242	Queries with 'IN' subquery produce incorrect results in 7.0 Interim Fix 3
IC86051	DROP CATALOG CASCADE fails with Error 13139: Catalog does not exist
IC86057	Memory leak in JDBC driver when using solidDB in HSB configuration
IC86063	Performance bottleneck in findcolumn() method (solidDB JDBC Driver)

---

Interim Fix 4 (7.0.0.2 Build 2012-08-28)
Fix release date: 20 August 2012 Last modified: 20 August 2012 Status: Available Download information	Back to Top

APAR	Description
IC81950	Universal Cache: After HSB role switch, first insert operation into solidDB (source) is not replicated to DB2 (target)
IC83071	Infosphere CDC for solidDB shuts down with solidDB transaction timeout error 10026

---

Interim Fix 3 (7.0.0.2 Build 2012-06-28)
Fix release date: 6 July 2012 Last modified: 11 July 2012 Status: Available Download information	Back to Top

APAR	Description
IC84624	solidDB process terminates at srv_task_execdirect after abnormal client disconnect
IC84866	Executing EXPLAIN PLAN statements with SQL.AuditTrailEnabled=yes causes assert 474@TAB0AUDIT.C
IC85057	Database reorganization does not reduce database size
IC85058	TC connections: rollback not always executed on both nodes
IC85059	Infinite wait with ODBC connections when using HotStandby and diskless server

---

Interim Fix 2 (7.0.0.2 Build 2012-06-09)
Fix release date: 11 June 2012 Last modified: 12 June 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
IC83065	Looped backup operation causes abnormal termination of solidDB 7.0 FP1 and FP2
IC83912	SELECT FROM VIEW returns illegal column name error
IC83960	Tables with both VARBINARY and WVARCHAR data cannot be exported and imported

---

Fix Pack 2 (7.0.0.2 Build 2012-04-20)
Fix release date: 26 April 2012 Last modified: 26 April 2012 Status: Available Download information	Back to Top

APAR	Description
IC82050	SELECT DATABASE_ENCRYPTION_LEVEL() always returns 0 whether encryption is set or not
IC82051	Query optimizer problem with nested queries in solidDB 7.0
IC82052	Memory footprint growth with diskless HSB in 1-SAFE mode
IC82342	Query with a "NOT EXISTS" subquery takes long time to execute

---

Interim Fix 1 (7.0.0.1 Build 2012-02-29)
Fix release date: 8 March 2012 Last modified: 09 March 2012 Status: Available Download information	Back to Top

APAR	Description
IC81371	NOW() with subsecond precision does not work in Windows
IC81505	Re-creation of table fails with error 10005: unique constraint (SYS_KEY_KEYS_NAMESCHEMACATALOG) violation
IC81808	SQL function TO_CHAR causes memory growth

---

Fix Pack 1 (7.0.0.1 Build 2012-01-28)
Fix release date: 31 January 2012 Last modified: 01 February 2012 Status: Available Download information	Back to Top

APAR	Description
IC81078	Redundant WHERE condition can cause abnormal shutdown
IC80674	SQL clause with the escape character in LIKE condition can return wrong results with unique indexes and M-tables
IC80675	SELECT query using rownum condition with a subquery causes abnormal shutdown
IC80677	solidDB Speed Loader (solload) hangs after reaching max error count
IC80678	MERGE JOIN using ORDER BY DESC produces incorrectly ordered result set
IC80679	Illegal RPC sequence in ODBC driver terminates the connection
IC81012	solidDB export (solexp) does not convert binary data to hexadecimal format as required by solidDB Speed Loader (solload)

Change history

• 16 May 2013: Added Interim Fix 9.
• 2 May 2013: Added Interim Fix 8.
• 10 April 2013: Added missing APAR IC88491 to Fix Pack 4.
• 4 March 2013: Added Fix Pack 5.
• 2 January 2013: Added Interim Fix 7.
• 7 December 2012: Added Fix Pack 4.
• 10 October 2012: Added Interim Fix 6.
• 21 September 2012: Added Interim Fix 5.
• 3 September 2012: Added Fix Pack 3.
• 20 August 2012: Added Interim Fix 4.
• 11 July 2012: Added Interim Fix 3.
• 12 June 2012: Added Interim Fix 2.
• 26 April 2012: Added Fix Pack 2.
• 8 March 2012: Added Interim Fix 1.
• 1 February 2012: Created fix list page.