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

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

CR:653694

CR Number:   653694 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2011 Fixed 25 Aug 2011 Fixed Description Transfer table command with destination to a 'fifo' file can fail for tables with rows of larger size.

CR:653722

CR Number:   653722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #5 15 Apr 2011 Fixed 15 Apr 2011 Reservation Made Description An infected with 11 occurs in NormalizeScaler when inserting the results of a UNION into a table with a materialized functional column.

CR:653786

CR Number:   653786 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2011 Fixed Description Sybase Central 6.0 with ASE Plug-in may raise the ClassCastException when displaying device information from database property if an additional segment exists on the database.

CR:653797

CR Number:   653797 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New feature request : sp_monitorconfig supports "statement cache". Workaround Description  Use monStatementCache.

CR:653916

CR Number:   653916 Product Name:   Adaptive Server Enterprise Product Component:   sybmigrate Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2011 Duplicate Description sybmigrate validate outputs messages "Index, Index Constraint" when the create table ddl on target did not specify the index name. Workaround Description  ignore these messages in the validate log

CR:653938

CR Number:   653938 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description upgrading ASE database to 15.x may sometimes raise an error Msg 1902, at upgrade step [ID 53] Workaround Description  sp_configure "allow updates to system tables", 1 on the source database: begin tran select name, first from sysindexes where name = 'sysusermessages' and id= 15 and indid =1 go update sysindexes set name ='csysusermessages' where name='sysusermessages' and id= 15 and indid =1 and first = <returned_value of first>

CR:653966

CR Number:   653966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2011 EOL'd version. Not to be Fixed. Description The Adaptive Server Enterprise can not bring the second engine online on Linux x86 platforms if max memory is over 2GB. Workaround Description  Use memory less than 2 GB or move to 64bit Linux.

CR:654011

CR Number:   654011 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2011 One-off Provided 11 Feb 2011 Fixed 01 Mar 2011 Fixed 17 Mar 2011 Fixed 30 Mar 2011 Fixed 01 Apr 2011 Fixed 01 Apr 2011 Fixed 05 Apr 2011 Fixed 05 Apr 2011 Fixed 05 Apr 2011 Fixed 05 Apr 2011 Fixed 20 Sep 2012 Fixed Description The message "current process infected with 11" in the module 'bufdlink' together with a stack trace which includes the modules 'pg_allocate' and 'bufpindirty' may be reported in the error log when a table was in the process of being created and ASE has previously hit a 1204 error "ASE has run out of LOCKS. Re-run your command when there are fewer active users, etc.".

CR:654063

CR Number:   654063 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jun 2011 Duplicate Description A SELECT INTO query that uses an ON SEGMENT clause when selecting data from a UNION ALL may raise an invalid error 205 or an infected with 11 error in GtElement*GcElement::GcGetGt()

CR:654105

CR Number:   654105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2011 Duplicate Description infected with 11 in GtuUnion::GtcPropagateAlias caused by a query that does a SELECT INTO that specifies an ON SEGMENT clause when selecting from a derived table based on a UNION.

CR:654233

CR Number:   654233 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2011 Fixed 05 Oct 2011 Fixed Description Adaptive server goes down after an assertion is hit in the module th__refresh_threshcache(), when running alter database command if systhresholds system table is corrupted and diagserver is used.

CR:654339

CR Number:   654339 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2011 Fixed 17 Feb 2011 One-off Provided 28 Jul 2011 Fixed 21 Sep 2012 Fixed Description A 539 error "Unexpected internal access methods error <value>, state <value> etc." may be reported when an UPDATE with OR clauses is executed on a Data Only Locked table while concurrent DML activity takes place on it. The execution plan would report "Using Dynamic Index" and "Positioning by Row IDentifier (RID)". Alternatively the message "The current row ID '<value>' does not match the new row ID '<value>' for update, etc." may be reported in the error log. Workaround Description  Use "SET INDEX_UNION 0" for executing the UPDATE command so optimizer will skip "OR strategy".

CR:654349

CR Number:   654349 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Control GA Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2011 Fixed 16 Feb 2011 Presently Not Targeted For Any Future Release Of This Product Description It will return a wrong number for patindex() while the matching text across two compressed blocks.

CR:654404

CR Number:   654404 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2011 Presently Not Targeted For Any Future Release Of This Product Description Depending on the optimization goal, queries that create a table using the select....into... syntax may choose a plan that does not use the expected indexes. This can occur if the optimizer has chosed a merge join or hash join for the query. Queries that do not save the result set in a temporary table are no affected. Workaround Description  Three workarounds have been identified. Use allrows_oltp as optimization goal. Either set this as a server wide setting or configure just for this query. Turn off merge joins and hash joins if using allrows_mix/allrows_dss as optimization goal. The issue can be avoided by placing an index hint in the create view statement. Changing: CREATE VIEW SpotDeals AS SELECT T1.SpotDeals_Id, T1.Entities_Id, T1.DealStatus, T1.InputMode, T1.CaptureDate, T1.TradeDate, .... T1.PositionOwner_Id FROM kplus..SpotDealsT T1 Go To CREATE VIEW SpotDeals AS SELECT T1.SpotDeals_Id, T1.Entities_Id, T1.DealStatus, T1.InputMode, T1.CaptureDate, T1.TradeDate, .... T1.PositionOwner_Id FROM kplus..SpotDealsT T1 (index SpotDealsTIdx1) Go This results in the optimiser making use of the index SpotDealsIdx1 when the query is executed in any optimization goal, however this is not an acceptable work around for the client.

CR:654408

CR Number:   654408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 3143, which is master database specific, is raised instead of the generic error 3120 if load database with headeronly is issued from the master database for a user database and the source was configured with a different character set and/or sort order.

CR:654532

CR Number:   654532 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2011 Fixed 15 Feb 2011 One-off Provided 25 Jan 2011 Reservation Made 31 Jan 2011 Fixed 18 Mar 2011 One-off Provided 21 Jul 2011 Bundled Request 22 Nov 2011 One-off Provided 20 Sep 2012 Fixed Description A 15412 error may be raised when during a decryption operation if there are a lot of concurrent user sessions using encrypted columns features in Adaptive Server.

CR:654605

CR Number:   654605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2011 Fixed 17 Mar 2011 Fixed 16 Mar 2011 Reservation Made Description If there are multiple IP addresses corresponding to the hostname provided in the interfaces file, ASE picks one to listen on. It should listen on all of them. Workaround Description  Use separate host names for each physical network interface

CR:654617

CR Number:   654617 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2011 Fixed 01 Apr 2011 One-off Provided Description Enable CIPC native thread on HP platform.

CR:654653

CR Number:   654653 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2011 Fixed Description The database option "no chkpt on recovery" may be left set for a given database mistakenly when ALTER DATABASE and QUIESCE DATABASE are executed by two sessions concurrently.

CR:654661

CR Number:   654661 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2011 Duplicate Description In rare circumstances Runtime execution error "invalid column length" may happen when executing a stored procedure updating temporary tables

CR:654775

CR Number:   654775 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2011 Not a Bug Description job sched: 'run_now' fails on 15.5 for sa and user Workaround Description  Don't use quotes for the jcmd part of the command. Use: sp_sjobcreate @name='sjname=Run_testdb_statistics', @option= 'jcmd=exec testdb..sp_run_statistics, server=JG_155, jproperties=shared,sjproperties=shared_run' go

CR:654922

CR Number:   654922 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Please add new functionality so that the plan displayed by sp_showplan spid in isql session 1, executed after opening a cursor in isql session 2, is the same as that displayed when a cursor is opened in a session that has already executed "set showplan on". In the example below we only see the query type now, but we want to see the query plan from the select statement SESSION 2 Long running query 1> select @@spid 2> go ------ 371 1> declare C1 cursor for select count(*) from tempdb..sysobjects a,tempdb..sysobjects b,tempdb..sysobjects c 2> go 1> open C1 2> go SESSION 1 run showplan to see the query plan 1> sp_showplan 371, null, null, null 2> go QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is OPEN CURSOR C1. (return status = 0) Before opening the cursor, turn on set showplan, when the cursor is opened the plan is displayed. declare C1 cursor for select count(*) from tempdb..sysobjects a,tempdb..sysobjects b,tempdb..sysobjects c go set showplan on go open C1 go QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is OPEN CURSOR C1. QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is DECLARE CURSOR. 5 operator(s) under root |ROOT:EMIT Operator (VA = 5) | | |SCALAR AGGREGATE Operator (VA = 4) | | Evaluate Ungrouped COUNT AGGREGATE. | | | | |N-ARY NESTED LOOP JOIN Operator (VA = 3) has 3 children. | | | | | | |SCAN Operator (VA = 0) | | | | FROM TABLE | | | | tempdb..sysobjects | | | | a | | | | Index : ncsysobjects | | | | Forward Scan. | | | | Positioning at index start. | | | | Index contains all needed columns. Base table will not be read. | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | |SCAN Operator (VA = 1) | | | | FROM TABLE | | | | tempdb..sysobjects | | | | b | | | | Index : ncsysobjects | | | | Forward Scan. | | | | Positioning at index start. | | | | Index contains all needed columns. Base table will not be read. | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | |SCAN Operator (VA = 2) | | | | FROM TABLE | | | | tempdb..sysobjects | | | | c | | | | Index : ncsysobjects | | | | Forward Scan. | | | | Positioning at index start. | | | | Index contains all needed columns. Base table will not be read. | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages. Workaround Description  Before opening the cursor, turn on set showplan, when the cursor is opened the plan is displayed. For example declare C1 cursor for select count(*) from tempdb..sysobjects a,tempdb..sysobjects b,tempdb..sysobjects c go set showplan on go open C1 go QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is OPEN CURSOR C1. QUERY PLAN FOR STATEMENT 1 (at line 1). STEP 1 The type of query is DECLARE CURSOR. 5 operator(s) under root |ROOT:EMIT Operator (VA = 5) | | |SCALAR AGGREGATE Operator (VA = 4) | | Evaluate Ungrouped COUNT AGGREGATE. | | | | |N-ARY NESTED LOOP JOIN Operator (VA = 3) has 3 children. | | | | | | |SCAN Operator (VA = 0) | | | | FROM TABLE | | | | tempdb..sysobjects | | | | a | | | | Index : ncsysobjects | | | | Forward Scan. | | | | Positioning at index start. | | | | Index contains all needed columns. Base table will not be read. | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | |SCAN Operator (VA = 1) | | | | FROM TABLE | | | | tempdb..sysobjects | | | | b | | | | Index : ncsysobjects | | | | Forward Scan. | | | | Positioning at index start. | | | | Index contains all needed columns. Base table will not be read. | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages. | | | | | | |SCAN Operator (VA = 2) | | | | FROM TABLE | | | | tempdb..sysobjects | | | | c | | | | Index : ncsysobjects | | | | Forward Scan. | | | | Positioning at index start. | | | | Index contains all needed columns. Base table will not be read. | | | | Using I/O Size 2 Kbytes for index leaf pages. | | | | With LRU Buffer Replacement Strategy for index leaf pages.

CR:655023

CR Number:   655023 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Drop#3A Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed 14 Mar 2011 Fixed Description After installation on windows, ASE reports it is running as a service but it was actually started by the installer, not as a service

CR:655126

CR Number:   655126 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2011 Added to user documentation Description The documentation needs to be clarified with respect to the expected behaviour in the event of error 2749 occuring. This is defined as a user error and in the case of user errors only the command causing the error is aborted and not the transaction. Any open transactions remain and must be handled by the user. Workaround Description  Always provide the correct number of parameters to any user defined message raised by rasierror.

CR:655188

CR Number:   655188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 May 2013 Insufficient priority to fix Description T450 does not work properly with large select list

CR:655195

CR Number:   655195 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Generic Original Version:   3.2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2011 Fixed Description ASEMAP Monitoring View - Blocked Process screen displays lock configuration information.

CR:655196

CR Number:   655196 Product Name:   ASE Management Product Component:   Web Console Status:   Closed OS:   Generic Original Version:   3.2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2011 Fixed Description Process screen in ASEMAP monitoring view for Sybase Control Center has a new option to allow users to filter out system processes from the list of processes displayed in the datagrid

CR:655342

CR Number:   655342 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2011 Duplicate Description Provide option for Rep Agent to only send SQL statements to the RS. Workaround Description  None at this time.

CR:655352

CR Number:   655352 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2011 Fixed 24 Jan 2011 Reservation Made Description When expressions on GROUP BY lists are in the select list or HAVING clause in which the same column is used on both sides of an operator, then a wrong answer could result e.g. col1 + col1 Workaround Description  change expression so that one side of an operator is not equal to the other side

CR:655386

CR Number:   655386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2011 Fixed Description When gracefully shutting down the coordinator node, the cluster may perform failure handling which will be aborted. This will cause some remaining nodes to become inaccessible.

CR:655440

CR Number:   655440 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Feb 2011 Added to user documentation Description Job Scheduler fails to execute the job, if the text (sql) in the jcmd has quotes around them.

CR:655496

CR Number:   655496 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2012 DEFER Description Error 9502 stating "Data exception - string data right truncated" is not raised when statement cache is on Workaround Description  turn statement cache off set "enable literal autoparam" to 0

CR:655519

CR Number:   655519 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2011 Duplicate Description Batch insert run slowly when using enable PCI and java

CR:655556

CR Number:   655556 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2011 Presently Not Targeted For Any Future Release Of This Product Description Feature request to support CREATE FUNCTION syntax with an empty set of parenthesis used when there are no input parameters for the function.

CR:655613

CR Number:   655613 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2011 Fixed 15 Feb 2011 One-off Provided 25 Sep 2012 Fixed Description A DB2 error indicating an invalid value may be returned when a query referencing a remote DB2 table contains a DATE search value.

CR:655642

CR Number:   655642 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2011 Fixed 09 Feb 2011 One-off Provided Description In ASE Cluster Edition, under some rare conditions, the CREATE/DROP database commands may hang forever as the other task does not send the wakeup event.

CR:655643

CR Number:   655643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2011 Fixed 18 Jul 2011 Fixed Description Re-implementation of the ASE counters supplied to Windows Performance Monitor (windows only)

CR:655745

CR Number:   655745 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Under some circumstances index hints prevent the optimiser from coming up with a valid plan resulting in a 325 error. Workaround Description  use a serial plan or force serial. Index hint of a global index on a partitioned table needs the degree/parallelism specified if Left Outer Join operator is used. Better to use a full AP rather than index hint. If you must use an index hint, consider specifying parallel 1. Consider also the Error Text of Message 325. Msg 325, Level 18, State 1: Server 'XXX', Line YYY: Adaptive Server finds no legal query plan for this statement. If an Abstract Plan is forcing the query plan, check its correspondence to the query. If not, please contact Sybase Technical Support. In this specific case, removing the force results in a plan!

CR:655766

CR Number:   655766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2011 Fixed 15 Mar 2011 Presently Not Targeted For Any Future Release Of This Product Description On some heavily-loaded systems, sybcluser might hit timeout error if it takes more than 1 minute to start a cluster or instance.

CR:655801

CR Number:   655801 Product Name:   ASE Management Product Component:   Administration Agent Plugin Status:   Closed OS:   Generic Original Version:   3.2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2011 Fixed Description In ASEMAP Monitoring's Database screen in SCC 3.1, the value in 'Type' column for a db whose name is 'tempdb' will be shown as empty (compared with 'Temporary') if its 'trunc log on chkpt' dboption is turned off. This fix correct the issue.

CR:655823

CR Number:   655823 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description infected with 11 in dbt_newseq associated with issuing a dump tran against a database in recovery.

CR:655828

CR Number:   655828 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2011 Fixed 09 Feb 2011 One-off Provided Description During shutdown instance processing, the shutdown thread may hang during dbtable cleanup. This prevents local instance polite shutdown

CR:655846

CR Number:   655846 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2011 Fixed 19 Jul 2011 Not a Bug Description ASE at a higher engine count may encounter error in allocating monitor memory during disk init for higher device count.

CR:655917

CR Number:   655917 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Apr 2011 Fixed 13 Jan 2012 Fixed Description ASE loops indefinitely with the message "NT operating system error 1056 in module 'nt386\source\demo\scm_nt.c' at line 1263: An instance of the service is already running." Workaround Description  Ensure there is a carriage return (or blank line) at the end of sql.ini

CR:656032

CR Number:   656032 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2011 Fixed Description sp_placeobject does not work with the index name having trailing spaces.

CR:656075

CR Number:   656075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2011 Fixed 14 Mar 2011 Reservation Made 12 Oct 2011 One-off Provided 16 Mar 2011 Fixed 16 Mar 2011 Fixed 06 Mar 2012 One-off Provided 18 Jan 2013 One-off Provided 26 Sep 2012 Fixed 02 Oct 2012 One-off Provided Description In environments with a high number of concurrent users and using the statement cache intensively, the monitor counters for spinlocks may indicate that the DES manager spinlock was excessively used.

CR:656135

CR Number:   656135 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a Replication Agent procedure to avoid 624 and 692 errors due to stale LTM or rs_locator values.

CR:656139

CR Number:   656139 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_start_rep_agent failure message indicate reason is db is in single user mode.

CR:656243

CR Number:   656243 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2011 Bundled Request Description Negative column length for collocate called by ptrcopyrow

CR:656248

CR Number:   656248 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A way to see if a procedure(object) have been created with T299 on or off.

CR:656294

CR Number:   656294 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2011 Fixed 31 Jan 2011 Fixed 23 Feb 2011 Fixed Description The values of the metrics in the monCachedStatement table are the same for all related columns.

CR:656337

CR Number:   656337 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2011 Work as design Description documentation: engineering saying "SQLJ functions in 1503 are not supported" need to remove any reference to SQLJ in the ASE 15.0.3 documents

CR:656351

CR Number:   656351 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2011 Fixed 19 Sep 2011 Fixed 18 Nov 2011 Fixed Description In a shared disk cluster, a change in ownership of a database on one node may be undetected by another node when a cross-database access is made to a dbo-owned table.

CR:656374

CR Number:   656374 Product Name:   Adaptive Server Enterprise Product Component:   Monitor Client Library Status:   Closed OS:   Windows Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2011 Fixed 03 Mar 2011 Fixed Description Sybase Central may fail to load 32bit mclib.dll on Winx64 platform.

CR:656425

CR Number:   656425 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide compile time warnings to ensure that typing errors which result in too few parameters being passed to raiserror are identified when the a stored procedure is created to help prevent the occurence of 2749 errors at runtime. Workaround Description  Always check that the correct number of parameters are provided when calling raiserror.

CR:656435

CR Number:   656435 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2011 Fixed 27 Jan 2011 Fixed Description Executing a sql query may hit error 8224 from des__lwpdescreate() together with stack trace involving modules open_lwpbyname() and open__byname().

CR:656463

CR Number:   656463 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX 5.1 Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description "kesetown: engine <engine number> is still not online after <number of attempts> attempts to affinity to it" may be raised when an engine is offline and dbcc monitor is executed multiple times through sp_sysmon.

CR:656469

CR Number:   656469 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2012 Fixed 18 Jun 2012 Presently Not Targeted For Any Future Release Of This Product Description After upgrade via binary overlay, some parameters are not found in sysconfigures.

CR:656475

CR Number:   656475 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2011 Fixed Description After changing the server's default sort order id from 52(no-case) to 50(binary), INSERT into list partitioned tables may result in error 9573.

CR:656566

CR Number:   656566 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2011 Fixed 25 Feb 2011 One-off Provided 25 Feb 2011 One-off Provided 02 May 2011 One-off Provided 26 Mar 2012 One-off Provided 07 Apr 2012 Insufficient priority to fix 07 Mar 2012 One-off Provided 27 Jun 2012 Fixed Description On AIX platforms, a client session running a batch job may be terminated with error "ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect] SQLCODE[-84083974]" and the ASE errorlog is logged with message"kernel nrpacket: recv, Resource temporarily unavailable, spid: <spid>, suid: <suid>".

CR:656582

CR Number:   656582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Apr 2013 Duplicate Description An update statistics with sampling operation that runs out of space in tempdb may fail to properly abort. This may cause an infinite loop of Error 1105, Msg 140030 or other errors.

CR:656606

CR Number:   656606 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Mar 2011 Fixed 18 Mar 2011 One-off Provided 23 Sep 2012 Fixed Description The message "current process infected with 11" in the module 's_retparams' together with a stack trace which includes the modules 's_setreturns' and 'execproc' may be reported in the error log when a SELECT statement is run on a table having an encrypted column and the configuration parameter "statement cache size" is greater than 0. Workaround Description  Set "statement cache size" to 0.

CR:656619

CR Number:   656619 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2011 Work as design Description sybcluster might not work if uaf agent or host is abruptly shutdown. Workaround Description  1) Start UAF agents on all nodes 2) Run Sybcluster and attach to the agents 3) Execute the "deploy agent" command for each node

CR:656643

CR Number:   656643 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2011 Fixed 14 Mar 2011 Fixed 23 Dec 2014 Fixed Description In rare scenarios when invalid tds packets are received, Adaptive Server gets infected with signal 11.

CR:656782

CR Number:   656782 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2011 Fixed 07 Feb 2011 Fixed 09 Feb 2011 Fixed 10 Feb 2011 Fixed 17 Feb 2011 Fixed 28 Feb 2011 Presently Not Targeted For Any Future Release Of This Product Description With 'enable functionality group' is enabled, executing a DYNAMIC QUERY may hit signal 11 together with a stack trace involving the module tdsrecv__dynexec_xoltp() in case of recompilation.

CR:656835

CR Number:   656835 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2011 Consult Complete Description creating spinlock contention artificially

CR:656902

CR Number:   656902 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.7 SP60 20 Nov 2013 Fixed 15.7 SP121 21 Nov 2013 Fixed 08 Oct 2013 Fixed 09 Apr 2014 Port Not Needed Description If a query contains a join between partitioned tables and one of the partitioned tables degenerates to a single partition through dynamic partition elimination and there is a CIS table in the query, then a SEGV could occur in the PartNodeInfo::collocatedSite() method. Workaround Description  Trace commandline flag 16980 works around this problem. However, there could be cases where performance suffers with this tcf. The scenario would be a query with a unbounded predicate (variable present) on a table's partitioning key such that all but one partition is eliminated and an order by clause where there exists an underlying local index that satisfies the needed ordering.

CR:657023

CR Number:   657023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2011 Duplicate Description IF (SELECT ...) statements can perform poorly. Workaround Description  Either turn off merge_join or turn off parallel

CR:657097

CR Number:   657097 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DBCC commands will currently tell you that the consistency of data is ok when the data in a table is not capable of being decrypted by the current key values. This feature requests a more complete check of the data which would identify data rows and columns having decrypt problems.

CR:657187

CR Number:   657187 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for syslogins table to be altered such that the columns 'pwdate', 'lastlogindate', 'crdate' & 'lockdate' have type datetime (usertype = 12) instead of datetimn (usertype = 15). Workaround Description  Unknown.

CR:657249

CR Number:   657249 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2012 Added to user documentation Description Attempting a normal shutdown on a dataserver will not terminate batches of sql which include infinite looping and waitfor delay tsql. Current documentation leads one to believe that loops will be terminated at the end of current sql statements. Workaround Description  Code while loops to check for shutdown or use "shutdown with wait=<time>".

CR:657271

CR Number:   657271 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2011 Fixed Description A 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache", may be reported followed by a stacktrace involving LeScrContext::updCacheStat when a query tries to acquire the cursor cache. Workaround Description  Increase procedure cache.

CR:657320

CR Number:   657320 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.7 Drop#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2011 Fixed 08 Feb 2011 Fixed 09 Feb 2011 Fixed 10 Feb 2011 Fixed Description With enable functionality group is enabled, executing a CURSOR FETCH may result in a signal 11 together with a stack trace involving the module LeEmitSndOp::_LeEoCopyParams().

CR:657326

CR Number:   657326 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Disk mirror should not report an error on a different database device when we mirror a database device which is used by archive database which is doable.

CR:657353

CR Number:   657353 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2011 Fixed Description Monitor elements SMC_NAME_PAGE_LOGICAL_READ and SMC_NAME_PAGE_PHYSICAL_READ may be calculated incorrectly. The logical and physical read counts are coming out the same, even when queries that only do logical reads are executed.

CR:657380

CR Number:   657380 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2011 Fixed Description The RowsAffected column in MDA table monSysStatement is incorrect for parent procedures.

CR:657407

CR Number:   657407 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2011 Fixed 16 Jun 2011 Fixed Description The error message, "There is heap memory not freed for spid <spid_id>. This heap memory pool will be destroyed", may be reported when ALTER TABLE command fails.

CR:657466

CR Number:   657466 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request for improvements to the number of recovery threads at start-up.

CR:657495

CR Number:   657495 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2013 Not reproducible with latest version of the product available as of Resolution Date Description If set 'optimization level' to ase1503 ESD2 or up, then a complex query joining more than six tables and having a few subqueries may get a slow query plan with suboptimal join order. The problem is due to a side effect of the fix of CR 550574 and avoid_bmo_sorts optimization criteria. Please try 'set avoid_bmo_sorts off' to workaround the problem. Workaround Description  By default, opt criteria avoid_bmo_sorts is off and doesn't show the problem. If you need to set optimization level to ase_current or other optimization level having the fix of CR 550574( on 1503 ESD2 or up), then a workaround is set avoid_bmo_sorts off

CR:657522

CR Number:   657522 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2011 Fixed Description After a polite ASE shutdown, no_recovery durability databases whose log segment is mixed with data segments may have inaccurate free space counts. Workaround Description  There are many workarounds : use "shutdown with nowait", use boot trace flag to force free space recalculation, use dbcc usedextent(dbname, 0, 1, 1) to recalcule the free space counts ...

CR:657529

CR Number:   657529 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description recovery takes longer when database have mixed data and log segement. Workaround Description  Separate log and data.

CR:657585

CR Number:   657585 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2011 Duplicate Description An 1105 error on the system segment during upgrade may occur despite preupgrade indicating the database has sufficient space.

CR:657590

CR Number:   657590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2012 Fixed Description DBCC LISTOAM on an invalid index ID may failed silently without any error message.

CR:657619

CR Number:   657619 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description capability for user written stored procedures to replicate work that would normally be replicated through master database replication.

CR:657655

CR Number:   657655 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2011 Fixed Description sp_helprotect shows only public permission instead of permissions of group that the user belongs to.

CR:657705

CR Number:   657705 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2011 Fixed 08 Feb 2011 Fixed Description The message "Current process infected with signal 11 (SIGSEGV)" followed by a stack trace that includes the module crdb_main() can be raised when trying to create a new database and the configuration parameter "number of open databases" has already been exceeded.

CR:657769

CR Number:   657769 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Open OS:   Solaris Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sysam support for cpu-cap with subcapacity liceneses

CR:657797

CR Number:   657797 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server New Features Guide Status:   Closed OS:   NA Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2012 Added to user documentation Description Document more clearly that turning on statement cache can have a impact on @@nestlevel and @@procid.

CR:657820

CR Number:   657820 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description set tracing needs mon_role for show_sqltext on if statement cache is on Workaround Description  either dbcc purgesqlcache each time before running the query or grant mon_role to the user who does the tracing.

CR:657855

CR Number:   657855 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description document feature error: 722 "Procedure cache exhausted before a query plan could be found"

CR:657899

CR Number:   657899 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE does not perform character set conversion on a text column if a jConnect application uses a PreparedStatement class and sets over 16KB length string data as a parameter. Workaround Description  Don't use PreparedStatement class. Instead, use Statement class.

CR:657908

CR Number:   657908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2011 Added to user documentation Description

CR:657963

CR Number:   657963 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Mar 2011 Fixed 31 Mar 2011 One-off Provided 21 Jul 2011 Fixed 18 Sep 2012 One-off Provided 11 Sep 2012 Fixed Description Error message 233 appears when a ISNULL clause is present in a SELECT INTO EXISTING query where the target table is a proxy table.

CR:657989

CR Number:   657989 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a batch size option for atomic INSERT, DELETE, and UPDATE statements that would break large atomic operations into multiple smaller independently-committed transactions.

CR:657997

CR Number:   657997 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2011 Fixed Description House keeper task never writes the in-memory statistics (SYSTABSTATS) of table created with 'for load' option to disk. This may result in sub optimal plans after un-paritioning the table.

CR:658094

CR Number:   658094 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Remove the impact Enable statement cache have on @@nestlevel and @@procid.

CR:658102

CR Number:   658102 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2011 Added to user documentation Description APs are not generated when statement cache on, and the statement cache has an entry for the query.

CR:658105

CR Number:   658105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2011 Fixed 18 Mar 2011 Reservation Made Description "set switch serverwide on 'disable_minmax_optimization' with override" has been enhanced with new session level criteria "set allow_minmax -1|0|off|1|on". It can also be used in query level AP to control just that query.

CR:658109

CR Number:   658109 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   NA Original Version:   2.2.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2011 Fixed Description Client connections to an AIX server occasionally fail due to the server being busy performing it's periodic CPU license checks. When this occurs the os_populate_cpu_info() function will be seen on the process stack. The default CPU licensing counting mechanism has been changed, however the original behavior can be re-instated by setting the environment variable SYBASE_SAM_CPUINFO=ORIGINAL

CR:658122

CR Number:   658122 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   all Original Version:   15.5 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2011 Fixed Description The DBCCLOG command in sybmon is extended to support reading dumps taken on a server with a logical page size greater than 2KB.