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

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

CR:634162

CR Number:   634162 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) 19 Sep 2010 Fixed Description Feature request to add 4 new messages equivalent to the messages currently logged in the ASE errorlog for reorg rebuild <tablename>. These should cover:- reorg rebuild <table> <index> & reorg rebuild <table> <index> partition <index_partitionname> Which would generate:- Beginning REORG REBUILD of index '%.*s' on table '%.*s'. REORG REBUILD of index '%.*s' on table '%.*s' completed. & Beginning REORG REBUILD of partition '%.*s' of index '%.*s' on table '%.*s'. REORG REBUILD of partition '%.*s' of index '%.*s' on table '%.*s' completed.

CR:634285

CR Number:   634285 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2010 Fixed 19 Jul 2010 One-off Provided 20 Jul 2010 Fixed 22 Jul 2010 Fixed 19 Jul 2010 Fixed Description A global reference to a Java object may be mistakenly destroyed twice, resulting in methods being executed unexpectedly due to class-loader structures getting corrupted. Alternatively Java Null Pointer Exceptions may be raised within classes unexpectedly. When global references get destroyed repeatedly, this will result in the COTS JavaVM aborting.

CR:634321

CR Number:   634321 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2010 Fixed 15 Feb 2011 Fixed Description The values of the monStatementCache table TotalSizeKB and UsedSizeKB columns are incorrect on servers using page size greater than 2K.

CR:634454

CR Number:   634454 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description investigate: self-deadlocks and causing 12311 error when running online index reorg on 12.5.4 esd #10

CR:634491

CR Number:   634491 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2010 Fixed Description If more than one -T parameters are used in ddlgen, e.g, ddlgen -Usa -S... -P... -D... -TD -TI -TLK -TKC -TR -TRI -TSGM -TTR -TU -TV -N% , ddlgen does not print a syntax error.

CR:634536

CR Number:   634536 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) 04 Aug 2010 Fixed Description In some circumstances the message "current process infected with 10" in the module 'rtrim_unichar' or 'lower_unichar' maybe be reported in the error log when it is executed a query joining two or more tables and using the functions RTRIM() or LOWER() on a column of datatype UNICHAR or UNIVARCHAR. Workaround Description  - Disable MERGE JOIN, for example with: 'set merge_join off' OR - Run the query using compatibility mode: 'set compatibility_mode on'

CR:634619

CR Number:   634619 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) 12 Jul 2010 Duplicate Description Transaction block it self when DDL involve Constraint.

CR:634635

CR Number:   634635 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 Customer needs to present a client certificate to consumer https site. He is unable to give direct webservices to use this certificate and integrate it into a keystore for usage. Gets error 403 when trying to access the https location because of no authentication. Workaround Description  # consumer properties added for client certificate javax.net.ssl.keyStore = /work/play/allianceBernstein/keystore.jks javax.net.ssl.keyStorePassword = XKWMEDIC to the ws.properties file. Also one could add the same to the runws file. One could use the pkcs12 file directly by adding the property for javax.net.ssl.keyStoreType = PKCS12

CR:634666

CR Number:   634666 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description doc bug: tibjms.jar file is different in newer versions

CR:634679

CR Number:   634679 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2010 Fixed 08 Sep 2010 Bundled Request Description If an additional language has been installed to the ASE, sp_passwordpolicy "list" incorrectly shows 2 rows.

CR:634692

CR Number:   634692 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) 21 Aug 2014 Insufficient priority to fix Description If an additional language has been installed to the ASE, sp_getmessage may show a conversion failure message or a localized message when an error occurs even if you connect to the ASE with us_english language.

CR:634694

CR Number:   634694 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) 21 Aug 2014 Insufficient priority to fix Description If an additional language has been installed to the ASE, sp_helpconfig may show a conversion failure message or a localized message even if you connect to the ASE with us_english language.

CR:634722

CR Number:   634722 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) 05 Sep 2011 Insufficient info provided Description Signal 10 and/or signal 11 may occur in CtlibRemoteAccess::_connectionState(sdes**) for a session which has earlier used an cursor.

CR:634735

CR Number:   634735 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) 22 Aug 2010 Fixed Description When using SQL statement replication, Replication Agent may shutdown reporting the error 9202, Severity 20, State 0, if the replicated table has a trigger and the SQL DML within the trigger attempts to use SQL Statement replication as well. Workaround Description  Disabling SQL Statement replication. sp_setrepdbmode <db name>, "udis", "off" go

CR:634759

CR Number:   634759 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) 15 Jul 2010 Fixed Description Under certain circumstances executing a procedure when using the with recompile clause can cause a stack trace if that procedure references a view which in turn has an instead of trigger and the view and trigger have been dropped and recreated between invocations of the procedure. Workaround Description  If it is necessary to drop the view/instead of triggers referenced by a stored procedure, avoid the with recompile clause when executing the procedure for the first time following the re-creation of the view and trigger.

CR:634801

CR Number:   634801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description CIS query fails with error ORDER BY error 169 in 1503 and 155

CR:634808

CR Number:   634808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2010 Fixed Description Under some rare cases, if a query involving processing an IN list with an expression, it could stacktrace during query plan compile time. Workaround Description  There are at least a couple workarounds which may help. The problem is due to processing an IN list with an expression. If there are a large number of elements in the IN list (~128+), then trace 15393 will help by turning off large IN list transformations. The repro mentions 300 elements in the IN list. Compatibility Mode is another possible workaround (if there is nothing which would disallow compat mode). We'd recommend using this for the specific problem queries, as setting compat mode by default has a much wider impact. Using Abstact Plans is another possibility if they can make updates for the specific problem query.

CR:634861

CR Number:   634861 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 Jul 2010 Not a Bug Description Transaction block with a rang lock when DDL involve Constraint.

CR:634875

CR Number:   634875 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2010 Fixed 16 Aug 2010 Fixed 05 Oct 2010 Fixed 08 Oct 2010 Fixed Description ASE 15.5 running on Windows cant be shutdown using the Windows Services Manager. Stack trace is seen in error log referring to storage access violation in syb_polite_shutdown Workaround Description  The server can be shutdown from ISQL using the shutdown command. To work around the problem, manually shutdown the server when required using ISQL.

CR:634947

CR Number:   634947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2010 Fixed 28 Mar 2013 Fixed 18 Oct 2010 Fixed Description Under certain circumstance, dropping a global database within a multi-node cluster may fail due to CIPC message contention.

CR:634993

CR Number:   634993 Product Name:   Unified Agent Product Component:   Agent Client Status:   Closed OS:   Windows XP Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2010 Fixed 15 Sep 2010 Fixed Description Lookup of the inetaddr attribute in the UDP response packet was modified to lookup explicitly (based on attribute name) rather than positionally.

CR:635012

CR Number:   635012 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 Add a MDA table for dynamic SQL LWPs.

CR:635017

CR Number:   635017 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 Add a function as lwp_number_count(spid) to report number of dynamic SQL LWPs for this spid.

CR:635018

CR Number:   635018 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 Add a function as show_cached_lwp_text() to report the SQL for dynamic SQL LWPs a show_cached_text() for the LWPs.

CR:635038

CR Number:   635038 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) 21 Aug 2014 Insufficient priority to fix Description Connection to a case insensitive server from ct-lib using -JUTF8 (specifically upper-case UTF8) could lead to a failed jdbc connection to the same case-insensitive server. This will be seen at the client-side:- java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s). SQLState: JZ0IB Message: JZ0IB: The server's default charset of UTF8 does not map to an encoding that is available in the client Java environment. Because jConnect will not be able to do client-side conversion, the connection is unusable and is being closed. Try using a later Java version, or try including your Ja va installation's i18n.jar or charsets.jar file in the classpath. Vendor: 0 SQLState: JZ006 Message: JZ006: Caught IOException: java.io.CharConversionException: java.io.UnsupportedEncodingException: UnsupportedCharset Vendor: 0 Workaround Description  Don't use uppercase 'UTF8' from any clients. Or:- sp_configure 'disable character set conversions', 1

CR:635047

CR Number:   635047 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Install Guide-Adaptive Server Enterprise Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2011 Added to user documentation Description Need to warn against using port scanners in ASE installations in our documentation.

CR:635084

CR Number:   635084 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 Jul 2010 Fixed 20 Jul 2010 Fixed 03 Aug 2010 Fixed 06 Aug 2010 Fixed 06 Aug 2010 Fixed Description At the end of a load sequence, a database incorrectly inherits the database timestamp of the database into which the load was done, if that is bigger than that of the database that was dumped.

CR:635150

CR Number:   635150 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) 22 Oct 2010 Not reproducible with latest version of the product available as of Resolution Date Description ASE 15.5 CE with wrong version of backup server cause the load database to hange this is a request to print a error message. Workaround Description  Use the correct version of backupserver.

CR:635154

CR Number:   635154 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 Error 511: "Attempt to update or insert row failed because resultant row of size <X> bytes is larger than the maximum size (<Y> bytes) allowed for this table" may be seen during 'optdiag binary statistics' output when running under compatibility_mode. Workaround Description  Turn compatibility_mode off for optdiag via a login trigger. Or:- Use optdiag output in standard (non-binary) mode.

CR:635155

CR Number:   635155 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request: Delay select into creating open transaction until it start populating data into a temp table Workaround Description  create a view for the very long query, bcp out the date from the view and then bcp into the temp table.

CR:635198

CR Number:   635198 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 New feature request to verify sysattributes passwordd security entries with dbcc checkcatalog. Workaround Description  n/a

CR:635315

CR Number:   635315 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) 05 Aug 2010 Fixed 05 Aug 2010 Reservation Made 28 Oct 2010 One-off Provided 24 Sep 2012 Fixed Description Under some circumstances when the execution of a stored procedure is aborted due to a 1205 error, "Your server command (family id ..., process id ...) encountered a deadlock situation. Please re-run your command." and the procedure was executed by another stored procedure that had a cursor opened inside a user transaction and the option SET CLOSE ON END TRAN was ON then the next execution of the same stored procedure that reuses the plan which was aborted could behave ignoring the WHERE clause for the statement that was aborted by the 1205 error. Workaround Description  Ensure that a new plan is generated for the stored procedure that could abort with the 1205 error. For example: - Use EXEC <procedure> WITH RECOMPILE OR - CREATE <procedure> WITH RECOMPILE

CR:635329

CR Number:   635329 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 Sep 2010 Fixed Description Login overrides specified through sp_addlogin, sp_modifylogin may fail with error 17932 if sp_setpsexe was invoked in the current session or adhoc rows were inserted in master.dbo.sysattributes with object_type = "PS".

CR:635362

CR Number:   635362 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 Sep 2010 Fixed Description Increase the default size of CIPC pools.

CR:635364

CR Number:   635364 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Procedures Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Apr 2012 Added to user documentation Description Document sp_post_xpload with force implemented from ASE1254ESD10

CR:635375

CR Number:   635375 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 sp_checkreswords always prints out messages in English even if an additional language has been installed to the ASE.

CR:635398

CR Number:   635398 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   usse Fixed Version Build Resolution Date Closure Code (If Appropriate) Description wants to link attributes in complex elements (and elements) in an XML Model to other attributes in complex elements of another XML Model with extended dependancies. Only the complex elements and elements but not their attributes are available for linking (Influenced Object).

CR:635453

CR Number:   635453 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2010 Fixed 03 Aug 2010 Fixed 21 Jul 2010 Fixed Description sp_post_xpload without force option will cause error605(reindex) Workaround Description  either use force option with sp_post_xpload or manually drop/recreate the indexes

CR:635454

CR Number:   635454 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   HP-UNIX Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description App tracing: File generated by <set tracefile on> is limited to 2GB

CR:635483

CR Number:   635483 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 Oct 2010 Fixed Description The monitor table monCachedStatement may contain wrong data. Target Version  auriga

CR:635507

CR Number:   635507 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Linux Original Version:   15.0.2 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error 9289 , RAT reports inconsistent data in the transaction log. Workaround Description  None, skip the offending record.

CR:635620

CR Number:   635620 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2010 Fixed 18 Nov 2010 Fixed Description ASE on Windows can occasionally hang on call csimtx_lock()=>WaitForSingleObject(). This can occur at server startup or at user authentication when attempting to obtain the lock which is already held.

CR:635627

CR Number:   635627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2010 Fixed 19 Jul 2010 Fixed 19 Jul 2010 One-off Provided 19 Jul 2010 Fixed Description In rare circumstances following the undo of a deallocation, the database timestamp may be inadvertently set higher than it needs to be, increasing the likelihood of running out of timestamps for any database during its lifetime.

CR:635663

CR Number:   635663 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) 07 Apr 2011 Fixed 23 Jun 2011 Fixed Description Executing parallel SELECT on syscomments with traceflag 15331 enabled may result in a 1289 error followed by a stacktrace involving the modules 'lock__ins_logical' and 'lock_logical'. Workaround Description  Workarounds: a) set parallel_query off b) remove the traceflag 15331 from the RUN_server file and restart ASE c) use sp_chgattribute on syscomments sp_configure updates, 1 go select sysstat, type from sysobjects where name="syscomments" go -- take note of the current value of sysstat, write it down! select * from sysobjects where name="syscomments" go begin tran go update sysobjects set sysstat = 99 where name="syscomments" go update sysobjects set type = 'U' where name="syscomments" go -- confirm only one row affected and confirm the change select * from sysobjects where name="syscomments" go -- if more then one row, or change is not correct rollback rollback go -- else commit commit go restart server sp_chgattribute "syscomments", "plldegree", 1 go begin tran go update sysobjects set sysstat = 97 where name="syscomments" go update sysobjects set type = 'S' where name="syscomments" go -- confirm only one row affected and confirm the change select * from sysobjects where name="syscomments" go -- if more then one row, or change is not correct rollback rollback go -- else commit commit go sp_configure updates, 0 go -- restart ASE set parallel_query on go select * from syscomments go -- completes

CR:635778

CR Number:   635778 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) 21 Jul 2010 Fixed 10 Aug 2010 Fixed Description The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'lt_sqlrep_comp_policy', 's_compile_stmt' and 's_recompile' when a DML command is ran and the involved queries are eligible for SQL Statement Replication.

CR:635950

CR Number:   635950 Product Name:   Adaptive Server Generic Docs Product Component:   Clusters Users Guide Status:   Open OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Each node in private installation doesn't need its own $SYBASE on CFS from ASE1503CE onwards

CR:635969

CR Number:   635969 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) 15.5 ESD #3 20 Sep 2010 Fixed 21 Aug 2012 One-off Provided 26 Oct 2007 One-off Provided Description In a multi-node cluster, messages like "Object Coherency Block Information: ocb=400385318, lockhandle=1ab1da5a8, version={high=0, pad=0, low=2},.." and "ocm_lock: task going to sleep as ocm__lock_object() returned OCM_ERR_DEADLOCK and bast is not yet received" would appear in the errorlog and transactional activity might be frozen in one or more instances.

CR:636014

CR Number:   636014 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) 16 Dec 2011 Deferred Description Update query never completes on 15.0.3 when it was 4 minutes to complete on 12.5.4. Once it has been run with the abstract plan from 12.5.4, it completes, but as soon as you update statistics again, it is broken. Workaround Description  You can use compat mode for this query provided you do not have any new optimizer set options. IE dont use set option show brief, set statistics plancost on and it will use compat.

CR:636065

CR Number:   636065 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2010 Fixed 07 Dec 2010 Fixed 15 Dec 2010 Bundled Request Description On IPv6 enabled machine, Job Scheduler task can not connect to jsagent if interfaces file entry for JSAGENT has IPv4 address.

CR:636236

CR Number:   636236 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 A 14108 error, "Could not find partition descriptor for objid <objid>, indid <indid>, ptnid <ptnid> in dbid <dbid>." may be reported during SELECT INTO a LOB column from a source table with a non-LOB column.

CR:636238

CR Number:   636238 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   Aries CE Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Sep 2010 Fixed Description On ASE SDC, Job Scheduler agent may fail to boot with following error message in the error log. " Job Scheduler Agent entry for host '<host_name>' not found. " when the machine name(host_name) for JSAGENT entry in the interface file is not same as name returned by `uname -a`.

CR:636277

CR Number:   636277 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 Feb 2011 Insufficient priority to fix 06 Jul 2011 Fixed 13 Jul 2011 Fixed Description Interrupting the load of a 12.x dump on a 15.x server may lead to 605 errors on a subsequent attempt to load the database. Workaround Description  Avoid striking Ctrl-C while loading a database dump taken from ASE 12.5.4 or lower into a server running ASE 15.0.3 ESD#2 or higher.

CR:636293

CR Number:   636293 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) 04 Aug 2010 Reservation Made 22 Sep 2010 Reservation Made Description CROSS JOIN is unsupported in ASE.

CR:636306

CR Number:   636306 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Infected with 11 occurs with GAGenericArray::_GaGetPtr at the top of the stack.

CR:636334

CR Number:   636334 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   ASE 15.5 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2010 Fixed Description The version string for Backup Server binaries is directed to STDERR instead of STDOUT.

CR:636431

CR Number:   636431 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: expire logins after x number of days with no password expiration/renewal possible.

CR:636439

CR Number:   636439 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2010 Fixed Description On AIX, a warning message "iof_reserve_device: fence device %s is already reserved in type 5" is always displayed.

CR:636454

CR Number:   636454 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Open OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request: uncheck preupgrade in sqlupgrade and sqlupgraderes

CR:636592

CR Number:   636592 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) 17 Aug 2010 Fixed 16 Aug 2010 Reservation Made Description select DISTINCT queries (or queries referencing DISTINCT views or derived tables) may choose a suboptimial plan, when a D! (i.e. opportunistic partial distinctness) property is found at the top of the unenforced subplan below the EMIT. The fix can be enabled by optcriteria cr636592 or optlevel ase155esd3. Workaround Description  set opportunistic_distinct_view off or:- Force the good join order via 'set forceplan on' or 'set compatibility_mode on' (the customer dropped index 'ProductMap_test1' on their production server to avoid the suboptimal plan)

CR:636677

CR Number:   636677 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2012 Fixed 24 Jul 2012 One-off Provided Description Improve efficiency of spinlocks on the AIX platforms.

CR:636684

CR Number:   636684 Product Name:   Adaptive Server Enterprise Product Component:   sql Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 May 2011 Fixed Description sp_unbindexeclass fails with error 512 when more than one row qualify for the delete operation.

CR:636706

CR Number:   636706 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) 09 Feb 2011 Fixed 12 May 2011 Fixed Description The "directio on" attribute of a database device may be lost mistakenly after having unmounted and mounted a database that is using this device. Workaround Description  sp_deviceattr device_name, directio, true

CR:636786

CR Number:   636786 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Aug 2010 Fixed 12 Nov 2012 Fixed Description The execution of SP_RENAME and SP_CONFIGURE will raise error 17260 "Can't run <procname> from within a transaction." incorrectly when invoked under chained transaction mode despite that there is no open transaction.

CR:636791

CR Number:   636791 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Timestamps will be recorded when each of the checks begins in the preupgrade process.

CR:636795

CR Number:   636795 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The new FR would like to have a output file to save the preupgrade output.

CR:636798

CR Number:   636798 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) 02 Aug 2010 Presently Not Targeted For Any Future Release Of This Product Description The FR would be possible to let sqlupgraderes use multiple engines.

CR:636806

CR Number:   636806 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) 10 Mar 2011 Fixed 10 Mar 2011 Fixed 20 Apr 2011 Fixed Description When Java methods that request lots of memory for their execution are run concurrently by multiple sessions, ASE may run into a situation where the PCI integrated JavaVM aborts after having reported "OutOfMemory" error messages. In some cases this may result in ASE shutting down itself.

CR:636825

CR Number:   636825 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) 02 Aug 2010 Presently Not Targeted For Any Future Release Of This Product 28 Sep 2010 Fixed 20 Sep 2011 Reservation Made 24 Oct 2011 Presently Not Targeted For Any Future Release Of This Product Description If "enable ssl" is configured and there is no ssl entry in the interfaces file when starting an ASE, sp_listener "start","ssltcp:<host>:<port>:'CN=<common name>'","<engine>" will fail, with common name mismatch error.

CR:636898

CR Number:   636898 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   AIX Original Version:   2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2010 Bundled Request Description On POWER 7 AIX systems with 4 SMT threads enabled, ASE requests twice as many licenses as it should. Workaround Description  Suggested workarounds: 1) If 4 SMT threads are not required then using 2 SMT threads will work. 2) For versions with no further EBFs (such as ASE 15.0.x) we will need to provide customers with the environment variable override as described in the Workaround section of CR 576652. 3) Other product releases should move to SyLAPI 2.2.0.6 to pick up the fix. We can use the existing LPAR exception policy (http://syberwiki.sybase.com/display/PM/Pricing) to provide these customers with temporary licenses until a product release with the fix is available.

CR:636958

CR Number:   636958 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2010 Fixed 09 Sep 2010 Bundled Request Description For Internal Use Only: Address review comments of CR#636430

CR:637002

CR Number:   637002 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   Solaris Original Version:   2.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2010 Fixed Description SySAM incorrectly identifies sun4v processor systems as LDOMs and prevents Small Business Edition from running unless a SYBASE_SAM_CAPACITY environment variable is specified. Workaround Description  Email help_sysam@sybase.com mentioning this CR and providing the following information. 1. Output from: cpuinfo -v 2. Output from: lmutil lmhostid Someone on the alias will reply with an environment variable override of the form: SYBASE_SAM_CAPACTY=DEFAULT:0943545897458973456 The customer will need to set this variable in the environment prior to starting the product.

CR:637005

CR Number:   637005 Product Name:   Adaptive Server Generic Docs Product Component:   Transact-SQL Users Guide Status:   Closed OS:   all Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2012 Added to user documentation Description Documentation needs clarifying with respect to Sybase NULLs and ANSI NULLs

CR:637007

CR Number:   637007 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2011 Fixed 07 Dec 2010 Fixed 23 Feb 2011 Added to user documentation 16 Jan 2011 Reservation Made 18 Feb 2011 Fixed Description Add a new MDA table monLockTimeout to track info when occurence of lock manager time out

CR:637012

CR Number:   637012 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) 04 Aug 2010 Duplicate Description Upgrading to 15.0.3 with bound system tables in model causes 696 errors

CR:637088

CR Number:   637088 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 Nov 2012 Bundled Request Description Update sp_drv_typeinfo in installmaster script

CR:637114

CR Number:   637114 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   bharani beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2010 Fixed 09 Sep 2010 Bundled Request Description For Internal Use Only(K21 stab):sig11 in listener_checkagain on solaris

CR:637172

CR Number:   637172 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) 06 Aug 2010 Fixed Description A SELECT query running at transaction isolation level 1 may sometimes not exhibit expected blocking behaviour on a row that is inserted by an uncommitted transaction if the inserted row is replacing a row deleted by the same transaction. Workaround Description  force a table scan(indid 0), or set transaction isolation level 3, or create unique nonclustered index pk_test1 on test1(a, b,c), or boot ASE with trace flag 693 (turns off some blocking optimizations in scan such as skipping uncommitted inserts and skipping or returning uncommitted updates based on info about what columns were updated)

CR:637193

CR Number:   637193 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2010 Duplicate Description In rare circumstances the error 706/20/3 may be raised when executing a query related to sysobjects with statistics on ASE 15.5 Workaround Description  trace flag 15352 to turn off expression histogramming or set compatibility_mode on or: delete statistics sysobjects

CR:637248

CR Number:   637248 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) 23 Aug 2010 Fixed Description Using compatibility mode results in a marginal performance drop for queries involving worktables.

CR:637262

CR Number:   637262 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) 13 Oct 2010 Fixed 13 Oct 2010 Fixed Description Adaptive Server Cluster Edition may rarely hit signal 11 error with stacktrace containing cmcc_bufsearch(), under high load of concurrent INSERT and SELECT statements issued on multiple instances of the cluster.

CR:637307

CR Number:   637307 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Nov 2010 Fixed Description Using the "with verify=full" option for a database causes warning messages in the backup server log relating to pages 24-31. These messages are due to the system table that uses these pages having a special format. They can be safely ignored. Workaround Description  TO avoid these messages fo not use the 'with verify option.

CR:637317

CR Number:   637317 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   auriga Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2010 Fixed 15 Nov 2010 Fixed 11 Jan 2011 Fixed 23 Feb 2011 Added to user documentation Description Added ProgramName, HostName, ClientName, ClientHostName, ClientApplName columns to monProcess, ProgramName, ClientName, ClientHostName, ClientApplName columns to monProcessLookup, Application, HostName, ProgramName, ClientName, ClientHostName, ClientApplName columns to monProcessActivity, HeldProgramName, HeldClientName, HeldClientHostName, HeldClientApplName, WaitApplName, WaitHostName, WaitProgramName, WaitClientName, WaitClientHostName, WaitClientApplName columns to monDeadLock.

CR:637395

CR Number:   637395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.5 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2011 Fixed Description In the Cluster Edition, when monitoring is enabled, the MaxIOServiceTime in the MDA table monOpenPartitionActivity may sometimes have values less than the AvgIOServiceTime.

CR:637468

CR Number:   637468 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) 27 Oct 2014 Insufficient priority to fix Description Error 247 Dynamic prepare statement fails with Arithmetic overflow from Jconnect

CR:637538

CR Number:   637538 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) 08 Aug 2010 Fixed Description Queries with non-correlated subqueries that references a grouped aggregated view in multiple places in the query will lead to a parallel plan not created.

CR:637589

CR Number:   637589 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) 31 May 2011 Fixed 01 Jun 2011 Fixed Description Signal 11 in function ScalarNormalizing() (amongst others) may be seen in the error log and the spid terminated when attempting to insert <table> (<column-list>)..select <col> from <table2> union/union all <select> in a procedure where <table> is created inside the procedure and <table> contains non-nullable columns that are not in <column-list>. Workaround Description  Ensure all columns in the table being inserted into that may be passed null values are create with nullable property (either declarative or by setting 'allow nulls' = true)

CR:637600

CR Number:   637600 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) 02 Jun 2011 Fixed Description Signal 11 stacktrace with error msg 416 may be seen in the error log and the spid terminated when attempting to insert <table> (<column-list>)..select <col> from <table2> union/union all <select> in a procedure where <table> is created inside the procedure and <table> contains non-nullable columns that are not in <column-list>.

CR:637651

CR Number:   637651 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2010 Duplicate Description Update statistics with/without consumers different histograms steps

CR:637698

CR Number:   637698 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 Mar 2011 Fixed 18 Mar 2011 Fixed Description A 9543 error, "Parameter passed to the builtin 'lockscheme' has an invalid type.", may be encountered when the lockschme function is used with id and dbid parameters from master..sysprocesses. Workaround Description  select lockscheme (convert (int, id), dbid) from sysprocesses where spid=2

CR:637723

CR Number:   637723 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) 08 Feb 2011 Fixed Description New Feature - Server wide events are displayed on Overview screen of ASEMAP monitoring view

CR:637729

CR Number:   637729 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.5 ESD #1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.5 ESD #3 11 Aug 2010 Fixed Description When running non-English regional settings it is possible for the CreationDate\LastExecution\NextExecution dates to display a 'null' when viewing 'Scheduled Jobs' (requires Job Scheduler) in Sybase Central 4.3 through to 6.0. Workaround Description  Switch regional setting to English. or:- You can still check the dates by running outside of Sybase Central of course:- sp_listscheduledjob 'list=scheduled_short'

CR:637828

CR Number:   637828 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) 13 Aug 2010 Fixed 17 Aug 2010 Fixed 17 Aug 2010 Fixed 23 Aug 2010 Presently Not Targeted For Any Future Release Of This Product 02 Sep 2010 One-off Provided Description ASE tasks may be terminated with a timeslice error if the ASE is running a multi-byte character set and SQL batch capture is configured to 1. The stack trace may contain oh_get_obfuscated(), copy_sqltext() and sqlpars(). Workaround Description  sp_configure "SQL batch capture", 0

CR:637872

CR Number:   637872 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description add the hostname and program_name from sysprocesses to the sybsecurity functionality so it can be archived together.

CR:637904

CR Number:   637904 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) 05 Sep 2010 Fixed Description sp_plan_dbccdb has wildly LOW recommendations for the dbccdb databases may cause dbccdb log fills and when cancel out of dbcc checkstorage may cause sigsegv and stackoverflow.

CR:637993

CR Number:   637993 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2010 Fixed 30 Nov 2010 Fixed 23 Nov 2010 Fixed 01 Dec 2010 Fixed 02 Dec 2010 Fixed 02 Oct 2012 One-off Provided 04 Oct 2012 Fixed Description In some ASE workloads, proc_spin shows up as having high contention. This fix could decrease the contention in some of these workloads.

CR:638062

CR Number:   638062 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) 31 Aug 2010 Fixed Description sp_dboption with no parameter doesn't display full descriptions of the database options if the ASE's language is japanese.

CR:638068

CR Number:   638068 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2010 Fixed Description On Windows systems when Adaptive Server is running with configuration options "enable literal autoparam" and "statement cache" active in some circumstances the execution of a query containing a big literal binary value may be aborted and the message "SQL Server system exception (0xc0000005) generated by a storage access violation" together with a stack trace which includes the modules 'memcpy' and 'mkconst_desc' may be reported in the error log. Workaround Description  Disable automatic literal parameterization, for example via "sp_configure "autoparam", 0"

CR:638098

CR Number:   638098 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Windows Original Version:   15.5 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2010 Fixed Description On windows, Database Emulator doesn't receive QaTrflag_status bitmap.

CR:638140

CR Number:   638140 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Converting char to int returns 249 error in 15.x Workaround Description  set compatibility_mode off

CR:638169

CR Number:   638169 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 Sep 2010 Fixed Description A configuration option 'enable deferred parallel' has been added to enable/disable the deferred parallel optimization mechanism. The default value is 0 (disabled); a value of 1 enables this method. Deferred Parallel Optimization is an alternative method for costing and selecting parallel query plans. When enabled, the best serial plan is chosen using the serial optimizer; this plan is then converted to a parallel plan, normally maintaining the same join order and physical operators as the serial plan. This method provides a parallel plan using less optimization time, while reducing the risk that a parallel plan will be chosen which is inferior to the best serial plan. With the full (default) parallel optimization mechanism, an inferior plan may be chosen due to optimizer time out, or due to limitations of parallel costing.