Switch to standard view 
  Sybase logo

Release Bulletin

RAP - The Trading Edition R4

Document ID: DC00795-01-0400-02

Last revised: March 11, 2010

Copyright 2010 Sybase, Inc. All rights reserved.

1. Product Summary

This release bulletin provides late-breaking information about RAP - The Trading Edition (RAP) R4. A more recent version may be available on the Web.

RAP - The Trading Edition includes a data model, configuration scripts, DDL scripts, manual and automated load scripts, sample data, and sample queries, and these components:

  • RAP The Trading Edition Operations Console
  • RAPStore (Sybase IQ 15.1 ESD #1)
  • RAPCache (Adaptive Server Enterprise 15.5)
  • PowerDesigner 15.1
  • Open Client 15.5
  • Unified Agent Framework (UAF) 2.0.1

For a list of installation media, see Installation Software in the Installation and Configuration Guide.

For information about new features in this version, see the New Features Summary.

For information about accessibility, see Accessibility Features. Accessibility ensures access to electronic information for all users, including those with disabilities.

1.1. Supported Platforms and Operating Systems

Refer to the Supported Platforms and Operating Systems table for a list of platform and operating system configurations that are compatible with RAP The Trading Edition.

Table 1. Supported platforms and operating systems


Supported Operating Systems

AMD Opteron 2.2 GHz or greater

Red Hat Linux 5.2 (AMD) for 64-bit systems

Sun Solaris 10 x64/x86 SunOS 5.10

UltraSPARC 1.2 GHz or greater

Sun Solaris 10 (SPARC) for 64-bit systems

SunOS 5.10

IBM AIX p6 4.7 GHz or greater


1.2. Product Compatibilities

Ensure that your system components are compatible with RAP.

RAP is compatible with the following platforms and operating system versions:

  • Linux Red Hat 5.2: Linux 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux

  • Sun Solaris x64/x86: SunOS 5.10 Generic_118855-33 i86pc i386 i86pc

  • Sun Solaris 10 64-bit: SunOS 5.10 Generic_118833-33 sun4u sparc SUNW, Sun-Fire-V240

  • IBM AIX 6.1: AIX 1 6 00C599344C00

RAP supports the use of the following products and product levels:

  • Sybase Adaptive Server Enterprise 15.5

    • Sun Solaris 10 SPARC 64-bit: Adaptive Server Enterprise/15.5/EBF 17429 SMP ONE-OFF/P/Sun_svr4/OS 5.8/ase155rap/2398/64-bit/FBO/Thu Jan 14 01:58:00 2010

    • Sun Solaris x64/x86: Adaptive Server Enterprise/15.5/EBF 17430 SMP ONE-OFF/P/Solaris AMD64/OS 5.10/ase155rap/2398/64-bit/FBO/Wed Jan 13 19:46:11 2010

    • Linux Red Hat 5.2: Adaptive Server Enterprise/15.5/EBF 17428 SMP ONE-OFF/P/x86_64/Enterprise Linux /ase155rap/2398/64-bit/FBO/Wed Jan 13 18:38:03 2010

    • Adaptive Server Enterprise/15.5/EBF 17427 SMP ONE-OFF/P/RS6000/AIX 5.3/ase155rap/2398/64-bit/FBO/Thu Jan 14 09:48:33 2010

  • Sybase IQ 15.1

    • Sun Solaris 10 SPARC: Sybase IQ/ 1/Sun_Sparc/OS 5.10/64bit/2009-09-25 04:28:41

    • Sun Solaris x64/x86: Sybase IQ/ 1/Sun_x64/OS 5.10/64bit/2009-09-25 02:49:35

    • Linux Red Hat 5.2: Sybase IQ/ 1/Enterprise Linux64 - x86_64 - 2.6.9-67.0.4 .ELsmp/64bit/2009-09-25 02:44:55

    • IBM AIX 6.1: Sybase IQ/ 1/RS6000MP/AIX 5.3.0/64bit/2009-09-25 03:21: 02

  • PowerDesigner 15.1

    • Windows: PowerDesigner Version 15.1

2. Installation and Upgrade

Get last-minute information about installation and upgrading that was omitted from or incorrect in your installation guide, or that needs special emphasis.

To install RAP components, see the RAP The Trading Edition Installation and Configuration Guide, on the RAP Getting Started CD.

  • Configuration of the Sybase Software Asset Management System (SySAM) is required with RAP. You must obtain a valid license for your RAP configuration. See the RAP The Trading Edition Installation and Configuration Guide for information on obtaining and activating your SySAM license.
  • PowerDesigner 15.1 can be installed only on a Windows system and requires a valid SySAM license.
Note these corrections to the Installation and Configuration Guide:

  • The demo installer installs RAPCache and RAPStore with RAP defaults. These are not the same as the Adaptive Server Enterprise and Sybase IQ defaults.
  • Ensure that the login used to install RAP has appropriate permissions for all installation tasks. For example, if you log in in as user sybase, you need access to create certain folders.
  • In Performing Postinstallation Tasks, Loading the Sample Data into RAPCache, should occur after the last time you restart the RAPCache server. Reload sample data any time you restart the RAPCache server.

2.1. Adaptive Server Enterprise 15.5

Install Adaptive Server Enterprise 15.5 from the RAP Product DVD.

For more information on installing Adaptive Server Enterprise, see the RAP The Trading Edition Installation and Configuration Guide.

For a successful installation, the machine on which you install Adaptive Server Enterprise must have at least 64MB of shared memory configured.

2.2. Sybase IQ 15.1 ESD #1

Install Sybase IQ 15.1 ESD #1 from the RAP Product DVD.

For more information on installing Sybase IQ, see the RAP The Trading Edition Installation and Configuration Guide.

2.3. PowerDesigner 15.1

Install PowerDesigner 15.1 from the Sybase ASE PC client product CD.

For installation details see the Performing Postinstallation Tasks > Installing Client Tools > Installing PowerDesigner.

2.4. Installing RAPStore in GUI Mode with the Express Install

[CR 621848] When you use the Express install (GUI mode) to install the RAPStore, the sample message template files fail to install. Use any of these workarounds: use the console mode, the custom option, or copy the templates from the RAPCache system.


  • Install the RAPStore component using the Express install in console mode.
  • Install the RAPStore component using the Custom install in either GUI or console mode.
  • Copy the templates from $RAP/RAPCacheSubscriber/templates into $RAP/RAPStoreSubscriber/templates, where $RAP is the installation directory.

3. Known Issues

Review the known issues and provided workarounds.

3.1. Known Issues for RAP Components

Learn about known issues and apply workarounds for RAP Components.

Table 2. RAP Component issues
614644 Manually truncating the RAP_JOB_HISTORY table in the OpsDB database results in errors.

If you manually truncate the RAP_JOB_HISTORY table and the spt_table Transfer table in ASE is not cleared at the same time, ASE can, as a result, end up with multiple entries in the spt_table Transfer table associated with the same ID. This results in RAP_JOB_HISTORY table entries with finish times that occur prior to their start times.

Workaround: To avoid such errors, do not manually truncate the RAP_JOB_HISTORY table. Instead, use the delete from command.

593491 Deadlocks are expected when running multiple interlink truncation rules on a table with all pages locking and a clustered index.

Locking is set as an option in the command while creating the table. To avoid deadlocking when running multiple interlink truncation rules, choose either datapages or datarows when locking the table. For example:

create table STOCK_TRADE (
INSTRUMENT_ID        SYB_ID                         not null
TRADE_DATE           SYB_DATE                       not null
TRADE_SEQ_NBR        SYB_COUNT                      not null
TRADING_SYMBOL       SYB_CODE_VAR                   null
TRADE_TIME           SYB_TIMESTAMP                  null
TRADE_PRICE          SYB_MONEY                      null
TRADE_SIZE           SYB_COUNT                      null
(constraint PK_STOCK_TRADE primary key nonclustered (INSTRUMENT_ID,TRADE_SEQ_NBR, TRADE_DATE)) lock datapages

When locking the table, choose either lock datapages or lock datarows.

440230 At least one Operations Console user must be an active administrator to manage the Operations Console through the Web graphical user interface.

Workaround: Sybase recommends that you do not change the operator administration status of the default administrative user rapadmin.

N/A In the current RAP release, the Job Scheduler uses 64 user connections.

Workaround: By default, the value of the RAPCache server number of user connections parameter is set to 250. Increase this value if more connections are needed based on system activity.

N/A The RAP installer loads sample data in the RAPStore STOCK_HISTORY table for use with the historical market data sample queries. A larger set of sample data is available. If you do not load the STOCK_HISTORY table with this additional sample data, some of the historical market data sample queries return no results.

Workaround: “Sample Queries†in the RAP - The Trading Edition Data Model and Queries contains an optional procedure that describes how to load additional sample data into the RAPStore STOCK_HISTORY table, as well as into the RAPStore STOCK_QUOTE and STOCK_TRADE tables.

N/A In some cases, the installer reports an error indicating that no Java Runtime Environment (JRE) is present on the system.

You may see:

Initializing Wizard........
		Verifying JVM.4916 Killed
		Verifying JVM..5117 KilledInitializing: Command not found

No Java Runtime Environment (JRE) was found on this system.

Workaround: If you encounter this error, re-run the installer from the command line by appending -is:jvmtimer 30 to the installation command. For example, use:

setupSolaris.bin -is:jvmtimer 30

3.2. Known Issues for Adaptive Server Enterprise 15.5

Learn about known issues and apply workarounds for Adaptive Server Enterprise 15.5.

Table 3. Adaptive Server Enterprise 15.5 issues
617421 Problems with the job scheduler process may cause a memory leak and require a restart.

RAP users accessing the data transfer and data truncation functions may notice a memory leak while performing scheduled job processes. To avoid memory leaks, shut down the job scheduler process periodically. To restart the job scheduler process:


use sybmgmtdb
sp_sjobcontrol @name=NULL, @option="stop_js"
sp_sjobcontrol @name=NULL, @option="start_js"
611360 Under some circumstances involving heavy I/O contention, ASE may throw segmentation fault error messages.

A timeslice error may occur during heavy I/O contention while the data transfer utility is active.



sp_configure 'cpu grace time', 1000
588919 When running multiple ASE engines, the engines must all attach to the shared memory at the same address. Otherwise, the engines fail to initialize.

On Linux RHEL Update 3.0 and greater, Adaptive Server version 15.5 running on multiple engines requires the security feature Exec-Shield to be disabled. To disable Exec-Shield:


Add the following lines in /etc/sysctl.conf:

kernel.exec-shield = 0

To make the action take effect without rebooting, as SU, enter: /sbin/sysctl -p for the action to take effect.

N/A Adaptive Server Enterprise load performance can be affected by both the amount of memory available on the machine and the size of the data set.

If you have sufficient memory to hold the entire RAPCache database, use an in-memory database for your RAPCache. If you do not have enough memory, use a relaxed-durability database instead.

If there is not enough physical memory on the machine, you can improve overall load performance of large data sets by using raw devices, rather than file system devices. Writes are faster while using raw devices, as there is no double buffering as with file system devices. The initial load performance with a raw device may not be as good as with a file system device, but there is no performance drop over time, and the total load time is less than the load time with a file system device.


To use raw devices rather than file system devices, change the physname specification in the disk init commands to the names of raw devices. The disk init dsync parameter has no effect when initializing a raw device.

3.3. Known Issues for Sybase IQ 15.1 ESD# 1

Learn about known issues and apply workarounds for Sybase IQ 15.1 ESD# 1.

Table 4. Sybase IQ 15.1 ESD# 1 issues
N/A When you define a message type, specify the precision and scale of all NUMERIC datatypes in the SQL file for the Sybase IQ RAPStore.

Sybase IQ running in Sybase RAP does not apply the default precision and scale when defining a message type.


For example, specify:
create table QA_EUREX ( 
YEAR          NUMERIC(4,0), 
MONTH         NUMERIC(2,0), 
DAY           NUMERIC(2,0), 
instead of specifying:
create table QA_EUREX ( 
YEAR          NUMERIC, 
DAY           NUMERIC, 

3.4. Known Issues for Migration

Learn about known issues and apply workarounds for Migration.

Table 5. Migration issues
620654 An extra OpsConsole folder is present in the migration script <RAP_INSTALL_DIR>/ OpsConsole/datamodel/scripts/update/Ops_Migrate_To_SA.sh.


To successfully run the migration script, first change the following paths:

  • For lines 17,19, and 21 the filepath shows
    Change this to:
  • An error in the bcp command on line 22 shows
    bcp master.dbo.OPERATOR out <RAP_DIR>/OpsConsole/OpsConsole/OpsDB/rap_operator.csv -S$4 -U$2 -P$3 -c -t, -e<RAP_DIR>/OpsConsole/OpsConsole/OpsDB/rap_operator.err -J
    Change this to:
    bcp master.dbo.OPERATOR out <RAP_DIR>/OpsConsole/OpsDB/rap_operator.csv -S$4 -U$2 -P$3 -c -t, -e<RAP_DIR>/OpsConsole/OpsDB/rap_operator.err -J
  • For lines 26,28, and 30 the filepath shows,
    Change this to:
  • An error on the dbisqlc command on line 33 shows
    Change this to:

4. Documentation Changes

Read about updates, corrections, and clarifications to the documentation released with RAP R4.

Table 6. RAP R4 Documentation Changes
N/A Performance and Tuning Guide

The Performance and Tuning Guide is a new guide that has been created to help fine tune RAP components.

N/A Data Model and Queries

The Users Guide has been renamed and is now called Data Model and Queries.

N/A New Features Summary

The New Features Summary gives a summary of the new updates, features, and configurations in RAP.

5. Obtaining Help and Additional Information

Use the Sybase Getting Started CD, the SyBooksâ„¢ CD, and the Sybase Product Manuals Web site to learn more about this product release.

  • The Getting Started CD contains release bulletins and installation guides in PDF format, in addition to other documents and updated information not included on the SyBooks CD.

  • The SyBooks CD contains product manuals. The Eclipse-based SyBooks browser allows you to access the manuals in an HTML-based format. Some documentation is provided in PDF format, which you can access through the PDF directory on the SyBooks CD. See the SyBooks Installation Guide on the Getting Started CD, or the README.txt file on the SyBooks CD for instructions about installing and starting SyBooks.

  • The Sybase Product Manuals Web site at Sybase Product Manuals, http://sybooks.sybase.com/, is an online version of the SyBooks CD that you can access using a standard Web browser. You can browse documents online or download them as PDFs. In addition to product manuals, the Web site also has links to EBFs/Maintenance, Technical Documents, Case Management, Solved Cases, newsgroups, and the Sybase Developer Network.

Note: A more recent release bulletin with critical product or document information added after the product release may be available from the Sybase Product Manuals site. To read or print PDF documents, you need Adobe Acrobat Reader, which is available as a free download at the Adobe Web site.

5.1. Technical Support

Get support for Sybase products.

If your organization has purchased a support contract for this product, then one or more of your colleagues is designated as an authorized support contact. If you have any questions, or if you need assistance during the installation process, ask a designated person to contact Sybase Technical Support or the Sybase subsidiary in your area.

5.2. Finding the Latest Information on Sybase EBFs and Software Maintenance

Use your MySybase account to find the latest information on EBFs and software maintenance.

  1. Point your Web browser to the Sybase Support Page at http://www.sybase.com/support.
  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.
  3. Select a product.
  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact†role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.

5.3. Sybase Product and Component Certifications

Certification reports verify Sybase product performance on a particular platform.

To find the latest information about certifications:

5.4. Creating a MySybase Profile

MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

  1. Go to http://www.sybase.com/mysybase.
  2. Click Register Now.

5.5. Finding the Latest RAP White Papers

As white papers on RAP - The Trading Edition become available, they are posted on the Sybase Web site.

  1. Point your Web browser to Technical Documents at http://www.sybase.com/support/techdocs/.
  2. Click White Paper - Technical.
  3. In the Product filter, select RAP - the Trading Edition, and then click Go.
  4. Click a white paper title to display the document.

5.6. Documentation for Other Core and Optional Components

A list of components and the location of their respective documents.

You may also need to refer to the documentation for the other core and optional components of RAP. All product documentation is included in the RAP – The Trading Edition package and is available on the Sybase Product Manuals Web site. To access this site, go to http://www.sybase.com/support/manuals/.

The following table lists the location of the product documentation in the RAP package:

Component name

Location of documentation

Sybase IQ 15.1 ESD #1

  • Getting Started with Sybase IQ CD

  • Sybase IQ SyBooks Bookshelf CD

Adaptive Server Enterprise 15.5

  • Getting Started ASE CD

  • ASE 15 SyBooks CD

PowerDesigner 15.1

  • RAP PowerDesigner Product CD

5.7. Accessibility Features

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.

The RAP documentation complies 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.

For information about accessibility support in the Sybase IQ plug-in for Sybase Central, see Introduction to Sybase IQ > Using accessibility features. The online help for Sybase IQ, which you can navigate using a screen reader, also describes accessibility features, including Sybase Central keyboard shortcuts.


You might need to configure your accessibility tool for optimal use. Some screen readers pronounce text based on its case; for example, they pronounce ALL UPPERCASE 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 http://www.sybase.com/accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.

Back to Top
© Copyright 2010, Sybase Inc.