Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > Release Bulletin > Release Bulletin Sybase IQ 15.2 for IBM AIX

Release Bulletin Sybase IQ 15.2 for IBM AIX

This document describes new features, enhancements, and changed functionality which are available for this version and platform.
 
RSS Feed
 
 
 

Release Bulletin Sybase® IQ 15.2 for IBM AIX

 

Document ID: DC74600-01-1520-01

Last revised: June 2010

 


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

  1. Go to Product Manuals.

  2. Select a product and language and click Go.

  3. Select a product version from the Document Set list.

  4. Select the Release Bulletins link.

  5. From the list of individual documents, select the link to the release bulletin for your platform. You can either download the PDF version or browse the document online.

 


Product summary

Enclosed is Sybase® IQ 15.2 for IBM AIX.

Refer to the Installation and Configuration Guide for IBM AIX for compatible platform and operating system configurations and minimum patch levels.

Refer to New Features Summary Sybase IQ 15.2 for descriptions of new features and behavior changes in Sybase IQ 15.2.

 


Special installation and migration instructions

For complete installation and migration instructions, see the Installation and Configuration Guide for IBM AIX. Read the chapters “Preparing for Installation” and “Migrating Data” before installing Sybase IQ 15.2.

Before you run a new version of Sybase IQ, see “Restrictions” for the most current requirements. This section includes installation and migration information that is new for this release or needs emphasis.

Sybase strongly recommends that you check the online support Web site for software updates to these components before you install the software. If a software update (ESD or EBF) has been released, it contains bug fixes made after this product shipped. You must download the latest update and install it after installing IQ from the product CD. See “Sybase EBFs and software maintenance”.


New installer for Sybase IQ 15.x

Sybase IQ 15.x has a new procedure for installation. The Sybase IQ 15.x interactive installer is a standard graphical installation wizard. The interactive installer supports all product editions and installation types. A new silent installation option is also available. See “Installing your software” in Chapter 1, “Preparing for Installation” in the Installation and Configuration Guide for IBM AIX.


Sybase IQ 15.2 requires a license

Sybase IQ 15.2 uses the Sybase Software Asset Management (SySAM) licensing mechanism that lets system administrators enable and monitor their site’s use of Sybase products.

Sybase IQ includes separate SySAM licenses for each product edition and separate licenses for any optional features available for that edition. See Chapter 2, “Licensing your software” in the Installation and Configuration Guide for IBM AIX.


Sub-capacity licensing

Sybase now offers sub-capacity licensing options for Sybase IQ Enterprise Edition. Sub-capacity licensing refers to licensing a Sybase product on a subset of the CPUs available on a physical machine.


Platform support

Sub-capacity licensing is supported on the following platforms:

Table 1: Sub-capacity licensing vendor support

Vendor

Product

Platform support

Virtualization Type

HP

nPar

HP IA 11.31

Physical Partition

vPar

Virtual Partition

Integrity Virtual Machines with Resource Manager

Virtual Machine

Secure Resource Partitions

OS Containers

IBM

LPAR

AIX 6.1

Virtual Partition

dLPAR

Virtual Partition

SUN

Dynamic System Domains

Solaris 10

Physical Partition

Solaris Containers/Zones with Solaris Resource Manager

OS Partition

INTEL/AMD

VMWare ESX Server 1Guest OS: Windows

VMWare ESX Server 3.5

Guest OS: Windows 2003

Virtual Machine

VMWare ESX ServerGuest OS: Linux

VMWare ESX Server 3.5

Guest OS: RH 5.3, SuSE 10

Virtual Machine

Xen2, DomainU: Windows

Windows 2003

Virtual Machine

Xen, DomainU: Linux

RH 5.3, SuSE 10

Virtual Machine

 

1 VMWare excludes VMWare Workstation and VMWare Server 2 Xen excludes Sun Solaris x64


How to enable Sybase sub-capacity licensing

You must have a sub-capacity licensing agreement with Sybase before you can enable sub-capacity licensing. If you choose to use Sybase IQ in a sub-capacity environment, see the SySAM Quick Start Guide for instructions for generating your license key.

Keep your license server up-to-date Although the installation media includes a copy of the most recent SySAM license server, Sybase recommends that you periodically check for license server updates on the SySAM Standalone License Server Install site.


SySAM Licensing checkout [CR #628594]

If Sybase IQ was licensed using a per-processor license type in previous releases, the license quantity was determined at startup. In this release, Sybase IQ periodically checks the number of processors it can use and attempts to check-out additional licenses for any increase. Sybase IQ shuts down after 30 days, if additional licenses are not made available within this period. See the SySAM Users Guide for details regarding license grace.


Sybase Central plug-in compatibility

The Sybase IQ 15.x plug-in for Sybase Central™ has been upgraded from version 4.3 to version 6.0 and is not compatible with earlier versions. You can use the 15.x plug-in only with 15.x servers; you cannot use the 15.x plug-in to connect to 12.x servers.


No Sybase IQ server support on Linux 32-bit

The Sybase IQ 15.x client is supported on Red Hat 5.2 Linux for 32-bit systems, but there is no Sybase IQ 15.x server support on Linux for 32-bit systems.


Using remote server classes for ASE [CR #615420]

Component Integration Services (CIS) connectivity from Sybase IQ to Adaptive Server® Enterprise (ASE) is available using server classes asejdbc and aseodbc. The asejdbc server class uses the Adaptive Server JDBC™ driver and the aseodbc server class uses the Adaptive Server ODBC driver. CIS connectivity through aseodbc server class is expected to provide better performance than the asejdbc class. The Adaptive Server ODBC driver requires a separate installation of SDK 15.5 ESD #5 which can be downloaded from the Sybase EBF download site. SDK 15.5 ESD #5 is not available for download at the time of Sybase IQ 15.2 release and is expected to be available shortly afterwards. Contact Sybase Technical Support for details on release dates.


SDK no longer included

Because Sybase IQ 15.x now embeds many features provided by the Software Development Kit, the SDK is no longer distributed as part of the product. The SDK is available as a separately purchased option.

The Copy Definition utility (defncopy) is included in the Software Development Kit and is no longer shipped with Sybase IQ.


Open Client no longer included

Open Client™ is no longer installed as part of the Sybase IQ product. Sybase IQ 15.2 does provide versions of Open Client utilities that have limited functionality to enable INSERT...LOCATION:

  • iqisql

  • iqdsedit

  • iqdscp (UNIX only)

  • iqocscfg (Windows only)


Increase IQ temporary cache setting for loads

The LOAD_MEMORY_MB option has been deprecated. Instead of setting LOAD_MEMORY_MB, you must now adjust the IQ temporary cache setting. The amount to increase the IQ temporary cache is approximately the sum of all the LOAD_MEMORY_MB settings of all of the concurrent LOAD TABLE executions.


Creating dbspaces on multiple files

Due to the IBM implementation of reads for JFS database files, Sybase IQ performance improves if you create dbspaces on each disk, instead of creating one large file. Smaller files allow Sybase IQ to handle disk I/O operations much more efficiently, especially when combined with disk striping and possibly multiple controllers.

Currently Sybase recommends that you create three files per underlying disk drive.

When setting up raw partitions, the system administrator specifies the sector size, which defines the minimum usable chunk of disk (and sets the minimum Sybase IQ block size). When you use raw partitions, the integer you specify as a block size for Sybase IQ must be a multiple of the sector size. The System Administration Guide: Volume 1 provides details on specifying block size.


Maximum file size on AIX systems

Dbspaces up to 512GB have been successfully created on raw partitions.


Time series function fails to execute [CR #629457]

On an AIX system, execution of a time series and forecasting SQL function (for example, TS_VWAP) may fail with this error:

could not execute statement
could not load dynamic library 'libtsudf.so'
SQLCODE=-620,ODBC 3 state='HY000" Line 1,column 1

Workaround:

Upgrade the operating system runtime environment to include:

xlsmp.aix52.rte 1.7.0.0
/usr/lpp/xlsmp/aix52/libxlsmpdebug.a
/usr/lpp/xlsmp/aix52/libxlsmp.a
/usr/lpp/xlsmp/aix52
/usr/lpp/xlsmp/aix52/libxlomp_ser.a
/usr/lpp/xlsmp


Creating demo database fails with sort error [CR #631097]

Creating the demo database may fail with an Informational stack trace for SORT and the error:

Exception Thrown from s_csort.cxx:1496, Err# 2,
tid 3676 origtid 3676
O/S Err#: 0, ErrID: 2062 (hs_csortexception);
SQLCode: -1009134, SQLState: 'QSB34', Severity: 14
[21023]: Insufficient buffers for 'Sort'.
-- (s_csort.cxx 1496)

The “insufficient buffers” error may be related to the small default Sybase IQ memory caches (-iqmc 32 and -iqtc 24) and a high number of processors on the machine.

Workaround:

If hyperthreading is on, set the -iqnumbercpus server startup option to the number of physical processors. This may avoid the “insufficient buffers” error, if -iqnumbercpus is 64 or less.

If hyperthreading is off and the number of processors is greater than 64, edit mkiqdemo.sh to increase the size of the memory cache. For example, on a machine with 128 processors, change -iqmc 32 and -iqtc 24 to -iqmc 100 and -iqtc 100.

See System Administration Guide: Volume 1 > Troubleshooting hints > Solutions for specific conditions > Performance issues > Slow performance on a multi-CPU or hyperthreaded machine.

 


New features and behavior changes

For new features and behavior changes, see New Features Summary Sybase IQ 15.2, which Sybase recommends you read before you install Sybase IQ 15.2. This section describes changes that were not included in that book or the documentation set.

Sybase IQ supports many of the new features in SQL Anywhere® 11. For more information, see SQL Anywhere 11 – Changes and Upgrading.


Administration and troubleshooting improvements

This section contains new features and changes related to administration and troubleshooting.


Default password value change

The default password is now sql in lowercase.


Security enhancements

This section contains new features and changes related to security.


System procedure behavior change [CR #589250]

The SQL text of all system procedures is hidden. sp_iqhelp returns encrypted results for the procedure definition of any Sybase IQ system procedure.

 


Product compatibilities

This section describes the compatibility of Sybase IQ with other products. Certification with client and partner products is an ongoing process. See “Sybase certifications on the Web” for instructions on accessing the most current online certification information.


Sybase products

These Sybase products are certified with Sybase IQ 15.2:

  • SQL Anywhere 11.0.1

  • Adaptive Server Enterprise 15.5

  • jConnect™ for JDBC™ 5.x and 6.x

  • Sybase ETL 4.8

  • Sybase Control Center (SCC) 3.1

Refer to “Sybase certifications on the Web” for instructions on accessing the latest online certification information.

 


Restrictions

Read this section! Your system may produce unexpected results if you ignore the restrictions and other instructions listed below.

The information in this section applies to version Sybase IQ 15.2 servers and databases that have been upgraded from any earlier version of Sybase IQ, unless specified otherwise.


Database name length restriction [CR #365281]

The dbbackup utility truncates the database name to 70 characters and creates a target file with a truncated name. Sybase IQ uses dbbackup when synchronizing secondary servers. Due to dbbackup restrictions, database names must be less than 70 characters long.


Dbspace management and file placement

When you allocate file system files for dbspaces (System, IQ Main, or IQ Temporary), do not place the files on a file system that is shared over a local area network. Doing so can lead to poor I/O performance and other problems, including overloading the local area network. On UNIX and Linux platforms, avoid Network File System (NFS) mounted file systems. On Windows, do not place dbspace files on network drives owned by another server.

To avoid conflicts, Sybase recommends that dbspace management be performed by a single database administrator on a single connection.


Dbspace naming in RESTORE command [CR #561366]

If the dbspace name contains a file extension such as .iq.iqtmp, or .iqloc, you must enclose the dbspace name in double quotation marks when specifying the name in a RESTORE command RENAME clause.

For example:

RENAME local1 TO '/work/local1_res.iqloc.iqloc' DBSPACENAME "local1_res.iqloc"

or

RENAME "test_prod2.iq" TO '/test/test_prod7.iq'


Unexpected query results

In a few unusual circumstances, differences in semantics between SQL Anywhere and Sybase IQ may produce unexpected query results. These circumstances are:

  • A query is issued from inside a user-defined function

  • A SELECT statement has no FROM clause

  • A FROM clause contains some tables that were created IN SYSTEM and others that were not created IN SYSTEM

In these circumstances, subtle differences between the semantics of SQL Anywhere and Sybase IQ may be exposed. These differences include:

  • Sybase IQ treats the CHAR and VARCHAR data types as distinct and different; SQL Anywhere treats CHAR data as if it were VARCHAR.

  • When the RAND function is passed an argument, the behavior is deterministic in Sybase IQ and nondeterministic in SQL Anywhere.


Interactive SQL restrictions

Sybase recommends that you use dbisql, rather than dbisqlc or iqisql, unless instructed to do otherwise, for specific tasks. dbisqlc is supported, but does not contain all the features of dbisql.

  • Do not use the Import option on the dbisql Data menu (or Command | Options | Input Format in dbisqlc). This option is not supported for use with IQ databases. Use the LOAD TABLE statement or the INSERT statement to load data into IQ tables.

  • If you run dbisql (Interactive SQL) with the -q (quiet mode) option, and the data extraction commands (primarily setting the option TEMP_EXTRACT_NAME1 to an output file) are in a command file, you must first set and make permanent the dbisql option “Show multiple result sets.” If you do not set this option, the output file is not created.

    To set the option “Show multiple result sets,” click Tools | Options in the dbisql window, choose “SQL Anywhere,” and select the “Results” tab. Then select “Show all results sets.”

  • There is no online help for dbisql and dbisqlc. [CR #560925]

  • The query plan in the dbisql Plan tab is a SQL Anywhere style query plan. For a Sybase IQ query plan, refer to the IQ .iqmsg file.

  • If you set the terminal type on UNIX and Linux systems to “dumb” or “unknown” and then start dbisqlc, Sybase IQ returns an error. For example:

    % setenv TERM dumb
    % dbisqlc
    
    error at line 1
    Unable to initialize screen routines
    

    To avoid problems, run dbisql (Interactive SQL) instead, or use an xterm window to run dbisqlc on UNIX and Linux systems. For example, to start an xterm window with a scroll bar, enter:

    % xterm -sb
    

 


Known problems

If there is a workaround for a problem, it is provided. Change request numbers appear in brackets, as in [CR #563004].

See also “Restrictions”, and “Documentation updates and clarifications”.


SySAM licensing

Learn about known issues and apply workarounds with SySAM licensing.


Changes to licensing behavior [CR #628596, CR# 628403]

Sybase IQ cannot be installed or fails to start in a virtual environment and reports an error similar to the following:

Cannot determine the total number of processor cores on
the machine from within this virtual system. The IQ_CORE
("DH") license type is restricted for use on a machine
with a maximum of 4 processor cores regardless of
whether the virtual system is limited to use fewer
processor cores. You need to run 'sysamcap' on the
physical machine (or virtual-machine/partition control
domain) and set the reported environment variable prior
to running Installer.

This error is raised in the following circumstances:

  1. Sybase IQ is running on a virtual system which doesn't have access to the processor counts of the physical machine (this applies to all virtual environments except AIX LPAR and HP-UX vPar).

    and

  2. Sybase IQ is using a license type that is restricted for use to a machine with no more than a specific number of processors (for example, Sybase IQ Single Application Server Edition cannot be used on a machine with more than 16 processor cores, ASE Small Business Edition cannot be used on a machine with more than 2 processor chips).

Workaround:

Run the sysamcap DEFAULT command on the physical machine or control domain for the virtualization technology (for example, VMware ESX console, or XEN dom0), then set the environment variable reported prior to running the product or product installer. The process is described in the SySAM Sub-capacity Licensing section of the SySAM Users Guide.


Sybase IQ operations

Learn about known issues and apply workarounds for Sybase IQ operations.


Server failure when running sa_text_index_vocab procedure [CR #627966]

If two connections simultaneously run the sa_text_index_vocab system procedure against the same TEXT index, the server may fail with a Sybase IQ Abort and the message caught signal 11, program abort.

Workaround: Call sa_text_index_vocab on a given TEXT index from one connection at a time.


PHP bound parameters on big endian platforms [CR #627872]

In Sybase IQ 15.2, PHP: Hypertext Preprocessor (PHP) drivers on big endian platforms require bound parameters to be initialized before the call to sasql_stmt_bind_param for INT and BIGINT data types.

This example shows the values properly initialized before the call to sasql_stmt_bind_param:

$stmt = sasql_prepare($conn, "insert into
testdefault(c1, c2, c3, c5) values(?,?,?,?)");
#Binding parameters with statement prepared
$c1=22;  $c2=33;  $c3="col3data";  $c5="col5data";
sasql_stmt_bind_param
($stmt,"iiss", $c1, $c2, $c3, $c5);
#executing statement
sasql_stmt_execute($stmt);


Remote query error [CR #626133]

NO PASSTHRU and PARTIAL PASSTHRU modes are useful in remote queries that use Component Integration Services (CIS) functional compensation, or in remote queries that join Sybase IQ tables to SQL Anywhere tables. When you execute a remote query in NO PASSTHRU or PARTIAL PASSTHRU mode and the query execution plan contains a group-by hash, distinct hash, join hash, or sort operator, a statement may fail and issue this error:

-728,Update operation attempted on non-updatable
remote query error

The affected statement fails, but no other statements or connections are impacted.

This error occurs only when the result computed by the operator is much larger than the available memory. Other operations in the query plan may reduce the amount of available memory. If available memory is small—for example, if fewer than 20 rows can be held in the available memory at one time—then Sybase IQ may report the above error. If the result set is very large—for example, if it contains more than 520x10^9 rows—then Sybase IQ may report the above error.

To avoid this problem, increase the amount of memory allocated to SQL Anywhere by increasing the SQL Anywhere cache, or wait for the load on the server to decrease, or rewrite the query so that it can be executed in FULL PASSTHRU mode.


sp_iqstatus returns error on Chinese and Japanese locale installations [CR #622928]

On Sybase IQ servers that are set up for Chinese and Japanese locales, running sp_iqstatus returns an error similar to:

Could not execute statement.
Syntax error near '2010' on line 1
SQLCODE=-131, ODBC 3 State="42000"
Line 1, column 1

Workaround:

  1. Run these commands:

    For Chinese locales:

    % cd $IQDIR15/res
    % rm dblgzh_iq11_eucgb.res
    % rm dblgzh_iq11_cp936.res
    
    

    For Japanese locales:

    % cd $IQDIR15/res
    % rm dblgja_iq11_eucjis.res
    % rm dblgja_iq11_sjis.res
    
    
  2. Restart Sybase IQ.

After this procedure, certain strings in the .iqmsg files and the output of sp_iqmpxinfo, sp_iqstatistics, and sp_iqstatus are in English, instead of Chinese or Japanese.


ASE connections to Sybase IQ with BIGDATETIME [CR #622007]

When a version 15.5 GA Adaptive Server Enterprise server uses Component Integration Services (CIS) to connect to a Sybase IQ server version that has BIGDATETIME and BIGTIME capability, any chronological data type sent to the Adaptive Server server using CIS results in the error:

Msg 7225, Level 16, State 4:
Line 1:
Unknown datatype token 188 'BIGDATETIME NULL'
encountered.
Exited passthru mode from server 'QA_IQ15_ASECIS'.

Sybase IQ sends the data as BIGDATETIME and relies on Adaptive Server to convert appropriately. The BIGDATETIME data type was implemented in CIS in Adaptive Server Enterprise version 15.5 ESD #1, so this error occurs with Adaptive Server Enterprise 15.5 before any ESDs have been applied.

Workaround:

SET TEMPORARY OPTION RETURN_DATE_TIME_AS_STRING='ON' in Sybase IQ for each session. The Sybase IQ server sends all chronological data as strings and Adaptive Server completes the conversion. This workaround is for Adaptive Server Enterprise 15.5 GA connecting to Sybase IQ in passthrough mode.

You can also use this workaround in the definition of a remote stored procedure, but it is not a solution for proxy tables created on Adaptive Server returning chronological data types from Sybase IQ.


Stored procedures for information only [CR #560032]

Stored procedures serve informational purposes. Sybase recommends that the DBA compare the output of the sp_iqbackupsummary and sp_iqrestoreaction procedures against the output of views SYSIQBACKUPHISTORY and SYSIQBACKUPHISTORYDETAIL to decide the restore sequence.


RSA certificate creation fails [CR #557702]

RSA certificate creation fails with the error createcert command not found because the createcert utility is missing. The utility is currently available only on the AIX64, LinuxAMD64, Sun64, and Win32 platforms. Please contact Sybase Technical Support, if you need this utility.


Multiplex environment

Learn about known issues and apply workarounds within a multiplex environment.


Restoring IQ store data in a different location [CR #623585]

There is an incorrect procedure in Using Sybase IQ Multiplex > Backing Up and Restoring Data in a Multiplex Environment > Backing up and restoring data in a multiplex environment > Restoring in the multiplex environment. This is the corrected procedure (only steps 5, 6, and 7 are different from the version listed above):

Restoring IQ store data when restoring database in different location

  1. Confirm that database home directories for each server still exist. If not, create them or restore them from file system backups.

  2. If this is not the first time you have restored to the new location, shut down all multiplex servers running at the destination location (coordinator and secondary servers). In Sybase Central, right-click the multiplex and use the Stop Server wizard. The wizard lets you stop one or more servers. The multiplex at the original location where the backup was taken may continue running.

    Note:If automatic startup is enabled in your ODBC configuration, users on the same machine as the server may be set up to automatically start the server. Prevent this from happening while you are restoring the database.

  3. After stopping all servers, confirm that the database shut down successfully. If you see an active iqsrv15 process with the name of a multiplex server, stop the process.

    To verify on a UNIX system, use the ps command. For example:

    % ps -ef | grep iqsrv15 
    
    fiona 434     1  1   May 19 ?? 0:05 start_iq
    -n myhost_myserver 
    -c 32MB -x tcpip(port=1234) mpxdb.db
    fiona 4751   442  1 16:42:14 pts/5 
    0:00 grep start_iq
    

    To verify on a Windows system, use Task Manager. Look on the Processes tab for iqsrv15.exe or find the IQ Server icon in the system tray and stop it using right-click and Shutdown.

  4. Move files required for debugging and reconfiguring the multiplex.

    Make a file system copy of the .iqmsg file. If you have message log archiving configured, see “Backing up the right files,” in System Administration Guide: Volume 1.

  5. Shut down the original coordinator, then start the utility database from the coordinator server directory using the coordinator server’s name:

    % start_iq -n coordinator_svr -c 32MB 
    -x tcpip(port=1234) 
    
  6. Connect to the utility database (utility_db):

    % dbisql -c "eng=coordinator_svr;uid=DBA;pwd=SQL;
    dbn=utility_db" -host myhost -port 1234 
    
  7. Run the RESTORE command with a new location path for the database and all of its dbspaces. To restore certain dbspace files to a different path, specify a RENAME clause. For details, see the RESTORE statement in Reference: Statements and Options.

  8. Start the restored database either by reconnecting to the utility_db server and specifying the restored database file name or by stopping the server and restarting it with the restored database. If you restart the server, use the single-node and override flags (-iqmpx_sn 1 -iqmpx_ov 1).

  9. Use DROP MULTIPLEX SERVER statement to drop all the secondary nodes. For example, DROP MULTIPLEX SERVER node_w3_skm.

    Once you drop the last secondary node, the coordinator shuts down automatically, signifying conversion to simplex.

  10. Restart the coordinator without the single node or override switch.

  11. Re-create all the secondary nodes with the correct location path. For example:

    CREATE MULTIPLEX SERVER node_r2_skm DATABASE
    '/sunx3005/mpx_simdb.db'
    HOST 'localhost' PORT 8998
    ROLE READER STATUS INCLUDED
    

    After you create the first secondary node, the coordinator automatically shuts down, signifying conversion to multiplex.

    Note:In the preceding command, you must include the database file extension .db.

  12. When you restart the coordinator, you see a warning in the server log about the multiplex environment being invalid. This warning is generated if IQ_SYSTEM_TEMP dbspace does not contain any files, and is the case for all the secondary nodes you created in step 12. Ignore this warning for now.

  13. Synchronize the secondary servers, following the instructions in “Synchronizing secondary servers” on page 30.

  14. Start the secondary servers.

  15. Connect to each secondary server and add files in IQ_SYSTEM_TEMP.

  16. Run sp_iqmpxvalidate on the coordinator. It should report no error detected.

To restore an exact copy of the multiplex to a different location, when copies of all of the server's temporary files exist at the new location, you replace steps 9 through 17 with:

Use ALTER MULTIPLEX SERVER to alter the server name, host, port, and database path of each server.


Emergency shutdown on secondary servers after CREATE TEXT INDEX [CR #611990]

A secondary server goes into emergency shutdown, when:

  • It is started with the -sf external_library_full_text flag, which disables loading of external libraries, and

  • The user issues a CREATE TEXT INDEX statement on the coordinator with a text configuration that uses external libraries.

All other servers replay the DDL successfully.

To avoid the problem, start secondary nodes in the multiplex without the -sf external_library_full_text flag.


Emergency shutdown on secondary servers after creating a proxy table [CR #557714]

A timing problem may cause an emergency server shutdown when a user accesses a new proxy table on a secondary server.

To avoid this problem, users should either reconnect or wait for some time and start another transaction, before trying to use a newly-created proxy table.


Sybase Central

Learn about known issues and apply workarounds for Sybase Central.


Create Trigger Wizard does not show user tables [CR #631447]

The Sybase Central Create Trigger Wizard does not list user tables.

Workaround: Use Interactive SQL (dbisql) to create a trigger.


Sybase IQ plug-in not registered [CR #629604]

The Sybase IQ plug-in for Sybase Central may not be registered on IBM POWER7 systems running AIX 6.1. A symptom of this problem is these messages in $IQDIR15/uninstall/IQ/RegisterIQjpr.out:

ERROR! This file could not be found: jh.jar
ERROR! This file could not be found: java 

Workaround:

You can correct this problem by manually executing Sybase Central and supplying the required configuration command line parameters:

  1. Open a command prompt or xterm window.

  2. Change to the Sybase IQ installation directory.

  3. Source the environment shell scripts:

    source IQ-15_2.csh
    
  4. Change to the directory that contains Sybase Central:

    cd $IQDIR15/shared/sybcentral600
    
  5. Execute the registration command:

    scjview -register $IQDIR15/java/iq.jpr
    
  6. Run Sybase Central:

    scjview
    


Sybase Central warning fails to refresh [CR #623638]

Viewing dbspace contents requires DBA authority or EXECUTE permission to run the sp_iqdbspaceobjectinfo procedure.

The first time you try to view dbspace contents without DBA authority or EXECUTE permission, Sybase Central returns an error message. Successive tries continue to show the same error, even when you press F5 to refresh. To improve performance, Sybase Central does not refresh each time you change folders.


Sybase Central fails to start after ASE install [CR #618082]

After installing Adaptive Server Enterprise (ASE) in the same directory in which Sybase IQ is already installed, Sybase Central fails to start and this error is reported:

Unable to locate the Java Runtime Environment
($SYBASE_JRE6).
The directory $SYBROOT[/shared]/jre-6_0 is missing or invalid.

Workaround:

Source IQ-15_2.csh for Sybase IQ, then source SYBASE.csh for ASE, before starting Sybase Central:

cd $SYBASE
source IQ-15_2.csh
source SYBASE.csh
cd $SYBASE/shared/sybcentral600
./scjview.sh &


Sybase IQ plug-in for Sybase Central not registered [CR #571188]

If Sybase IQ is installed on the same system as other products, such as Adaptive Server Enterprise (ASE), Replication Server®, or Replication Manager, the Sybase IQ plug-in for Sybase Central may not be registered automatically. If you attempt to register the Sybase IQ plug-in, Sybase Central reports this error:

The library "dbput11_r" could not be loaded. Please
ensure that this file exists as part of your
installation.

Workaround:

Source IQ-15_2.csh for Sybase IQ, then source SYBASE.csh for ASE, Replication Server, or Replication Manager, before starting Sybase Central:

cd $SYBASE
source $SYBASE/IQ-15_2/IQ-15_2.csh
source SYBASE.csh
setenv LD_LIBRARY_PATH_64
"$SYBASE/IQ-15_2/lib64:${LD_LIBRARY_PATH_64}"
cd $SYBASE/shared/sybcentral600
./scjview.sh &


Remote client cannot connect to Sybase IQ Agent [CR #563823]

When Sybase Central running on a remote client attempts to connect to the Sybase IQ Agent running on the server host, this error may be reported:

“Unable to connect to the IQ Agent on Server host
“<hostname>:<port_number>”

The root cause of this problem may be the configuration of the network, which incorrectly resolves the hostname to loopback IP address 127.0.0.1, rather than the real IP address. You can verify the source of the problem by running the command ping <hostname>, which returns an IP address. If the IP address returned is 127.0.0.1, rather than the real IP address of the host, then the network configuration is the problem.

To resolve this issue, ask your system administrator to change the network configuration, so that the hostname is resolved as the real IP address. On a UNIX system, you can edit the system file /etc/hosts, so that the hostname is resolved to the real IP address.


Creating proxy tables with “Selected Columns” option [CR #559895]

Creating a proxy table in the Sybase Central wizard with the All Columns option creates the proxy table as expected. However, if you create a proxy table in the Sybase Central wizard with the Selected Columns option, even if you select all columns, the proxy table does not show the data.

Either build the proxy table with the All Columns option, or use dbisql to build the proxy table with just the selected columns that you want.


Sybase Central operation issues [CR #549750]

These issues with Sybase Central operations while using the Create Database Wizard and browsing for a file on remote systems are related to JRE 6.0. The workarounds are either to enter in the text field the required path name to the file, rather than selecting the file using the wizard, or to run Sybase Central on the system on which you are creating the database.

  • Running Sybase Central in either Windows or Linux: you cannot traverse inside a newly created directory, while browsing on a remote system

  • Running Sybase Central in Windows: double clicking on directories on a remote Linux system is non-responsive

  • Running Sybase Central in either Windows or Linux: the Create New Directory button is disabled, while browsing for files on a remote Linux system

  • Running Sybase Central in Linux: while navigating the C: drive on a remote Windows system, if you click the Up > Up > ... button, the listing of files for the C: drive is not correct

  • Running Sybase Central on all platforms: renaming a file on a remote system does not work. After you enter the new name and press Enter, there is no response and the rename operation fails without returning an error.

  • Running Sybase Central on all platforms: clicking and double clicking files and directories on a remote system does not work as expected. Sometimes Sybase Central navigates into the directory and sometimes it edits the directory name for rename. Similarly for files, sometimes Sybase Central selects the file and some times it edits the file name for rename.

 


Documentation for this version

Documentation for Sybase IQ version 15.2 is included with your product shipment. All the information you need to get started and to use the new features in Sybase IQ 15.2 is on the Sybase IQ Getting Started CD and the Sybase IQ SyBooks™ CD.

Sybase Central includes online help for Sybase IQ.

Table 2 lists documentation on the Sybase IQ 15.2 Getting Started CD.

Table 2: Sybase IQ 15.2 Getting Started CD contents

Part number

Book title

DC01014-01-1520-01

Quick Start

DC74600-01-1520-01

Release Bulletin for IBM AIX

DC30051-01-1520-01

Installation and Configuration Guide for IBM AIX

Table 3 lists Sybase IQ documentation on the Sybase IQ 15.2 SyBooks CD.

Table 3: Sybase IQ SyBooks contents

Part number

Book title

DC01087-01-1520-01

New Features Summary Sybase IQ 15.2

DC00462-01-1520-01

Error Messages

DC38159-01-1520-01

Introduction to Sybase IQ

DC38151-01-1520-01

Reference: Building Blocks, Tables, and Procedures

DC00801-01-1520-01

Reference: Statements and Options

DC00170-01-1520-01

System Administration Guide: Volume 1

DC00800-01-1520-01

System Administration Guide: Volume 2

DC00169-01-1520-01

Performance and Tuning Guide

DC00168-01-1520-01

Utility Guide

DC01268-01-1520-01

Unstructured Data Analytics in Sybase IQ

DC01015-01-1520-01

Advanced Security in Sybase IQ

DC00802-01-1520-01

Using Sybase IQ Multiplex

DC01034-01-1520-01

User-Defined Functions Guide

DC01033-01-1520-01

IMSL Numerical Library User?s Guide: Volume 2 of 2 C Stat Library

DC01154-01-1520-01

Time Series Guide

Check Product Manuals for the latest available versions of the Sybase IQ 15.2 documents.

Note these changes to the documentation set in Sybase IQ 15.2:

  • The Time Series Guide contains the descriptions of the SQL functions for time series forecasting and analysis, formerly in Reference: Building Blocks, Tables, and Procedures.

  • Unstructured Data Analytics in Sybase IQ includes the former contents of Large Objects Management in Sybase IQ, plus instructions about the new full text search capability. See New Features Summary Sybase IQ 15.2.

Sybase IQ and SQL Anywhere Because Sybase IQ is an extension of SQL Anywhere Server, a component of the SQL Anywhere package, Sybase IQ supports many of the same features as SQL Anywhere Server. The IQ documentation set refers you to SQL Anywhere documentation, where appropriate. Only a subset of the functionality in the SQL Anywhere documentation is supported by Sybase IQ. For more information, refer to Appendix A, “Compatibility with Other Sybase Databases” in Reference: Building Blocks, Tables, and Procedures.

You may also need to refer to this SQL Anywhere 11.0.1 documentation, which is included on the SyBooks CD:

  • SQL Anywhere Server – Database Administration describes how to run, manage, and configure SQL Anywhere databases. It describes database connections, the database server, database files, backup procedures, security, high availability, and replication with Replication Server®, as well as administration utilities and options.

  • SQL Anywhere Server – Programming describes how to build and deploy database applications using the C, C++, Java, PHP, Perl, Python, and .NET programming languages such as Visual Basic and Visual C#. A variety of programming interfaces such as ADO.NET and ODBC are described.

  • SQL Anywhere Server – SQL Reference provides reference information for system procedures, and the catalog (system tables and views). It also provides an explanation of the SQL Anywhere implementation of the SQL language (search conditions, syntax, data types, and functions).

The SQL Anywhere 11.0.1 documentation is also available online on the Sybase Web site Product Manuals and in DocCommentXchange.

Note:Most of the Sybase IQ books now contain links directly to online SQL Anywhere 11.0.1 documentation sections referenced in the Sybase IQ documentation.

Documentation included for Sybase Software Asset Management (SySAM):

  • SySAM 2 Users Guide introduces asset management concepts and provides instructions for establishing and administering SySAM 2 licenses.

  • SySAM 2 Quick Start Guide tells you how to get your SySAM-enabled Sybase product up and running quickly.

  • FLEXnet Licensing User Guide explains FLEXnet Licensing for administrators and end users and describes how to use the tools which are part of the standard FLEXnet Licensing distribution kit from Sybase.

 


Documentation updates and clarifications

This section contains information omitted from documentation and new information that needs emphasis.


New Features Summary Sybase IQ 15.2

This section contains updates to New Features Summary Sybase IQ 15.2.


CIS performance enhancements

Sybase IQ uses Component Integration Services (CIS) to query tables on remote servers. Changes in Sybase IQ 15.2 allow queries with proxy tables or SA IN SYSTEM tables to execute faster than earlier versions, when the number of rows returned from an IN SYSTEM or proxy table is small compared to the number of rows returned from Sybase IQ.

Queries that benefit from these changes include:

  • SELECT, SELECT INTO, or INSERT…SELECT statements only

  • A statement that contains one or more Sybase IQ tables and one or more proxy or SA IN SYSTEM tables

Queries that do not benefit from these changes include:

  • References to system catalog tables

  • A subquery in a CASE expression

  • LOBs (columns of LONGBINARY, LONGVARCHAR, LONGNVARCHAR, LONGBITSTRING, or XML) on remote tables

  • A function not supported by target node (for example, bit_or or user defined functions)

  • Queries with global variables


Interactive SQL (dbisql) online help

There is no online help available for Interactive SQL (dbisql or dbisqlc).


System Administration Guide: Volume 1

This section contains updates to the System Administration Guide: Volume 1.


Working with NULLs [CR #626626]

In Moving Data In and Out of Databases > Converting data on insertion > Working with NULLS, the syntax and example should be “NULL” instead of “NULLS”.

The correct syntax is:

NULL ({BLANKS | ZEROS | literal' ['literal']...})

The correct example is:

LOAD TABLE lineitem(
    l_orderkey NULL(ZEROS) ASCII(4),
    l_partkey ASCII(3),
    l_shipdate date('MM/DD/YY'),
    l_suppkey ascii(5),
FILLER(1))
FROM 'C:\\MILL1\\tt.t'
PREVIEW ON

All other instances of the word “NULLS” in this section should be “NULLs”.


Remove .iq files before restoring [CR #620249]

In Data Backup, Recovery, and Archiving > Restoring your databases > Before you restore, replace the sixth bullet item with this text:

  • For a full restore, the store files (by default, the .iq files), the catalog store (by default, the .db file), and the transaction log (by default, the .log file) must not exist in the location to which you are restoring. If any of these files exist, delete them or move them to a different directory before doing the full restore.

    A full restore destroys all old database files and re-creates them. Manually deleting the store, catalog store, and transaction log files protects you from inadvertently performing a full restore.


System Administration Guide: Volume 2

This section contains updates to the System Administration Guide: Volume 2.


Syntax correction in CREATE SERVER statement [CR #628912]

In Accessing Remote Data > Sybase IQ and remote data > Working with remote servers > Querying data without native classes > Querying remote data using DirectConnect and proxy table from UNIX > Setting up Sybase IQ to connect to the ASE server, the correct syntax for CREATE SERVER is:

create SERVER jones_1207 CLASS 'asejdbc'
    USING 'jones:4101/tst_db'


Reference: Building Blocks, Tables, and Procedures

This section contains updates to Reference: Building Blocks, Tables, and Procedures.


Dbspace does not support NAS [CR #629367]

Currently Physical Limitations > Size and Number Limitations > Table 6-1: Sybase IQ database object size and number limitations contains the following two rows:

Item

Limitation

Catalog file size

Maximum is 1TB for all platforms except for Windows systems with FAT 32-file systems, which have a 4GB limit. Windows systems with NTFS support the 1TB maximum. Sybase IQ does not support creating dbspaces on NAS (Network Attached Storage) devices.

Dbspace size

Raw device: Maximum size is 4TB.

Operating system file: Maximum size supported by the operating system.

The rows should be:

Item

Limitation

Catalog file size

Maximum is 1TB for all platforms except for Windows systems with FAT 32-file systems, which have a 4GB limit. Windows systems with NTFS support the 1TB maximum.

Dbspace size

Raw device: Maximum size is 4TB.

Operating system file: Maximum size supported by the operating system.

Sybase IQ does not support creating dbspaces on NAS (Network Attached Storage) devices.


Reference: Statements and Options

This section contains updates to the Reference: Statements and Options.


ON_ERROR option [CR #624849]

The ON_ERROR option was deprecated in Sybase IQ 15.0, but reinstated in Sybase IQ 15.1.

Table 2-4 “DBISQL options” in the Sybase IQ 15.1 and Sybase IQ 15.2 documentation states that ON_ERROR is not currently supported by Sybase IQ. This is incorrect.

“Alphabetical list of options” should include this section:


ON_ERROR option [DBISQL]

Function

Controls what happens if an error is encountered while executing statements in Interactive SQL (dbisql).

Allowed values

String. See Description for allowed values.

Default

PROMPT

Description

Controls what happens if an error is encountered while executing statements as follows:

  • STOP – dbisql stops executing statements from the file and returns to the statement window for input.

  • PROMPT – dbisql prompts the user to see if he or she wants to continue.

  • CONTINUE – The error displays and dbisql continues executing statements.

  • EXIT – dbisql terminates.

  • NOTIFY_CONTINUE – The error is reported, and the user is prompted to press Enter or click OK to continue.

  • NOTIFY_STOP – The error is reported, and the user is prompted to press Enter or click OK to stop executing statements.

  • NOTIFY_EXIT – The error is reported, and the user is prompted to press Enter or click OK to terminate Interactive SQL.

When you are executing a .SQL file, the values STOP and EXIT are equivalent.


Using Sybase IQ Multiplex

This section contains updates to Using Sybase IQ Multiplex.


Correction to mpx_mode column description [CR #627055]

In Table A-5, sp_iqmpxinfo columns, in Multiplex Reference > System procedures > sp_iqmpxinfo procedure, the Description for the mpx_mode column erroneously lists ‘writer’ twice.


Multiplex and virtualization [CR #625061]

In Multiplex Overview > Introduction, the following note should be included:

Note:Sybase IQ Multiplex is not supported in virtualized environments.


Restoring IQ store data in a different location [CR #623585]

See “Restoring IQ store data in a different location [CR #623585]” for a correction to a procedure in Backing Up and Restoring Data in a Multiplex Environment > Backing up and restoring data in a multiplex environment > Restoring in the multiplex environment.


Installation and Configuration Guide

For updates about installation and migration, including database upgrades, see “Special installation and migration instructions”.


New name for iqunload -n procedure [CR #612677]

The name of the “Correcting invalid SQL” procedure has been changed to “Running iqunload -n.” See Migrating Data >Avoiding potential migration problems > Correcting invalid SQL syntax.

 


Technical Support

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.

Before you contact Technical Support

Technical Support needs information about your environment to resolve your problem. Before contacting Technical Support, run the getiqinfo script to automatically collect as much information as possible. You may also need to manually collect some information.

In this list, * indicates items collected by getiqinfo:

  • Sybase IQ version (for example, 15.2 GA or ESD level)

  • Type of hardware, amount of memory, number of CPUs*

  • Operating system and version (for example, AIX 64-bit 5L version 6.1)*

  • Operating system patch level

  • Front-end tool used (for example, Business Objects Crystal Reports)

  • Connectivity protocol used (for example, ODBC, JDBC, Tabular Data Stream™ (TDS))

  • Open Client version

  • Configuration type (single user or multiuser)

  • (Important) Message log file* – by default, named dbname.iqmsg and located in the directory where you started the database server.

  • Stack trace file for the date and time the problem occurred (if applicable), by default named stktrc-YYYYMMDD-HHMMSS_#.iq and located in the directory where you started the database server.*

  • Command or query that produced the error

  • Query plan* (recorded in .iqmsg file)

    The query plan is collected automatically by getiqinfo. If you manually collect information, enter these commands, then re-run the command that produced the error:

    SET TEMPORARY OPTION Query_Plan = 'ON'
    
    SET TEMPORARY OPTION Query_Detail = 'ON'
    
    SET TEMPORARY OPTION Query_Plan_As_Html= 'ON'
    
    SET TEMPORARY OPTION Query_Plan_As_Html_Directory=
    'ON'
    

    The plan is in the message log file.

    If you have performance problems, set this database option:

    SET TEMPORARY OPTION Query_Plan_After_Run = 'ON'
    

    This enables Technical Support to see which steps in the query processing used the time.

  • Server logs

    • For UNIX and Linux: IQ-15_2/logfiles/<servername>.nnnn.stderr and IQ-15_2/logfiles/<servername>.nnnn.srvlog*

    • On Windows platforms: %ALLUSERSPROFILE%SybaseIQ\logfiles\ <servername>.nnnn.srvlog*

      For example, on Windows 2003 the server log files are located in C:\Documents and Settings\All Users\SybaseIQ\logfiles and on Windows 2008 the server log files are located in C:\ProgramData\SybaseIQ\logfiles

  • Startup and connection option settings, from the configuration file (by default, dbname.cfg)*

  • Database option settings and output from sa_conn_properties* (if the server is still running)

  • Schema and indexes for the database

  • Output from sp_iqstatus and sp_iqcheckdb

  • On multiplex databases, execute getiqinfo on each node (coordinator and secondary nodes)

  • Screen snapshot of the problem, if possible

A checklist for recording this information for Technical Support is provided at the end of this release bulletin.

See System Administration Guide: Volume 1 > Troubleshooting Hints > Reporting problems to Technical Support > Collecting diagnostic information using getiqinfo.

Online support

You may find additional help from the Sybase online support Web site MySybase. MySybase is a free service that allows you to search through closed support cases, the latest software bulletins, and resolved and known problems, using a view customized for your needs. You can even open a Technical Support case online.

MySybase can be used from most Internet browsers. Go to the Sybase support home page and click the MySybase tab for information on how to sign up for and use this free service.

 


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:

  • The Getting Started CD contains release bulletins and installation guides in PDF format, and may also contain other documents or updated information not included on the SyBooks CD. It is included with your software. To read or print documents on the Getting Started CD, you need Adobe Acrobat Reader, which you can download at no charge from the Adobe Web site using a link provided on the CD.

  • The SyBooks CD contains product manuals and is included with your software. The Eclipse-based SyBooks browser allows you to access the manuals in an easy-to-use, HTML-based format.

    Some documentation may be provided in PDF format, which you can access through the PDF directory on the SyBooks CD. To read or print the PDF files, you need Adobe Acrobat Reader.

    Refer to the SyBooks Installation Guide on the Getting Started CD, or the README.txt file on the SyBooks CD for instructions on installing and starting SyBooks.

    Note:The SyBooks browser software runs on Windows and Linux platforms. Users with non-Linux UNIX platforms must use Acrobat Reader to open PDF files on the SyBooks CD.

  • The Sybase Product Manuals Web site is an online version of the SyBooks CD that you can access using a standard Web browser. In addition to product manuals, you will find links to EBFs/Maintenance, Technical Documents, Case Management, Solved Cases, newsgroups, and the Sybase Developer Network.

    To access the Sybase Product Manuals Web site, go to Product Manuals.

Creating a filter to narrow your search of the online documentation

  1. Point your Web browser to Sybooks Online Infocenter Help.

  2. Click Create/Edit search filter.

  3. Select Search within a user-defined search filter in the Select search filter dialog box.

  4. Click Create New Filter.

  5. Enter a name for your search filter in the New Search Filter list dialog box. For example, IQ_15.2_Install_Guides.

  6. Scroll down to your product and select the product or expand the list of documentation for this product in the Select product(s) list. For example, scroll down to Sybase IQ 15.2 and click the plus sign.

  7. Select the documents to search and click OK. For example, select the five Installation and Configuration Guides for the IQ_15.2_Install_Guides filter.

  8. Select the filter name and click OK in the Select search filter dialog box. The name of the search filter displays in the Current search filter drop-down box and is used for your next search.


Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

Finding the latest information on product certifications

  1. Point your Web browser to Technical Documents.

  2. Click Partner Certification Report.

  3. In the Partner Certification Report filter select a product, platform, and timeframe and then click Go.

  4. Click a Partner Certification Report title to display the report.

Finding the latest information on component certifications

  1. Point your Web browser to Availability and Certification Reports.

  2. Either select the product family and product under Search by Base Product, or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

Creating a personalized view of the Sybase Web site (including support pages)

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

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.


Sybase EBFs and software maintenance

Finding the latest information on EBFs and software maintenance

  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, type 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.


Sybase IQ 15.2 Network Clients and ODBC kits available

Sybase IQ 15.2 Network Clients and ODBC kits for development are available on the Sybase download site. A Network Client is available for each platform supported by Sybase IQ 15.2.


IQ Newsgroup

Sybase newsgroups allow users to exchange information over the Internet. The newsgroup for Sybase IQ is sybase.public.iq.

For information on subscribing to Sybase newsgroups, configuring your newsreader or Web browser, and for guidelines on posting, go to Newsgroups.


IQ Users’ Group

The IQ Users’ Group lets Sybase IQ users exchange information about Sybase IQ. You can visit the IQUG homepage. To have your name added to the IQ Users’ Group list, send an e-mail message to iqug-subscribe@dssolutions.com.

 


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.

Sybase IQ 15.2 and the HTML documentation have 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.

For Section 508 compliant core documentation, see your SyBooks CD or the Sybase Web site Product Manuals.

For Section 508 compliant installation guides and release bulletins, see the HTML files on your Getting Started CD.

The online help for this product is also provided as HTML-based JavaHelp, which you can navigate using a screen reader.

For information about accessibility support in the Sybase IQ plug-in for Sybase Central, see the online help. The online help for this product, which you can navigate using a screen reader, also describes accessibility features, including Sybase Central keyboard shortcuts and using this product without a mouse.

For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.

For a Section 508 compliance statement for Sybase IQ, go to Sybase Accessibility.

Note: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, or to pronounce certain characters or punctuation such as underscore. Consult the documentation for your tool for information on the most useful configuration for your use.

 


Checklist: information for Technical Support

Run the getiqinfo script to automatically collect much of this information.

Information requested

Value

Sybase IQ version (for example 15.2 GA or ESD number)

 

sp_iqlmconfig output

 

Type of hardware

 

Amount of memory

 

Number of CPUs

 

Operating system name and version (for example, AIX 64-bit 5L version 6.1)

 

Operating system patch level

 

Front-end tool used (for example, Business Objects Crystal Reports)

 

Connectivity protocol used (for example, ODBC, JDBC, TDS)

 

Open Client version

 

Configuration type (single node or multiplex)

 

Message log file (dbname.iqmsg)

 

Server log files (server.nnnn.srvlog and server.nnnn.stderr)

 

Stack trace file (stktrc-YYYYMMDD-HHNNSS_#.iq)

 

Command or query that produced the error

 

Startup option settings

 

Connect option settings

 

Database option settings

 

Schema and indexes for the database

 

sp_iqstatus output

 

Query plan: set options (Query_Plan, Query_Detail, Query_Plan_After_Run, Query_Plan_As_Html, Query_Plan_As_Html_Directory, Query_Timing), rerun command or query

 

Screen snapshot of the problem, if possible

 

 

DOCUMENT ATTRIBUTES
Last Revised: May 17, 2010
Part Number: DC74600-01-1520-01
Product: Sybase IQ
Technical Topics: Security, Migration, Cost Control, SQL Anywhere, Error Message, Bug Information, Cloud Computing, Install/Upgrade, Backup & Recovery, Total Cost of Ownership, Client/Server Development
  
Business or Technical: Technical
Content Id: 1069821
Infotype: Release Bulletin
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics