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

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

CR:624923

CR Number:   624923 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Apr 2010 Duplicate Description Reorg rebuild or AMC may get into infinite loop that prints message Error: 8203, Severity: 26, State: 18 when concurrently run with selects.

CR:624938

CR Number:   624938 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2010 Duplicate Description alternative greedy algo takes too long to complete in parallelism mode Workaround Description  There are several workarounds: ------------------------------ 1) Increase "max parallel degree" to be at least one greater than "max scan parallel degree" AND increase timeout limit. I found that a setting of "set plan opttimeoutlimit 50" did the trick in this case. OR 2) Set "max scan parallel degree" to 1. OR 3) Turn off parallelism or change the IN list in the query

CR:624979

CR Number:   624979 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2010 Fixed 31 May 2010 Fixed 07 Mar 2014 Insufficient priority to fix Description Performance drop with sp_helprotect on databases with large syscolumns tables. Workaround Description  Use the script for sp_helprotect from 15.0.2.

CR:624996

CR Number:   624996 Product Name:   Adaptive Server Enterprise Product Component:   QPtune Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2010 Fixed Description QPTune encounters premature end of file error when there is a different version of xercesImpl.jar released under $SYBASE_ASE/lib directory which might cause compatibility problems with QPTune. So we updated the classpath for running QPTune command to search xercesImpl.jar only under QPTune's own lib directory. Workaround Description  Modified the libs entry in the QPtune script so that $SYBASE/$SYBASE_ASE/qptune/lib/xercesImpl.jar is before $SYBASE/$SYBASE_ASE/lib/xercesImpl.jar For example: libs="$SYBASE/$SYBASE_ASE/lib/qptune.jar:$SYBASE/jConnect-6_0/classes/jconn3.jar: $SYBASE/$SYBASE_ASE/qptune/lib/xercesImpl.jar:$SYBASE/$SYBASE_ASE/lib/xercesImpl.jar: $SYBASE/$SYBASE_ASE/lib/xml-apis.jar:$SYBASE/$SYBASE_ASE/qptune/lib/xml-apis.jar: $SYBASE/$SYBASE_ASE/qptune"

CR:625009

CR Number:   625009 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description upgrade does not detect and fix id column for external proxy file system access Workaround Description  All external proxy tables must be dropped and recreated.

CR:625010

CR Number:   625010 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A feature request for alter table where error 14127 would be raised if necessary during the initial phases of the operation.

CR:625116

CR Number:   625116 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2010 Added to user documentation Description There is a typing error in the online documentation in the section describing the procedure sp_chgattribute for ASE 15.0 and upward. In Example 11, the object name has been ommited from the command syntax. The first parameter after the stored procedure name has been omitted. This should read: Example 11 Switches the deallocation for text and image space on using dealloc_first_txtpg: sp_chgattribute "mytable","dealloc_first_txtpg", 1 To switch the feature off: sp_chgattribute "mytable","dealloc_first_txtpg", 0

CR:625133

CR Number:   625133 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description With UTF-8 charset charindex, str_replace maybe give wrong result for space and , on non binary sortorder.

CR:625144

CR Number:   625144 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) 07 Jun 2010 Fixed 15 Apr 2010 Presently Not Targeted For Any Future Release Of This Product 02 Jun 2010 Consult Complete Description Sometimes the bind cache operation can raise an error 834 at an instance, when one of the other instances crashes.

CR:625146

CR Number:   625146 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   15.0.1.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2010 Fixed 29 Mar 2011 Presently Not Targeted For Any Future Release Of This Product Description ASE CE setup with multiple buffer pools and multiple cache configured may hit timeslice with lock_multiple_physical function in call stack.

CR:625178

CR Number:   625178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feat req: Incorporate Unix groups into user authentication - Kerberos

CR:625200

CR Number:   625200 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) 02 Jun 2010 Fixed 22 Apr 2010 Fixed 22 Apr 2010 Reservation Made 23 Apr 2010 Fixed Description The dump and load operation initiated by specific ASE version and involving database devices with directio or dsync property may fail with error "Option 'iomode' is not valid" when Backup Server does not support 'iomode' option.

CR:625217

CR Number:   625217 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) 07 Nov 2013 Fixed Description UPDATE STATISTICS command on a proxy table writes the wrong page count for a row having indid 0 or 1 into systabstats system table if the ASE page size is more than 2K.

CR:625226

CR Number:   625226 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) 04 Nov 2013 Not reproducible with latest version of the product available as of Resolution Date Description ASE mis-calculates the used data page count of a proxy table retrieved from systabstats and puts it in memory if the proxy table is an APL table with a clustered index.

CR:625298

CR Number:   625298 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add diagnostics for error 707, state 10 retcode=-10

CR:625356

CR Number:   625356 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) 26 Apr 2010 Fixed 29 Apr 2010 Fixed Description Diagnostics with "set option show_lio_costing on" was incorrectly reporting large I/O prefetch being used when eventually it was not Workaround Description  - use compatibility mode - force prefetch - use trace flag 15326

CR:625360

CR Number:   625360 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2010 Fixed Description Reorg processing messages seen in too long intervals.

CR:625365

CR Number:   625365 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2010 Fixed Description Internal only. Implement new stored procedure feature in Bharani to report status of external passwords and hidden text protected by service key.

CR:625383

CR Number:   625383 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   AIX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2010 Duplicate Description Server build failed using srvbuildres if the resource file including below items: sqlsrv.avail_physical_memory: PUT_THE_AVAILABLE_PHYSICAL_MEMORY_FOR_ASE_IN_OPTIMIZATION sqlsrv.avail_cpu_num: PUT_THE_AVAILABLE_NUMBER_CPU_FOR_ASE_IN_OPTIMIZATION. Workaround Description  After removing the description string for sqlsrv.avail_physical_memory and sqlsrv.avail_cpu_num, srvbuildres can build server. Use: ===== sqlsrv.avail_physical_memory: sqlsrv.avail_cpu_num:

CR:625392

CR Number:   625392 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request for ASE to support Native hierarchical XML publication.

CR:625395

CR Number:   625395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2010 Bundled Request Description The error Msg 3114, "Database does not have an entry in Sysdatabases", can be seen at load transaction time, if we load several transaction dump repeatedly into an archive database, each of them from a different node.

CR:625429

CR Number:   625429 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description To support CIO on AIX for ASE

CR:625430

CR Number:   625430 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2010 Fixed Description The error Msg 12594,"Unable to obtain exclusive access to database '<archive_db>' can be raised when bringing an archive database online on a node in the cluster if the database is loaded repeatedly and each load is done in a different node.

CR:625572

CR Number:   625572 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) 21 May 2010 Fixed 07 Jun 2010 One-off Provided Description Alter table add partition command on APL tables with clustered index will zero out the table statistics while writing new rows to SYSTABSTATS catalog. Workaround Description  run dbcc checktable drop and recreate the clustered index

CR:625582

CR Number:   625582 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jun 2010 Fixed Description Version string is truncated in sp_sysmon output.

CR:625627

CR Number:   625627 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central Plug-in Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2010 Fixed 19 Apr 2010 Fixed Description When a 32-bit release is installed on a 64-bit Unix system, Sybase Central launch script doesn't launch Sybase Central. The workaround is to re-define SYBASE_JRE6 to point to SYBASE_JRE6_32.

CR:625660

CR Number:   625660 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) 14 Apr 2010 Fixed 14 Apr 2010 Fixed Description ASE 15.5 Cluster Edition may raise error 820 in rare conditions, when multiple tasks are actively inserting and modifying data.

CR:625722

CR Number:   625722 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) 30 Apr 2010 Fixed Description Migration of a client spid from one node to another will fail when using SSL connections. Many errors will be produced with -6989 in the error message.

CR:625780

CR Number:   625780 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2010 Fixed 21 Sep 2010 Reservation Made 07 Oct 2010 Fixed 11 Oct 2010 Fixed Description Oam recount thread during failover recovery performance is very slow. Workaround Description  The threshold manager recovery process could be speed up if customers suppress free-space accounting and execution of threshold actions for the nonlog segments. They can do that by the following command: sp_dboption <dbname>, 'no free space acctg', true

CR:625796

CR Number:   625796 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description FEATURE REQUEST: ability to monitor physical i/o by virtual page

CR:625816

CR Number:   625816 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) 18 Apr 2010 Fixed 18 Apr 2010 Fixed 23 Apr 2010 One-off Provided 10 Jun 2010 Insufficient info provided Description Fix the 832 error when building index.

CR:625977

CR Number:   625977 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2010 Fixed 21 May 2010 Fixed 21 May 2010 Fixed 26 May 2010 Fixed 04 Jun 2010 Fixed 03 Jun 2010 Fixed 23 May 2010 Fixed 21 May 2010 Fixed 24 May 2010 Fixed 26 May 2010 Fixed 01 Jun 2010 Fixed 03 Jun 2010 Fixed 02 Jun 2010 Fixed 28 May 2010 Fixed 27 May 2010 Fixed 10 May 2010 Reservation Made 13 May 2010 Reservation Made 18 May 2010 Reservation Made 21 May 2010 Reservation Made 17 May 2010 Reservation Made 20 May 2010 Fixed 18 May 2010 Reservation Made 21 May 2010 Reservation Made 24 May 2010 Reservation Made 24 May 2010 Reservation Made 07 Jun 2010 Fixed 31 May 2010 Presently Not Targeted For Any Future Release Of This Product 25 May 2010 Reservation Made 24 May 2010 Reservation Made 28 May 2010 Reservation Made 31 May 2010 Fixed 30 May 2010 Reservation Made 02 Jun 2010 Reservation Made 02 Jun 2010 Reservation Made 03 Jun 2010 Reservation Made 04 Jun 2010 Reservation Made 07 Jun 2010 Reservation Made 08 Jun 2010 Fixed 08 Jun 2010 Fixed 08 Jun 2010 Reservation Made 08 Jun 2010 Reservation Made Description Adaptive Server 15.5 ESD #2 adds wait event IDs and descriptions to monSysWaits and monProcessWaits monitoring tables to improve their wait event reporting and eliminating situations in which the same wait event ID was used to report more than one wait event. Adaptive Server 15.5 ESD #2 also adds new descriptions to the monWaitEventInfo monitoring table.

CR:626000

CR Number:   626000 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) 30 Jun 2010 Fixed 02 Jul 2010 Fixed 02 Jul 2010 Fixed Description A 702 error, "Memory request for <big number> bytes exceeds the size of single page of 16384 bytes" or some random stack traces may be reported in the error log when a stored procedure (or SQL user defined function) which contains an insensitive cursor involving an expression which results in a size bigger that 255 bytes is executed by reusing a plan generated by a previous session. Workaround Description  For the procedure having the insensitive cursor just avoid to reuse the same plan: this can be achieved with CREATE ... WITH RECOMPILE or EXEC ... WITH RECOMPILE

CR:626029

CR Number:   626029 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) 12 May 2010 Fixed Description If SSL is used, trace flag "3608" will cause ASE dataserver startup to fail.

CR:626258

CR Number:   626258 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2010 Fixed Description In situations where only index ddl has been generated, the existence check for the index will not exclude the entry in sysindexes for the table itself. This could lead to a failed drop index on running the script in scenarios whereby a table has the same name as one of its indices. Workaround Description  create the table and index ddl at the same time (i.e. -TU and don't use -FI to filter the indices out) or manually modify the script.

CR:626273

CR Number:   626273 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2010 Not a Bug Description XPserver: Include files to build Extended Procedure sample xp_echo are missing from ASE 15.5 GA release. Workaround Description  Unknown.

CR:626423

CR Number:   626423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jun 2010 Fixed Description When upgrading ASE, ASE may encounter conn_migrate_read_context error when restarting, if it was shutdown with migrations in progress. Workaround Description  Manually delete stale migration rows from syssessions.

CR:626435

CR Number:   626435 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 May 2010 One-off Provided 28 May 2010 Fixed 01 Jun 2010 Fixed Description Signal 11 in LeSQLRep::LeSQLRep is happening occasionally when using SQL statement replication and the ASE is configures with CIS services to access non ASE servers.

CR:626449

CR Number:   626449 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2010 Fixed Description Error: 605 may be seen in the error log accompanied by a read failure under a scenario whereby a rollback has been performed on an insert via an insert trigger and a further insert..select then references a text column from the inserted logical table. It is not supported to reference text (or other LOB off-row storage) datatype columns in the inserted\logical tables used by a trigger. inserttext() will be seen in the stack trace. From 15.0.3 ESD#4, we will raise error 2116 and prevent the trigger from being created.

CR:626458

CR Number:   626458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2010 Fixed 26 Apr 2010 Fixed 26 Apr 2010 Fixed Description When sybase NULL semantics are enabled i.e. set ansinull off (which is the default) then there is a possibility of a wrong answer when a DISTINCT, ORDER BY, or GROUP BY is used in the query with = NULL .... or an equi-sarg like = @v1. The behavior is as if ansinull is on, which would eliminate NULLs. Workaround Description  issue not seen using compatibility mode. trace flag 15313 use IS NULL instead of = NULL to test for NULL

CR:626464

CR Number:   626464 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) 29 Apr 2010 Added to user documentation Description the doc communicates that one could send all 14 (7 pairs) of arguments at one time ... now granted the sp_lmconfig then executes without error but only the first 2 (pair) of parameters / arguments were used to change anything . the following syntax is incorrect ... sp_lmconfig [ 'edition' [, edition_type ]] [ , 'license type' [ , license_type_name ]] [ , 'smtp host' [ , smtp_host_name ]] [ , 'smtp port' [ , smtp_port_number ]] [ , 'email sender' [ , sender_email_address ]] [ , 'email recipients' [ , email_recipients ]]] [ , 'email severity' [ , email_severity ]] the following syntax is correct ... sp_lmconfig [ [ 'edition' [, edition_type ]] | [ 'license type' [, license_type_name ]] | [ 'smtp host' [, smtp_host_name ]] | [ 'smtp port' [, smtp_port_number ]] | [ 'email sender' [, sender_email_address ]] | [ 'email recipients' [, email_recipients ]]] | [ 'email severity' [, email_severity ]] ]

CR:626471

CR Number:   626471 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2010 Fixed 15 Jun 2010 Fixed 20 Jul 2010 Deferred 02 Jun 2014 Presently Not Targeted For Any Future Release Of This Product 13 Jul 2010 Fixed 29 Jun 2010 Fixed 29 Jun 2010 Fixed 26 Jul 2010 Fixed 17 Aug 2010 Fixed 17 Aug 2010 Reservation Made 25 Aug 2010 Fixed Description Performance of log scans are negatively impacted by the fix for CR 623307. CR 623307 fixed a problem in which a 692 error might be reported by the Adaptive Server Replication Agent task. The current fix besides addressing that performance issue it ensures that a scanner of the log is able to recognize a stale log page and refresh it.

CR:626534

CR Number:   626534 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Dec 2011 Fixed Description A 7928 error, "Index <idx_name> is not consistent; found <num1> leaf rows but <num2> data rows.", may be reported when running DBCC CHECKTABLE with bottom_up option on a non-empty dol table having one or more indexes.

CR:626618

CR Number:   626618 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description extend 'order by' clause functionality for 'group by' -specify columns by their IDs (1, 2, 3, ...)

CR:626619

CR Number:   626619 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2010 One-off Provided 05 Jun 2013 Presently Not Targeted For Any Future Release Of This Product Description For the system that is heavily use local temp DBs, performance degradation may be noticed for the time being, and long lock hash chains may showed up in "lockhash" output for table locks.

CR:626623

CR Number:   626623 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) 06 Oct 2010 Duplicate Description REORG: Access to table while REORG REBUILD is running

CR:626655

CR Number:   626655 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) 03 May 2010 Fixed Description If there is an instead of trigger on a view and this trigger has an outer join of inserted or deleted table with other table or view, it could raise 225 error msg when insert/delete/update this view. Workaround Description  See descriptions

CR:626711

CR Number:   626711 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2010 Fixed 26 Aug 2010 Fixed Description There will be exception stack trace when NTLM is used for authentication in 15.0.3ESD#2 on Windows platform.

CR:626744

CR Number:   626744 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2010 Fixed 19 May 2010 Presently Not Targeted For Any Future Release Of This Product 16 Aug 2010 Fixed Description Bigdatetime/Bigtime types are not disabled under compatibility mode under some circumstances.

CR:626767

CR Number:   626767 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) 01 Jun 2010 Fixed 09 Jun 2010 Fixed Description Deferred compilation is sometimes not used for a statement with LIKE clause.

CR:626833

CR Number:   626833 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2010 Fixed 12 May 2010 Bundled Request Description cpuinfo.mechanism=NOAPICCHECK exists in ASE-15_0/sysam/<server>.properties file

CR:626839

CR Number:   626839 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2010 Fixed 26 Apr 2010 Fixed Description ASE on hppa64 platform can hit SIGBUS in poll_using_memory function when we do disk init on raw devices. Workaround Description  Disable async i/o. Use filesystem devices.

CR:626890

CR Number:   626890 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2012 Fixed 07 May 2012 Reservation Made Description Per page compaction for DOL with fixed length rows is enabled for REORG RECLAIM_SPACE

CR:626897

CR Number:   626897 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description On a server that has statement cache enabled, executing a very large SQL query may cause signal 11 and a stack trace starting in the function sqx__do_transform. The problem can be avoided if statement cache is disabled before executing the query. Workaround Description  The simple workaround is to turn off statement cache before executing the query: set statement_cache off go Execute problem query set statement_cache on go Alternatively turn off statement cache for the server.

CR:626918

CR Number:   626918 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2010 Fixed 04 Aug 2010 Fixed 05 Aug 2010 Fixed Description Heap memory growth is observed when a readtext or writetext command on a textpointer pointing to a proxy column is executed repeatedly.

CR:627065

CR Number:   627065 Product Name:   Adaptive Server Enterprise Product Component:   ssm Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2011 Not a Bug Description ASE goes into grace when local host properties has LT=OT Workaround Description  change the local host sysam properties file from LT=OT to LT=SR

CR:627074

CR Number:   627074 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2011 Not reproducible with latest version of the product available as of Resolution Date Description DBISQL cancel button not effective in canceling executing query.

CR:627103

CR Number:   627103 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2010 Presently Not Targeted For Any Future Release Of This Product 04 May 2010 Fixed 04 May 2010 One-off Provided 04 May 2010 Fixed 13 May 2010 One-off Provided 26 Feb 2009 Fixed Description Login performance degrade when there are a large number of multiple simultaneous connections that use a single or a small pool of Syslogins login credentials.

CR:627114

CR Number:   627114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2010 Third Party Problem 13 Sep 2010 Third Party Problem Description ASE configured with hugepages on Linux platform hits leak in hugepages in every boot-shutdown of ASE due to Linux kernel bug https://bugzilla.redhat.com/show_bug.cgi?id=593131 . Install Linux kernel patch for this bug to resolve the memory leak.

CR:627118

CR Number:   627118 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2010 Fixed Description DDLGEN write objects the order depends on the object ids in sysobjects. This makes it very hard to find differences Workaround Description  isql -Usa -S<server_name> -P | tee /tmp/objout >use pubs2 >go > select type, name from sysobjects order by type, name > go ... >quit 2. Edit /tmp/objout to get rid of any headers, system tables, etc. 3. Run a script like this: #!/bin/ksh a=1 for b in `cat /tmp/objout` do if [ $a -eq "1" ] then type=$b else ddlgen -Usa -Shostname:port -P -Dpubs2 -T$type -N$b fi a=`expr 1 - $a` done > ddlgen.out

CR:627161

CR Number:   627161 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) 04 May 2010 Fixed 04 May 2010 Fixed Description In ASE cluster edition, server may hang after seeing error 8243 when doing "alter table unpartition" on table created for load.

CR:627166

CR Number:   627166 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   amboise EBF9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2012 Presently Not Targeted For Any Future Release Of This Product Description Customer modified the standard resource file (XML Schema Model language ) "xsd.xsl" by adding customized Property tab page (e.g. for Element in XSM). With the new tab page, it includes the original NAME property in Element entity. It is discovered that modifying the NAME property, the corresponding CODE property will not be changed together as the default General tab page.

CR:627201

CR Number:   627201 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2010 Third Party Problem Description When allocating large shared memory segments on a Red Hat 5.4 system, which also has one or more ramdisk mounted, it may take a very long time for Linux to return the shared memory to the ASE server. Workaround Description  Set /proc/sys/vm/zone_reclaim_mode = 0

CR:627222

CR Number:   627222 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) 07 Jun 2010 Fixed 30 Aug 2010 Reservation Made 15 Jun 2010 Fixed 15 Jul 2010 Fixed Description Adaptive server might update the values of few page counts in systabstats incorrectly especially for partitioned tables, when upgrading the database from any release to 15.0 or higher.

CR:627249

CR Number:   627249 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2010 Fixed Description The rowcount reported in sp_spaceused does not match with the actual row count.

CR:627447

CR Number:   627447 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) 04 May 2010 Fixed 29 Jun 2010 Fixed Description Add SMP or SDC to the ICU tools version strings to distinguish the two different binaries.

CR:627651

CR Number:   627651 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2010 Fixed 18 Oct 2010 Fixed Description Cluster may hang if a complex failure occurs when a node is shutdown and then killed. Workaround Description  Increase ShutdownWaitLimit from 60secs to prevent ASE from being shutdown during recovery. hares -modify <ASE resource> ShutdownWaitLimit <limit(seconds)> hares -modify ase ShutdownWaitLimit 600 Also increase OfflineTimeout from 300secs to prevent ASE from being shutdown during recovery. sudo hatype -modify Sybase OfflineTimeout <limit(seconds)> sudo hatype -modify Sybase OfflineTimeout 600

CR:627652

CR Number:   627652 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2010 Fixed 14 May 2010 Reservation Made 26 May 2010 Fixed Description Union all queries with a distinct select query on one or more sides of the UNION ALL may generate a SEGV during the cloning of the hash operator's input aligned data row. This will occur if there is a join between projected columns of differing lengths in at least one of the UNION ALLs select statements. Workaround Description  Workaround: turn off hash distinct set distinct_hashing off

CR:627675

CR Number:   627675 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 May 2010 Fixed 03 May 2010 Fixed Description The WITH DBID = <N> option to the CREATE DATABASE command does not work in ASE 15.5.

CR:627722

CR Number:   627722 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 May 2010 Fixed 28 May 2010 Fixed 01 Jun 2010 Fixed Description Intermittent memory errors resulting in various stack traces and 'infected with 11' messages may happen when executing a procedure with a cursor with union operator and if the query returns constant literal values. Workaround Description  create or execute a proc WITH RECOMPILE so that for each execution new plan would be generated

CR:627725

CR Number:   627725 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2010 Fixed 06 Jul 2010 Fixed 08 Jul 2010 Fixed Description This is a memory corruption issue and the following case could cause this memory corruption.If a table is created with a column of BIT datatype and this column is encrypted, after insert a row to this table, the memory could get corrupted. The subsequent queries could get stacktraces or some unexpected results.

CR:627751

CR Number:   627751 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 reorg rebuild on a single partition on a partitioned table with local indexes

CR:627881

CR Number:   627881 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2012 Added to user documentation Description Document Enhancement: Java performance can be improved on single-cpu machines by reducing the sp_configure "runnable process search count" setting. This results in ASE voluntarily yielding the CPU more often, which allows the OS to schedule the JVM sooner and more frequently.

CR:627901

CR Number:   627901 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) Description In rare circumstances, executing stored procedure including FUNCTION may raise error 325, Level 18, State 1. Workaround Description  set plan optgoal allrows_oltp for the query. Better to wrap it in plan "use optgoal allrows_oltp" in the proc.

CR:627908

CR Number:   627908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2010 Fixed 18 May 2010 Fixed Description BCP into a table with at least one encrypted columns and more than one "bit" type column raises 15417 errors on select of the rows. Workaround Description  bcp in data first before issuing the alter table encryption command (similar to the 2nd repro which got no problem ) or insert the data to an alternate table that doesn't have encryption and them insert select to the table that has encryption.

CR:627937

CR Number:   627937 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) 14 Nov 2010 Fixed 14 Nov 2010 Fixed Description When character set conversion is active, embedded null bytes followed by invalid characters may produce a TDS protocol error instead of expected error message 2403 or 2431. Workaround Description  Use command-line trace flag -T2416 or issue dbcc traceon(2416)

CR:627992

CR Number:   627992 Product Name:   SyBooks CD Product Component:   SyBooks Status:   Open OS:   MacOS Original Version:   11.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ASE 15.5 SYBOOKS will not install on a MAC JRE not found error Workaround Description  No work around can be found customer can use the Raw PDF files, thats about it.

CR:627993

CR Number:   627993 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) 05 May 2010 Fixed 05 May 2010 Fixed 05 May 2010 Fixed Description A 208 error may be mistakenly reported "<tablename> not found. Specify owner.objectname or use sp_help ..." with Adaptive Server 15.0.3 when a SELECT command is run against an archive database user table and the archive database dump was taken with Adaptive Server version prior to 15.0. Workaround Description  After loading the archive database run the command below. select dbinfo_update("<archive database name>","asevers",12540) go Also, if you reboot, the same command has to be run after the database has been automatically onlined.

CR:628012

CR Number:   628012 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Fixed 01 Jul 2010 Fixed Description Include EBF numbers in auditinit version string.

CR:628072

CR Number:   628072 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2013 Presently Not Targeted For Any Future Release Of This Product Description Currently there is a limitation with SOAP 1.2 support for certain web services. This is due to the current Axis 1.3 implementation within ASE Web Services. You may receive:- Msg 15200, Level 20, State 0: Server 'ws', Line 1: No web methods mapped to proxy tables for the WSDL URI on running sp_webservices 'add' against the wsdl Workaround Description  Need to change the namespace to point to soap 1.0\1.1 to allow it to be consumed:- For example:- Before change: xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" After change: xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap/"

CR:628077

CR Number:   628077 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2012 Added to user documentation Description Request to document the behaviour covered under IB entry 11371840. Since 11.9.2, to facilitate concurrency we raise a 2601 error on insert into a unique index on a datarows locking table if that key already exists (whether committed or uncommitted). There is no risk to data integrity. The request is really to document this from the perspective of the relaxation of the isolation level for this scenario.

CR:628124

CR Number:   628124 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2010 Fixed Description In ASE Cluster Edition, server may hang under rare circumstances while running utilities like ALTER TABLE.

CR:628174

CR Number:   628174 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2010 Fixed 10 May 2010 Fixed Description Job Scheduler may be aborted after getting spurious state from the JS Agent when number of jobs running simultaneously is equal to value of 'job scheduler tasks'.

CR:628284

CR Number:   628284 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) 28 Jun 2010 Fixed 29 Jun 2010 Fixed Description In a rare scenario it may happen that requested lock was granted , but the corresponding lock request is still sleeping.

CR:628292

CR Number:   628292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description OPTDIAG: Input mode raises datatype mismatch message for numeric column

CR:628305

CR Number:   628305 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) 14 May 2010 Fixed 14 May 2010 Reservation Made 15 May 2010 Fixed 20 May 2010 Fixed 26 May 2010 Fixed Description If forced indexes do not exist then table scans will be used instead of ignoring the bad index id and using the best index available Workaround Description  force an existing indid

CR:628311

CR Number:   628311 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2010 Fixed 09 Jun 2010 Reservation Made 11 Jun 2010 Fixed 11 Jun 2010 Fixed Description if a reformat on a table in a "multi-table" subquery is executed outside the subquery (i.e. it was "decorrelated") and if there are correlated joins to that table, then it is possible that cost of the reformat could be very underestimated resulting in a performance issue. optcriteria cr628311 associated with optlevel ase1503esd4 or trace flag 16909 will turn on the change to correct this issue. Workaround Description  We have suggested the customer to try a new index create nonclustered index HospitalServices_newind4col on SMSPHw0v001cm.dbo.HospitalServices(EpisodeID, EntityID, RevenueCode, Charges) so that the optimizer will consider this new index, rather than create a big worktable for reformatting. Compatibility mode works for customer's query, but the customer cannot apply compatibility mode. Feedback from the customer regarding workaround: The development group veto'd the compatibility mode due to application design.They are not able to change the code itself. Login trigger affects too much other code, since this application handles most of the code. Server wide has too much of a performance impact.

CR:628343

CR Number:   628343 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description XP Server may log the message "16331 - Recursive Calls to srv__seterr() in spid: nnn. Thread terminated." in the XP error log.

CR:628454

CR Number:   628454 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 lock timeout option for dbcc checkverify.

CR:628508

CR Number:   628508 Product Name:   Adaptive Server Enterprise Product Component:   MonitorServer Status:   Closed OS:   Microsoft Windows Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2010 Fixed Description Windows Only: Monserver boot failed when the ASE installation path include space character.

CR:628555

CR Number:   628555 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2010 Fixed 23 Jun 2010 One-off Provided 02 Jun 2010 Fixed 16 Jun 2010 Fixed 16 Jun 2010 Fixed 24 Jun 2010 Fixed 30 Aug 2010 One-off Provided Description Many long-running sessions which need to create worktables, could lead to a signal 11 (or storage access violation on Windows) in memset() and stacktrace. This is due to fragmentation in the Pss Session Heap memory pool Workaround Description  Increase 'heap memory per user' or 'number of user connections'

CR:628557

CR Number:   628557 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2010 Duplicate Description Different results may be obtained for a query that contains GROUP BY when using compatibility_mode. Workaround Description  dbcc traceon (15387) --to turn off 421607

CR:628566

CR Number:   628566 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) 16 May 2010 Fixed Description ASE incorrectly reports directio ON in sysdevices table, even if setting directio failed for devices not supporting directio.

CR:628590

CR Number:   628590 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Nov 2010 EOL'd version. Not to be Fixed. 21 Jul 2010 Fixed 21 Jul 2010 Fixed 29 Sep 2010 Fixed 31 Jan 2011 Presently Not Targeted For Any Future Release Of This Product Description 'drop role' sql may hit SIG11 in qualpage() due to faulty internal scan method

CR:628597

CR Number:   628597 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) 09 Jul 2010 Bundled Request Description In a shared disk cluster system, poor performance of failover recovery can result from an unnecessarily large number of disk writes that are performed when recalaculating OAM counts at the end of the failover recovery redo pass.

CR:628691

CR Number:   628691 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2010 Fixed 16 Jun 2010 Reservation Made 17 Jun 2010 Reservation Made 07 Jul 2010 Fixed 07 Jul 2010 Fixed 06 Jul 2010 Fixed 06 Jul 2010 Reservation Made Description When a stored procedure is first executed by a session with a particular SET ANSINULL setting (ON or OFF) and later a session with different SET ANSINULL setting executes the same stored procedure then the stored procedure is recompiled. This could cause excessive recompilations if the same stored procedure is executed concurrently by many sessions with different ANSINULL setting.

CR:628837

CR Number:   628837 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) 30 Mar 2012 Presently Not Targeted For Any Future Release Of This Product Description CPU utilization becomes 100% when procedure cache utilization is almost full. After this fix, boot time trace flag 753 is obsolete and large allocation auto-tune in memory manager is turned off by default. Use boot time trace flag 758 to turn on when necessary.

CR:628845

CR Number:   628845 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2010 Fixed 25 Jun 2010 Fixed 23 Jun 2010 Reservation Made 02 Jul 2010 Fixed 01 Jul 2010 Fixed Description If running optimizer level ase_current on 15.0.3 ESD#2 or higher (or any optimizer level from ase1503esd2), and your server is configured for parallel, you may see a degradation in performance for certain ORDER BY queries due to the avoid_bmo_sorts optimizer criterion being enabled. optcriteria cr628845 or trace flag 16912 will correct this issue. Workaround Description  set parallel_query 0 --or set avoid_bmo_sorts 0 --if running ase_current --or set plan optlevel ase_default --session or sp_configure 'optimizer level',0,ase_default

CR:628853

CR Number:   628853 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2010 Fixed 26 May 2010 Fixed 26 May 2010 Fixed 14 Sep 2010 One-off Provided Description update statistics on partitioned tables may be slower in 15.0.3 ESD #3 than previous ESDs.

CR:628867

CR Number:   628867 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 May 2010 Fixed 01 Jun 2010 Fixed Description signal 11 on solaris, and error 403 without stacktrace on aix with insert into a table after adding a check constraint on encrypted column with a decrypt_default