Fix list for IBM solidDB V7.0

Product documentation


Abstract

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

Content

  • Fix Pack 9
  • Fix Pack 8
  • Interim Fix 12
  • Interim Fix 11
  • Fix Pack 7
  • Interim Fix 10
  • Fix Pack 6
  • 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
    Fix Pack 9 7.0.0.9 Build 2014-02-07 -
    Fix Pack 8 7.0.0.8 Build 2013-12-06 -
    Interim Fix 12 7.0.0.7 Build 2013-11-02 -
    Interim Fix 11 7.0.0.7 Build 2013-10-24 -
    Fix Pack 7 7.0.0.7 Build 2013-08-27 -
    Interim Fix 10 7.0.0.6 Build 2013-08-13 -
    Fix Pack 6 7.0.0.6 Build 2013-05-28 7.0.0.6 Build 2013-05-28
    Interim Fix 9 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



    Fix Pack 9 (7.0.0.9 Build 2014-02-07)
    Fix release date: 11 February 2014
    Last modified: 11 February 2014
    Status: Available

    Download information
    APAR Description
    IC99227 SOLIDDB MAY ABNORMALLY TERMINATE IF ADVANCED REPLICATION IS BEING USED CONCURRENTLY WITH HOTSTANDBY ROLESWITCH AND NETCOPY
    IC99161 ADMIN COMMAND 'REPORT' MAY CAUSE DELAYS TO OTHER OPERATIONS WHEN SOLIDDB HAS VERY LARGE MEMORY FOOTPRINT.
    IC99159 IN CERTAIN CONDITIONS SOLIDDB MAY FAIL WITH ERROR (10086) DELETED ROW NOT FOUND
    IC98994 CHANGE OF EXECUTION PLAN MAY CAUSE ABNORMAL PROGRAM TERMINATION IN SQL RE-EXECUTE WHEN USING SOLIDDB LINKED LIBRARY ACCESS
    IC98995 ADVANCED REPLICATION WITH MULTIPLE CONNECTIONS MAY REPORT "CONNECTION BROKEN" AFTER HOT-STANDBY CONNECTION SWITCH.
    IC98993 CONNECTIONS BLOCK DURING SLOW I/O OPERATIONS
    IC97628 IMDBMEMORYLIMIT RELATED PARAMETERS WORK INCORRECTLY DUE TO THE INCORRECT CALCULATION OF IMDBSIZE
    IC98603 SYS_LOG SYSTEM VIRTUAL TABLE ONLY ALLOWS LIMITED SQL SYNTAX TO BE USED AND MAY ABNORMALLY TERMINATE IF UNSUPPORTED SQL IS USED
    IC98605 SOLIDDB SQL INTERPRETER MAY ABNORMALLY TERMINATE IN CERTAIN CASES WHEN ALIAS NAMES ARE NOT USED FOR COLUMN NAMES



    Fix Pack 8 (7.0.0.8 Build 2013-12-06)
    Fix release date: 10 December 2013
    Last modified: 10 December 2013
    Status: Available

    Download information
    APAR Description
    IC95152 PERFORMANCE ISSUES USING MMAP IN-MEMORY PAGE ALLOCATOR IN AIX
    IC98229 SOLIDDB MAY ABNORMALLY TERMINATE IN CERTAIN SQL STATEMENT
    RE-EXECUTE AND RE-OPTIMIZE CASES
    IC98226 FAILED MERGE OPERATION MAY LEAD TO AN ERROR MESSAGE "(10086)
    DELETED ROW NOT FOUND"
    IC97981 MICROSOFT ODBC DRIVER MANAGER LEAKS MEMORY WHEN USING SOLIDDB
    ODBC DRIVER
    IC98142 SOLIDDB HIGH AVAILABILITY CONTROLLER MAY TERMINATE ABNORMALLY
    DURING SHUTDOWN.
    IC98069 IN CERTAIN SCENARIOS XA TRANSACTION MAY CAUSE A SIGSEGV





    Interim Fix 12 (7.0.0.7 Build 2013-11-02)
    Fix release date: 7 November 2013
    Last modified: 8 November 2013
    Status: Available

    Download information
    APAR Description
    IC97481 CONCURRENT INSERTS TO ROWS WITH ADJACENT PRIMARY KEYS CAUSE SERVER SHUTDOWN





    Interim Fix 11 (7.0.0.7 Build 2013-10-24)
    Fix release date: 28 October 2013
    Last modified: 30 October 2013
    Status: Available

    Download information
    APAR Description
    IC96995 Transaction log in not flushed to disk within the time speficied by Logging.RelaxedMaxDelay parameter
    IC95777 solidDB terminates abnormally when using START AFTER COMMIT statement in XA transaction
    IC95997 Segmentation fault in dbe_trx_ishsbcommitsent when shutting down primary server
    IC96786 Cannot start server on Solaris if IP address (-i) is specified in Com.Listen
    IC97149 Server cannot start when database is over 2 GB on Windows 32-BIT
    IC97153 Secondary fails when netcopy starts during high workload
    IC97154 Universal Cache: significant load on non-subscribed tables halts replication on low volume subscriptions




    Fix Pack 7 (7.0.0.7 Build 2013-08-27)
    Fix release date: 30 August 2013
    Last modified: 02 September 2013
    Status: Available

    Download information
    APAR Description
    IC95080 JDBC connections take too long to timeout during prolonged shutdown
    IC95203 RPC compression (-z option) does not work in hotstandby netcopy connections
    IC95539 Message lock is not released properly if user is thrown out during message processing




    Interim Fix 10 (7.0.0.6 Build 2013-08-13)
    Fix release date: 19 August 2013
    Last modified: 19 August 2013
    Status: Available

    Download information
    APAR Description
    IC92909 ODBC driver does not return SQL_NEED_DATA from SQLEXECUTE with multirow binding
    IC93961 Fetching INTEGER into SQL_C_DOUBLE returns incorrect size
    IC94838 Advanced replication REFRESH replicates some UNICODE characters incorrectly
    IC94841 solidDB terminates abnormally in MME search routines under high load using multiple threads
    IC94848 Cannot connect to database during simultaneous checkpoint and large I/O operation
    IC94882 User-specified callback (sscsetnotifier) is not called in case of ADMIN COMMAND 'shutdown force'
    IC94884 Performance degradation with partial deletes in D-tables




    Fix Pack 6 (7.0.0.6 Build 2013-05-28)
    Fix release date: 3 June 2013
    Last modified: 3 June 2013
    Status: Available

    Download information
    APAR Description
    IC92283 Logging uses uncontrolled amount of memory for write queue items
    IC92372 Performance degradation due to frequent and slow merge operations
    IC92628 Universal Cache: dmimportconfiguration fails due to timeout



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

    • 8 November 2013: Added Interim Fix 12.
    • 30 October 2013: Added missing APAR IC96995 to Interim Fix 11.
    • 28 October 2013: Added Interim Fix 11.
    • 2 August 2013: Added Fix Pack 7.
    • 19 August 2013: Added Interim Fix 10.
    • 3 June 2013: Added Fix Pack 6.
    • 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.

    Rate this page:

    (0 users)Average rating

    Add comments

    Document information


    More support for:

    IBM solidDB

    Software version:

    7.0

    Operating system(s):

    AIX, HP-UX, Linux, Solaris, Windows

    Reference #:

    7023966

    Modified date:

    2014-02-13

    Translate my page

    Machine Translation

    Content navigation