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

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

CR:350658

CR Number:   350658 Product Name:   Adaptive Server Enterprise Product Component:   SQL Advantage Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2004 Fixed 15 Jul 2004 Fixed Description SQL Advantage returns incorrect syntax when there are comments in query. Tested and reproduced with: SQLAdvantage 12.5.0.3/EF 10752, 12.5.1 EBF 11428, 11.5.1.3 ASE 12.0.0.8, ASE 12.5.0.3, ASE 12.5.1 Workaround Description  use isql instead.

CR:350662

CR Number:   350662 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2004 Fixed Description Could not find any Documentation on Error Number 3021, as you can see below the message does exist in the server. 3021 10 2 Unable to write statistics for all indexes of object %ld in database %l d. Please run update statistics on all indexes after loading this database or pr ior to using the indexes in the loaded database.

CR:350686

CR Number:   350686 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2004 Fixed 23 Aug 2004 Fixed Description In a multi-engine ASE under very light load, a comatosed ASE engine may skip recognizing pending I/O on one of the networks as soon as possible leading to delayed I/O processing.

CR:350763

CR Number:   350763 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2004 Fixed Description When using trace flags 3607 or 3608 to bypass recovery or to recover master db only, error 840 will appear in the errorlog if configuration parameter 'enable rep agent' is not set to 0. Workaround Description  Check that configuration parameter 'enable rep agent' = 0, before starting the ASE server with -T3607, or simply ignore the error message printed to the log.

CR:350848

CR Number:   350848 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2004 Fixed 13 Mar 2006 DEFER Description Due to Large Identifier implementation in ASE, tooltip will appear for names in ASE Plugin to faciliate user of reading the object name without using scrolling.

CR:350856

CR Number:   350856 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2004 Consult Complete 06 Apr 2004 Fixed Description Memory allocated to java virtual machine may be insufficient, causing the server to hang on MacOS X. The solution is to configure more shared class heap space. For ASE on Mac OS X, the default "size of shared class heap" is 1536 memory pages (2048 bytes each). This can be increased by: sp_configure "size of shared class heap", 3072 Which will double the amount of memory available to the shared class heap, assuming there is sufficient shared memory available. Symptoms of this problem include a message similar to the following written to the ASE errorlog: 00:00000:00018:2004/03/29 16:16:55.18 server Java VM Host: Memory allocation request failed because of insufficient memory in Jvm Shared Class. 00:00000:00015:2004/03/29 16:26:48.06 kernel timeslice -501, current process infected

CR:350880

CR Number:   350880 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 May 2004 Not a Bug Description An arithmetic overflow occurrs when the internal expression evaluator chooses temp variables that are too small to contain transient data. Workaround Description  *** Monday, March 29, 2004 3:24:40 PM *** cooperg *** set arithabort numeric_truncation off go Play around with order and parens to get the expression to work. May not be acceptable to all customers.

CR:350907

CR Number:   350907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Nov 2004 Fixed Description The error 8201 "Keep count of descriptor (objid=<value>, dbid=<value>) was expected to be 1. Instead 0 was found." may be reported in the error log in module 'des_rekeep' when the statement cache option is active. The module 'des_lwpdescreate' will also be reported in the stack trace. Alternatively the error 8203 "Expected to find the descriptor for object <value> in database <value> in DROP state." may be reported in module 'des__markdestroy'. The modules 'ssql__rmplans' and 'des_objdrop' will also be reported in the stack trace. Workaround Description  Don't use statement cache feature.

CR:350919

CR Number:   350919 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2004 Fixed Description While configuring "number of devices" through sp_configure, ASE sometimes raise error that the number of devices should be greater than the highest device number used in sysdevices.

CR:350942

CR Number:   350942 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 20 Jan 2005 Third Party Problem 20 Apr 2004 Fixed 07 Dec 2004 Presently Not Targeted For Any Future Release Of This Product 14 May 2004 Fixed Description On HP platform, a signal 11 may be encountered in HP function U_get_previous_frame_x() while printing the stacktrace after a JVM failure.

CR:350946

CR Number:   350946 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Fixed Description "Cache Wizard" section is under "Sample interval and time reporting" sections. It should be in new section like other sysmon sections - Kernel utilization or Task management.

CR:350948

CR Number:   350948 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Basics Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2006 Fixed Description Remove internal comment from Cache Wizard Documentation

CR:351008

CR Number:   351008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2004 Fixed Description Replication Agent may report the error 691, including page '0', when trying to process an update where the before image has not been marked for replication.

CR:351032

CR Number:   351032 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Mar 2007 Fixed 19 Apr 2007 Fixed Description If a user does not supply password when invoking DDLGen from command line, he will be prompted to enter the password from the console.

CR:351067

CR Number:   351067 Product Name:   Adaptive Server Generic Docs Product Component:   P&T: Physical Database Tuning Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jan 2008 Added to user documentation Description sp_sysmon with default tempdb size can cause log full with 12.0.x and higher. Workaround Description  Extend tempdb size.

CR:351074

CR Number:   351074 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2004 Fixed 21 Jan 2005 Fixed 29 Jul 2004 Fixed 31 Jan 2005 Fixed 29 Jun 2005 Fixed Description A 614 error, "Adaptive Server accessed a row that has an illegal length of <length> while in database <dbname> ... The page size is <pagesize>." may be reported when a transaction doing DELETE and UPDATE operations on a Data Only Locked table is rolled back. The session is terminated abnormally and may not have its resources cleaned up.

CR:351077

CR Number:   351077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 02 Aug 2005 Fixed 10 Aug 2005 Fixed 11 Aug 2005 Fixed Description In an Active/Passive HA configuration, a Backup Server process remains on primary node even though failover is successful.

CR:351104

CR Number:   351104 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed 27 Apr 2004 Fixed Description When the configuration parameter 'number of pre-allocated extents' is set to zero, or ASE has been started with -T1101 to disable large page allocation, DBCC TABLEALLOC may report a 12909 error after data has been inserted into an All Pages Locked table using fast BCP.

CR:351116

CR Number:   351116 Product Name:   Adaptive Server Enterprise Product Component:   SQL Expert Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2004 Fixed Description After installing SQL Expert or Database Expert the SYSAM Service is removed. Workaround Description  The workaround for Database Expert is to either specify '.\setup.exe -W bean.active=false' or to stop the SYSAM service prior to installation 'net stop SYSAM'. You can restore Sysam service by running the sysam.bat file in the sybase\SYSAM-1_0\bin directory. All you need to do is pass in the path to the SYSAM-1_0 directory. ex. sysam.bat C:\sybase\SYSAM-1_0 The workaround for Database Expert is to either specify '.\setup.exe -W bean.active=false' or to stop the SYSAM service prior to installation 'net stop SYSAM'.

CR:351124

CR Number:   351124 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jun 2010 Duplicate Description Feature request to have ASE support NTFS directory and file names that include spaces.

CR:351152

CR Number:   351152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description The RTMS_MSGBODY_FORMAT and RTMS_MSGBODY_SCHEMA ASE properties have been renamed to ASE_MSGBODY_FORMAT and ASE_MSGBODY_SCHEMA respectively.

CR:351168

CR Number:   351168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Apr 2004 Fixed Description Due to a bug in RH AS 2.1 [Issue #351168 shmat() not returning EINVAL when already mapped address is passed as start address], ASE may use one block of memory as two separete memory blocks. This can result in unpredictable results and data corruption. Workaround Description  1. Set Linux shared memory segment size to 2Gb for example you can set kernel.shmmax to 2Gb 2. Set ASE config parameter 'max memory' to 2.7 Gb or less. 3. Set ASE config parameter 'allocate max shared memory' to 1 and boot ASE with this configuration. Do not change this value during run time from 0 to 1.

CR:351354

CR Number:   351354 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Apr 2004 Duplicate Description Feature request to provide a way to rename or move a master device once it has been mirrored.

CR:351364

CR Number:   351364 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2004 Fixed Description A stored procedure that creates table with a column declared NOT NULL based on a nullable user defined datatype is able to insert NULL values into the table.

CR:351369

CR Number:   351369 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation Bulletin for Solaris Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2004 Fixed Description This problems seems to affect all the 12.5.1 release bulletins except for the HP one. The problem is in this section: 4.2 Adaptive Server 12.5.1 backward compatibility. The problem is this sentence: You can to earlier 12.5.x versions of Adaptive Server, but to do so you must take the precautions described in the technical note before using any of the new 12.5.1 features. The sentence should say: You can downgrade to earlier 12.5.x versions of Adaptive Server, but to do so you must take the precautions described in the technical note before using any of the new 12.5.1 features. The "downgrade" is missing, the, Release Bulletin Adaptive Server Enterprise Version 12.5.1 for IPF/HP-UX is correct.

CR:351422

CR Number:   351422 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2005 One-off Provided Description INSTRUMENTATION: ASE engine dies without any trace

CR:351446

CR Number:   351446 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2004 Not a Bug Description The 12.5.2 installer doesn't show the license text in the language chosen. e.g Dutch, Norwegian, Danish and Swedish license files are in English.

CR:351485

CR Number:   351485 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2010 Insufficient priority to fix Description Customer requests that ASE has a way to confirm whether the logical host is failed back before we start recovering databases, as that would prevent corrupt primary server's master.

CR:351506

CR Number:   351506 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   macosx Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.3 05 Aug 2004 Fixed Description In the Job Scheduler Schedule properties window, the schedule start time will incorrectly display the current server time rather than the schedule's start time.

CR:351545

CR Number:   351545 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2004 Fixed 16 Apr 2004 Fixed 22 Apr 2004 Fixed Description When the statment cache is configured and a query includes a system table update, the first excution of the query works correctly. If the user changes the "allow updates" state, the new state is ignored when the exact same query is subsequently executed.

CR:351576

CR Number:   351576 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) To Be Determined 25 Jun 2004 Fixed 10 Jun 2004 Fixed 30 Jul 2004 Fixed 17 Sep 2004 Fixed Description Stacktraces may occur in the jvm garbage collector code. The following function are part of the stacktrace: GarbageCollect (), WalkReferences (), IsFirstFrame().

CR:351586

CR Number:   351586 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Installation and Configuration Guide-ASE Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2004 Fixed Description Character set of ASE can be changed using reource file. Sample resource file sqlloc.rs is located in $SYBASE/ASE-12_5/init/sample_resource_files/ directory. There is no documentation of this resource file in any manuals/guides.

CR:351608

CR Number:   351608 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2004 One-off Provided Description INSTRUMENTATION: Some of the ASE clients appear to hang. ASE itself is not hung, new client connections are successful, but some commands do not run properly, possibly because the blocking process is holding a lock on tempdb..syslogs.

CR:351618

CR Number:   351618 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2004 Fixed 09 May 2004 One-off Provided Description CIS : Omni server class, RPCServer, does not allow the setting of encryption, CS_SEC_ENCRYPTION, on remote openserver logins. Workaround Description  No workaround possible as the customer needs the rpc capabilities

CR:351656

CR Number:   351656 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description Stacktrace may occur in ASE jvm. The stack contains the following functions : VMClassLoader::Destroy(), VMClassLoader::CreateInstance(), FindOrCreateLoader(). This usually occurs when the server runs out of memory to launch the jvm.

CR:351670

CR Number:   351670 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Apr 2004 Duplicate Description Should the RepAgent replicate DDL commands executed from a non_replicated database? When it effects tables in a primary database that is marked to replicate DDL?

CR:351687

CR Number:   351687 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2004 Fixed Description A call of sp_msgadmin 'remove', 'subscription', 'xxx' returns successfully if the subscription 'xxx' does not exist. With the fix to this CR it will raise an exception.

CR:351764

CR Number:   351764 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed 15 Jul 2004 Fixed Description If an optdiag output file is specified and the password is not given, then optdiag does not prompt for a password and fails to connect to the server.

CR:351771

CR Number:   351771 Product Name:   Adaptive Server Enterprise Product Component:   DDLGen Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2004 Fixed Description DDLGen doesn't check the necessary permission before issuing setuser, causing errors. This is now fixed. For various other places where DDLGen needs user to have select permission on system catalogs, the appropriate errors will still be thrown.

CR:351808

CR Number:   351808 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed 27 Apr 2004 Fixed Description The DBCC DBREPAIR(<dbname>, fixlogfreespace) maintenance command unexpectedly resets the data free space accounting with empty database counts. Workaround Description  . Once the data free space count are off, one of the following would reinstanciate the right counts : - dbcc usedextents(db, 0, 1, 1) - non polite shutdown + server restart - polite shutdown + server restart using -T7409 . Otherwise, don't use DBCC DBREPAIR(db, fixlogfreespace), but instead use dbcc tablealloc(syslogs, full, fix), this will fix the log free space count without touching the data free space count.

CR:351817

CR Number:   351817 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2004 Fixed Description ASE Install guide states: Upgrading, or dump and load migration is not supported from 11.0.x to 12.5.x. You would have to upgrade to at least 11.5.x first. The newest version of ASE you can upgrade 11.0.3.x to is 12.0. However, if you look in the 12.5.1 System Admin Guide here, it states that you can't load a pre 10.x dump, which to ct means that we support loading an 11.0.3 dump, and it will automatically be upgraded by a 12.5 server.

CR:351919

CR Number:   351919 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) 21 Mar 2006 Fixed Description After upgrade, table level statistics on system tables are wrong.

CR:351934

CR Number:   351934 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2004 Fixed Description If the mirrored master device is corrupt or not readable, ASE fails to boot rather than failing over to mirror device when started with '-r' option.

CR:351942

CR Number:   351942 Product Name:   Adaptive Server Generic Docs Product Component:   Troubleshooting:Error Messages Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error message 1204 is documeneted wrong in the Troubleshooting and Error Messages Guide: Error 1204 Severity 19 Error message text SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS. Should be 17 not 19.

CR:351965

CR Number:   351965 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description In rare circumstances the message "process infected with 11" in the module 'buf__unhash_and_keep_grabbed_mass' may be reported on a server that uses a lot of memory (more than 1GB) some time after the creation (and possible destruction) of a buffer pool. In 12.5.1 and above, boot time recovery may automatically create (and later destroy) such a buffer pool. Workaround Description  Boot the server with -T3474 to disable buffer pool tuning during recovery. Avoid creating or increasing the size of a pool at run-time using a source pool of a lesser size (for example, avoid creating a 16K pool using buffers from the 2K pool). Modify these pools either by editing the configuration file, or by rebooting ASE immediately after the sp_poolconfig has been run.

CR:351981

CR Number:   351981 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2005 Fixed Description CIS: When UPDATE STATISTICS with sampling is issued against a proxy table, an incorrect message 2727, "Cannot find index ' '" is raised. Workaround Description  CIS doesn't support update statistics with sampling anyway, so the workaround is not to try to use sampling with CIS.

CR:351983

CR Number:   351983 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 May 2004 Fixed 27 Jul 2004 Fixed 14 Sep 2004 Fixed Description Importing data with the bulk copy utility into a Data Only Locked table that has an index defined on a column of CHAR datatype may result in the corruption of the given table. ASE may then shutdown itself implicitly with the modules 'bulk__normal', 'dol__ncinsert', 'bt__splitleaf' and 'bt__addrids_to_nonleafrow' reported in the stack trace in the error log. Workaround Description  1) Drop the indexes. 2) Change the column to varchar.

CR:351984

CR Number:   351984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2004 Fixed Description The message "Current process infected with 11" in the module 'memshrink' together with a stack trace which includes the modules 'update_statistics_col' and 'ups__minorattributes' may be reported in the error log when an UPDATE STATISTICS or an UPDATE INDEX STATISTICS command is executed.

CR:352027

CR Number:   352027 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2004 Fixed Description A 7951 error may be reported by DBCC CHECKTABLE after a valid XML document that is encoded in a multi-byte character set, has been BCP'd into this table. Workaround Description  Copy all data to another using SELECT INTO command after bcp in.

CR:352044

CR Number:   352044 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 May 2004 Fixed Description If character set conversion is already active, executing the statement "set char_convert on" will cause incorrect information to be reported via the global variables @@char_convert and @@client_csid, and it may ultimately lead to the process being terminated with a a stack trace. Workaround Description  Do not set the conversion on when connected with different charset than the server. The conversion would be set to ON automatically when client connected with different charset. If the user doesn't know if the client connection would be using different charset, then they should check the conversion status first before setting it on/off accordingly by 'select @@char_convert'. If the status is 1 (conversion is ON), then don't set it on again.

CR:352081

CR Number:   352081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for 'send doneinproc option' to send rowcount status for modifications

CR:352103

CR Number:   352103 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2004 Fixed Description CIS: SELECT..INTO from proxy table command against DB2 backend is slow when the WHERE clause is not forwarded to the remote server. Workaround Description  -

CR:352122

CR Number:   352122 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2004 Fixed 26 Aug 2004 Fixed Description The Server User Identifier, ServerUserID, has been added to the monProcessActivity, monProcessSQLText and mnSysSQLText Monitoring Tables.

CR:352125

CR Number:   352125 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2004 Fixed Description In the monProcessStatement and monSysStatement Monitoring Tables report the DBID of the current database (rather than 0) when the statement being executed is not part of a stored procedure.

CR:352153

CR Number:   352153 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 May 2004 Fixed Description A 257 error, "Implicit conversion from datatype <datatype1> to <datatype2> is not allowed" may be raised when inserting a NULL value using a parameterized statement and the datatype of the parameter does not match with the datatype of the column.

CR:352161

CR Number:   352161 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2006 Fixed Description Feature Request that starting sp_start_rep_agent dbname 'recovery" provide more output information to the command line after repagent finished replaying the tran log of database.

CR:352168

CR Number:   352168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2010 Insufficient priority to fix Description Customer would like a way to get a count of the number of executable statements (DML) in a stored procedure and would also like to be able to get a count of variable declarations in a stored procedure.

CR:352213

CR Number:   352213 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2004 Fixed Description sp_monitor "procedure" will no longer monitor light weight processes.

CR:352219

CR Number:   352219 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed Description Under certain conditions when sp_monitor "procedure" is executed Arithmetic overflows could occur. Also, under certain conditions when sp_monitor "connection" or sp_monitor "statement" is executed the columns SPID, LoginName, ElapsedTime, CPU_Time, PhysicalReads, LocksHeld would by empty and only the SQL Text column would be displayed.

CR:352223

CR Number:   352223 Product Name:   Adaptive Server Enterprise Product Component:   SDBE Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2004 Fixed Description In some cases the Database Expert Migration Analyzer did not report that a query plan changed between ASE releases.

CR:352224

CR Number:   352224 Product Name:   Adaptive Server Enterprise Product Component:   SDBE Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2004 Fixed Description In the Database Expert Configuration Analyzer, Migration Analyzer and Index Impact Analyzer a negative total cost value is shown when the total cost is greater then 2147483647.

CR:352227

CR Number:   352227 Product Name:   Adaptive Server Enterprise Product Component:   SDBE Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2004 Fixed Description Ad-hoc inspecting using the SQL Inspector does not update the Start Time and End Time column. correctly when the inspector finishes collection. This may make it appear that the collector is still running.

CR:352233

CR Number:   352233 Product Name:   Adaptive Server Generic Docs Product Component:   Adaptive Server Troubleshooting Guide Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jul 2004 Fixed Description ASE Troubleshooting and Error Messages Guide Vol 1 has the steps of creating sp_marksuspect and sp_resetstatus in the wrong order.

CR:352238

CR Number:   352238 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2005 Fixed Description Installshield creates masterdb default size of 6Mb eventhough you define a different size during custom installation. Workaround Description  Login to the server and do "alter database master on <device> = <size>".

CR:352247

CR Number:   352247 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2004 One-off Provided Description INSTRUMENTATION: Some of the ASE clients appear to hang. ASE itself is not hung, new client connections are successful. Pending task list shows a CREATE TABLE statement trying to insert a row into tempdb..sybtabstats waiting for some event to complete.

CR:352309

CR Number:   352309 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2004 Fixed 26 Apr 2006 Not reproducible with latest version of the product available as of Resolution Date Description Query with DISTINCT and ORDERBY may sometimes fail to provide required order. This may happen if the server is configured to use backward scans. Workaround Description  1) disable backward scans 2) enable parallelism in the server or force parallelism for the table scan (eg ... FROM t1 (parallel 2) 3) use a groupby ... order by instead of distinct ... orderby 4) Dont force anything 5) Only force the join order (set forceplan)

CR:352329

CR Number:   352329 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2005 Reservation Made Description Overflow, divide by zero and domain errors were being downgraded from EX_USER to EX_INFO.

CR:352443

CR Number:   352443 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2004 Fixed Description An unassigned bit variable was assigned a null, however when it was assigned explicitely a null, these variables are zeroed out. The behaviour has been made consistent and an unassigned variable is now assigned a 0 as well. Also, the error 403, 'Invalid operator for datatype op: is null type: BIT.' was incorrectly raised when using the predicates IS NULL or IS NOT NULL, or the built-in COALESCE with a bit column or variable.

CR:352478

CR Number:   352478 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description On a system which is very busy or has very large buffer caches, the message "timeslice <value>, current process infected" may be reported in the error log when selecting from monCachedObject. The stack trace does not identify the offending select from monCachedObject.

CR:352509

CR Number:   352509 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2004 Fixed 05 Oct 2004 Fixed 25 Oct 2004 Bundled Request 25 Oct 2004 Bundled Request Description This change affects the layout of the various Job Scheduler wizard and property windows. While no new controls were added, some fields have been moved to different wizard pages or property tabs and borders have been removed. There has been no change in functionality nor have any of the underlying stored procedures or API been changed.

CR:352548

CR Number:   352548 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2004 Fixed Description Sybase Central ASE Plug-in has 'User Tables' subfolder under Proxy databases, which is not correct as all tables in Proxy Databases are Proxy Tables.

CR:352568

CR Number:   352568 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2004 Fixed Description In rare circumstances, ASE may hang forever if the IO subsystem is overloaded and a process goes to sleep while holding the default data cache spinlock. The call stack of this process will show the modules 'dstartio', 'kd_p_semaphore' and 'upsleepgeneric'. Workaround Description  It is very a very hard problem to reproduce. The probabilities increase if the IO system is so saturated that the async io calls return a SDTRYAGAIN error.

CR:352586

CR Number:   352586 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2004 Fixed 01 Nov 2004 Insufficient priority to fix Description In rare circumstances error 11068 may be raised during the parallel execution of a select-into command in module 's_estmt_loopend' reported by a stack trace in the error log.

CR:352587

CR Number:   352587 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2004 Bundled Request Description The sp_shmdumpconfig stored procedure does not consider the amount of memory configured for the statement cache when calculating estimated shared memory dump file sizes.

CR:352600

CR Number:   352600 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2004 Fixed Description The sp_shmdumpconfig stored procedure prints a message saying that DEFAULTS is not a valid shared memory dump condition.

CR:352636

CR Number:   352636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description There is no message printed when DBCC CHECKCATALOG with the 'fix' option fixes an error.

CR:352660

CR Number:   352660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: Add an "in memory" option for temporary databases that disables all physical I/O for that database. The database would be bound to a named cache of sufficient size and would not require physical devices to back the space.

CR:352672

CR Number:   352672 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2004 Presently Not Targeted For Any Future Release Of This Product Description Feature request for a rand() function variant that would generate a different value for every row when multiple rows are affected by a query.

CR:352702

CR Number:   352702 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 May 2004 Insufficient priority to fix Description Feature request to have ASE continue to try to update the failed login count in cases where it currently gives up and prints "failed to update syslogins" to the errorlog.

CR:352766

CR Number:   352766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2004 Bundled Request Description The sp_shmdumpconfig stored procedure does not correctly calculate estimated shared memory dump file sizes for the configured shared memory dump conditions when the procedure cache is omitted from the shared memory dump.

CR:352796

CR Number:   352796 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: allow the database page size to be specified by object instead of server-wide.

CR:352801

CR Number:   352801 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2004 Fixed Description The scripts runproducer, runconsumer, stopproducer, stopconsumer, runws, and stopws now accept the tokens "" and '' as a null string password for the option -P. In addition, if no argument is given for the -P option, the value of the password is also assumed to be a null string.

CR:352802

CR Number:   352802 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Apr 2004 Fixed Description The functionality for invoking the Consumer are now available in SybCentral. The web pages that provided an interface to the Consumer did not work properly and are no longer available.

CR:352817

CR Number:   352817 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2004 Fixed Description *** Wednesday, May 26, 2004 4:11:19 PM *** ralmeida *** Problem : To make this useful to customers, we need to enhance sp_depends to also report the column level dependencies. Currently, sp_depends supports: sp_depends <tablename> [, <column name> ] By default, sp_depends lists all compiled objects that depend on table <tablename>. This shows up as the 1st chunk in the output. Solution : sp_depends will now filters the 1st chunk of output to restrict the list of compiled objects that actually use the specified column. This information can be obtained from the column ID map.

CR:352826

CR Number:   352826 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description RepAgent does not replicate "drop view" if issued from within a procedure Workaround Description  No workaround, Trying to create the the sproc w/o the execute immediate results in error... 1> create proc myproc as 2> if object_id('view_test') is not null 3> drop view view_test 4> else 5> create view view_test as select * from rep_test1 6> go Msg 192, Level 15, State 1: Server 'BAPDS', Procedure 'myproc', Line 5: Can't create a view inside a stored procedure. the 'exec' usage w/in the sproc might not be fully supported. Our support for execute immediate is a bit "blurry", not all things will work.

CR:352912

CR Number:   352912 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Dec 2004 Fixed Description CIS: CREATE TEMPORARY DATABASE command with WITH DEFAULT_LOCATION and FOR PROXY_UPDATE options may result in error 691. With the fix, the CREATE TEMPORARY DATABASE command cannot be used with the WITH DEFAULT_LOCATION and FOR PROXY_UPDATE clause. The sp_defaultloc stored procedure will also not be able to remap objects in temporary databases.

CR:352972

CR Number:   352972 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2010 Fixed 06 Mar 2012 Added to user documentation 25 Nov 2011 Fixed Description A new option is provided to turn ON/OFF FDP currency in MDA tables.

CR:352973

CR Number:   352973 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Apr 2004 Fixed Description CIS: INSERT <local table> SELECT * FROM <proxy table> inserts garbage when NULL source column is inserted into TEXT/IMAGE column.

CR:352980

CR Number:   352980 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.2 ESD#1 29 Apr 2004 Fixed Description Deleting a named cache with the same name as a configuration parameter results in the configuration option being deleted from sysconfigures.

CR:353003

CR Number:   353003 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2004 Fixed Description The two-phase commit stored procedures are not installed when using syconfig.exe, sybatch.exe, srvbuild[res], or sqlupgrade[res] to configure or upgrade an Adaptive Server.

CR:353014

CR Number:   353014 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Linux Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 May 2004 Fixed Description The system dynamic loadable shared object sybsysesp.so supporting xp_cmdshell could terminate with a signal 11 (segmentation violation) under constructs where no external o/s command did execute.

CR:353066

CR Number:   353066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jan 2005 Fixed Description The fix for CR 274800 and CR 287252 was incomplete. As a result an isolation level 0 query involving TEXT/IMAGE data, could hang or fail with the message 'illegal TDS token received'. Workaround Description  n/a

CR:353095

CR Number:   353095 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jul 2004 Third Party Problem Description Disk init hangs on large device when using TCP on NetApp Workaround Description  use trace 1623

CR:353098

CR Number:   353098 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description The message "infected with 11 in module prot_desc" is printed in the errorlog together with a stacktrace containing the modules 's_normalize', 'colnames_driver' and 'prot_desc' when a SELECT * FROM [ ] is executed whereby the tablename consist of one or multiple spaces.

CR:353102

CR Number:   353102 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2004 Fixed Description A 2601 error, "Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers2'" could be raised by a migration tool that tried to recreate user defined roles from a server where any of the roles DTM_TM_ROLE, HA_ROLE, MON_ROLE, MESSAGING_ROLE, JS_ADMIN_ROLE did not exist. Workaround Description  Delete entries for system roles from sysusers and sysroles.

CR:353109

CR Number:   353109 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   all Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2004 Fixed Description EFTS 12.5.2 is missing all of the extended language support (including Japanese, Chinese, and Korean). Note - The extended languages are only supported on Solaris and Windows.

CR:353173

CR Number:   353173 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to require a "with override" clause for DISK INIT to overwrite a raw partition that contains ASE data. Workaround Description  Set up each Sybase instance under a different "sybase" user, with permissions on the raw partition only to that user.

CR:353176

CR Number:   353176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jul 2004 Not a Bug Description Write out error messages that exist in sysmessages with their error numbers and severity , eventhough they are informational.

CR:353257

CR Number:   353257 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2004 Fixed 05 Aug 2004 Fixed 17 Aug 2004 Fixed Description Partition level statistics need to be displayed in the Monitoring Tables. The monCachedObject and monProcessObject tables should be updated to add Partition information, and a new table monOpenPartitionActivity added to report statistics for all open partitions.

CR:353277

CR Number:   353277 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2004 Fixed Description Sample program xp_echo.c does not compile on Mac OS X, and shared library does not build Workaround Description  none.