background image

CHAPTER 10    Adding Optional Functionality to Adaptive Server

Configuration Guide

121

3. size of the new device (Meg): 5

4. Device size for auditing:5

3

Select each remaining entry you want to change.

4

Press Ctrl+A to save the new entries.

Installing online help for Transact-SQL syntax 

This section provides instructions for installing online help for Transact-SQL 
syntax. 

Online syntax help: sp_syntax

The $SYBASE/$SYBASE_ASE/scripts directory contains scripts for installing 
the syntax help database,

 sybsyntax

. You can retrieve this data with 

sp_syntax

For more information on 

sp_syntax

, see the Reference Manual.

The scripts directory contains one or more of the 

sp_syntax

 scripts shown in 

Table 10-1, depending on which Sybase products are included with your 
server: 

Table 10-1: sp_syntax installation scripts

All Adaptive Server installations include the 

ins_syn_sql

 script. This script 

includes syntax information for Transact-SQL, the system procedures, and the 
Sybase utilities. When you execute this script, you install the SQL portion of 
the 

sybsyntax

 database.

Script

Product

ins_syn_cl

Open Client Client-Library™

ins_syn_esql

Embedded SQL™

ins_syn_os

Open Server

ins_syn_sql

Transact-SQL

Summary of Contents for Adaptive Server

Page 1: ...Configuration Guide Adaptive Server Enterprise 15 0 UNIX...

Page 2: ...DI Database Gateway media splash Message Anywhere Server MetaWorks MethodSet mFolio Mirror Activator ML Query MobiCATS MobileQ MySupport Net Gateway Net Library New Era of Networks Next Generation Lea...

Page 3: ...ize of a database device 9 Client server communication 11 Changing Adaptive Server configuration 12 Languages other than U S English 13 Adaptive Server specifications 13 CHAPTER 2 Starting and Stoppin...

Page 4: ...hard limits 35 Increasing the soft limit 35 Increasing the hard limit 36 Sample program 37 Enabling asynchronous disk I O 38 Adjusting the client connection timeout period 41 For HP UX 41 For IBM RS...

Page 5: ...t backup 62 IPv6 support 63 Understanding IPv6 63 IPv6 infrastructure 64 Starting Adaptive Server Enterprise as IPv6 aware 65 Troubleshooting 66 Server fails to start 66 Error when executing an ESP 67...

Page 6: ...disabling error logging 106 Setting error log paths 106 Setting the Adaptive Server error log path 106 Managing messages 107 Logging user defined messages 107 Logging auditing events 108 CHAPTER 9 Man...

Page 7: ...em administration tasks Working with system administration issues that are relevant to Adaptive Server running on UNIX platforms This manual supplements the System Administration Guide and the Perform...

Page 8: ...cter sets sort orders and language modules Chapter 8 Logging Error Messages and Events describes how to use the error logging features of Adaptive Server Chapter 9 Managing Adaptive Server Databases p...

Page 9: ...rprise data Glossary defines technical terms used in the Adaptive Server documentation Java in Adaptive Server Enterprise describes how to install and use Java classes as data types functions and stor...

Page 10: ...nsact SQL system procedures catalog stored procedures system extended stored procedures and dbcc stored procedures Tables Transact SQL system tables and dbcc tables System Administration Guide provide...

Page 11: ...ase and documents the query and mapping functions that comprise XML Services Other sources of information Use the Sybase Getting Started CD the SyBooks CD and the Sybase Product Manuals Web site to le...

Page 12: ...on the left 3 Select a product name from the product list and click Go 4 Select the Certification Report filter specify a time frame and click Go 5 Click a Certification Report title to display the r...

Page 13: ...e report or click the product description to download the software Conventions The following sections describe conventions used in this manual SQL is a free form language There are no rules about the...

Page 14: ...in BNF notation Do not type this symbol Indicates is defined as Curly braces mean that you must choose at least one of the enclosed options Do not type the braces cash check credit Brackets mean that...

Page 15: ...of the Sybase installation directory Text editor refers to an ASCII text editor or any editor that can save files to text format Accessibility features This document is available in an HTML version th...

Page 16: ...nks to information on Section 508 and W3C standards If you need help Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Syba...

Page 17: ...erver Installation Guide for your platform This chapter provides an overview of how to configure Adaptive Server and the steps you need to take to customize it for your use About Adaptive Server Adapt...

Page 18: ...Server to run operating system and user defined commands System specific issues Adaptive Server runs on a variety of hardware and operating system platforms System specific issues do not affect the b...

Page 19: ...a UNIX login that owns all the Sybase installation directories and files sets permissions on those directories and files and performs the installation and upgrading of Adaptive Server This login is p...

Page 20: ...y path to search for executables The Sybase executables are located in the installed_components bin directory When using the source files SYBASE csh or SYBASE sh the following paths are prepended to P...

Page 21: ...stemdb and sysprocsdev devices are created when you create a new Adaptive Server The master device The master device contains the following databases master controls the operation of Adaptive Server a...

Page 22: ...rt distributed transaction management DTM features Before installation make sure you have enough space available on the default segment to support sybsystemdb The sysprocsdev device The sybprocsdev de...

Page 23: ...n an Adaptive Server audit trail You can use this audit trail to monitor the use of Adaptive Server or system resources For instructions on configuring Adaptive Server for auditing see Chapter 10 Addi...

Page 24: ...r data from devices on the file systems By default Adaptive Server enables dsync for file system devices However dsync may cause performance degredation for file system devices that experience high wr...

Page 25: ...There are no changes needed to the operating system or to Sybase Adaptive Server to use network appliance filers NFS mounted devices have been tested on Solaris HP UX IBM AIX and Linux For All Platfor...

Page 26: ...rtition beyond the size specified for the device becomes inaccessible unless you drop and re create the device For best performance place the Sybase software and all disk devices including the master...

Page 27: ...forms located in the SYBASE installation directory or In an LDAP server After your Adaptive Server or client software is installed it can connect with any server on the network that is listed in the d...

Page 28: ...tory Service Changing Adaptive Server configuration Use sp_configure to change the configuration of Adaptive Server To change the configuration of several servers enter the sp_configure information in...

Page 29: ...ormation on srvbuild see the Utility Guide Adaptive Server specifications Database specifications Databases per Adaptive Server A maximum of 32 767 databases per server Maximum database size 2K page s...

Page 30: ...able size needed Maximum size of object name 255 Query specifications Maximum number of tables participating in a query for a query without a union or for each side of a union in a query 64 Maximum of...

Page 31: ...ried and tempdb if it is used for results or worktables Maximum number of tables with referential integrity constraints for a query 192 Procedure specifications Number of buffers and procedure buffers...

Page 32: ...ta limits for tables according to page size model database 3MB 6MB 12MB 24MB tempdb database 4MB 6MB 12MB 24MB sybsystemdb database 3MB 6MB 12MB 24MB Databases 2K page 4K page 8K page 16K page Tables...

Page 33: ...by Adaptive Server when an XP command is issued through isql You can use Sybase Central to start and stop servers manually or automatically For more information about Sybase Central see Chapter 1 Over...

Page 34: ...editing the RUN_server_name Server start up parameters The default start up parameters are stored under SYBASE SYBASE_ASE install RUN_server_name where server_name is the name of the server you insta...

Page 35: ...information required to restart that server RUN_server_name files are created in the SYBASE SYBASE_ASE install directory For Adaptive Server the RUN_server_name file is named RUN_server_name where ser...

Page 36: ...he monserver and backupserver commands Use the monserver command to start Monitor Server from the UNIX command line For details see the Adaptive Server Enterprise Monitor Server User s Guide Starting...

Page 37: ...startserver command in the etc inittab file Here is a suggested format for an Adaptive Server start up command to add to etc inittab sybase 2 wait release_directory install startserver f RUN_serverna...

Page 38: ...command at the beginning of the linked RUN_server_name file you created To configure your operating system for automatic restart of Adaptive Server and Backup Server 1 Create a start up script file w...

Page 39: ...executed last so you should use a sequence number that follows all existing numbers in ASCII order You can perform an ls command on the rc directory to view existing sequence numbers For example ls e...

Page 40: ...en you execute an extended stored procedure ESP you see an error message similar to the following Msg 11018 Level 16 State 1 Procedure xp_cmdshell Line 2 XP Server must be up for ESP to execute To add...

Page 41: ...s waiting for processes to complete and you must stop Adaptive Server immediately you can use shutdown with nowait which neither waist for currently executing statements to finish nor performs checkpo...

Page 42: ...art If the Monitor Server heartbeat feature is in effect Monitor Server automatically detects the termination of Adaptive Server within the specified period and shuts itself down Therefore before atte...

Page 43: ...321 3320 80 10 31 45 pts 4 324 47 dataserver ONLINE 1 jorge 3322 3320 80 10 31 45 pts 4 326 02 dataserver ONLINE 2 jorge 3323 3320 80 10 31 45 pts 4 328 56 dataserver ONLINE 3 This example shows four...

Page 44: ...a normal manner the shared memory files are automatically removed If Adaptive Server crashes or is stopped with the kill 9 command these files are not deleted You need read and write permissions on t...

Page 45: ...e products that the system environment variables be set correctly Environment variables are set in the user s environment either interactively or by including them in the user s login and cshrc files...

Page 46: ...uild window displays Choose the servers you want to configure by clicking the boxes on the left When you select each of the boxes the server name text field is enabled where you can enter the server n...

Page 47: ...sport type Host name Port number In the Edit Advance Adaptive Server Attributes tab enter Adaptive Server configuration file Sybsystemdb device path Sybsystemdb device size Sybsystemdb database size S...

Page 48: ...nsport type Host name Port number 8 In the XP Server type screen select Transport type Host name Port number 9 In the Full Text Search SDS type screen select Error log Collection directory Default dat...

Page 49: ...e Self Management user name new Self Management user password 12 Click Build Servers to proceed with the servers configuration srvbuild displays the configuration status as it builds the servers you s...

Page 50: ...s Although most of the open file descriptors are available for user connections a few are used by Adaptive Server for opening files and devices For HP UX The kernel parameters maxfiles and maxfiles_li...

Page 51: ...le descriptors available to an Adaptive Server engine The limit is 10 000 Although most of the open file descriptors are available for user connections a few are used by Adaptive Server engines for op...

Page 52: ...37 v Setting up the sample program to increase the hard limit 1 Create file_name c where file_name is the name you give the file by using an ASCII text editor Type the text shown in the sample in Sam...

Page 53: ...The following example shows the source code that you can use to increase the hard limit include sys time h include sys resource h include sys types h define MAX_CONNECTIONS to a number less than 10000...

Page 54: ...ing system administrator or HP technical support Note Before executing the following instructions shut down Adaptive Server or SQL Server To enable asynchronous I O 1 From the SAM Kernel Configuration...

Page 55: ...To launch the Kernel Configuration use kcweb F 2 Select Modules 3 Select asyncdsk and change the next boot to static 4 Rebuild the kernel and reboot the system 5 Execute the following commands using...

Page 56: ...the values from Table 3 2 Table 3 2 SMIT parameters for asynchronous I O If your system uses more than seven disks at the same time for Asynchronous I O increase the MAXIMUM number of servers value by...

Page 57: ...hours 7 200 000 ms To display the current time value use the command for your platform as shown in the following sections For HP UX To display the current timeout period enter usr contrib bin nettune...

Page 58: ...tcp_keepalive_time To reduce the timeout period to 15 minutes 900 seconds enter sbin sysctl w net ipv4tcp_keepalive_time 900 Checking for hardware errors The following types of hardware error message...

Page 59: ...Microsystems diagnostic tool sundiag to check memory and disks See the operating system documentation for more information For Linux Check the var log messages file on a regular basis See the operatin...

Page 60: ...mmand monitors network status netstart v displays Transmit Receive Statistics It is also used to determine if enough buffers have been configured for network traffic no a command displays current netw...

Page 61: ...ral isql scripts to help you do this bin csh f if e dbcc_mail out then rm dbcc_mail out endif foreach i dbcc isql Usa Ppassword i dbcc_out if grep c Msg 25 0 9 0 9 dbcc_out then echo There are errors...

Page 62: ...priate dump transaction commands to your scripts If there are 2500 level error messages the script does not back up the database At the end of the script dbcc_mail out is mailed to the System Administ...

Page 63: ...ministration Guide For information about configuring languages character sets and sort orders as well as optional features see the System Administration Guide Default settings After installation Adapt...

Page 64: ...rder Linux Binary ordering Login security mode Standard Item Default value Server Item Default value Backup Server Name AdaptiveServername_back Network support TCP IP Socket number 5001 Error log path...

Page 65: ...t s language or character set When a client initiates a connection it looks in its directory services for the network location of the target server Directory services list the name and address of ever...

Page 66: ...its own name by checking the value of the DSLISTEN environment variable If the DSLISTEN environment variable is not set then it assumes that the server name is SYBASE Type of interfaces file Task or t...

Page 67: ...he server If the client cannot connect the first time it makes additional attempts according to the delay and retry numbers indicated in directory services If no matching entry is found an error messa...

Page 68: ...Server and any other Open Server applications The network information in the file includes the server name network name or address of the host machine and the port object or socket number depending o...

Page 69: ...ch machine For more information see Creating a master interfaces file on page 58 If the host machine supports multiple networks see Configuring interfaces files for multiple networks on page 59 Hetero...

Page 70: ...ptive Servers running in a homogeneous environment can use copies of the interfaces file to establish connections Because the two Adaptive Servers are running under the same operating system they can...

Page 71: ...e that follows the servername line must begin with a space or a character tab Each element on the line must be separated by a single space Each entry is separated by a blank line You can add comments...

Page 72: ...er ASCII a through z A through Z The characters that follow must be letters numbers or underscores _ retry_attempts optional Number of times you want the client to try to connect to a server after ini...

Page 73: ...are in use Enter the Adaptive Server port number in a new section of etc services labeled Sybase specific services You do not have to make this entry for the operating system to function properly but...

Page 74: ...Using dsedit or dscp Using a text editor Using dsedit or dscp to create a master interfaces file You can use the dsedit or dscp utility to create a master interfaces file which you can then distribute...

Page 75: ...ame find any duplicate SYBASE entries in your merged file and rename them A combination of the host machine s network name or address and Adaptive Server s port or object number If the original interf...

Page 76: ...ODUCTION server with two network listeners PRODUCTION tab 3 tab 3 newline tab master tcp ether SERV_CORPNET 4559 tab master tcp ether SERV_ENGNET 5479 tab query tcp ether SERV_CORPNET 4559 When Adapti...

Page 77: ...mong Sybase installations on different networks The interfaces file looks like the following example on the engineering network PRODUCTION tab 3 tab 3 newline tab query tcp ether SERV_ENGNET 5470 tab...

Page 78: ...query Clients on each network must use the DSQUERY value that corresponds to the network the client is on In the following example either PRODUCTION_network1 or PRODUCTION_network2 can be used Client...

Page 79: ...erfaces file entry for the Adaptive Server into the client interfaces file 4 A connection on the secondary port occurs only if the corporate network is disabled or if the corporate network interface o...

Page 80: ...Sybase products that are Open Client Server based like XP Server Backup Server Replication Server and Open Switch became automatically IPv6 aware due to the layered Open Client Transport Control Laye...

Page 81: ...ava support License Management Server LDAP driver Starting Adaptive Server Enterprise as IPv6 aware Adaptive Server is IPv6 unaware by default To make Adaptive Server IPv6 aware you must start Adaptiv...

Page 82: ...port 17100 would typically look like SYBASE master tcp ether revival sybase com 17100 query tcp ether revival sybase com 17100 master tcp ether revival v6 sybase com 17100 query tcp ether revival v6...

Page 83: ...t 3 To verify that the server port is in use start the server manually The server does not start if its assigned port number is already in use For information on starting servers manually see the inst...

Page 84: ...n use If you find no processes using the same port number 1 Restart Adaptive Server 2 Execute the ESP that you attempted earlier XP Server should start automatically If you find a process using the sa...

Page 85: ...user and software information that is used throughout the enterprise or over a network The LDAP server can be located on a different platform from the one on which Adaptive Server or the clients are...

Page 86: ...ssion connection to an LDAP server Note The user name and password that are passed to the LDAP server for user authentication purposes are distinct and different from those used to access Adaptive Ser...

Page 87: ...ybase LDAP directory entries Table 6 2 Sybase LDAP directory definitions interfaces file Directory services Platform specific Platform independent Specific to each Sybase installation Centralized and...

Page 88: ...N This tree is call the directory information tree DIT Client applications use a DIT base to specify where entities are stored See The libtcl cfg file on page 73 sybaseAddress String Each server addre...

Page 89: ...in Table 6 2 For example this is an LDAP entry for an Windows server listening on two addresses with different connection protocols sybaseAddress TCP 1 TOEJAM 4444 sybaseAddress NAMEPIPE 1 pipe sybas...

Page 90: ...e following LDAP entry using these same attributes is an anonymous connection and only works only if the LDAP server allows read only access ldap libsybdldap dll ldap seashore d sybase dc com You can...

Page 91: ...fines the keywords for the ldapurl variables Table 6 3 ldapurl variables 4 Verify that the appropriate environment variable points to the required third party libraries The Netscape LDAP SDK libraries...

Page 92: ...delete them v Adding a server entry to the directory service using dsedit Before you can add delete or modify an LDAP server entry you must add the LDAP URL to the libtcl cfg file See The libtcl cfg f...

Page 93: ...r You can specify multiple directory services for high availability failover protection Not every directory service in the list needs to be an LDAP server For example DIRECTORY ldap libsydbladp so lda...

Page 94: ...ap seashore dc sybase dc com one bindname uid Manager dc sybase dc com password Replace the password with the encrypted string ldap libsybdldap so ldap seashore dc sybase dc com one bindname uid Manag...

Page 95: ...ive Server to Adaptive Server version 15 0 see the Installation Guide for Windows Once you have upgraded the server you can configure your server to use LDAP service 1 Shut down the server See Chapter...

Page 96: ...Migrating from the interfaces file to LDAP 80 Adaptive Server Enterprise...

Page 97: ...nt including translated system messages and correct formats for date time and currency Adaptive Server supports localization for international customers and for customers with heterogeneous environmen...

Page 98: ...ion translated documentation is available in Chinese Simplified French German Japanese Korean Language modules Adaptive Server stores its localized software messages in separate language modules When...

Page 99: ...ve Server it displays a message box asking if you want to localize your Adaptive Server to a language other than us_english and if you want to use a character set or sort order other than the default...

Page 100: ...ISO 8859 1 If your server is operating in a heterogeneous language environment choose a character set that works with all the character sets needed Often this is Unicode UTF 8 Warning Make all change...

Page 101: ...equires Unilib conversion Unilib Required column Check mark x the character set requires Unilib conversion No check mark the character set may use either the Unilib conversion or the built in conversi...

Page 102: ...X EUC GB encoding Simplified Chinese character sets cp936 X Microsoft Simplified Chinese character sets gb18030 X PRC 18030 standard Character set Unilib required Description cp950 X PC Microsoft Tra...

Page 103: ...sets Table 7 12 lists the Turkish character set Character set Unilib required Description cp869 IBM PC Greek cp1253 MS Windows Greek greek8 HP GREEK8 iso88597 ISO 8859 7 Latin Greek Character set Unil...

Page 104: ...kish cp1254 Microsoft Windows Turkish iso88599 ISO 8859 9 Latin 5 Turkish turkish8 HP TURKISH8 Character set Unilib required Description utf8 X Unicode UTF 8 encoding Character set Unilib required Des...

Page 105: ...turn enable unicode conversions on For more information see the System Administration Guide If either Adaptive Server or Backup Server does not support a client s language or character set that serve...

Page 106: ...er definition files srt files These files accompany the character set definition files and can be found in the same directory You can select a sort order for your data according to the needs at your s...

Page 107: ...values for that character set Binary order sorts all ASCII uppercase letters before lowercase letters Accented or ideographic multibyte characters sort in their respective standards order which may be...

Page 108: ...alternate dictionary sort order with lowercase variants sorted before uppercase Use with several of the Western European languages Alternate dictionary order case insensitive accent insensitive Case i...

Page 109: ...he distribution media You must load this software into the same directory in which you loaded Adaptive Server 2 Reconfigure the language and if necessary the character set and sort order for Adaptive...

Page 110: ...finition files for Western European character sets U S English system message files During the installation process or through reconfiguration you can specify a different language character set and so...

Page 111: ...cy formatting that is used by all products The locales dat file contains entries that associate platform specific locale names with Sybase language and character set combinations About the charsets di...

Page 112: ...at file to identify the language and character set to use The connection process follows these steps 1 When a client application starts it checks the operating system locale setting and then checks th...

Page 113: ...If the locales definitions in your system configuration files do not match the Sybase locale definitions your applications will not run properly For example if you want your Open Client messages to a...

Page 114: ...n see the System Administration Guide 1 Source SYBASE csh or SYBASE sh if you have not set up the Sybase environment variables 2 To configure localization for Adaptive Server on the server start sqllo...

Page 115: ...rder_file with the name of the sort order file See Table 7 17 on page 100 Replace character_set with the Sybase name for your character set See Table 7 18 on page 101 2 Use charset utility to load any...

Page 116: ...e accent sensitive dictiona srt 51 Dictionary order case insensitive accent sensitive nocase srt 52 Dictionary order case insensitive accent sensitive with preference nocasepr srt 53 Dictionary order...

Page 117: ...nocs srt 56 Dictionary order case insensitive accent insensitive espnoac srt 57 Thai Dictionary order dictionary srt 51 Turkish These sort orders work only with ISO 8859 9 Dictionary order case sensit...

Page 118: ...rt order of Adaptive Server see the System Administration Guide CP 1253 cp1253 CP 1254 cp1254 CP 1255 cp1255 CP 1256 cp1256 CP 1257 cp1257 CP 1258 cp1258 DEC Kanji deckanji EUC CNS euccns EUC GB eucgb...

Page 119: ...e DSQUERY environment variable to identify the server name If there is no DSQUERY environment variable charset attempts to connect to a server named SYBASE I Specifies the interfaces file to use If no...

Page 120: ...Changing the localization configuration 104 Adaptive Server Enterprise...

Page 121: ...information about the success or failure of each start up attempt Logs error and informational messages generated by the server during its operations Remains open until you stop the server process Con...

Page 122: ...E ASE install servername_ms log At start up you can reset the name and location of the Adaptive Server error log file from the command line Use the e start up parameter and value in the dataserver com...

Page 123: ...erver Logging user defined messages You can specify whether a user defined message is logged to the Adaptive Server error log Adaptive Server lets you make this determination for New messages sp_addme...

Page 124: ...parameters and values are log audit logon success at 1 to enable logging of successful Adaptive Server logins sp_configure log audit logon success 1 log audit logon failure at 1 to enable logging of...

Page 125: ...n of a disk that stores Adaptive Server databases and database objects Device requirements Adaptive Server devices and databases are subject to the following limits The maximum device size is 4TB The...

Page 126: ...tored on one or more database devices in one or more disk pieces The maximum number of disk pieces in one database is 8 388 608 However Adaptive Server must retain a description of all active database...

Page 127: ...any other device on this server Use sp_helpdevice to see what device numbers have already been used If you find an existing database device is too small you can make that device larger using the disk...

Page 128: ...Managing database devices 112 Adaptive Server Enterprise...

Page 129: ...resources By examining the audit trail the System Security Officer can inspect patterns of access to objects in databases and can monitor the activity of specific users Audit records can be traced to...

Page 130: ...ou configure Adaptive Server for auditing you determine the number of audit tables for your installation You can specify up to eight system tables sysaudits_01 through sysaudits_08 Plan to use at leas...

Page 131: ...th two auditing tables when one fills up you can switch to the other With a third auditing table if one device fails the System Security Officer can install a new threshold procedure that changes the...

Page 132: ...dit table s 3 Add a device for the audit database transaction log 4 Delete a device entry 5 Change a device entry List of devices for the audit tables Logical name Physical name Segment name Table nam...

Page 133: ...dd Change a New Device for Auditing menu which displays the physical name of the device ADD CHANGE A NEW DEVICE FOR AUDITING 1 sybsecurity physical device name secret1 sybase_dr install aud1 dat 2 Log...

Page 134: ...ce entry List of devices for the audit tables Logical name Physical name Segment name Table name Size 6 Audit_01 secret1 sybase_dr install aud1 dat sysaudits_01 5 7 Audit_02 secret1 sybase_dr install...

Page 135: ...the remaining items on this menu As you do so be aware of the following Sybase recommends a minimum size of 2MB for the size of the transaction log auditinit displays the size in both Size of the Devi...

Page 136: ...capabilities Done Auditing capability installed Task succeeded install auditing capabilities Configuration completed successfully Press return to continue Enabling auditing After auditing is installed...

Page 137: ...se sybsyntax You can retrieve this data with sp_syntax For more information on sp_syntax see the Reference Manual The scripts directory contains one or more of the sp_syntax scripts shown in Table 10...

Page 138: ...iskdefault to change the status of the master device which is installed as the default disk or to specify another default device the scripts install sybsyntax on the master device Sybase does not reco...

Page 139: ...where status 1 1 select sum size from sysusages sysdevices where vstart sysdevices low and vstart sysdevices high and sysdevices status 1 1 select sum sysusages size from sysusages where dbid 3 begin...

Page 140: ...server name with DSQUERY 5 To ensure that you have installed the sybsyntax database and that it is working correctly use isql to log in to the server on which you installed the database and execute sp...

Page 141: ...omponent in interfaces files TCP protocol entry 57 administrator operating system 3 Sybase system 3 API component in interfaces file described 56 Arabic character sets 85 asynchronous I O AIO enabling...

Page 142: ...orders 90 comma in SQL statements xiv commands disk init 10 iostat 44 maxfiles 34 maxfiles_lim 34 netstat 43 44 netstat v 44 no a 44 ps 44 45 sar 43 setenv 30 setperm_all 34 time 44 45 vmstat 43 44 c...

Page 143: ...isk init command 10 displaying current file descriptors 34 documentation Adaptive Server translated 82 dscp utility 12 creating master interfaces files with 58 dsedit adding an LDAP server 76 dsedit u...

Page 144: ...nd 44 monitoring systems 44 netstat command 44 netstat v command 44 network protocol 56 no a command 44 ps command 44 time command 44 timeout period 41 vmstat command 44 installation directory Sybase...

Page 145: ...e 93 translation support 81 Latin character sets 86 LD_LIBRARY_PATH environment variable 4 LDAP access restrictions 70 adding a server 76 defined 69 directory definitions 71 directory schema 73 enabli...

Page 146: ...e for 51 58 multiple networks interfaces files and 51 interfaces files for 59 used as a backup in case of network failure 62 N named pipes default pipe 48 naming requirements for servers 56 NCR monito...

Page 147: ...evices See character devices raw partitions availability of 10 minimum size for database devices 10 referential integrity constraint 15 retry_attempts component in interfaces files 56 roman8 character...

Page 148: ...ment variable 4 SYBASE_FTS environment variable 4 SYBASE_OCS environment variable 4 SYBASE_SYSAM environment variable 4 sybsecurity database 7 114 device 7 9 sybsyntax database 121 sybsystemdb device...

Page 149: ...133 user defined message 107 utilities slloc 91 V vmstat command HP UX 43 IBM RS 6000 44 Sun Solaris 44 W Windows Sockets default socket 47 48 X XP Server default configuration 48 XP Server starting...

Page 150: ...Index 134 Adaptive Server Enterprise...

Reviews: