Release Bulletin Adaptive Server® Enterprise 15.0.2 for Windows
Release Bulletin Adaptive Server® Enterprise 15.0.2 for Windows
Document ID: DC71335-01-1502-02
Last revised: October 08, 2007
Accessing current release bulletin information
A more recent version of this release bulletin may be available on the Web. To check for critical product or document information added after the product release, use the Sybase Product Manuals Web site.Accessing release bulletins at the Sybase Product Manuals Web site
Enclosed is Sybase Adaptive Server Enterprise version 15.0.2. Server and client components are distributed on separate CDs.
For details on system requirements, including disk space and RAM, see the installation guide for your platform.
The installation kit includes:
Operating system requirements
Adaptive Server Enterprise version 15.0.2 has the following minimum operating system requirements:
Special installation instructions
Sybase strongly recommends that you install Adaptive Server version 15.0.2 into its own directory. Where this is not practical, install Adaptive Server version 15.0.2 last.
Adaptive Server Enterprise 15.0.2 includes new versions of many supporting components. The most current version of other Sybase products (such as Enterprise Connect™ Data Access 12.6) contain earlier versions of those same components. Installing Adaptive Server version 15.0.2 into the same directory with existing products should not impact the existing products.
See “Highlighted known installation issues” for known installation problems.
WARNING! Sybase recommends that you not install an older version of a Sybase product in a %SYBASE% directory that already includes a newer Sybase product as this may not work. For example, attempting to install Replication Server 12.6 on top of Adaptive Server 15.0.2 may make either Adaptive Server Enterprise or Replication Server inoperable depending on the choices taken during install.
JRE patch for daylight saving time and Sybase products
WARNING! It is necessary to download the latest DST patch for your specific platform. If you do not, applications written in Java may report the incorrect local time. See link below:
In the 2007 USA DST change, daylight saving time moved ahead 3 weeks in March and behind 1 week in October. This has affected the local reported time for JRE applications. A problem persists despite the fact that a new JRE has been released with updated DST specifications. Because of this, it is necessary that users install a patch. Download the appropriate patch for your platform at the Sybase Web site.
Once you have downloaded the appropriate patch follow the instructions below:
Apply the tzupdate tool with -bc (backward compatibility) and -f (force) options.
java -jar tzupdater.jar -bc -f
Installing Adaptive Server 15.0.2 with previous versions of Adaptive Server
If you install Adaptive Server version 15.0.2 onto the same machine as previous version of Adaptive Server, your older version will not work.
Installing both OpenServer and Adaptive Server on the same machine
If you plan to install both OpenServer and Adaptive Server on the same machine, install OpenServer prior to installing Adaptive Server.
If you have already installed Adaptive Server, then during the OpenServer install select “yes” when prompted to override older version of “OpenServer”, “srvlib”, “Common Ctlib” and “ctlib” components. Then you must use Adaptive Server 15.0.2 install program to reinstall CT-lib components to fix older files installed.
Installing Adaptive Server interim releases on top of existing installations
When an Adaptive Server interim release is applied on top of an existing Adaptive Server high availability installation, it overwrites files that are modified and saved during the original Adaptive Server high availability installation.
The Adaptive Server interim release replaces:
To avoid problems, complete the following tasks before any interim release installation:
Using SySAM 2.0
Starting with Adaptive Server Enterprise version 15.0, the Sybase Software Asset Management System (SySAM) implementation has changed. With these changes, SySAM configuration is no longer optional, and requires some changes in the Adaptive Server Enterprise installation and configuration process. Review the updated SySAM implementation and plan your SySAM deployment before you install Adaptive Server Enterprise.
See the Sybase Software Asset Management User’s Guide for complete details.
WARNING! Adaptive Server Enterprise works for an initial period of 30 days without proper SySAM configuration. If your configuration does not identify a valid license within this 30-day grace period, Adaptive Server Enterprise shuts down.
Monitoring and Diagnostic (MDA) tables
The installmontables script for installing Monitoring and Diagnostic tables (MDA) has been modified to now use the materialized parameter when defining the MDA proxy tables. This change results in improved performance for many queries using the MDA tables, making it no longer necessary to define a “loopback” remote server in your sysservers table in order to use the MDA tables.
Sybase recommends you reinstall the MDA tables using the installmontables script contained in this release.
Note:No changes are needed to the installmontables script unless you plan to use the MDA tables to monitor remote servers.
Make these changes to use the MDA tables to monitor remote servers:
If the remote server has not already been registered with the server on which you are installing the MDA tables, use the sp_addserver stored procedure to do so.
When installing the MDA tables in order to reference a remote server as described above, be sure to use the version of the installmontables script that came with the version of the Adaptive Server Enterprise installed at the remote server.
Use of the materialized directive has changed the way some error messages from the MDA tables are sent to the client application. If all configuration parameters required by an MDA table used in a query are not enabled, then the client application receives an error message.
Special uninstallation instruction
This section describes special uninstallation instructions.
Multiple Sybase products installed in same $SYBASE directory
If there are other Sybase products installed in the same $SYBASE directory as Adaptive Server that also make use of Sybase Central then if you uninstall Adaptive Server some .jar files used by Sybase Central will be removed and “files not found” error messages will display when you attempt to start Sybase Central after the uninstall.
Workaround: After Adaptive Server is uninstalled, re-install other Sybase products to $SYBASE and overwrite the old products.
Special upgrade instructions
This section describes special upgrade instructions for Adaptive Server.
Upgrading using allrows_dss in parallel
If you are using the configuration option allrows_dss when upgrading from a 15.0.x version to 15.0.2 in parallel mode, the server may stack trace when the optimizer selects a plan that requires tempdb, which has not yet been onlined.
Workaround: Change configuration from allrows_dss when rebooting with the new binary. After minor upgrade is complete the server can be returned to its previous configuration.
Disabling High Availability during upgrade
When High Availability (HA) is enabled, upgrading the master database in one server (for example, PRIMARY) attempts to apply the same changes to the other server (for example, SECONDARY).The result is that you cannot upgrade syspartitionkeys and sysslices because those tables do not yet exist. Consequently, the first server that is upgraded cannot upgrade the master database.
The upgrade on the second server succeeds, although you see several warning messages about the privileges not being revoked (message 4622, state 1). When you re-run the upgrade process on the first server, it then succeeds, although it also produces the same messages.
To avoid this problem:
Upgrading High Availability and cluster support
Adaptive Server version 15.0.2 supports the following cluster platforms for High Availability:
Adaptive Server does not support SunCluster2.2 and VCS1.3/2.0 HA agents on Sun Solaris. If you are using these agents, upgrade the respective cluster versions to configure Adaptive Server 15.0.2 for High Availability on Sun Solaris.
Upgrading the cluster subsystem
You can upgrade the cluster subsystem in two ways:
Upgrading Adaptive Server configured with high availability
The following procedure explains how to upgrade an Adaptive Server configured with High Availability. These upgrade steps are only applicable for major upgrades such as 12.5.x to 15.0.2.Upgrading a High Availability-enabled Adaptive Server in an active-active configuration:
Changes that affect existing applications
Following are changes in Adaptive Server that affect your existing applications.
Syntax updates for sysquerymetrics
insert select statements are supported but not insert value statements. select, delete, and update statements are supported when at least one table is involved and no Component Integration Services (CIS) are involved.
dbisql.bat launcher is no longer supported
DBISQL has a new launcher for Windows. The old launcher is removed and no longer supported. The new launcher is dbisql.exe located in %SYBROOT%\DBISQL\bin directory.
Merge existing lib config files manually
Merge any existing libtcl.cfg/libcl64.cfg manually to libtcl.cfg. Before doing so make sure the service provider entry names are unique in the configuration file being used. Make sure a softlink, libtcl64.cfg under $SYBASE/$SYBASE_OCS/config is created and is pointing to libtcl.cfg.
Support for certain traceflags has been removed from Adaptive Server
The traceflags 1630, 1639, and 1649 have been rendered obsolete. Support for these traceflags has been removed from Adaptive Server.
Adaptive Server version now supports Secure Sockets Layer (SSL) on: Windows 2003 X64 Enterprise Edition.
Cipher Suites not supported by OpenSSL
Cipher Suites supported by OpenSSL
We do not recommend you to use these cipher suites with 'anon' certificate exchange algorithms and 'NULL' session encryption algorithms. You can still use these cipher suites, but they must be explicitly specified and are not included in any pre-defined lists, such as All, Strong, Weak, and FIPS.
Sybase has made the following directory structure changes:
Changes to ODBC and OLE DB Driver support
Adaptive Server version 15.0 and later contains new ODBC and OLE DB drivers developed by Sybase. The third-party rebranded ODBC and OLE DB Driver Kits included with previous versions are no longer shipped.
The retired ODBC Driver Kit was installed in %SYBASE%\ODBC, and registered with the ODBC Driver Manager as “Sybase ODBC Driver.” The new Adaptive Server ODBC Driver by Sybase is installed in %SYBASE%\DataAccess\ODBC, and registered as “Adaptive Server Enterprise.” The version shipping with Adaptive Server and SDK 15.0 is version 15.0.2.
The retired OLE DB Driver Kit was installed in %SYBASE%\OLEDB, and used the provider short name of “SYBASE.OLEDBProvider” and the long name of “Sybase OLE DB Provider.” The new OLE DB Provider by Sybase is installed in %SYBASE%\DataAccess\OLEDB, and uses provider short name “OLEDB.” The version shipping with SDK 15.0 is version 15.0.2.
Sybase recommends that you update your ODBC Driver and OLE DB Provider to the new Sybase ODBC Driver and OLE DB Provider as soon as possible. Specifically, you should migrate:
For your convenience during the migration process, the third-party drivers and providers support connectivity to the 15.x version of Adaptive Server until November 29, 2007. They will not support new features added after Adaptive Server 12.5.3. Patches released after that date will perform a version check, and will not allow connection to Adaptive Server 15.x. This version-check behavior will only be incorporated in patches released after November 30, 2007. If patches released after November 30, 2007 are not applied, the third-party driver and provider can continue to connect to any versions of Adaptive Server available in the market.
See New Features for Open Server 15.0 and SDK 15.0 for Windows, Linux and UNIX, for instructions on migrating to the new drivers.
For more information on migrating to the new OLE DB Provider, see Open Server 15.0, Open Client 15.0 and SDK 15.0 and New Features Open Server 15.0 and SDK 15.0 for Microsoft Windows, Linux, and UNIX.
The release of PowerDesigner® Physical Modeling, included on the PC-Client CD with this release, no longer contains the DataDirect ODBC drivers that were previously bundled with the product. The Software Developer Kit (SDK), also included on the PC-Client CD, includes an ODBC Driver for Adaptive Server.
Changes that affect application behavior
This section discusses changes that affect application behavior.
Component Integration Services changes
Error message changes
jConnect version 6.05 ships with Adaptive Server Enterprise
Starting with Adaptive Server version 15.0 only jConnect™ for JDBC™ version 6.05 is shipped. If you have applications that are dependent on jConnect 5.5, Sybase recommends you either migrate those applications to jConnect 6.0 or use an existing jConnect 5.5 release area.
SQL Remote no longer ships on the PC-Client CD
SQL Remote has been replaced with a more flexible and powerful technology called MobiLink that provides bidirectional synchronization between ASA/UltraLite clients and various back-end databases, including Adaptive Server Enterprise. Download the developer edition of MobiLink.
Changes that affect database administration operations
This section discusses changes that affect database administration operations.
Usage of system built-in functions
Built-in functions that provide space information, such as data_pgs, reserved_pgs, used_pgs, ptn_data_pgs, and rowcnt have been replaced with data_pages, reserved_pages, used_pages, and row_count, respectively. See Reference Manual: Building Blocks for detailed information.
DDL and DML changes
System stored procedure changes
Common diagnostics changes including trace flag usage
System resource changes
Unpartitioning of user tables during upgrade
In version 15.0, each table partition must have a different partitionid. To avoid the expense of changing the partitionid for each page during the upgrade process, Adaptive Server Enterprise unpartitions any partitioned tables. Repartition these tables when the upgrade process completes.
Space management changes
Changes to transaction dump content
You can load a transaction dump from Adaptive Server Enterprise version 11.9.2, 12.0x, or 12.5x over a database dump or transaction dump that has preceded it in the load sequence.
However, if that transaction dump contains a create index transaction, then load transaction recovery treats that transaction’s sort record as the end of the log. Adaptive Server Enterprise does not process any more log records in that transaction, and does not allow load transaction dumps in the load sequence. This message prints:
The pre-15.0 log for database '%.*s' includes a create index incompatible with this server version and operating environment. Only transactions completed before create index will be recovered.
This behavior is much like the point-in-time recovery that is affected by the load transaction until_time option.
In contrast, Adaptive Server Enterprise should successfully load any database dump from one of the earlier versions, regardless of its content.
There is no content limitation in load database or load transaction when using a dump from a version 15.0.2 Adaptive Server Enterprise.
Open Client and Open Server changes
For information about changes that affect Open Client and Open Server, see the most recent release bulletins for these products at the Sybase Web site.
This section describes known problems and workarounds for Adaptive Server Enterprise.
Note:Sybase no longer includes System Problem Reports (SPR) and Closed Problem Reports (CPR) with your copy of Adaptive Server Enterprise. Known problems, which used to be in the SPR, are now described in this section of the release bulletin. Closed issues that were documented in the CPR are now searchable from Solved Cases at the Sybase Web site. To access the Solved Cases search form, click Support and Services | Solved Cases.
Column join issue with no case sort order and others
Workaround: There is no workaround for this issue.
Error message: “ks_falloc() memory allocation failed”
[CR# 468669] If you connect to Adaptive Server using Extended Password Encryption you may see error message: “ks_falloc() memory allocation failed” in the error log. This message may also appear if “net password encryption” is enabled for server-to-server communication.
Workaround 1: To prevent the memory leak from exhausting all resources, avoid using Extended Password Encryption in the client and set sp_serveroption “net password encryption” to “false” for any Adaptive Server Enterprise class remote server. You can find remote servers using the stored procedure “sp_helpserver”.
Workaround 2: To temporarily avoid the problem increase the value of the configuration parameter “additional network memory” or reboot the server to release memory resources.
Syntax error for Queries containing certain clauses
Workaround: Add '()' around the column name following 'order by' or ' group by'.
Scenario 1: When data is encrypted using a key with one or more key copies. The encrypted data is accessed through a stored procedure by two users. One user has access to the data through the base key and the other user has access through a key copy.
Workaround: The user who has access to data through the base key should always execute the procedure with the recompile option.
Scenario 2: When encrypted data is accessed through a stored procedure and the password on the base key is changed between consecutive executions of the procedure.
Workaround: Execute the stored procedure with recompile once after the base key's password has been modified. Subsequent executions of the stored procedure do not require recompile.
Source code text in syscomments corruption
[CR# 470100] If there are spaces before the create procedure keywords in a batch, the procedure source code text in syscomments may be corrupted. The first execution of these procedures after upgrade has marked them for recompilation, will generate a syntax error.
Workaround: If the execution generates a syntax error, re-create that procedure manually.
[CR# 469665] If you run update all statistics on syslogins in Adaptive Server 15.0.2, when you downgrade to a pre-15.0.2 Adaptive Server, queries selecting data from syslogins may encounter a 2708 error. This is due to the column length changes in the password field.
Workaround: Before running sp_downgrade on Adaptive Server 15.0.2, execute the two commands delete statistics master..syssrvroles(password) and delete statistics master..syslogins(password) to remove statistics for password columns.
syconfig cannot execute preupgrade
[CR# 470078]. If you install a new version of Adaptive Server in a different directory than the existing installation, the length of the path environment variable may exceed the maximum permissible length. As a result, syconfig may not be able to execute preupgrade during the upgrade process.
Workaround: Remove unwanted directories from the path and make sure new Adaptive Server installation directories are found in the path.
Deallocated sysindexes page is deleted
Workaround: There is no workaround for this issue.
Maximum password length for Adaptive Server
[CR# 471287] When a new login is created with a password longer than 30 characters, a warning is shown to indicate only the first 30 characters will be used for the password. However, using just the first 30 characters at connection time results in authentication failure.
Workaround: Only set passwords that are 30 characters or less. Reset any long password using sp_password to a password that is only 30 characters.
Password error message with encrypted columns key with user password
[CR# 465538] If a table has more than one column encrypted with same key protected by a user password and one of the columns is decrypted using alter table after setting password for that column, it results in error that the user password has not been set.
Workaround: Set encryption password to specify the key instead of the column.
Owner of a key copy can be made the new owner of the key
Workaround: The new owner should drop their key copy.
Workaround 2: The original key owner should drop any key copies held by the user to whom key ownership is being transferred.
Wrong or no error message with set encryption password
Workaround: When set encryption password statement specifies a column which is not encrypted, error 15424 is given wrongly.
sp_engine fails under certain scenarios
Workaround: Disable 'enable real time messaging' then reboot Adaptive Server before attempting to online an engine.
Scenario 2: If 'enable java' is set to 1 in the config file and its license is expired, after Adaptive Server is booted successfully, the attempt to online an engine will fail.
Workaround: Shutdown Adaptive Server. Modify the Adaptive Server config file to set 'enable java' as 0. Then reboot Adaptive Server and this time onlining an engine succeeds.
Sybase Central Plug-in failure
java.sql.SQLException: JZ006: Caught IO Exception:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: Certificate signature validation failed
Workaround: Exit Sybase Central and open it again. Afterwards, Plug-in will connect to the Adaptive Server using SSL.
Connection deadlock with two or more concurrent connections and LDAP authentication
[CR# 451821] A deadlock can occur while establishing a new connection resulting in the termination of a connection. This can occur when two or more connections from a multi-threaded client application to the same login account are attempted concurrently and LDAP User Authentication is used to authenticate the connections
Workaround: There is no workaround for this issue.
Installing PC-Client on 64-bit Windows platforms
[CR# 440048] You must install the 64-bit Adaptive Server on Windows 64-bit platforms. If you install the 32-bit version of PC-Client with a 64-bit Adaptive Server you will overwrite the 64-bit binaries with the 32-bit binaries.
Workaround: Only install 64-bit Adaptive Server products on Windows 64-bit platforms.
Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese
[CR# 439404] When you attempt to create a Job Scheduler schedule using the Adaptive Server plug-in for an Adaptive Server localized for Simplified Chinese, you occasionally receive an error indicating that the varchar datatype can not be converted to a date.
Workaround: There is no workaround for this issue.
Configuring Job Scheduler Self Management for Simplified Chinese
[CR# 439406] When you configure the Job Scheduler Self Management feature for an Adaptive Server localized for Simplified Chinese, you occasionally receive an error saying that a varchar datatype can not be converted to a date. The Job Scheduler configuration process stops at this point.
Workaround: Do not configure the Self Management feature for Simplified Chinese.
Installing an ESD overlay with Unified Agent
Workaround: Rename the old ARL.xml before you run the installer.
Highlighted known installation issues
This section contains information about known installation problems and their workarounds.
WARNING! If you have multiple Sybase products installed in the same %SYBASE% directory, uninstalling one of them may make the other products inoperable. If this happens, you may need to reinstall those remaining products.
Formatting the options file during a silent installation
Workaround: You can safely ignore these error messages. An accurate options file has been generated.
Warning message when installing ODBC Driver from or SDK 15.0
Workaround: This warning can be safely ignored. The ODBC Driver is functional at the end of the install.
Installing Adaptive Server 15.0.2 on top of Workspace
Workaround: Re-register these plug-ins manually.
[CR# 468836] When Adaptive Server is installed on top of Workspace two Start menu items are created for Sybase Central. Start | Programs | Sybase | Sybase Central v4.3 is created by Adaptive Server. The other Start | Programs | Sybase | Sybase Workspace | EAServer 5.3 | EAServer Manager is created by Workspace. The menu item created by Workspace will produce a “JRE not found” error message when started.
Workaround: Edit the target and “Start in” directory for this short cut to match the values from the menu item created by Adaptive Server.
EAServer manager and Security manager
[CR# 400839] The Adaptive Server Enterprise Sybase Central 15.0.2 install overwrites the EAServer Manager and the Security Manager. When you cannot access the EAServer Manager you cannot access Jaguar Manager.
Workaround: Copy the information about EAServer Manager and Security Manager from file C:\Sybase\WorkSpace\DevRuntimes\Shared\Sybase Central 4.3\.scRepository to the end of file C:\Sybase\Shared\Sybase Central 4.3\.scRepository, save it. You must restart EAServer Manager.
Installing Adaptive Server Anywhere with Adaptive Server Enterprise
On Windows, Adaptive Server Anywhere default directory is C:\Program files\Sybase, for Adaptive Server Enterprise 15.0.2 it is c:\Sybase. The Adaptive Server Anywhere Sybase Central's register session is overwritten by Adaptive Server Enterprise.
Workaround: Install both the Adaptive Server Anywhere and Adaptive Server Enterprise to the same directory, or manually re-register the ASA Sybase Central plug-in.
Interactive SQL and Adaptive Server Enterprise plug-in issues
This section discusses Interactive SQL and Adaptive Server Enterprise plug-in issues and their workarounds.
Connecting Adaptive Server Enterprise plug-in to RepConnector
[CR# 400709] The Adaptive Server Enterprise plug-in cannot connect to Adaptive Server Enterprise if RepConnector™ 2.5 and the Adaptive Server Enterprise plug-in 15.0.2 are installed in the same $SYBASE location.
Workaround: Install RepConnector and the Adaptive Server Enterprise plug-in into different $SYBASE directories.
Query support in Interactive SQL
Workaround: Use isql from the command line instead.
Monitor GUI does not start when the LDAP server is used
Workaround: Create an interfaces file with entries for the servers that are monitored and use this with the Monitor Client GUI.
allow backward scan does not work
Workaround: If you are encountering increased deadlocks while executing backward scans, separate problematic scans:
set statistics io does not display I/O generated by worker processes
[CR# 433611] After executing a parallel query, displays only show the alpha thread scan, and logical and physical I/O counts. set statistics io does not display I/O counts generated by worker processes.
Workaround: Use set statistics plancost on to display the I/O counts from alpha thread scan and any child threads in a graphical format.
Replication Server compatibility issues
Workaround: Create the RSSD database manually before using rs_init to create a new Replication Server if you do not use an Embedded RSSD. See the Replication Server Administration Guide for additional information.
Handling multibyte character sets during migration
[CR# 353079] If you configure multibyte character sets after migrating data from system catalogs sysattributes and sysxtypes, the text columns in these catalogs are inconsistent with the multibyte character sets.
Workaround: Manually run dbcc fix_text on sysattributes and sysxtypes to make the text columns consistent with the multibyte character sets.
Workaround: Update the existing Sybase Central version, or install Sybase Central in a new location.
[CR# 416569] When updating the filename column of a proxy table mapped to a directory of files, Sybase recommends that you qualify the update to specific files by having the filename included in the where clause of the update. Since some file systems may implement a rename as a deletion followed by the creation of a new directory entry, the same filename could be updated multiple times if the update were not restricted.
For example, this statement could cause multiple updates:
update t1 set filename=filename + 'old' where filetype = 'REG'
Workaround: Add a clause such as 'and filename like '%.c' .
Running syconfig with LANG variable set
[CR# 426402] If you have not yet installed additional language and character sets, unset the LANG environment variable before running syconfig utility. If you do not, connectivity errors may prevent syconfig from completing the tasks.
Workaround: Unset the LANG environmental variable before running syconfig.
sp_configure current audit table
sp_configure 'current audit table' <number>
You see an informational message:
18932, "Resulting configuration value and memory use have not changed from previous values: new configuration value %1!, previous %2!."
Workaround: There is no workaround for this issue.
Error while executing SQL for migration
2002/07/16 17:28:02.818\TASK (1:11)\ERROR\ Error while executing SQL for migration of 'P.dbo...rsm_where_list;1' Root Cause;Msg 208, Level 16, State 1 Server DST, Procedure rsm_where_list, Line 52, Status 0, TranState 1 #subs not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Msg 208, Level 16, State 1 Server DST, Procedure rsm_where_list, Line 67, Status 0, TranState 1 #rules not found. Specify owner.objectname or use sp_help to check whether object exists (sp_help may produce lots of output). Msg 208, Level 16, State 1 Server DST, Procedure rsm_where_list, Line 70, Status 0, TranState 1 #rules not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Workaround: User must manually create this store procedure after the migration.
This section lists the Sybase components that are compatible with Adaptive Server version 15.0.2. For information about operating system requirements, see individual component documentation.
Note:The DirectConnect for Informix, DirectConnect for Microsoft SQL Server, and DirectConnect for DB2 UDB do not support LDAP.
The following components have been tested for compatibility with Adaptive Server Enterprise version 15.0.2:
Adaptive Server interoperability
The following tables show the interoperability of Adaptive Server version 15.0.2 against other Sybase products across different platforms and versions, as well as client products. For specific platform or operating system level information, perform a search at the Sybase Certification Web page for the appropriate platform certification.
Note 2 Interoperability between big-endian and little-endian platforms has also been verified. Windows and Linux-32 platforms are little-endian. IBM AIX, Sun Solaris, Linux on Power, and HP-UX are big-endian platforms.
Adaptive Server Replicator 15.0 support of Adaptive Server Enterprise 15.0.2 datatypes
Adaptive Server Replicator 15.0 does not support large identifiers, or these datatypes that are supported in Adaptive Server version 15.0.2: bigint, unsigned bigint, unsigned int, unsigned smallint, unitext, computed columns, XML, and encrypted columns.
Known compatibility issues
This section discusses known compatibility issues.
RTDS 4.0 incompatibility with 15.0.2
Sybase Real-Time Data Service (RTDS) version 4.0 is not certified on Adaptive Server 15.0.2. If you have RTDS 4.0, and you upgrade Adaptive Server to version 15.0.2, RTDS messaging stops. To use the RTDS feature, upgrade to RTDS 4.5.
Password compatibility with Replicator Server
The new 15.0.2 master device can only replicate to other 15.0.2 installations and not to 15.0.1 or other upgraded 15.x installations.
Installing Enterprise Connect Data Access (ECDA) or MainframeConnect DirectConnect for z/OS with other Sybase software
Sybase strongly recommends you install the ECDA DirectConnect option or MainframeConnect DirectConnect for z/OS, including DirectConnect Manager, into its own product directory.
Installing Replication Server with other Sybase software
Sybase strongly recommends that you install Replication Server, including Replication Server Manager (RSM), in its own product directory, separate from other Sybase products.
Using Job Scheduler templates
Sybase recommends that you upgrade to the Job Scheduler templates provided with Adaptive Server Enterprise 15.0.2. The templates contain important changes in support of new functionality, and use new functions reserved_pages and data_pages. For information on upgrading the templates, see Chapter 5, “Upgrading Adaptive Server,” in the installation guide for your platform.
Note:If you have existing jobs created from templates delivered with a pre-15.0 Adaptive Server Enterprise, see the 15.0 release bulletin for your platform and follow the upgrade steps there for the Job Scheduler templates. Then you can upgrade Job Scheduler templates as explained above.
Job scheduler context menus are nonstandard. The options on the Copy menu do not copy to the clipboard, but create new objects in sybmgmtdb.
Edit | Duplicate As is identical to the Copy command.
Documentation updates and clarifications
This section describes updates and clarifications for Adaptive Server documentation.
Messaging Services User's Guide
The Adaptive Server Messaging Services User's Guide is no longer part of the Adaptive Server documentation set. The book is now called Real-Time Data Services Messaging Services User's Guide for Adaptive Server Enterprise, and is available as part of the documentation set for Real-Time Data Services. To obtain the most recent version of this book, go to SYBOOKS and select Real-Time Data Services from the product listing.
System Administration Guide
This section discusses updates and clarifications to System Administration Guide.
o/s file descriptors Summary and Information
The System Administration Guide lacks clarification on the behavior of configuration parameter o/s file descriptors. By default Adaptive Server uses just under 2000 max o/s file descriptors. Then Adaptive Server dynamically increases its usage of o/s file descriptors from the @@max_connections setting up to the max configured value allowed by the o/s upon startup. This number does not decrease though. To process DBA’s request to increase @@max_connections setting, Adaptive Server first check the o/s max setting.
@@max_connections stored number of file descriptors
The System Administration Guide needs to be updated in light of recent changes in code. The number of maximum connections that the file descriptors configuration allows can be higher than the number of maximum connections stored in @@max_connections. The number can dynamically increase with an increase in connections, however at startup it will default back to the previous stored number in @@max_connections.
enable metrics capture
The System Administration Guide contains incorrect summary information for 'enable metrics capture'. The correct information is captured below:
Transact SQL User’s Guide
Add the following to the “Overview” section of the “Partitioning Tables and Indexes chapter of the Transact SQL User’s Guide.
Range-partitioned tables and sort order change
If you change the sort order, Adaptive Server marks range-partitioned tables with character-bd partition keys as “suspect” in sysindexes. These restrictions apply when you run commands on tables that are marked suspect:
Reference Manual: Building Blocks
This section discusses updates and clarifications to Reference Manual: Building Blocks.
Corrections to global variables
Chapter 3, “Global Variables,” includes the following global variables, which return the values in ticks, but were described erroneously as returning the values in seconds. Replace the descriptions in the chapter with the following text:
Correction to example in curunreservedpgs
Example 1 for the function curunreservedpgs includes the following erroneous select syntax:
select db_name(dbid), d.name, curunreservedpgs(dbid, lstart, unreservedpgs) from sysusages u, sysdevices d where d.low <= u.size + vstart and d.high >= u.size + vstart -1 and d.status &2 = 2
Replace Example 1 in its entirety with the following text:
If a database is open, curunreservedpgs takes the value from memory. If it is not in use, the value is taken from the third parameter you specify in curunreservedpgs. In this example, the value comes from the unreservedpgs column in the sysusages table.
select db_name(dbid), d.name, curunreservedpgs(dbid, lstart, unreservedpgs) from sysusages u, sysdevices d where u.vdevno=d.vdevno and d.status &2 = 2
name ------------------------------ -------------------------- ----------- master master 1634 tempdb master 423 model master 423 pubs2 master 72 sybsystemdb master 399 sybsystemprocs master 6577 sybsyntax master 359 (7 rows affected)
Update in derived_stat
The information for the derived_stat built-in function in Reference Manual: Building Blocks is incomplete. Replace the entire reference section for derived_stat with the following:
Returns derived statistics for the specified object and index.
derived_stat("object_name" | object_id, index_name | index_id, ["partition_name" | partition_id,] “statistic”)
select derived_stat("titles", "titleidind", "space utilization")
select derived_stat("titles", 2, "dpcr")
1> select derived_stat(object_id("t1"), 2, "drcr") 2> go
1> select derived_stat(object_id("t1"), 0, "t1_928003306", "drcr") 2> go
--------------------------- 1.000000 (1 row affected)
select convert(varchar(30), name) as name, indid, convert(decimal(5, 3), derived_stat(id, indid, 'sput')) as 'sput', convert(decimal(5, 3), derived_stat(id, indid, 'dpcr')) as 'dpcr', convert(decimal(5, 3), derived_stat(id, indid, 'drcr')) as 'drcr', convert(decimal(5, 3), derived_stat(id, indid, 'lgio')) as 'lgio' from syspartitions where id = object_id('titles') go
name indid sput dpcr drcr lgio ------------------------------ ------ -------- -------- -------- -------- titleidind_2133579608 1 0.895 1.000 1.000 1.000 titleind_2133579608 2 0.000 1.000 0.688 1.000 (2 rows affected)
1> select * into mymsgs_rr4 partition by roundrobin 4 lock datarows 2> from master..sysmessages 3> go
(7597 rows affected)
1> create clustered index mymsgs_rr4_clustind on mymsgs_rr4(error, severity) 2> go 1> create index mymsgs_rr4_ncind1 on mymsgs_rr4(severity) 2> go 1> create index mymsgs_rr4_ncind2 on mymsgs_rr4(langid, dlevel) local index 2> go 2> update statistics mymsgs_rr4 1> 2> select convert(varchar(10), object_name(id)) as name, 3> (select convert(varchar(20), i.name) from sysindexes i 4> where i.id = p.id and i.indid = p.indid), 5> convert(varchar(30), name) as ptnname, indid, 6> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'sput')) as 'sput', 7> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'dpcr')) as 'dpcr', 8> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'drcr')) as 'drcr', 9> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'lgio')) as 'lgio' 10> from syspartitions p 11> where id = object_id('mymsgs_rr4')
name ptnname indid sput dpcr drcr lgio ----------------------------- -------------------------- ----- ---- ----- ---- ---- mymsgs_rr4 mymsgs_rr4 mymsgs_rr4_786098810 0 0.90 1.000 1.00 1.000 mymsgs_rr4 mymsgs_rr4 mymsgs_rr4_802098867 0 0.90 1.000 1.00 1.000 mymsgs_rr4 mymsgs_rr4 mymsgs_rr4_818098924 0 0.89 1.000 1.00 1.000 mymsgs_rr4 mymsgs_rr4 mymsgs_rr4_834098981 0 0.90 1.000 1.00 1.000 mymsgs_rr4 mymsgs_rr4_clustind mymsgs_rr4_clustind_850099038 2 0.83 0.995 1.00 1.000 mymsgs_rr4 mymsgs_rr4_ncind1 mymsgs_rr4_ncind1_882099152 3 0.99 0.445 0.88 1.000 mymsgs_rr4 mymsgs_rr4_ncind2 mymsgs_rr4_ncind2_898099209 4 0.15 1.000 1.00 1.000 mymsgs_rr4 mymsgs_rr4_ncind2 mymsgs_rr4_ncind2_914099266 4 0.88 1.000 1.00 1.000 mymsgs_rr4 mymsgs_rr4_ncind2 mymsgs_rr4_ncind2_930099323 4 0.877 1.000 1.000 1.000 mymsgs_rr4 mymsgs_rr4_ncind2 mymsgs_rr4_ncind2_946099380 4 0.945 0.993 1.000 1.000
2> select convert(varchar(10), object_name(id)) as name 3> (select convert(varchar(20), i.name) from sysindexes i 4> where i.id = p.id and i.indid = p.indid), 5> convert(varchar(30), name) as ptnname, indid, 6> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'sput')) as 'sput', 7> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'dpcr')) as 'dpcr', 8> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'drcr')) as 'drcr', 9> convert(decimal(5, 3), derived_stat(id, indid, partitionid, 'lgio')) as 'lgio' 10> from syspartitions p 11> where lockscheme(id) = "allpages" 12> and (select o.type from sysobjects o where o.id = p.id) = 'U'
name ptnname indid sput dpcr drcr lgio ----------- ----------------- --------------------------- ----- ---- ---- ---- ---- stores stores stores_18096074 0 0.276 1.000 1.000 1.000 discounts discounts discounts_50096188 0 0.075 1.000 1.000 1.000 au_pix au_pix au_pix_82096302 0 0.000 1.000 1.000 1.000 au_pix tau_pix tau_pix_82096302 255 NULL NULL NULL NULL blurbs blurbs blurbs_114096416 0 0.055 1.000 1.000 1.000 blurbs tblurbs tblurbs_114096416 255 NULL NULL NULL NULL t1apl t1apl t1apl_1497053338 0 0.095 1.000 1.000 1.000 t1apl t1apl t1apl_1513053395 0 0.082 1.000 1.000 1.000 t1apl t1apl t1apl_1529053452 0 0.095 1.000 1.000 1.000 t1apl t1apl_ncind t1apl_ncind_1545053509 2 0.149 0.000 1.000 1.000 t1apl t1apl_ncind_local t1apl_ncind_local_1561053566 3 0.066 0.000 1.000 1.000 t1apl t1apl_ncind_local t1apl_ncind_local_1577053623 3 0.057 0.000 1.000 1.000 t1apl t1apl_ncind_local t1apl_ncind_local_1593053680 3 0.066 0.000 1.000 1.000 authors auidind auidind_1941578924 1 0.966 0.000 1.000 1.000 authors aunmind aunmind_1941578924 2 0.303 0.000 1.000 1.000 publishers pubind pubind_1973579038 1 0.059 0.000 1.000 1.000 roysched roysched roysched_2005579152 0 0.324 1.000 1.000 1.000 roysched titleidind titleidind_2005579152 2 0.777 1.000 0.941 1.000 sales salesind salesind_2037579266 1 0.444 0.000 1.000 1.000 salesdetai salesdetail salesdetail_2069579380 0 0.614 1.000 1.000 1.000 salesdetai titleidind titleidind_2069579380 2 0.518 1.000 0.752 1.000 salesdetai salesdetailind salesdetailind_2069579380 3 0.794 1.000 0.726 1.000 titleautho taind taind_2101579494 1 0.397 0.000 1.000 1.000 titleautho auidind auidind_2101579494 2 0.285 0.000 1.000 1.000 titleautho titleidind titleidind_2101579494 3 0.223 0.000 1.000 1.000 titles titleidind titleidind_2133579608 1 0.895 1.000 1.000 1.000 titles titleind titleind_2133579608 2 0.402 1.000 0.688 1.000 (27 rows affected)
ANSI SQL – Compliance level: Transact-SQL extension.
Only the table owner can execute derived_stat.
Correction in xa_bqual example
Example 1 in the reference pages for the xa_bqual built-in function shows an incorrect binary translation. Replace the example with the following.
Example 1 Returns “0x227f06ca80”, the binary translation of the branch qualifier for the Adaptive Server Enterprise transaction ID “0000000A_IphIT596iC7bF2#AUfkzaM_8DY6OE0”. The Adaptive Server Enterprise transaction ID is first obtained using sp_transactions:
xactkey type coordinator starttime state connection dbid spid loid failover srvname namelen xactname ------------------------------ ----------- ----------- -------------------- ----------------- ---------- ------ ------ ----------- -------------------------- ------------------------------ ------- ----------------------------------------------------------------- 0x531600000600000017e4885b0700 External XA Dec 9 2005 5:15PM In Command Attached 7 20 877 Resident Tx NULL 39 0000000A_IphIT596iC7bF2#AUfkzaM_8DY6OE0
1> select xa_bqual("0000000A_IphIT596iC7bF2#AUfkzaM_8DY6OE0", 0) 2> go
... -------------------------------------------------------------------- 0x227f06ca80
Reference Manual: Commands
This section discusses updates and clarifications to Reference Manual: Commands.
Clarification in alter table
The Usage section of the alter table reference pages includes the following bulleted description:
Correction in create table
The Usage section of the create table reference pages includes the following information, which erroneously lists the limit of user-defined columns per table as 250:
The correct number of user-defined columns per table is 1024.
Correction in create trigger
The following bullet in the Usage section of create trigger is incorrect:
The correct text is:
Clarification in dbcc
Example 13 for the dbcc command is described as being an abbreviated output for the dbcc traceon(3604) command. You can obtain the same abbreviated version using dbcc serverlimits; running dbcc traceon(3604) results in a complete listing of limits in the server.
Correction in grant set proxy
The syntax for restricting roles using set proxy in the reference pages for the grant command incorrectly describes the parameter as “restricted role.” If you execute grant set proxy with this syntax, you see the following error:
1> grant set proxy to tester restricted role all 2> go
Msg 102, Level 15, State 1: Server 't15', Line 1: Incorrect syntax near 'restricted'.
The correct syntax is “restrict role”:
grant set proxy to role_list [restrict role role_list | all | system]
The error also appears in examples 38, 39, and 40 of the grant command.
Additional usage information for reorg
Add this note to the description of reorg reclaim_space:
Note:reorg reclaim_space only affects tables with variable-length rows, and only frees up space within a page. To reduce the number of pages used, use the reorg rebuild command.
Add these items to the Usage section of the reorg command description:
Correction in select
Beginning with Adaptive Server Enterprise version 12.5.4, you can specify the IDENTITY column with int, smallint, and tinyint, as well as precision.
[existing table] [[database.]owner.]table_name
This information is incorrect. Replace it with the following:
existing table table_name
In addition, example 13—which updated the existing authors table to include only books priced over $20—is incorrect, as it implied that the authors table existed, without including the existing keyword.
Correction in set proc_output_params off
The example provided for set proc_output_params off in the set command reference pages includes two errors in the output:
In the first portion, the value of @x returned from the command is erroneously listed as “2.” The value is 1, and appears in bold in the following corrected version:
In the second portion, the return parameters output is erroneously published as “3.” The value is 2, and appears in bold in the following corrected version:
1> create procedure sp_pout (@x int output) as select @x = @x + 1 2> go 1> set proc_output_params off 2> go 1> declare @x int 2> select @x = 1 3> exec sp_pout @x output 4> print "Value of @x returned from sproc is: %1!", @x 5> go (1 row affected) (return status = 0) Value of @x returned from sproc is: 1
If you do not perform set proc_output_params off, the output after (return status = 0) includes the following:
Return parameters: ----------- 2
The setuser command has no effect when creating a database.
Reference Manual: Procedures
This section describes updates and clarifications in Reference Manual: Procedures.
Add the following note in the description of sp_dbcc_deletehistory:
Note:sp_dbcc_deletehistory does not free any space associated with the deleted historical data, as workspaces are pre-allocated and of a fixed size.
sp_helpconstraint truncates keys
Add the following bullet in the Usage section of sp_helpconstraint:
sp_monitorconfig example updated with new parameters
Replace example 8 for sp_monitorconfig in the book with the following, which incorporates new parameters introduced in version 12.5.3:
1> create table sample_table 2> (Name varchar(35),Config_val int, System_val int, Total_val int, 3> Num_free int, Num_active int, Pct_act char(6), Max_used int, 4> Num_Reuse int, Date varchar(30)) 5> go
The name of the table created becomes the second parameter of sp_monitorconfig:
1> sp_monitorconfig "locks", sample_table 2> go
(return status = 0)
1> sp_monitorconfig "number of alarms", sample_table 2> go
(return status = 0)
1> select * from sample_table 2> go
Name Config_val System_val Total_val Num_free Num_active Pct_act Max_used Num_Reuse Date ------------------- ----------- ---------- --------- --------- ---------- ------- -------- --------- ------------------------------ number of locks 5000 684 5000 4915 85 1.70 117 0 Aug 23 2006 6:53AM number of alarms 40 0 40 28 12 30.00 13 0 Aug 23 2006 6:53AM
The result set saved to the table accumulates until you delete or truncate the table.
Note:If sample_table is in another database, you must provide its fully qualified name in quotes.
The reference pages for sp_poolconfig have been revised. Replace the pages for sp_poolconfig with the following.
Creates, drops, resizes, and provides information about memory pools within data caches.
To create a memory pool in an existing cache, or to change pool size:
sp_poolconfig cache_name [, "mem_size [P|K|M|G]", "config_poolK" [, "affected_poolK"]]
To change a pool’s wash size:
sp_poolconfig cache_name, "affected_poolK ", "wash=size[P|K|M|G]"
To change a pool’s asynchronous prefetch percentage:
sp_poolconfig cache_name, "affected_poolK ", "local async prefetch limit=percent "
sp_poolconfig pub_cache, "10M", "16K"
sp_poolconfig pub_cache, "16M", "32K", "64K"
sp_poolconfig pub_cache, "0K", "16K"
sp_poolconfig pub_cache, "2K", "wash=508K"
sp_poolconfig pub_cache, "2K", "local async prefetch limit=15"
Only a System Administrator can execute sp_poolconfig to reconfigure memory pools within data caches. Any user can use sp_poolconfig to get information about memory pools.
Values in event and extrainfo columns from the sysaudits table are:
sp_sproc_columns column_type description
In the reference pages for the sp_sproc_columns stored procedure, the table listing the result set includes the following description of the column_type column:
This information is erroneous and should be removed from the description.
Change in xp_cmdshell
The maximum length of the command parameter of the xp_cmdshell extended stored procedure has been expanded, from 255 to 8192 bytes.
Reference Manual: Tables
This section describes updates and clarifications in Reference Manual: Tables.
In the reference page for syscomments, the description for the status column is blank. Insert the following information:
The reference page for sysdatabases includes Table 1-8, which lists the status3 control bits for sysdatabases. In it, the 0x0001 status was left blank. Insert the following description:
This section describes updates and clarifications in the installation guide for your platform.
Run installmaster script when performing binary overlay
When performing a binary overlay you must run installmaster to pick up the new stored procedures.
Determining devices for a database
[CR# 407828] The installation guide gives incorrect information on how to determine which device a database is using. The infocenter.sybase.com search function may show many hits but it does not show the documents where the hits occur. See Appendix 2 of the installation guide for complete details.
Incorrect syntax for running uninstmsgs.ebf and instmsgs.ebf after upgrade:
Use the following syntax to run uninstmsgs.ebf:
isql -Usa -P<sa-password> -w1000 -iuninstmsgs.ebf -orestoremsgs.ebf
Use the following syntax to run instmsgs.ebf:
isql -Usa -P<sa-password> -iinstmsgs.ebf
If you downgraded back to original installation after upgrading to 15.0.2
You must restore the original messages by running the following script after downgrading the server.
isql -Usa -P<sa-password> -irestoremsgs.ebf
Performance and Tuning Guide: Monitoring
The behavior for sp_sysmon has changed so that you no longer have to specify the noclear option to prevent sp_sysmon from clearing the monitor counters. The noclear option is now the default behavior for sp_sysmon when you specify a sample interval.
If you run sp_sysmon using the begin_sample and end_sample options to begin and end the sample period, sp_sysmon always clears the monitor counters. Adaptive Server issues an error message if you run sp_sysmon with begin_sample or end_sample and the noclear option.
If you need to clear the monitor counters, use sp_sysmon with the clear option. For compatibility reasons, Adaptive Server accepts the noclear option as a valid parameter, but it does not affect the behavior of sp_sysmon.
Each Sybase installation that has purchd a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you have any questions about this installation or if you need assistance during the installation process, ask the designated person to contact Sybase Technical Support or the Sybase subsidiary in your area.
Other sources of information
Use the Sybase Getting Started CD, the SyBooks™ CD, and the Sybase Product Manuals Web site to learn more about your product:
Sybase certifications on the Web
Technical documentation at the Sybase Web site is updated frequently.Finding the latest information on product certifications
Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.
Sybase EBFs and software maintenanceFinding the latest information on EBFs and software maintenance
This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.
Adaptive Server Enterprise HTML documentation has been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.
Note:You might need to configure your accessibility tool for optimal use. Some screen readers pronounce text bd on its c; for example, they pronounce ALL UPPERC TEXT as initials, and MixedCase Text as words. You might find it helpful to configure your tool to announce syntax conventions. Consult the documentation for your tool.
For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.