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

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

CR:530282

CR Number:   530282 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Mar 2009 Fixed Description certain queries with multiple outerjoins may stack trace if executed under forceplan. Workaround Description  Version: Adaptive Server Enterprise/15.0.2/EBF 15093 ESD#2/P/Sun_svr4/OS 5.8/ase1502/2516/64-bit/FBO/Thu Dec 20 04:05:37 2007 Remove forceplan. Upgrade to: Adaptive Server Enterprise/15.0.2/EBF 15651 ESD#4/P/Sun_svr4/OS 5.8/ase1502/2528/64-bit/FBO/Sat Apr 5 09:36:08 2008

CR:530311

CR Number:   530311 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2008 Fixed Description Export_options is enabled by default on the first login but not subsequent ones. Workaround Description  1) To workaround the issue you may create a global login trigger that turns of "export_options": ============================================ use sybsystemprocs go create proc sp_globallogin as set export_options off go sp_logintrigger 'sybsystemprocs..sp_globallogin' go ============================================ 2) Modify the application to issue "set nocount off" explicitly after the sp_server_info

CR:530417

CR Number:   530417 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) 03 Sep 2008 Fixed 04 Sep 2008 Fixed 23 Jan 2009 Not reproducible with latest version of the product available as of Resolution Date Description Query with ORDER BY clause on a column not present in the SELECT target list may not provide the requested ordering. Workaround Description  include order by column in select list

CR:530470

CR Number:   530470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2008 Fixed Description sp_configure a cluster-wide value from instance having instance-specific value on the same option failed due to the code error in sp_configure stored procedure.

CR:530473

CR Number:   530473 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) 15 Jun 2008 Not reproducible with latest version of the product available as of Resolution Date 31 Jul 2009 Fixed Description Under rare circumstances, dbcc checkalloc might report a 2525 error: "Table Corrupt: Object id wrong" with "objid in ext=0" following an ONLINE DATABASE after loading two or more transaction logs.

CR:530481

CR Number:   530481 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2008 Fixed Description LDAP URL setting did not fail when the access account distinguished name (DN) is an invalid or non-existing DN. The error 'No such object' is returned by LDAP server for invalid DN.

CR:530498

CR Number:   530498 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2008 Fixed 24 Jul 2008 Fixed Description Misleading error message from Backup server indicating write failure for archive device during load operation. The actual failure occurrs while writing to data device. Following or similar error messages could be seen in errorlog: "D01: SYBMULTBUF ERROR: Internal error: In db_proc, the C_MBUF command is invalid when the context is DEST_RUN. Backup Server: 4.145.2.22: [107] Error for device '<archive_device>'. Attempted to transfer xxxxxx bytes, but yyyyyy bytes were transferred by operating system call write/read."

CR:530510

CR Number:   530510 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2008 Fixed Description dbcc release_lock() can not release the locks owned by recovery daemon.

CR:530618

CR Number:   530618 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) 19 Aug 2008 Fixed 20 Aug 2008 Fixed Description Indirectly activated sa_role is not able to execute system stored procedure sp_listener. Workaround Description  Modify the install master script from: proc_role('sa_role') != 1 to proc_role('sa_role') = 0 OR proc_role('sa_role') < 1 Drop and recreate the effected procedures.

CR:530648

CR Number:   530648 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2008 Fixed Description In rare circumstances a duplicate object id might be used in the creation of a temporary table in the local temporary database of an instance.

CR:530664

CR Number:   530664 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2008 Fixed Description This feature could be implemented using the ADA technology. http://msdn.microsoft.com/en-us/library/ms187054.aspx And looking at how it works, it is nothing but what we already had in mind for the incremental dumps. The snapshot would be an archive database that would use the original database and the modified pages section instead of a dump + modified pages section. Creating a snapshot will also be very similar to creating an archive database, but building the original diskmap would be much easier. Then, a couple of new fields in the dbtable would tell ase that it has to forward a write defined by (xactid, page) to a set of snapshots, while a daemon would be writting the original pages as the transactions commits, if the pages had not been copied already. I see the project pretty easy to implement, and we would kill two birds with one shot: - Database snapshots - Incremental dumps. These could require having internally two types of snapshots. A real one, with access to the original page, and a light one, with access only to the list of modified pages but not the pages themselves.

CR:530826

CR Number:   530826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2009 Fixed 27 Jan 2009 Fixed 20 Jan 2009 Duplicate Description Add support for multiple Backup Servers in Cluster.

CR:530872

CR Number:   530872 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2008 Fixed Description For a dedicated log database, if a node joins after LCT is crossed then log segment unreserved page count might be set incorrectly to a wrong value and the processes suspended on LCT might continue.

CR:530882

CR Number:   530882 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The customer has very large database and their maintenance window does not allow a complete checkstorage to finish so they would like the ability to pause and restart it.

CR:530958

CR Number:   530958 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2008 Fixed Description Introduce a new dbcc command to delete a particular plan or all plans associated with a particular procedure from the procedure cache. dbcc deleteplan(db_id/db_name, obj_id/obj_name, plan_number) Delete the procedure plan specified by plan_number dbcc deleteplan(db_id/db_name, obj_id/obj_name, 'all') Delete all plans associated with this procedure object.

CR:531043

CR Number:   531043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2008 Fixed Description In case of database with mixed log and data, 603 error (out of session descriptors) might occur due to lot open descriptors on an object with id 99. Workaround Description  Use a dedicated log database instead of a mixed log and data database.

CR:531062

CR Number:   531062 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2008 Fixed Description When configuration value "number of worker processes" is updated using 'sp_configure', its value printed by 'set option show long' is not updated until the next reboot of the server.

CR:531111

CR Number:   531111 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2008 Fixed 17 Jul 2008 Fixed Description When 'statement cache' is enabled, Adaptive Server might incorrectly display that it is using an expression to evaluate the selectivity of a predicate containing a 'BUILT-IN function' as part of 'set option show long' output.

CR:531159

CR Number:   531159 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2008 Fixed Description A query with a large in-list against a user defined view may fail with Message 3626, "the transaction was aborted because it used too much stack space." Workaround Description  generate result set from the view to a #table outside of the main query

CR:531171

CR Number:   531171 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Commands Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2008 Fixed Description The 12.5.x and 15.x Commands Reference Manual entries for CREATE PROCEDURE incorrectly list the limit on the number of parameters as 255 rather than 2048

CR:531176

CR Number:   531176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jun 2008 Fixed Description In rare circumstances, the message "timeslice -501, current process infected" together with a stack trace which includes the modules 'memalloc' or 'mempagecount' may be reported in the error log when running a complex query.

CR:531177

CR Number:   531177 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2008 Fixed 06 May 2009 One-off Provided Description Under some circumstances the message "current process infected with signal 11" in the module s_free' together with a stack trace which includes the modules 'metrics_proc_dump' and 's_cleanframe' may be reported in the error log when a session executing a stored procedure is killed and the configuration option "enable metrics capture" was set to 1. Workaround Description  Disable config option via sp_configure "enable metrics capture",0

CR:531199

CR Number:   531199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2008 Fixed 03 Sep 2008 Reservation Made Description Optimizer doesnt consider certain query plans for large queries, which could result in suboptimal query plans.

CR:531322

CR Number:   531322 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) 03 Jun 2008 Fixed Description During quorum creation a core dump may result if the input file has duplicate entries in the management nodes section. This applies to ASE and qrmutil.

CR:531372

CR Number:   531372 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jun 2008 Fixed Description When configuration command 'sp_configure "current audit table", 0, "with truncate"' is executed, there will be error message with number 4720, severity 16.

CR:531462

CR Number:   531462 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jun 2008 Fixed 17 Jun 2008 Fixed 19 Jun 2008 Duplicate Description When size of 'default data cache' is increased with less than 256 pages, error is printed but return status of sp_cacheconfig is 0 which should be 1.

CR:531485

CR Number:   531485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2008 Fixed Description In rare circumstances, cluster instance may hit timeslice error. Stacktraces containing the string "ocm" would be seen in the erorrlog.

CR:531492

CR Number:   531492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Dec 2008 Fixed 02 Dec 2008 Reservation Made 08 May 2009 Fixed Description When the configuration parameter 'max concurrently recovered db' is active it is possible that during parallel recovery ASE tries to online an archive database before the scratch database this archive database is bound had a chance to come online, causing the recovery of the archive database to fail. Workaround Description  Specify a user defined recovery order to make sure that the scratchdb gets recovered first.

CR:531588

CR Number:   531588 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2009 Insufficient priority to fix Description create set command for for turning off the min/max algorithm, traceflag 15385 set minmax off

CR:531631

CR Number:   531631 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Apr 2009 Fixed 16 Apr 2009 Fixed Description In rare circumstances, datatype field in c6 column in sysstatistics FMT_COLUMN formatid row might be corrupted during upgrade during online database after the database is loaded across platform where byte-order is different, if the table has more than 255 columns.

CR:531687

CR Number:   531687 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2008 Fixed Description The server hangs because of an undetected deadlock between one task destroying a page in a MASS and BCM thread that is trying to downgrade the physical locks on the MASS.

CR:531708

CR Number:   531708 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jun 2008 Not a Bug Description Optimizer fails to consider 'special or strategy' for delete with or & subquery

CR:531713

CR Number:   531713 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2008 Fixed Description UPDATE with view and inner join fails with error 206.

CR:531748

CR Number:   531748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2008 Fixed Description Spurious error message 2513 "Table Corrupt: Object id 892527182 (object name = v1) does not match between syscolumns and sysattributes" is given when decrypt default is defined on an encrypted column and a VIEW is defined on the table with the encrypted column and decrypt default and DBCC CHECKCATALOG is run on the database. Target Version  15.0.2 ESD#6

CR:531755

CR Number:   531755 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Mar 2009 Insufficient priority to fix Description Feature request for a to_lower_ascii() function that would replace accented characters with the base character. Workaround Description  A user-defined function could do this with a series of str_replace() calls, one for each accented character.

CR:531782

CR Number:   531782 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed 27 Jun 2008 Fixed 01 Jul 2008 Workaround Description To completely turn off ASE Plug-in's "remember passwords" feature, the system administrator can execute this command: "$SYBASE_JRE/bin/java -jar $SYBROOT/ASEP/lib/ASEPlugin.jar -s Setting.RememberPassword false". Once turned off, ASE Plug-in will always ask for password while attempting a connection. Furthermore, the "Remember passwords..." check boxes will not be shown on the plug-in Preferences page ("Tools"->"Adaptive Server Enterprise"->"Preferences").

CR:531785

CR Number:   531785 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Fixed Description Add an option to remove the server entry after disconnecting from ASE.

CR:531911

CR Number:   531911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2008 Fixed Description Install JRE 1.6 in $SYBASE/shared for ASE 15.0.3 release

CR:531936

CR Number:   531936 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2008 Fixed Description Calculate the max qualified starting port value and set it as the maximum value of the spinbox. The user can not input any starting port larger than this maximum value.

CR:531941

CR Number:   531941 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   NA Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jun 2008 Added to user documentation Description Installation Guide: Add post-upgrade task to run DBCC checkcatalog with fix in 15.0.2 and higher.

CR:531942

CR Number:   531942 Product Name:   Adaptive Server Generic Docs Product Component:   Other Status:   Closed OS:   NA Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2008 Added to user documentation Description Installation Guide: Add post-upgrade task to run DBCC checkcatalog with fix in 12.5.4 and higher.

CR:531947

CR Number:   531947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2008 Fixed Description dbcc replicate_txtcol does not reflect 4th parameter (setrep_index) in the 9142 message. Workaround Description  This is an internal procedure. Customers should use the documented procedure, sp_setrepcol

CR:531964

CR Number:   531964 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2008 Fixed Description The sysprocesses cpu and physical_io fields are both flushed together whenever the lesser of the "io accounting flush interval" or "cpu accounting flush interval" is reached. Workaround Description  Don't rely on sysprocess.cpu for the spids accounting, use the MDA table monProcessActivity in 15.0.1 and higher (CR 427668)

CR:531997

CR Number:   531997 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2008 Fixed Description Error message 942 "Database cannot be opened because a system descriptor cannot be installed." is enhanced to include the database name and the object ID of the system table whose table descriptor could not be installed. Similarly error message 952 "Database '%.*s' cannot be opened because a system index descriptor cannot be installed." is enhanced to include the object ID of the system table whose index descriptor could not be installed.

CR:532119

CR Number:   532119 Product Name:   Adaptive Server Generic Docs Product Component:   To Be Determined Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description unichar and univarchar datatypes are not fully supported by Web Services. Documentation should be corrected to reflect this. Workaround Description  N/A

CR:532154

CR Number:   532154 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Not a Bug Description Queries with a large IN list may not be optimized. Workaround Description  Add an index for column CodeStartDate or Increasing the step count to 500 for the column "ProgramId" and the repro query will choose an index scan.

CR:532198

CR Number:   532198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2008 Fixed Description When ASE starts up with large default network packet size which is equal to max network packet size, ASE may raise a message "usinitpktsz: Unable to allocate overflow buffer of size xxxxx from pool". Workaround Description  Increase additional network memory till the messages disappear.

CR:532256

CR Number:   532256 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2008 Fixed 31 Aug 2008 Fixed 02 Sep 2008 Not a Bug Description Job Scheduler stored procedure sp_jst_svr_update_statistics stops processing if it encounters an offline/single user database. Workaround Description  *** Monday, June 09, 2008 9:49:13 AM *** cooperg *** Customer made the following code change. Not sure if this is the best change as we should specifically check for offline and single user bits: =============================================================================== In this case, if you look at the code in "sp_jst_svr_update_statistics", you will see that the code gets all the databases in the server and one by one it calls "sp_jst_db_update_statistics" for those databases. The moment one of the database is not ONLINe, the job aborts and does not proceed to run for next dbid. Current code is like this: -- Find all the databases on the server select @max_id = MAX(dbid) from master..sysdatabases where name not in ("tempdb","model","sybsystemprocs", "sybsystemdb", "master", "sybmgmtdb") and (status3 & 256) != 256 while(@db_id <= @max_id ) begin if( @db_id = @max_id ) begin break end select @db_id = MIN(dbid) from master..sysdatabases where dbid > @db_id and name not in ("tempdb","model","sybsystemprocs", "sybsystemdb", "master", "sybmgmtdb") and (status3 & 256) != 256 select @db_name = name from master..sysdatabases where dbid = @db_id if( @db_name is not NULL ) begin print 'processing db: %1!', @db_name select @cmd_str = @db_name + "..sp_jst_db_update_statistics" exec @err = @cmd_str @db_name, @index_flag, @datachg_threshold, @rowcnt_threshold, @pagecnt_threshold, @step_value, @consumers, @spercent if( @err < 0 ) select @status = @err end end -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ---Modified code is where you see the comment below: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- Find all the databases on the server select @max_id = MAX(dbid) from master..sysdatabases where name not in ("tempdb","model","sybsystemprocs", "sybsystemdb", "master", "sybmgmtdb") and (status3 & 256) != 256 while(@db_id <= @max_id ) begin if( @db_id = @max_id ) begin break end select @db_id = MIN(dbid) from master..sysdatabases where dbid > @db_id and name not in ("tempdb","model","sybsystemprocs", "sybsystemdb", "master", "sybmgmtdb") and (status3 & 256) != 256 and status <1024 --Added by Sundeep to get list of databases and run sp_jst_db_update_statistics for ONLINE databases online. select @db_name = name from master..sysdatabases where dbid = @db_id if( @db_name is not NULL ) begin print 'processing db: %1!', @db_name select @cmd_str = @db_name + "..sp_jst_db_update_statistics" exec @err = @cmd_str @db_name, @index_flag, @datachg_threshold, @rowcnt_threshold, @pagecnt_threshold, @step_value, @consumers, @spercent if( @err < 0 ) select @status = @err end end

CR:532358

CR Number:   532358 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Provide a method to enable Web Services to automatically refresh after successful deploy/undeploy Workaround Description  Restart web services.

CR:532474

CR Number:   532474 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2009 Fixed 30 Jan 2009 Reservation Made Description Open cursor command takes a long time with a complex select statement Workaround Description  Consider using low value for optimization timeout for these applications maybe in a login trigger. If I use "set option show_abstract_plan on" to get the query plan when the cursor is opened and then force that query plan with the "plan" clause when I re-try the query, I can get the 'elapsed time' from statistics time output to be reduced from 17998 ms to 3 ms. So I guess the workaround is to use a 'plan' clause in the cursor declare statement. If the application is a canned application, then try using the "create plan" feature, and then using load abstract plan as a workaround. This will allow you to attach plan to the query without changing the application.

CR:532478

CR Number:   532478 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jun 2008 Fixed Description A 12316 error: "Internal error: Attempt to garbage collect a deallocated data page %d in table '<table>', database '<dbname>'. Aborting the transaction." may occur in rare circumstances when there are rollbacks of DMLs on data-only locked tables, and a subsequent DML hits a free space threshold for the log.

CR:532511

CR Number:   532511 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2008 Fixed 20 Jun 2008 Reservation Made Description In ASE 12.5, cursors with DISTINCT, ORDER BY, GROUP BY or UNION in their defining SQL statements would often have their result rows stored in a worktable when the cursor OPEN command is executed. Subsequent cursor FETCH commands would read rows from the worktable, thus insulating the cursor from changes to the tables upon which the cursor was defined, in between FETCH commands. In ASE 15, the optimizer attempts to avoid creating worktables for better performance. In this CR, command line trace flag 457 has been introduced to force ASE 15 to internally convert many of the cursors that would have used a worktable in ASE 12.5, but would not use on in ASE 15 to insensitive cursors to force materialization of the cursor rows when the cursor OPEN command is executed.

CR:532621

CR Number:   532621 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2008 Fixed Description The instance Log SQL Statements output go to the cluster window so that there is only a single window opened. This will also make it consistent with logging to a file where all output goes to a single file.

CR:532645

CR Number:   532645 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2008 Fixed Description A join containing an MDA table may stacktrace with a signal 10 if a Nested Loop Join is used. Workaround Description  Force a merge or hash join plan

CR:532648

CR Number:   532648 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed Description In rare circumstances, a signal 11 may be encountered in the 'xls_getnext' routine at transaction commit time, with the stack trace showing modules 'xls_getnext' and 'xact__postcommit_processing'.

CR:532672

CR Number:   532672 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2011 Added to user documentation Description Job Scheduler users may encounter "login failed" errors after changing their password. They must also use the sp_addexternlogin procedure to update their password for the job scheduler server loopback entry.

CR:532743

CR Number:   532743 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2008 Fixed 11 Jul 2008 Fixed Description Running a query with large joins of more than six tables may get a stacktrace in the module 'stat_add_sample'. Workaround Description  Use traceflags 15363 to disable new greedy pass. Remove "enable sort-merge join and JTC" from config since this parameter is deprecated (documented as such).

CR:532777

CR Number:   532777 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jun 2009 Fixed 17 Jun 2009 Fixed 18 Jun 2009 Fixed Description sp_configure may encounter error message 10840 with error message, "Internal error, FDP API, fdp_get_memory(): Failed to allocate 2097061 bytes.", in the errorlog. Workaround Description  NA

CR:532790

CR Number:   532790 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jun 2008 Bundled Request Description For clusters with two or more instances, if object binding operation fails at some instance then the message "current process infected with 11" in module 'cm_bind_cache' may be reported in the errorlog.

CR:532880

CR Number:   532880 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) 17 Jul 2008 Fixed Description In rare circumstances the quorum device may become corrupted, reported via quorum library error 14 (Found invalid magic numbers and / or table of contents entries on the quorum device. This device may be corrupted.). This is most likely to occur in simulated cluster environments with an NFS mounted quorum device and a low configuration for "quorum heartbeat interval".

CR:532911

CR Number:   532911 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2008 Fixed Description Kerberos logins with 'data integrity' or 'replay detection' option (-Vi, -Vr) may raise a TDS protocol error: "An invalid PARAMFMT stream was received." when a query is sent to ASE.

CR:532933

CR Number:   532933 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2009 Fixed 23 Jan 2010 Fixed Description The error 3935, "Fatal protocol error. xact_beginupdate() API was invoked in the wrong context. The transaction is currently in 'Abort tran-attached' state." will be raised if the command DROP DATABASE fails while trying to release the internally created devices of an archive database.

CR:533001

CR Number:   533001 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) 17 Jul 2008 Fixed Description External LDAPUA/PAMUA login accounts with 'CREATE LOGIN' mapping failover to ASE authentication when 'enable ldap user auth'/'enable pam user auth' is set to 1.

CR:533030

CR Number:   533030 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jul 2008 One-off Provided 16 Jul 2008 Fixed 21 Jul 2008 Fixed Description When LDAP User Authentication is configured and there is exactly one mapping of LDAP user to ASE login, then synchronization of LDAP and ASE password fails. Additionally, when LDAP server is down and failover to ASE authentication is permitted by configuration (enable ldap user auth = 1), then providing LDAP user name with correct password fails the login despite the fact that there is mapping of the LDAP user to ASE user. Workaround Description  If zero mapping is used, then the password will be sync. In this case, it is not possible as ct has to use one mapping since his ldap logins are digits and we don't suport that.

CR:533031

CR Number:   533031 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0.1 03 Jul 2008 Fixed Description When an Adapative Server SDC cluster undergoes multiple failovers in a row, the message of work completion in failure table may be reported on the new coordinator for previous failed instances in addition to the current failed instance.

CR:533204

CR Number:   533204 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2009 Fixed Description Selecting zero rows from monOpenObjectActivity or monOpenObjectActivity with a filter on DBID can give a spurious "Command has been aborted." error however processing continues as normal.

CR:533213

CR Number:   533213 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2009 Fixed 28 Jul 2009 Reservation Made 04 Dec 2009 Fixed 11 Dec 2009 Fixed 13 Dec 2009 Fixed Description A 834 error, "Illegal attempt to clean buffer:...", may be reported in the errorlog.

CR:533267

CR Number:   533267 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) 16 Jun 2008 Fixed Description sp_cluster logical, help output incorrectly lists 'user' as a route type. The correct route type is 'login'.

CR:533277

CR Number:   533277 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2008 Fixed 08 Jul 2008 Fixed 23 Aug 2009 One-off Provided Description A query involving a UNION such that one side of the UNION is a SELECT from a derived table involving a join between two tables with a DISTINCT on the projection; and the other side of the UNION is a SELECT <constant> might lead to wrong results. An example query would be: SELECT et.col1 from (SELECT DISTINCT et.col1 from et, cl clkp where et.col2 = clkp.col2 and clkp.col1 = 'Dependency' ) et UNION SELECT 'All'.

CR:533280

CR Number:   533280 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2008 Insufficient priority to fix Description Error 235 is raised when using the identity_insert setting with a UNION ALL and identity values based on the INT datatype rather than NUMERIC.

CR:533285

CR Number:   533285 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Oct 2008 Third Party Problem Description Frequent disconnect with ASE12.5.4 running on HP-UX 11.31 with 2 engines

CR:533289

CR Number:   533289 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation and Configuration Guide-ASE Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2010 Added to user documentation Description Cover letters for ASE ESD#3 windows platforms uses unix syntax

CR:533331

CR Number:   533331 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Microsoft Windows Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed 11 Sep 2008 Fixed 11 Sep 2008 Fixed Description Scheduled jobs stop unexpectedly after running a few months on nt386 platform. Target Version  15.0.2 ESD#6

CR:533419

CR Number:   533419 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2008 Fixed 08 Aug 2008 Fixed Description ASE does not set the length for TEXT columns in dynamic SQL statements.

CR:533467

CR Number:   533467 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jul 2008 Fixed 23 Jul 2008 Reservation Made Description A query of the form: INSERT tab1 SELECT ... UNION ALL SELECT ..., where the second SELECT contains a NOT EXISTS subquery that references the target table (tab1) may insert extra rows into tab1 in ASE 15 compared to pre-ASE 15 versions. The ASE 15 behavior is the expected behavior, but to maintain backwards compatability, command line trace flag 9580 has been introduced to force pre-ASE 15 behavior.

CR:533470

CR Number:   533470 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) 04 May 2009 Duplicate Description tdssend__column_formats is sending TDS indicating a maxlen of 0 for text / image.

CR:533518

CR Number:   533518 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   SunOS Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2008 One-off Provided Description When attempting to create an index on certain text document, indexing fails with the following error message in the log: "Warn E0-1514 (Drvr): TstrIOFilter:flt_kv: KV failed on filtering document: error = 7. " Note that EFTS tracing should be turned on to see the error in the log.

CR:533558

CR Number:   533558 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2008 Consult Complete Description Datediff return wronge value.

CR:533609

CR Number:   533609 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) 27 May 2010 Fixed Description kill command will not work for Kerberos logins when trying to kill a spid on a remote instance. Workaround is to: Login with username/password to kill DBMS processes on remote instances. OR Login to the instance of the cluster where the DBMS process is local. OR Define external login mappings (using sp_addexternlogin) for Kerberos logins for each instance. Workaround Description  Login with username/password to kill DBMS processes on remote instances. OR Login to the instance of the cluster where the DBMS process is local.

CR:533614

CR Number:   533614 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2008 Added to user documentation Description manual says to use the following syntax: set proxy...restricted role the correct syntax is set proxy...restrict role http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sag1/html/sag1/sag1814.htm

CR:533621

CR Number:   533621 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   NA Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2012 Presently Not Targeted For Any Future Release Of This Product Description Request to provide Query Plan option in DBISQL for ASE 12.5.X connections.

CR:533623

CR Number:   533623 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2009 Fixed Description Error 287 "Command not allowed within a trigger" may happen during trigger's execution. The message header indicates the name of a stored procedure called by the trigger and not the trigger's name.

CR:533686

CR Number:   533686 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) 01 Aug 2008 Fixed 07 Aug 2008 Fixed Description The message "User has been dropped from current database" may be mistakenly reported when SP_DROPUSER is run although the user to drop is not actually dropped.

CR:533715

CR Number:   533715 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jun 2008 Fixed 13 Jul 2008 Fixed 14 Jul 2008 Fixed Description Error 3475, "There is no space available in SYSLOGS to log a record for which space has been reserved in database '%.*s' (id %d). This process will retry at intervals of one minute." may be reported in a multi-node cluster after instance failover recovery.

CR:533757

CR Number:   533757 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2008 Fixed 28 Oct 2008 Reservation Made Description Added support to configure, at database level, the threshold used for SQL statement replication.

CR:533767

CR Number:   533767 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2008 Fixed Description Error 511 could be raised incorrectly for queries having unknown result length if trace flag 244 is turned on.

CR:533788

CR Number:   533788 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) 20 Jun 2008 Bundled Request Description Under rare circumstances for clusters with two or more instances, the message "current process infected with 11" in the module 'cm_delete_cache' may be reported in the error log. Workaround Description  Configure the cluster with at least two engines per instance. Set 'max online engines' and 'number of engines on startup' to at least '2'

CR:533812

CR Number:   533812 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2008 Fixed Description If an insensitive cursor referenences a java ADT, then doing fetch may hit error 'process infected with signal 11" with stack trace in the module of jcnstGetObject() and LeEmitSndOp::_LeEoRouteResults().

CR:533825

CR Number:   533825 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) 30 May 2012 Bundled Request Description The error message 3405 is modified as "Recovering database '<Database name>' (dbid <Database ID>).". The enhanced message includes the database ID as part of the error message.

CR:533858

CR Number:   533858 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description auditing: request to add hostname in extrainfo column for table_access option

CR:533945

CR Number:   533945 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2008 Fixed Description Job Scheduler Agent on NT uses IPv4 even if IPv6 is enabled on the host machine.

CR:534014

CR Number:   534014 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2010 Fixed 28 Mar 2010 EOL'd version. Not to be Fixed. 25 Mar 2010 Fixed 23 Feb 2010 One-off Provided 23 Apr 2010 Fixed Description Backup Server does not use directio or dsync i/o as configured for database devices.

CR:534044

CR Number:   534044 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2008 Fixed 17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date Description A complex query with many views and a union results in SIGSEGV. Workaround Description  Set 0 to "enable cis" if you don't use CIS. If you are using CIS, trace flag 4402 could help your situation.

CR:534108

CR Number:   534108 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2008 Fixed Description In multidb transaction, tempplc gets flushed even when it is not necessary.

CR:534139

CR Number:   534139 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2009 Fixed Description Backup Server crashes due to Open Server bug 471786 Workaround Description  Configure Qualys such that it does not touch any ports used by Open Server based applications.

CR:534175

CR Number:   534175 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Sep 2008 Fixed Description Query with a groupby under a correlated subquery might miss a much better execution plan if the groupby itself also has its own correlated subquery. The better plan would be evaluating the groupby only once and storing the intermediate result in a worktable. Workaround Description  (edwins) one workaround would be to rewrite the query so that we get the 12.5 transformation behavior (until we do this automatically in 15.0) select * from IHC_NPI_MATCHING WHERE EXISTS (select * from ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND MATCH_STATUS_CD = '' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY = 'F' AND CLCL_ID NOT IN ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY IN ('', 'P')) GROUP BY CLCL_ID HAVING COUNT(CLCL_ID) = 1) AS GROUP_BY_ONE(CLCL_ID), ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND MATCH_STATUS_CD = '' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY = 'P' AND CLCL_ID NOT IN ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY IN ('', 'G', 'F')) GROUP BY CLCL_ID HAVING COUNT(CLCL_ID) = 1) AS GROUP_BY_TWO(CLCL_ID) WHERE CLPR_TYPE = 'RC' AND MATCH_STATUS_CD = '' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND (MATCH_PRPR_ENTITY = 'F' AND CLCL_ID NOT IN ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY IN ('', 'P')) AND CLCL_ID = GROUP_BY_ONE.CLCL_ID ) OR ( MATCH_PRPR_ENTITY = 'P' AND CLCL_ID NOT IN ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY IN ('', 'G', 'F')) AND CLCL_ID = GROUP_BY_TWO.CLCL_ID ) ) go The above rewrite will not use the clustered index on the worktable CLCL_ID column, so ... If the performance of the above rewrite is not acceptable, then you may need create 2 temp tables, as a clustered index #GROUP_BY_ONE and #GROUP_BY_TWO both clustered on CLCL_ID, and push the reference to the temp tables into the subquery so a positioned lookup can be made. select * from IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND MATCH_STATUS_CD = '' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND (MATCH_PRPR_ENTITY = 'F' AND CLCL_ID NOT IN ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY IN ('', 'P')) AND EXISTS (select * from #GROUP_BY_ONE WHERE IHC_NPI_MATCHING.CLCL_ID = #GROUP_BY_ONE.CLCL_ID) ) OR ( MATCH_PRPR_ENTITY = 'P' AND CLCL_ID NOT IN ( SELECT CLCL_ID FROM IHC_NPI_MATCHING WHERE CLPR_TYPE = 'RC' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND MATCH_PRPR_ENTITY IN ('', 'G', 'F')) AND EXISTS (select * from #GROUP_BY_TWO WHERE IHC_NPI_MATCHING.CLCL_ID = GROUP_BY_TWO.CLCL_ID) ) go Also, note that the way the original query is written, you may have an unintended precedence, that may be giving an answer that is unexpected. ANDs have precedence over ORs, and will get evaluated first, so that the possibility of using any index on some of the predicates at the beginning of the WHERE will not be taken advantage of... if it is intended that these search arguments get evaluated prior to the evaluation of the subqueries then you need to explicitly bracket the ORed subqueries. However, if the OR needs to be applied to everything then the current bracketing is OK. i.e. you may want to consider if the following bracketing is desired or not WHERE CLPR_TYPE = 'RC' AND MATCH_STATUS_CD = '' AND CLCL_CL_SUB_TYPE IN ('M', 'D') AND (( MATCH_PRPR_ENTITY = 'F' AND SUBQUERY1) OR (MATCH_PRPR_ENTITY = 'P' AND SUBQUERY2)) The above will allow search arguments CLPR_TYPE = 'RC' AND MATCH_STATUS_CD = '' AND CLCL_CL_SUB_TYPE IN ('M', 'D') to filter rows before evaluating the subqueries under the OR ... in the workaround rewrite, you may want to consider moving the search arguments out of the EXISTS, which would have the same effect as the above explicit bracketing.

CR:534180

CR Number:   534180 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2008 Bundled Request Description In a cluster server, during heavy DDL/DML operations, on rare ocassions server can hit error 1289. Stack traces reported might contain the word "des__revalidate".

CR:534240

CR Number:   534240 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed Description In rare circumstances for clusters with two or more instances, a 692 error, "Uninitialized logical page <pageno> was read while accessing...", or a 891 error, "rying to unhash a buffer which is in Dirty state.." may be reported in the errorlog after database binding operation fails.

CR:534275

CR Number:   534275 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.1 ESD #3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2008 Fixed Description In rare circumstances , stack trace may be reported in the errorlog showing message string like "Spinlock Pdes Chain Spinlocks at address owned".

CR:534281

CR Number:   534281 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plugin Status:   Closed OS:   all Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2008 Fixed Description Sybase Central ASE Plug-in needs to allow for sysindexes.fill_factor being NULL. If it is null, it will be displayed as 0 in the table Properties/Locking Scheme page. And the label is changed from "Fill factor (1 - 100)" to "Fill factor (0 - 100)". Workaround Description  Workaround is to issue: sp_chgattribute "table_name", "fillfactor", 0 to get rid of the null