Sybase ADAPTIVE SERVER IQ 12.4.0 Uživatelský manuál

Procházejte online nebo si stáhněte Uživatelský manuál pro Počítače Sybase ADAPTIVE SERVER IQ 12.4.0. Sybase ADAPTIVE SERVER IQ 12.4.0 User Manual Uživatelská příručka

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 52
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 0
Copyright 1989-1999 by Sybase, Inc. All rights reserved. Sybase, the Sybase logo, Data Workbench, InfoMaker,
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
Zobrazit stránku 0
1 2 3 4 5 6 ... 51 52

Shrnutí obsahu

Strany 1 - Digital UNIX

Copyright 1989-1999 by Sybase, Inc. All rights reserved. Sybase, the Sybase logo, Data Workbench, InfoMaker, PowerBuilder, Powersoft, SQL Advantage,

Strany 2

Data definition Adaptive Server IQ 12.4.010 Release Bulletin for Digital UNIX 7.1 Data definitionThis section reports pr

Strany 3 - 2. Restrictions

Adaptive Server IQ 12.4.0 Large IN subqueriesRelease Bulletin for Digital UNIX 11•= ALL•!

Strany 4

User-defined variable issue Adaptive Server IQ 12.4.012 Release Bulletin for Digital UNIXTo avoid truncated output, incr

Strany 5 - 3. Installation Instructions

Adaptive Server IQ 12.4.0 Sybase CentralRelease Bulletin for Digital UNIX 13 7.4 Sybase C

Strany 6 - 5.1 Obtaining query plans

Data Type column in Table Editor retains focus Adaptive Server IQ 12.4.014 Release Bulletin for Digital UNIXWhen you use

Strany 7

Adaptive Server IQ 12.4.0 Additions to the start_asiq or asiqsrv12 command-line optionsRelease Bulletin for Digital UNIX

Strany 8

-gm command line option Adaptive Server IQ 12.4.016 Release Bulletin for Digital UNIXThe -iqmt switch is not set by star

Strany 9 - 7. Known problems

Adaptive Server IQ 12.4.0 Confirming connectionsRelease Bulletin for Digital UNIX 17The f

Strany 10 - 7.1 Data definition

Using a .odbc.ini file Adaptive Server IQ 12.4.018 Release Bulletin for Digital UNIXIf Adaptive Server IQ does not detec

Strany 11 - 7.2.2 Large IN subqueries

Adaptive Server IQ 12.4.0 Addition to STOP DATABASE statementRelease Bulletin for Digital UNIX

Strany 12

Required Operating System Patches Adaptive Server IQ 12.4.02 Release Bulletin for Digital UNIX• Digital Unix V4.0fNote

Strany 13 - 7.4 Sybase Central

Error in DBSTOP example Adaptive Server IQ 12.4.020 Release Bulletin for Digital UNIXThe following information should be

Strany 14 - 8. Product compatibilities

Adaptive Server IQ 12.4.0 -Z switch must be uppercaseRelease Bulletin for Digital UNIX 21

Strany 15

MESSAGE PATH Adaptive Server IQ 12.4.022 Release Bulletin for Digital UNIX 9.2.2 MESSAGE PATHIn the MESSAGE PATH clause

Strany 16

Adaptive Server IQ 12.4.0 Error documenting IQ PATHRelease Bulletin for Digital UNIX 23•

Strany 17 - 9.1.7 Confirming connections

SIZE clause of CREATE DBSPACE Adaptive Server IQ 12.4.024 Release Bulletin for Digital UNIXin database /tech1/iq/cdrdb.d

Strany 18 - 9.1.10 stop_asiq utility

Adaptive Server IQ 12.4.0 Recommended index typesRelease Bulletin for Digital UNIX 25 9.2

Strany 19

Changes to “Using join indexes” Adaptive Server IQ 12.4.026 Release Bulletin for Digital UNIXIf the join column is made

Strany 20

Adaptive Server IQ 12.4.0 Changes to “Using join indexes”Release Bulletin for Digital UNIX

Strany 21 - 9.2 Data definition (DDL)

Error in DISK_STRIPING default Adaptive Server IQ 12.4.028 Release Bulletin for Digital UNIX 9.3 Error in DISK_STRIPING

Strany 22 - 9.2.2 MESSAGE PATH

Adaptive Server IQ 12.4.0 DefaultRelease Bulletin for Digital UNIX 29DefaultONDescription

Strany 23 - /disk1/iqdata/company.iqmsg

Adaptive Server IQ 12.4.0 Converting 12.0.x databases to 12.4.0Release Bulletin for Digital UNIX

Strany 24

New and changed general database options Adaptive Server IQ 12.4.030 Release Bulletin for Digital UNIX• In order to join

Strany 25 - LF or HNG

Adaptive Server IQ 12.4.0 DescriptionRelease Bulletin for Digital UNIX 31DescriptionThis

Strany 26

Description Adaptive Server IQ 12.4.032 Release Bulletin for Digital UNIXDescriptionFor joins within a query, the IQ opt

Strany 27

Adaptive Server IQ 12.4.0 String function REPEAT is supportedRelease Bulletin for Digital UNIX

Strany 28 - 9.4 Data manipulation (DML)

Using ISNULL() and COALESCE() Adaptive Server IQ 12.4.034 Release Bulletin for Digital UNIXThe NUMBER(*) function is not

Strany 29 - Description

Adaptive Server IQ 12.4.0 DefaultRelease Bulletin for Digital UNIX 35Default1DescriptionT

Strany 30 - Allowed Values

Effect of checkpoints Adaptive Server IQ 12.4.036 Release Bulletin for Digital UNIXTemporary IQ Blocks Used:,163 of 6144

Strany 31 - JOIN_PREFERENCE Option

37• Incremental backups are disabled After the database is opened in forced recovery mode, incremental backups are disabled. The next backup must be a

Strany 32

38 To verify that the data is not corrupt and set the database storage to its actual value, you start the server with the -iqdroplks switch and connec

Strany 33

39Running sp_iqcheckdbIn order to recover leaked storage within a database, first start the server with the -iqdroplks switch in the asiqsrv12 command

Strany 34

Insert into table from remote SQL database not supported Adaptive Server IQ 12.4.04 Release Bulletin for Digital UNIXYou

Strany 35

40 The dbcc_option settings of 0 and 3, when combined with the server option -iqdroplks, update the free list if no errors are detected. In order to p

Strany 36

41ExampleAssume that the DBA cannot successfully open and connect to database foo, because of reported IQ errors during database open and recovery. To

Strany 37 - -iqfrec

42 9.5.6 SP_IQSTATUS now displays IQ Page SizeThe sp_iqstatus stored procedure now displays the IQ page size in addition to the block size. For examp

Strany 38

43When you use the RESTORE statement to move and/or rename a database, you can rename all of the files except the transaction log. Transactions contin

Strany 39 - -iqdroplks is

44 Set the name of the transaction log file (-t ) This option sets a filename, including an optional directory path, for a new transaction log. If the

Strany 40

45The same command can also be used to add a new user. For this reason, if you inadvertently enter the user ID of an existing user when you mean to ad

Strany 41

46 9.5.14 Changes to BACKUP statementIn the Adaptive Server IQ Reference, the SIZE and STACKER option descriptions in the BACKUP statement should re

Strany 42

47ipcrm -m mid1 -m mid2 ... -s sid1 -s sid2 ...For example:% ipcrm -m 40965 -s 5130 -s36682 9.5.16 Monitoring server activityIt may be helpful, especi

Strany 43 - [switches] database-file

48 9.6 Client applications 9.6.1 ODBC AutoPreCommit omittedThe ODBC AutoPreCommit option was omitted from the Adaptive Server IQ Reference. Turning t

Strany 44 - IDENTIFIED BY

49 9.7.1 Adaptive Server IQ plug-in help reflects Multiplex supportAdaptive Server IQ Multiplex 12.4.0 is a separate product from Adaptive Server IQ 1

Strany 45

Adaptive Server IQ 12.4.0 Setting the LD_LIBRARY_PATH Environment VariableRelease Bulletin for Digital UNIX

Strany 46

50 • Output from sp_iqstatus procedureYou may find additional help from the Sybase online support database, MySupport. MySupport lets you search throu

Strany 47

51techinfo.sybase.com2 In the Browse section, click on the What’s Hot entry.3 Explore your area of interest: Hot Docs covering various topics, or Hot

Strany 49 - 10. Technical Support

Accessing Current Release Bulletin Information Adaptive Server IQ 12.4.06 Release Bulletin for Digital UNIXDepending on

Strany 50 - Rollups:

Adaptive Server IQ 12.4.0 Changed functionality in Adaptive Server IQ 12.4.0Release Bulletin for Digital UNIX

Strany 51

Improved stored procedure output Adaptive Server IQ 12.4.08 Release Bulletin for Digital UNIX• Improved stored procedure

Strany 52

Adaptive Server IQ 12.4.0 stop_asiq utilityRelease Bulletin for Digital UNIX 9•-iqmc sets

Komentáře k této Příručce

Žádné komentáře