Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:690097

CR Number:   690097 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 06 Dec 2011 Fixed Description Support for binary and varbinary datatypes in Java UDF resultsets and proxy tables was missing for sizes > 255 bytes. It has now been added. Target Version  15.4 e01

CR:690218

CR Number:   690218 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When a partitioned table resides on online and offline dbspaces, data of the table can not be accessed, if any data/index/partition of the table resides on the OFFLINE dbspace. Also, sp_iqcheckdb doesn't check partitioned table with OFFLINE dbspaces. To create indexes on a partitioned table, all dbspaces have to be online.

CR:690233

CR Number:   690233 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Unable to effectively use TDS client packet sizes greater than 4096(max actually accepted by IQ is 7300). So for example is you tried connecting with isql -Udba -Psql -Smyserver -A8192 the select connection_property ('PacketSize') will shows 7300. If you then try send a client packet that is 8192 in size this causes CT-LIBRARY error: ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect Workaround Description  do not exceed max TDS packet size of 4096

CR:690299

CR Number:   690299 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2013 Fixed Description On a machine under heavy load, a TCP connection attempt could fail with an incorrect error code. On certain operating systems, the connection attempt could hang. This has been fixed.

CR:690354

CR Number:   690354 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Linux Red Hat Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description iqunload may fail with "Feature, aggregate 'list' at line 0, is not supported."

CR:690410

CR Number:   690410 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 29 Dec 2011 Fixed Description Writer nodes request coordinator for storage on demand basis. Coordinator maintains certain persistent and recoverable book-keeping structures to track writer allocations. After a successful allocation, these structures are passed to writer nodes so that they can update their local storage structures. If a checkpoint occurs after coordinator creates allocation structures but before it commits them, coordinator allocation transaction loses ownership of the newly created structures to checkpoint. During commit, coordinator transaction creates its own copy from checkpoint owned allocation structures. However, writer node still receives checkpoint owned copy for local update. In a rare scenario, if another checkpoint happens before writer can update the local storage, checkpoint owned copy gets destroyed. Any further update by writer using destroyed copy can result in database crash.

CR:690664

CR Number:   690664 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 e00.x 20 Jun 2012 Fixed 15.4 e02 15 Jun 2012 Fixed 15.4 e01.x 23 Oct 2012 Fixed 15.4 e01.x 23 Oct 2012 Fixed Description The IQ server crashes if query has HASH JOIN and due to incorrect estimates the runtime rehashing is required.

CR:690706

CR Number:   690706 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for IQ to use timezone different from local Windows machine timezone, so that getdate() return date/time is base on IQ specified timezone instead of Windows machine timezone.

CR:690939

CR Number:   690939 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2012 Fixed Description Improved Load performance of tables having text indexes.

CR:691158

CR Number:   691158 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Nov 2011 Fixed 28 Jun 2012 Fixed Description Attempting to make a Kerberos connection with a large Kerberos ticket could incorrectly fail with the error "Kerberos login failed". This could occur with Keberos ticket size approaching 8K, which was possible if the ticket was part of a large number of Active Directory groups.

CR:691164

CR Number:   691164 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows XP Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 28 Mar 2012 Fixed Description IQ 15.3 windows network client installer only installs dboledba11.dll, dboledb11.dll is missing. The server installer has it. also problem with IQ 15.4 installer where dboledb12.dll is missing. Workaround Description  use file from server install.

CR:691275

CR Number:   691275 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp08 18 Dec 2013 Fixed 16.0 sp08 10 Jan 2014 Added to user documentation Description need a switch implemented that disallows checkout of any optional graced license if someone inadvertently tries to use an unlicensed feature

CR:691465

CR Number:   691465 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Dec 2011 Fixed Description When using the fetch_block() UDF api to retrieve rows from an input table 1 row will be lost for every subsequent block fetch. This is now fixed. Target Version  15.4 e01

CR:691527

CR Number:   691527 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03.x 04 Jan 2012 Fixed Description Server failure may occur in st_txncb.cxx when a sql batch is interrupted by a DROP CONNECTION command.

CR:691609

CR Number:   691609 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2008 Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2012 One-off Provided 15.4 e01 28 Nov 2011 Fixed 16.0 30 Nov 2011 Fixed Description The JDBC driver sajdbc4.jar might not be installed on Windows.

CR:691733

CR Number:   691733 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 22 Feb 2012 Fixed Description Recommendations in "MAIN_RESERVED_DBSPACE_MB Option" in Reference: Statements and Options and "Sizing guidelines for main and temporary stores" in System Administration Guide: Volume 1 seem contradictory, but sizing for MAIN_RESERVED_DBSPACE_MB depends on many factors, such as IQ page size and the number of concurrent connections. Set MAIN_RESERVED_DBSPACE_MB to at least 20 percent of the IQ_SYSTEM_MAIN size.

CR:691756

CR Number:   691756 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.3 e00.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2012 Fixed 18 Apr 2012 Fixed 18 Apr 2012 Fixed Description The failure was caused due to access of invalid memory in queries with hash join. The issue is specific to Linux Power Series. This has been fixed. Workaround Description  Today dec th 20th while SPS was implementing migrating customer to another platform, could find that if the procedure syntax is switched from T-SQL to ANSI, the problem is avoided on Linux PPC. However for AIX , IQ do not crash even with T-sql syntax, however result set seem to be wrong. Quick WA from SPS , was suggest customer to switch from T-sql procs to ANSI on linux ppc. However this could not apply for system sp's, these were avoided increasing catalog store memory.

CR:691839

CR Number:   691839 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 future 05 Feb 2012 Fixed 16.0 26 Dec 2011 Fixed Description A derived table that contains UNION ALL and SCALAR correlated subqueries with conjunctive condition causes the query fail with a non-fatal stack trace at opt_TableNode.cxx. Workaround Description  The workaround for this issue is as below, set temporary option Subquery_Flattening_Preference = '-2'; This option disables the scalar subquery flattening.

CR:691845

CR Number:   691845 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 31 Jan 2012 Added to user documentation Description The documentation for the sp_iqspaceused stored procedure had inaccurate descriptions for the tempKBUsed and shTempTotalKBUsed columns. tempKBUsed is the number of kilobytes of total IQ temporary store space in use by the database. shTempTotalKBUsed is the number of kilobytes of total IQ global shared temporary store space in use by the database. (Secondary multiplex nodes return '(Null)'.)

CR:692222

CR Number:   692222 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 04 Jan 2012 Fixed 16.0 19 Jan 2012 Fixed Description If an attempt to insert a value requiring implicit conversion into a column that results in a conversion error, previously inserted, uncommitted values are rolled back.

CR:692449

CR Number:   692449 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description a DQP query under certain circumstances can be slower than the same query run non-dqp Workaround Description  set temporary option DML_Options75=181891; -- Explicit group by estimate to force a parallel hash group by

CR:692460

CR Number:   692460 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp08 05 Dec 2013 Already Fixed by Another CR Description Executing a SELECT * from a procedure that includes an INSERT fails with a non fatal error at df_Heap.cxx:2613 when one of the parameters passed in exceeds the defined parameter length. Subsequent queries from the same client fail with "CURSOR ALREADY OPEN" errors. Workaround Description  To work around the problem the ct should either only used data of the correct length , or change the table and procedure definitions to increase the length of column / parameter causing the issue.

CR:692519

CR Number:   692519 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 12 Dec 2011 Fixed Description If an application connected via jConnect or Open Client to a blank padded UTF8 database and fetched a non-nullable char(n) value, then the client may experience protocol errors if n is less than 3. This has been fixed. Workaround Description  a. use convert() to explicitly convert char strings to varchar. This is not acceptable to cust. since this means lot of modifications in the scripts

CR:692528

CR Number:   692528 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows 2008 Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request monthname(getdate()), datename(mm,getdate()) to return localized Japanese month names when LANG is set to Japanese. Also request to support additional languages.

CR:692572

CR Number:   692572 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.4 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New feature request to allow a way for temp objects to only exist in cache, never to be written to disk unless temp cache gets full.

CR:692575

CR Number:   692575 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.4 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description allow mpx dqp queries to work across locations (if Frankfurt needs London data it will split off part of the query and send it to the London server to get that data for example)

CR:692599

CR Number:   692599 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2012 Fixed 11 Jan 2012 Fixed Description If the server is started with a TLS/HTTPS identity file that requires a password but none is supplied, an unhelpful error message is given ("Error parsing certificate file, error code 20763"). This has been fixed; the error message is now "An identity password must be specified".

CR:692694

CR Number:   692694 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 14 Dec 2011 Added to user documentation Description The 15.4 documentation describing the permissions required for these permissions is incorrect: DEFAULT_PROXY_TABLE_ROW_COUNT Option DEFAULT_TABLE_UDF_ROW_COUNT Option TABLE_UDF_ROW_BLOCK_CHUNK_SIZE_KB Option DBA permissions are not required for these options.

CR:692802

CR Number:   692802 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   12.7 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under rare circumstance the server might incorrectly parse the SQL statement for a procedure and result in a crash. This has been now been fixed.

CR:693033

CR Number:   693033 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2011 Presently Not Targeted For Any Future Release Of This Product 15.4 e01 22 Dec 2011 Fixed Description If a column has a data type VARCHAR or VARBINARY greater than 255 bytes, sp_iqrebuildindex does not rebuild a default index. This problem was erroneously reported fixed in the 15.4 Sybase IQ New Features Summary.

CR:693109

CR Number:   693109 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 12 Nov 2012 Added to user documentation Description When a partitioned table resides on online and offline dbspaces, data of the table can not be accessed, if any data/index/partition of the table resides on the OFFLINE dbspace. Also, sp_iqcheckdb doesn't check partitioned table with OFFLINE dbspaces. To create and use indexes on a partitioned table, all dbspaces have to be online.

CR:693122

CR Number:   693122 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 future Description a union all query may abort in df_heap.cxx: 12140 Workaround Description  The workaround for this issue is turning off shadow transformation for Group By using below dml option, set temporary option dml_options8 = 8 ;

CR:693311

CR Number:   693311 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 03 Feb 2012 Added to user documentation 16.0 sp01 25 Mar 2013 Added to user documentation 15.4 e03 25 Mar 2013 Added to user documentation Description Modifying a column data type using alter command is not supported.

CR:693421

CR Number:   693421 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 7 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 09 Feb 2012 Fixed 16.0 09 Feb 2012 Fixed Description In the 15.4 Release Bulletin, the section "Network Clients and ODBC Kits" should state: Sybase IQ Network Clients and ODBC kits for development are available on the Sybase download site. A Network Client is available for each platform supported by this version of Sybase IQ. The Linux 32-bit client is also available. The Sybase download site is http://www.sybase.com/downloads.

CR:693648

CR Number:   693648 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description LOAD TABLE with 3 char ROW DELIMITER ';]\x0a' can not always load the data files

CR:693662

CR Number:   693662 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 15.4 and all previous versions of 15, sp_iqdbspaceinfo lists objects residing in a dbspace, customer require ability to list objects residing in a specific dbfile

CR:693833

CR Number:   693833 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 01 Feb 2012 Fixed 16.0 14 May 2012 Fixed Description A query might cause datatype conversion error at dfe_Cast.cxx : 918 and subsequent IQ server failure at hos_mem.cxx:243 while converting varchar column value to numeric datatype.

CR:693904

CR Number:   693904 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 17 Feb 2012 Fixed Description The following was omitted from the LOCK TABLE statement in Sybase IQ Reference: Statements and Options. Using the WITH HOLD clause in the same statement with WRITE MODE is unsupported and returns the error SQLCODE=-131, ODBC 3 State="42000".

CR:693905

CR Number:   693905 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Lock Table: instead of syntax error, return meaningful msg: 'with hold' and in 'write' mode are not allowed in same statement

CR:693970

CR Number:   693970 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer would like extra diagnostics about objects involved when hitting errors like.. I. 12/19 01:29:26. 0001304510 [20895]: Insert Pass 1 completed in 2 seconds. I. 12/19 01:31:19. 0001304510 main Bufman: Incorrect page header read; buffer={btype=12,nlb=16,blk=11084,pbn=447979368,npb=7,uid=1387737518,txn=418596030,sp=1,flgs=0x818 page={btype=12,nlb=16,npb=16,ctr=131,cta I. 12/19 01:31:19. 0001304510 =131,pbn=447979368,txn=418039238,sp=844,ver=1,pb=104,pus=43966}. s_trycatch.cxx:1549 I. 12/19 01:31:19. 0001304510 There was an s_buf::Read() error during s_bufman::Find(). I. 12/19 01:31:19. 0001304510 Exception Thrown from s_blockmap.cxx:4469, Err# 0, tid 1089 origtid 1089 I. 12/19 01:31:19. 0001304510 O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14 I. 12/19 01:31:19. 0001304510 [20060]: main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb.

CR:694467

CR Number:   694467 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2012 Added to user documentation 16.0 13 Nov 2012 Added to user documentation Description Customers using Sybase IQ/CIS on SunOS version 5.10 Generic_144488-04 to access remote ASE tables using the 15.7 ASE ODBC driver will get the following message: "Error when attempting to connect: Unable to connect to server 'MYASE': [Sybase][ODBC Driver Manager] Unable to load driver" To connect, install the June 30, 2011 OS patch bundle. Kernel version: SunOS 5.10 Generic_144488-17

CR:694685

CR Number:   694685 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2012 Fixed 16.0 13 Jul 2012 Fixed Description If a NON zero return status produced by script called by a BACKUP DATABASE FULL VIRTUAL ENCAPSULATED command IQ is not picking this up and not throwing an error on Linux Redhat. Instead the backup is treated as sucessful.

CR:694840

CR Number:   694840 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2012 Fixed Description When execute a Java UDF in IQ the server might crash when trying to right truncate data for a binary column whose size is greater than 256 bytes. This has been fixed.

CR:695298

CR Number:   695298 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 31 Jan 2012 Added to user documentation Description In Sybase IQ 15.4 > System Administration Guide: Volume 1 > Sybase IQ Indexes > Criteria for Choosing Indexes > Number of Unique Values in the Index, the documentation stated that the recommended index type for less than 1000 unique values is HG when the table has <25,000 rows. This is incorrect. Sybase recommends using the HG index when the table has <100,000 rows.

CR:695461

CR Number:   695461 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 19 Jan 2012 Fixed 19 Jan 2012 Presently Not Targeted For Any Future Release Of This Product 19 Jan 2012 Presently Not Targeted For Any Future Release Of This Product Description While performing a database backup that required multiple tapes, the backup stopped with error "Unable to write to archive" shortly after displaying the message prompting to load tape #2.

CR:695758

CR Number:   695758 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SELECT .. UNION SELECT .. ORDER BY COLUMN could returns The field 'COLUMN' specified in the query cannot be found Workaround Description  WA set temporary option CIS_OPTION=8; When your UNION contains an SA table and IQ table. In this case the select att=1 --> select att=1 FROM DUMMY In IQ 12.7 the whole query would have been exeucted at the SA side. IN IQ 15 this is executed at the IQ side. Even in IQ 12.7 you would get the same result for this test query if you change the SELDCT att=1 to SELECT att=1 FROM IQDUMMY.

CR:695904

CR Number:   695904 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2012 Fixed 01 Mar 2012 Fixed Description Customers might experience an error while trying to create a raw database on Windows 2008 R2. This has now been fixed.

CR:695918

CR Number:   695918 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 19 Jul 2012 Fixed 05 Nov 2012 Fixed 05 Nov 2012 Fixed Description In a MPX, if the column id of a table is greater than 65535 and any DML operation is done on the table, during TLV replay the secondary servers will abort with SEGV

CR:696059

CR Number:   696059 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2012 Fixed 05 Sep 2012 Fixed 15.3 e00.x 04 May 2012 Fixed Description There was an issue in the parallel HG index insert logic which could lead to an inconsistent index. The load/insert used to throw a non-fatal error from HG index logic. This issue has been resolved. Target Version  15.4 e01

CR:696213

CR Number:   696213 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 08 Feb 2012 Work as design 15.4 e02 04 Mar 2012 Fixed 16.0 27 Feb 2012 Fixed 16.0 10 Apr 2012 Fixed Description Out of sync R/W lock may cause secondary node emergency shutdown. It is an expected server behavior.

CR:696317

CR Number:   696317 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description PATINDEX could return wrong results for wildcard chars and latin special chars

CR:696396

CR Number:   696396 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR: Allow extraction of data from mixed on and offline partitioned objects

CR:696563

CR Number:   696563 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 7 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 03 Feb 2012 Fixed Description A bulk insert of large object data using host variables will insert, for each row, the same value that was inserted to the same column in the first row inserted.

CR:696673

CR Number:   696673 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 7 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 17 Feb 2012 Fixed Description If bulk inserts are sent to the server and one encounters an error, previous successful bulk inserts may be rolled back.

CR:696880

CR Number:   696880 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RESTORE cause utlity_db crash on s_buf*s_blockmap::Find

CR:696885

CR Number:   696885 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Assertion failed: 109512 Freeing already-freed memory on SELECT TOP

CR:696982

CR Number:   696982 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 13 Apr 2012 Fixed 15.4 e02 02 May 2012 Fixed 15.4 e01.x 29 Apr 2012 Fixed Description A query with right outer hash join node could return internal error at s_csort.cxx:3161 in IQ15.4 while sorting output from right outer hash join node.

CR:697069

CR Number:   697069 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 16 Dec 2012 Fixed 16.0 27 Feb 2013 Added to user documentation Description The LOAD TABLE clauses BLOCK FACTOR, BLOCK SIZE and UNLOAD FORMAT are deprecated. IQ nolonger accepts this syntax and will return syntax errors if these clauses are used.

CR:697153

CR Number:   697153 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2008 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 28 Feb 2012 Fixed 28 Feb 2012 Fixed 28 Feb 2012 Fixed Description SybaseIQAgent15 would fail to start the IQ Server if the Windows environment variable PATH was greater than 1024 characters.

CR:697211

CR Number:   697211 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2012 Added to user documentation Description A new version of the Sybase IQ 15.4 Quick Start Guide on the Sybase Product Documentation Web site includes some path name changes. Some sections in the 15.4 Quick Start Guide use a variable as part of the path where an absolute path may have been more appropriate. The revised Quick Start includes full and explicit path names.

CR:697212

CR Number:   697212 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2012 Added to user documentation Description A new version of the Sybase IQ 15.4 Quick Start Guide on the Sybase Product Documentation Web site includes some path name changes and a note on distributed queries. Some sections in the 15.4 Quick Start Guide use a variable as part of the path where an absolute path may have been more appropriate. The revised Quick Start includes full and explicit path names. A change in the Running a Distributed Query section notes that the query engine may choose a query plan that does not distribute to the write server.

CR:697314

CR Number:   697314 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 02 Feb 2012 Fixed 16.0 30 Aug 2012 Fixed Description Sybase IQ has been upgraded to Sybase Open Client 15.7. This will be automatically installed with version 15.4 ESD #1 and up.

CR:697490

CR Number:   697490 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 7 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 03 Feb 2012 Added to user documentation Description The SCC online help for Sybase IQ does not contain information on recent changes to the SCC security modules. See the SCC 3.2.6 Release Bulletin for the updated documentation.

CR:697746

CR Number:   697746 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2003 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description discrepancy in the representation of floating point numbers to the IEEE 754 standard in any version of IQ. 4.70000000000000028865798640254E-1 is the most accurate representation of 0.47000000000000003 for double precision in the IEEE 754 standard But IQ chooses a slightly different representation of 0.47000000000000008437694987150000000000000000000000 when retrieving the number stored in a DOUBLE datatype when using a select convert ( numeric(126,50)

CR:698044

CR Number:   698044 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 10 Apr 2012 Duplicate 14 May 2012 Fixed Description A non-fatal error occurred on NTILE and RANK functions run on tables of a million rows.

CR:698206

CR Number:   698206 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description This a doc enhancement request regarding the minimum permission's setting for the $IQTMP15 directory.

CR:698347

CR Number:   698347 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2013 Presently Not Targeted For Any Future Release Of This Product Description IQ 15 checkpointing more frequently and spending more time on checkpoints than 12.7

CR:698374

CR Number:   698374 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2013 Fixed Description If the identity_insert option was set for a user on a table owned by a user other than DBA, iqunload would be unable to set that option on the new database. This has been resolved. Workaround: unset the identity_insert option for that table prior to running iqunload and re-establish it on the reloaded database afterwards. Workaround Description  set option "user1"."identity_insert"=''

CR:698573

CR Number:   698573 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 01 Jun 2012 Fixed Description Server failure may occur when loading data with logging turned on and there are default values for a column.

CR:698659

CR Number:   698659 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Suse Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When the database option Max_Query_Parallelism is set to a decimal value instead of an integer, IQ server can crash. Workaround Description  Set the option Max_Query_Parallelism to an integer value.

CR:698811

CR Number:   698811 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request. IQ to allow users with expired password to connect and be prompted to change the password as ASE does.

CR:699014

CR Number:   699014 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 14 Mar 2013 Fixed Description There was a 508 issue where keyboard access in the Domain Wizard did not work properly.

CR:699206

CR Number:   699206 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ could crash when running multi-table UPDATE when one of the tables is a proxy table. Multi-table UPDATE is not allowed. It will fire an error instead of crashing Workaround Description  Rewrite the UPDATE as batch. In customer's case, it could be rewriten as follows: begin declare @vdate datetime; select min (dateformat(tproxy.snapshot_date, 'yyyy-mm-dd hh:mm:ss.sss')) into @vdate from iqtab where loaded=0 and deleted<>1; update iqtab set loaded=0 where (snapshot_date) >= @vdate; end

CR:699327

CR Number:   699327 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 12 Jun 2012 Fixed Description Fixed an internal memory corruption error causing server failure.

CR:699486

CR Number:   699486 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A selective restore of a RO dbspace with RENAME to a raw device where the TO device name alread exists causes restore error like this... Could not execute statement. Dbspace file with name or path '/dev/rdsk/c1t6d0s2' already exist. SQLCODE=-1234, ODBC 3 State="42000" Line 1, column 1 Investigative CR to see if this is expected behaviour / document clarification

CR:699969

CR Number:   699969 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Mar 2012 Fixed Description Migration from 12.7 to 15.4 could fail if on on 12.7 there is a proxy table to ASE and an index on that proxy table exists. Workaround Description  In IQ, drop the proxy table on 12.7, then run iqunload, then recreate the prxy table on 15.4

CR:700118

CR Number:   700118 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Solaris Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 24 May 2012 Fixed Description On data set with large numner of rows, a query resulting aggregated values with large precision and scale via aggregate functions that has a subtree that predicts aggregate value size undergoes shadow transformation might hit an validation error at dfo.cxx:9638 on 15.2 esd 2.x. This has been fixed.

CR:700166

CR Number:   700166 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2008 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 12 Jun 2012 Fixed 15.4 e02 23 Aug 2012 Fixed 15.4 e02 23 Aug 2012 Fixed Description Previous installers did not stop and delete the previous SCC version window service. This has now been fixed.

CR:700647

CR Number:   700647 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_iqversionuse fail with Function 'hextoint' has invalid parameter or return negative version IDs. Workaround Description  2012-10-09 ltang ==================== I found a possible workaround. By creating a new temp table in the IQ store instead of IN SYSTEM, you can run hextoint without conversion issues or getting a negative value for versionID. CREATE PROCEDURE test_iqversionuse() result( VersionID unsigned bigint, Server char(128), IQConnID unsigned bigint, WasReported unsigned bigint, MinKBRelease unsigned bigint, MaxKBRelease unsigned bigint ) begin declare oldestver unsigned bigint; declare newestver unsigned bigint; declare writerID unsigned bigint; declare myID unsigned bigint; declare local temporary table #iqtrantmp( TxnID unsigned bigint not null, VersionID unsigned bigint null, State char(16) null, CreateKB unsigned bigint null, DropKB unsigned bigint null, CursorCount unsigned bigint null, IQConnID unsigned bigint null, primary key(TxnID),) in SYSTEM on commit preserve rows; declare local temporary table #iqversionlist( VersionID unsigned bigint not null, CreateKB unsigned bigint null, DropKB unsigned bigint null,) in SYSTEM on commit preserve rows; declare local temporary table #iqversionuse( VersionID unsigned bigint null, ServerID unsigned bigint null, WasReported unsigned bigint null, IQConnID unsigned bigint null,) in SYSTEM on commit preserve rows; declare local temporary table sp_iqactiveversions_table( server_id unsigned integer null, active_versions long varchar null,) in SYSTEM on commit delete rows; /* CREATE A TEMP TABLE IN IQ STORE */ declare local temporary table sp_iqactiveversions_tmp( server_id unsigned integer null, active_versions char (8) null, active_versions_hex bigint null ) on commit delete rows; call dbo.sp_iqversionuse_internal(); set writerID = (select server_id from SYS.SYSIQMPXSERVER where role = 0); set myID = (select server_id from SYS.SYSIQMPXSERVER where server_name = @@servername); insert into #iqtrantmp select TxnID, case VersionID when 0 then CmtID else VersionID end, State,MainTableKBCr,MainTableKBDr,CursorCount,IQConnID from dbo.sp_iqtransaction(); if myID = writerID then insert into #iqversionlist select VersionID,CreateKB,DropKB from #iqtrantmp where State in( 'COMMITTED','APPLIED' ) ; /* REPLACE THIS SELECT, BY THE 3 CMD: INSERT + UPDATE + SELECT BELOW select isnull(min(hextoint(substr(active_versions,1,locate(active_versions,'Z')-1))),1) into oldestver from sp_iqactiveversions_table where locate(active_versions,'Z') > 1; */ insert sp_iqactiveversions_tmp (server_id, active_versions) (select server_id, substr(active_versions,1,locate(active_versions,'Z')-1) from sp_iqactiveversions_table where locate(active_versions,'Z') > 1); update sp_iqactiveversions_tmp set active_versions_hex = hextoint (active_versions); select isnull(min(active_versions_hex), 1) into oldestver from sp_iqactiveversions_tmp; -- Add a row for the oldest version if it does not appear in sp_iqtransaction if not exists(select * from #iqversionlist as it where it.VersionID = oldestver) then insert into #iqversionlist values( oldestver,0,0 ) end if; -- Calculate version usage for active transactions on this server insert into #iqversionuse select(select isnull(max(it2.VersionID),1) from #iqversionlist as it2 where it2.VersionID <> 0 and it2.VersionID < it.TxnID), myID,1,IQConnID from #iqtrantmp as it where it.State = 'ACTIVE'; -- Add rows for versions used by query servers reported back by SQL remote insert into #iqversionuse select it.VersionID,vl.server_id,1,0 from sp_iqactiveversions_table as av,SYS.SYSIQMPXSERVER as vl,#iqversionlist as it where vl.role <> 0 and vl.status = 0 and it.VersionID <> 0 and av.server_id = vl.server_id and lower(replace('Z'+av.active_versions,'Z','Z000000000000000')) like lower('%'+inttohex(it.VersionID)+'Z%'); -- Add rows for versions used by query servers not reported back by SQL remote insert into #iqversionuse select it.VersionID,mi.server_id,0,0 from SYS.SYSIQMPXSERVER as mi,#iqversionlist as it where mi.role <> 0 and mi.status = 0 and it.VersionID > (select isnull(max(VersionID),0) from #iqversionuse as vt where vt.ServerID = mi.server_id) else -- Query server -- Gather version list from sp_iqtransaction insert into #iqversionlist select distinct VersionID,0,0 from #iqtrantmp where(State = 'ACTIVE' or CursorCount > 0); -- Calculate version usage for active transactions on this server insert into #iqversionuse select VersionID,myID, isnull((select 1 where exists(select * from sp_iqactiveversions_table as av where lower(replace('Z'+av.active_versions,'Z','Z000000000000000')) like lower('%'+inttohex(it.VersionID)+'Z%'))),0),IQConnID from #iqtrantmp as it where(State = 'ACTIVE' or CursorCount > 0); -- Add a row for the latest version select max(VersionID) into newestver from dbo.sp_iqmpxversioninfo(); if newestver <> 0 and not exists(select * from #iqversionlist where VersionID = newestver) then insert into #iqversionlist values( newestver,0,0 ) ; insert into #iqversionuse values( newestver,myID,0,0 ) end if end if; set oldestver = (select min(vu.VersionID) from #iqversionuse as vu); select vt.VersionID as VersionID, isnull((select mi.server_name from SYS.SYSIQMPXSERVER as mi where mi.server_id = vt.ServerID),@@SERVERNAME) as Server, vt.IQConnID as IQConnID, vt.WasReported as WasReported, case vt.VersionID when oldestver then it2.DropKB else 0 end as MinKBRelease, case vt.VersionID when oldestver then it2.DropKB when it2.VersionID then 0 else case sign(cast(it2.DropKB as bigint)-cast(it.CreateKB as bigint)) when 1 then it.CreateKB else it2.DropKB end end as MaxKBRelease from #iqversionuse as vt,#iqversionlist as it,#iqversionlist as it2 where vt.VersionID = it.VersionID -- it2.VersionID is the previous version used to calculated release and it2.VersionID = (select isnull(min(it3.VersionID),it.VersionID) from #iqversionlist as it3 where it3.VersionID > vt.VersionID) order by vt.VersionID asc,vt.ServerID asc,vt.IQConnID asc end ;

CR:700675

CR Number:   700675 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Suse Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to reduce disk i/os when doing insert select into temporary table.

CR:700886

CR Number:   700886 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 04 Nov 2013 Duplicate Description Execution times of prefetches increased when comparing IQ version 15 with previous Sybase IQ releases. This has been fixed.

CR:700980

CR Number:   700980 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 May 2012 Fixed 15.4 e02 26 Jun 2012 Fixed 15.4 e01.x 25 Jun 2012 Fixed Description 1. The unhandled datatype exception is observed when host variable of type date with 6 digit precision in declared application using jConnect client 5.X onwards, used in query running on IQ table. 2. The Secondary error is observed when query has Sort Merge join executed serially and early resource release option is disabled.

CR:701039

CR Number:   701039 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2014 One-off Provided 18 Apr 2012 Fixed 15.4 e01.x 20 Apr 2012 Fixed 15.4 e02 21 Jun 2012 Fixed 16.0 30 Jun 2012 Fixed Description Added new database option AES_Encrypt_Header_Format for decrypting data upgraded from 12.7 to 15.x or imported from 12.7 to 15.x. Option usage: SET OPTION public. AES_Encrypt_Header_Format = VAL ; Where VAL is an integer and it can have the following possible values: -1 -> Default: format is that of current release. Data is encrypted and decrypted using the same release. e.g. data is encrypted on 15.3 database and decrypted on 15.3 database. 127 -> Set this option to decrypt data if database is upgraded or imported from 12.7 release. e.g. data is encrypted on 12.7 database and it is upgraded to 15.x. 153 -> Set this option if data is from previous 15.3 release. e.g. Data is encrypted on previous 15.3 database and decrypted on next 15.x release. 154 -> Set this option if data is from previous 15.4 release. e. g. Data is encrypted on previous 15.4 database and decrypted on next 15.x release. 1000 -> Data is from fixed releases.

CR:701052

CR Number:   701052 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e01.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 09 Mar 2012 Fixed 11 Oct 2012 Fixed Description Grant multiple authority to multiplex users does not propagate on secondary nodes.

CR:701085

CR Number:   701085 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 18 Oct 2012 Added to user documentation Description Contents of Permissions of alter index and alter table are not corret. alter index not required RESOURCE authority. alter table not required CREATE permission on the new dbspace and be the table owner.

CR:701097

CR Number:   701097 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2008 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 24 Sep 2012 Fixed Description IQ15.4 includes 15.2ESD#3 and 15.3GA updating.

CR:701116

CR Number:   701116 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Japanese file name containing "0x5c" makes Temp_Extract fail. Workaround Description  Please do not use Japanese for Temp_Extract_Name.

CR:701326

CR Number:   701326 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 12 Mar 2012 Fixed 15.4 e01 19 Mar 2012 Added to user documentation Description As of 15.4 ESD #1, Sybase IQ no longer supports elliptic-curve cryptography (ECC) encryption.

CR:701447

CR Number:   701447 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Backup FULL and INCREMENTAL a database older than 30 days that has and uses the VLDB license. On a installation that has no license at all, RESTORE FULL would succeed but then even after installing a valid VLDB license, the subsequent RESTORE INCREMENTAL could faile with error: Msg 21, Level 14, State 0: SQL Anywhere Error -1012008: Database has changed since last restore. -- (db_backupID.cxx 617) Workaround Description  Before any kind of RESTORE, ensure that the restore system has valid IQ licenses installed.

CR:701474

CR Number:   701474 Product Name:   IQ Management Product Component:   Web UI - Node Monitor - View All Statistics in Tab Status:   Open OS:   Generic Original Version:   3.2.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ Multiplex Coordinator node statistcs: No data was found for statistics

CR:701641

CR Number:   701641 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 19 Apr 2012 Fixed 16 May 2012 Fixed 22 May 2012 Fixed Description In DQP, a simple SELECT COUNT(*) FROM TABLE WHERE COL like '123%' could return incorrect values. Workaround Description  set temporary option index_preference = 5 or donot use the option set temporary option hg_search_range=1000

CR:701907

CR Number:   701907 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 26 Jun 2012 Fixed Description New Clickwrap licenses were received for Australia and Japan. These have been added to the installer.

CR:701953

CR Number:   701953 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 22 Mar 2012 Fixed 16.0 22 Mar 2012 Fixed 15.4 e01 13 Apr 2012 Fixed 15.4 e02 17 Apr 2012 Fixed 16.0 03 May 2012 Fixed Description A query that contains a parallel orderby over a union with constant values for a column in all arms of the union could fail with an internal error.

CR:702246

CR Number:   702246 Product Name:   IQ Product Component:   Documentation Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 32-bit GNU C Libraries package (glibc-2.xx-x.xx.el6.i686.rpm) also need to be installed before installing IQ 15.3 or 15.4 64-bit to a Redhat Enterprise Linux 6.x x86_64.

CR:702363

CR Number:   702363 Product Name:   IQ Product Component:   Sybase Central Status:   Open OS:   Windows 2008 Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When proxy table to an Oracle table is created, IQ plug-in maps NUMBER (5,2) to a different type.

CR:702419

CR Number:   702419 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When backup full is taken on a coordinator and if it crash, backup incremental is taken on the new coordinator (failover server), then restore full or incremental can faile.

CR:702433

CR Number:   702433 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Windows XP Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description dbisql for IQ 15 returns columns in fixed width necessitating resizing to see longer data which is not persistent. 12.7 returned data in variable length columns display.

CR:702454

CR Number:   702454 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Unknown Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 02 Apr 2012 Fixed 16.0 03 Apr 2012 Fixed Description With IQ 15.4 esd 1 on Windows platform, when you run "iqdsedit" it is missing the network protocols from the drop down box. This has now been fixed.

CR:702845

CR Number:   702845 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 06 Jul 2012 Added to user documentation Description A Max_Warnigs option does not affect IQ server. The description about this option will be removed from a manual.

CR:702999

CR Number:   702999 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 30 Oct 2012 Fixed 16.0 22 Nov 2012 Fixed 15.4 e02.x 02 May 2013 Fixed Description An insert..select query caused the server to crash when the record length exceeded the max record length a Parallel Combiner node can support. Workaround Description  Please try dml_options8=8 as a W/A ================================================= [Problem SQL] ... case b.datatype_cls when 'T' then b.info_val_text when 'N' then left(repeat('0',2-length(cast(cast(b.info_val_num as int) as varchar)))||cast(b.info_val_num as int),2) end [Modified SQL] ... case b.datatype_cls when 'T' then b.info_val_text when 'N' then right('00'||left(cast(cast(b.info_val_num as int) as varchar(10)),2),2) end