Sybase ADAPTIVE SERVER IQ 12.4.0 Bedienungsanleitung

PowerBuilder, Powersoft, SQL Advantage, SQL Debug, Transact-SQL, Adaptive Server, Adaptive Server Any-

where, Adaptive Server Enterpr ise, Adaptive Server Enterprise Monitor,AnswerBase, Backup Server, ClearCon

nect, Client-Library, DB-Library, dbQueue, DirectConnect, Distribution Agent, Embedded SQL, Enterprise Cli-

ent/Server, Enterprise Connect, InformationConnect, KnowledgeBase, MainframeConnect, MAP, Net-Gateway,

NetImpact, Net-Library, ObjectConnect, OmniConnect, OmniSQL Access Module, Open Client, Open ClientCon-

nect, Open Client/Server, Open Gateway, Open Server, Open ServerConnect, PC DB-Net, PowerDesigner, Repli-

cation Agent, Replication Driver, Replication Server, Replication Server Manager, RW-Library, Secure SQL Server,

Security Guardian, SQL Anywhere, SQL Remote, SQL Server, SQL Server Manager, SQL Toolset, Sybase Central,

Sybase IQ, Sybase SQL Desktop, Sybase SQL Workgroup, SyBooks, System 10, System 11, Watcom SQL,

Web.SQL, WorkGroup SQL Server, XA-Library, XA-Server, and XP Server are trademarks of Sybase, Inc. Other

product names used herein may be trademarks or registered trademarks of Sybase or other companies. 1/99

Release Bulletin

Adaptive Server® IQ 12.4.0

for

Digital UNIX

Document ID: 74950-01-1240-01

Last revised: September 10, 1999

1. Product summary

Enclosed is Adaptive Server™ IQ version 12.4.0, which is compatible

with the following platform and operating system configurations:

• Digital UNIX V4.0d

• Digital UNIX V4.0e

Topic Page

1. Product summary 1

2. Restrictions 3

3. Installation Instructions 5

4. Documentation for this version 5

5. Special migration instructions 6

6. Changed functionality in this version 7

7. Known problems 9

8. Product compatibilities 14

9. Documentation updates and clarifications 14

10. Technical Support 49

11. Other sources of information 50

Required Operating System Patches Adaptive Server IQ 12.4.0

Release Bulletin for Digital UNIX

• Digital Unix V4.0f

Note The product name Digital UNIX has recently been changed to Tru64

UNIX. However the Adaptive Server IQ documentation still uses the old

Digital UNIX name.

The following operating system command shows the level of your base system

software:

% sizer -v

Tru64 UNIX V4.0D (Rev. 878);

Wed Jul 15 12:31:49 EDT 1998

Adaptive Server IQ 12.4.0 has been built to take advantage of certain

performance features found in the Digital Alpha EV5.6 (21164A) and later

chip architecture.

1.1 Required Operating System Patches

You must install the patches listed in this section to run Adaptive Server IQ on

Digital UNIX.

• Digital UNIX V4.0d requires the March 1998 patch kit as the absolute

minimum.

Normally, it is best to install the latest patch kit. However, as of Adaptive

Server IQ 12.4.0 certification, the latest patch kits contain a problem in the

pthreads library which causes a one to two times performance slowdown in

Adaptive Server IQ, most notably in loads and multi-user activity. For this

reason, you should avoid using those patches and use the previous patch kits.

The following table shows you which kits to avoid (the middle column) and

which you should use (the last column).

This problem should be resolved in the next release of these patch kits.

For this operating

system version DoNOTusethispatch

kit Use this patch kit

DUNIX 4.0D duv40das0004-

19990723 duv40das00003-

19990208

DUNIX 4.0E duv40eas0002-

19990617 duv40eas00001-

19990202

DUNIX 4.0F duv40fas0001-

19990609 None required

Adaptive Server IQ 12.4.0 Converting 12.0.x databases to 12.4.0

Release Bulletin for Digital UNIX 3

To obtain patches, download them from the website at

http://www.service.digital.com/ or contact your Digital representative.

Note These patches require that you rebuild your kernel. You must halt your

system and then boot from the console after the new kernel is put into place.

When installing patches, log in as the “root” (superuser) and follow the

directions provided with the patch. All tasks for adjusting the operating system

configuration must be performed as “root”.

Failure to install the appropriate patches before starting Adaptive Server IQ

requires reinstalling Adaptive Server IQ.

2. Restrictions

Read this section! Your system may produce unexpected results if you ignore

the restrictions and other instructions listed below.

If you are upgrading from version 11.x to 12.4.0, see chapter 3 of the Adaptive

Server IQ Installation and Feature Guide for further restrictions.

Converting 12.0.x

databases to 12.4.0 Before you can use a database created with earlier versions of Adaptive Server

IQ, you must run the script upgrasiq.sql, located in the $ASDIR/scripts

directory. For example, to update a database named old.db:

%dbisql -c "uid=dba;pwd=sql;dbn=old;eng=servername"

$ASDIR/scripts/upgrasiq.sql

If you do not run this script, errors like the following may occur when you use

certain front end tools with the ODBC driver to import or link to a table:

The operation failed. There are too many indexes

on table ’amadbdbo_midtown’.

Delete some of the indexes on the table

and try the operation again.

Insert into table from remote SQL database not supported Adaptive Server IQ 12.4.0

Release Bulletin for Digital UNIX

You must run upgrasiq.sql once for each 12.0.x database to upgrade it to

12.4.0.

Note For Adaptive Server IQ versions 12.0.3, 12.03.1, and 12.4.0: Due to a

timing related issue, the database server process will sometimes hang if an IQ

database is started on the command line. For a workaround, see the readme file

included with the software.

Insert into table from

remote SQL database

not supported

Adaptive Server IQ for Digital UNIX does not include Open Client Libraries.

Current communications libraries (up to and including EBF 8263) do not

support native kernel-threading. Therefore, using current communications

libraries, you will be unable to insert data directly from Adaptive Server

Enterprise using the INSERT INTO tablename LOCATION command. Place

such data in an ASCII file and load it using the LOAD command.

CREATE DATABASE

restrictions For this release, to obtain the best performance, Sybase recommends the

following minimum IQ page sizes:

•32KB(

IQ PAGE SIZE 32768) for a database containing up to 10 million

rows.

•64KB(

IQ PAGE SIZE 65536) for a database containing up to 100 million

rows. Note that this is the default IQ page size.

• 128KB (IQ PAGE SIZE 131072) for databases with more than 100 million

rows.

• Do not create any databases with an IQ PAGE SIZE of less than 16KB.

Query restrictions • By default Adaptive Server IQ cursors are scrollable, meaning that

Adaptive Server IQ keeps all the query results in a buffer so that you can

scroll backwards. If the query returns more than a few thousand rows of

output, you can improve performance by issuing the following command

before running the query:

SET TEMPORARY OPTION Force_No_Scroll_Cursors = ’ON’

• Adaptive Server IQ does not support Transact-SQL style outer joins on

expressions. The workaround is to use ANSI style outer joins instead.

For example, statements containing clauses like the following are

unsupported:

SUBSTRING(COL1 ...) *= SUBSTRING(COL2 ...)

The following outer join format is supported:

FROM t1 LEFT OUTER JOIN t2 ON (SUBSTRING(COL1 ...) =

Adaptive Server IQ 12.4.0 Setting the LD_LIBRARY_PATH Environment Variable

Release Bulletin for Digital UNIX 5

SUBSTRING(COL2 ...)

3. Installation Instructions

For complete installation instructions, see Adaptive Server IQ Installation and

Feature Guide for Compaq Digital UNIX.

3.1 Setting the LD_LIBRARY_PATH Environment Variable

You must set the LD_LIBRARY_PATH environment variable before running

Adaptive Server IQ and utilities.

For instructions on setting the LD_LIBRARY_PATH environment variable,

see the Adaptive Server IQ Installation and Feature Guide.

4. Documentation for this version

The table below lists the documentation for Adaptive Server IQ version 12.4.0.

All documentation for Version 12.4.0 is available in one of two formats:

* indicates document found on the Adaptive Server IQ Technical Library

CD. Hard copy documentation can be ordered separately.

** indicates document may be provided in hard copy.

Table 1: Current Adaptive Server IQ documentation

If you are also using Adaptive Server IQ Multiplex, please refer to the

following documentation for further instructions:

Part Number Book Title

74950-01-1240-01 Release Bulletin Adaptive Server IQ for Digital

Unix**

34359-01-1240-01 Adaptive Server IQ Installation and Feature Guide

for Digital Unix**

38152-01-1200-01 Adaptive Server IQ Administration and Performance

Guide*

38151-01-1200-01 Adaptive Server IQ Reference*

38159–01–1200–01 Introduction to Adaptive Server IQ*

35008–01–1240–01 Adaptive Server IQ Multiplex Installation and

Feature Guide for Digital UNIX

Accessing Current Release Bulletin Information Adaptive Server IQ 12.4.0

Release Bulletin for Digital UNIX

Depending on how you use Adaptive Server IQ, you may also need to refer to

the documentation for Adaptive Server Anywhere. Refer to the Version 6.02

edition of Adaptive Server Anywhere documentation on the Sybase Technical

Library Web site, for the most current information that applies to Adaptive

Server IQ. Older editions of the Adaptive Server Anywhere User’s Guide and

Adaptive Server Anywhere Programming Interfaces Guide are included on the

Adaptive Server IQ Technical Library CD and in the printed documentation

set.

4.1 Accessing Current Release Bulletin Information

A more recent version of this Release Bulletin may be available on the World

Wide Web. To check for critical product or document information added after

the release of the product CD, use the Sybase Technical Library Product

Manual Web site.

To access release bulletins at the Technical Library Product Manual Web site:

1Gotosupport.sybase.com.

2 Click the Manuals tab.

3 From the drop-down list choose Adaptive Server IQ.

4 In the window on the right, under Platform-Specific Collections, choose

the appropriate version link.

5 In the window on the right, choose the release bulletin for your platform.

5. Special migration instructions

See the Adaptive Server IQ Installation and Feature Guide for instructions on

migrating to Adaptive Server IQ 12.4.0 from earlier versions.

If you participated in the Adaptive Server IQ Beta Program and have not yet

upgraded to any GA (General Availability) version, please call technical

Support before upgrading to Version 12.4.0

The “Restrictions” in this Release Bulletin lists late-breaking requirements.

Please read this section before running a new version of Adaptive Server IQ.

5.1 Obtaining query plans

Adaptive Server IQ 12.4.0 Changed functionality in Adaptive Server IQ 12.4.0

Release Bulletin for Digital UNIX 7

In version 11.x, you could output the query plan using the command IQ SET

QUERYINFO ON. In Adaptive Server IQ 12.0, run the following command to

output the query plan:

SET TEMPORARY OPTION Query_Plan = ’on’

The plan will be in the .IQMSG file.

If you want additional detail or are sending the plan to Technical Support you

can use:

SET TEMPORARY OPTION Query_Detail = ’ON’

6. Changed functionality in this version

The following sections describe changes since the Adaptive Server IQ

documentation set was updated.

6.1 Changed functionality in Adaptive Server IQ 12.4.0

This section summarizes new features and other changes toAdaptive Server IQ

12.4.0. Details of most of these features are provided in “Documentation

updates and clarifications” on page 14.

• Improved handling of out-of-space conditions If you run out of disk

space, Adaptive Server IQ now provides better assurance that you will be

able to add space where you need it.

•Adaptive Server IQ now reserves space so you can issue a create

dbspace command. You can control the amount of space reserved by

setting two new options, Reserved_Main_DBSpace_MB and

Reserved_Temp_DBSpace_MB. For details on these options, see

“New options for reserving space” on page 34.

•The error message now specifies the amount of space you need to add in

megabytes, and matches the syntax in create dbspace.

It is extremely unlikely that you will ever need to bring down the server to

add space. For revised documentation on what to do if you run out of

space, see “Insufficient disk space” on page 35.

• Forced recovery and leaked space recovery Adaptive Server IQ

12.4.0 adds better support for recovering from crashed and potentially

corruptdatabases. Italso addssupport forrecoveringleaked storagespace.

For details of these features, see “Forced recovery and leaked space

recovery” on page 36.

Improved stored procedure output Adaptive Server IQ 12.4.0

Release Bulletin for Digital UNIX

• Improved stored procedure output Stored procedures now display

output in units that are easier to understand.

• Minimum password length Database administrators can specify a

minimum password length, to discourage easily discovered passwords.

For more information, see “MIN_PASSWORD_LENGTH option” on

page 42

• ODBC 3.51 The ODBC driver has been updated to ODBC 3.51. This

version of ODBC includes support for Unicode applications.

For more information, see “ODBC conformance” in the online edition of

the Adaptive Server Anywhere Programming Interfaces Guide, Version

6.02.

• Control of allowed JOIN syntax In previous releases, some multi-

table queries have been allowed that have ambiguous join clauses. In the

present release, you can set an option to disallow such queries.

For more information, see “EXTENDED_JOIN_SYNTAX option” on

page 28.

• Zero-length data storage If the length of a CHAR or VARCHAR cell is

zero and the cell is not NULL, Adaptive Server IQ creates a zero-length

cell, not a NULL. This change reverts to the original behavior in Adaptive

Server IQ 12, as documented Chapter 5 of the Adaptive Server IQ

Administration and Performance Guide.

6.2 Changed functionality in Adaptive Server IQ 12.03.1

Thissectionsummarizes newfeatures andother changesto AdaptiveServerIQ

added in Version 12.03.1 and not yet included in the documentation.

• sp_iqstatus displays IQ Page Size See “SP_IQSTATUS now displays

IQ Page Size” on page 42 for more information.

• LOAD_MEMORY_MB option This option replacesseveral older options

for adjusting memory use during loads. For more information see

“LOAD_MEMORY_MB option” on page 30.

• JOIN_PREFERENCE option Two new values were added for the

JOIN_PREFERENCE option. For more information see

“JOIN_PREFERENCE Option” on page 31.

• Command-line options for server caching Two new server switches

override the database cache parameters you set with the SET OPTION

command:

Adaptive Server IQ 12.4.0 stop_asiq utility

Release Bulletin for Digital UNIX 9

•-iqmc sets the size of the main buffer cache

•-iqtc sets the size of the temporary buffer cache

See “Additions to the start_asiq or asiqsrv12 command-line options” on

page 15 for details.

• stop_asiq utility You can stopthe server using the stop_asiq utility. For

more information see “stop_asiq utility” on page 18.

6.3 Changed functionality in Adaptive Server IQ 12

Adaptive Server IQ 12 takes a giant step forward from earlier versions. Among

the most important new features it includes are:

• Transactional database capabilities with table-level versioning

• The ability to update the database concurrently with queries by multiple

users

• A new, more efficient database format

• More intelligent index loading, allowing faster loads for many indexes

• Syntactic compatibility with Adaptive Server Anywhere, allowing

Anywhere users to build on their existing knowledge base as they begin to

use Adaptive Server IQ

• Support for Transact-SQL

• Additional query and view support

• Improved front end support

See the Adaptive Server IQ Installation and Feature Guide Chapter 3,

“Migrating Data from Prior Versions,” for important notes about how new

features change database creation and connection.

7. Known problems

For a description of known problems in Adaptive Server IQ version 12.4.0, see

the following sections. If there is a workaround for a problem, it is provided.

See also “Restrictions” for more information.

“Documentation updates and clarifications” contains details that were not

documented in time for this release.

Data definition Adaptive Server IQ 12.4.0

Release Bulletin for Digital UNIX

7.1 Data definition

This section reports problems with data definition.

7.1.1 Temporary tables in procedures

When you include an automatically created temporary table in a procedure, the

table should be dropped automatically when the procedure completes.

In Adaptive Server IQ 12.4.0, however, the table is not dropped. As a result, it

becomes visible outside the procedure, and a new instance of the table is

created each time the procedure executes. These tables instances are not

dropped until you disconnect.

This problem will be corrected in a future release. As a workaround in this

release, put an explicit

drop table

#temp_table_name

at the end of the procedure.

For example, the following procedure has been corrected so that the

automatically created temporary table, #temp0, is explicitly dropped and will

not be replicated.

create procedure foo

begin

select * into #temp0 from table

drop table #temp0 /* this line fixes the problem*/

end

7.2 Adaptive Server IQ Queries

This section reports problems with Adaptive Server IQ queries.

7.2.1 ANY, SOME, and ALL subquery support

Adaptive Server IQ does not yet support subqueries that use the ANY, ALL or

SOME keywords. For example:

•>ALL

• >= ALL

•<ALL

• <= ALL

Inhaltsverzeichnis

Andere Sybase Software Handbücher

Sybase

Sybase Adaptive Server Enterprise 12.5.x Bedienungsanleitung

Sybase

Sybase Adaptive Server Anywhere SNMP Extension... Bedienungsanleitung

Sybase

Sybase PATRIOT compliance Solution Version 2.2... Installations- und Betriebshandbuch

Sybase

Sybase PowerDesigner XML Bedienungsanleitung

Sybase

Sybase Powerdesigner 7.5 Bedienungsanleitung

Sybase

Sybase 3.8 Bedienungsanleitung

Sybase

Sybase Adaptive Server Anywhere Service-Handbuch

Sybase

Sybase Replication Server 15 Bedienungsanleitung

Sybase

Sybase Adaptive Server Bedienungsanleitung

Beliebte Software Handbücher anderer Marken

COMPRO

COMPRO COMPROFM Bedienungsanleitung

Muratec

Muratec OFFICEBRIDGE ONLINE Bedienungsanleitung

Oracle

Oracle Contact Center Anywhere 8.1 Bedienungsanleitung

Adobe

Adobe 65007312 - Photoshop Lightroom Handbuch

Avaya

Avaya NULL One-X for RIM Blackberry Bedienungsanleitung

HP ProLiant BL420c Bedienungsanleitung

PS Audio

PS Audio PowerPlay Betriebsanleitung

Brady

Brady LOCKOUT PRO 3.0 Service-Handbuch

Avaya

Avaya Interaction Center Bedienungsanleitung

Texas Instruments

Texas Instruments TI-83 Plus Silver Edition Handbuch

Novell

Novell GROUPWISE 8 - INTERNET AGENT Bedienungsanleitung

Oracle

Oracle Application 9i Bedienungsanleitung

Acer

Acer RDM Bedienungsanleitung

Canon

Canon Vixia HF21 Bedienungsanleitung

Canon

Canon ZR950 Bedienungsanleitung

Samsung

Samsung Auto Backup Bedienungsanleitung

Polycom

Polycom Vortex EF2201 Montage- und Bedienungsanleitung

Brocade Communications Systems

Brocade Communications Systems Brocade 8/12c Bedienungsanleitung