Home

Sybase DC35823-01-1500-04 Server User Manual

Contents

1. Sybase recommends that you specify the full path to all database devices Do not use environment variables when specifying path names with disk init Here is an example of creating a database device using disk init 110 disk init name user devicel physname work data devicel dat size 2048 Adaptive Server Enterprise CHAPTER9 Managing Adaptive Server Databases Configuration Guide In this example size 2048 tells the command to allocate 2048 virtual pages to the device A virtual page is 2048 bytes so this command creates a 4MB device The example command does not specify a device number instead letting the server choose one Unless you need to assign a specific number to a given device Sybase recommends you use this method If you do need an explicit device number use the parameter vdevno N where N is the device number you want to use If you specify a device number that number must not be in use by 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 resize command This command takes the same name and size parameters as disk init except that the size parameter specifies how much larger you want the device to be Note Operating system constraints will limit how much larger you can make any given device For example you canno
2. See the System Administration Guide for additional information on user connections Displaying current soft and hard limits To display the current soft limit for C shells enter limit descriptors For Bourne shells enter ulimit n To display the current hard limit for C shells enter limit h descriptors For Bourne shells enter ulimit Hn Increasing the soft limit To increase the soft limit for C shells enter limit descriptors n For Bourne shells enter Configuration Guide 35 File descriptors and user connections ulimit Sn new value where n is the current value for the soft limit and new_value is the value to which you want to increase the soft limit Note You can use the preceding commands in your RUN_server_name file to increase the hard and soft limits The RUN_server_name file is a Bourne shell script be sure to use the Bourne shell versions of these commands in the RUN_server_name file Increasing the hard limit To increase the hard limit use a program like the sample program shown in Sample program on page 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 Sample program on page 37 2 Compile the file cc file name c o program name where file_name is the name of the source file you created and program_name is the name
3. Thai client character sets Character set Unilib required Description tis620 X TIS 620 Thai standard cp874 X Microsoft Windows Thai Table 7 12 lists the Turkish character set Configuration Guide 87 Overview of localization support Table 7 12 Turkish character sets Character set Unilib required Description cp857 IBM PC Turkish cp1254 Microsoft Windows Turkish iso88599 ISO 8859 9 Latin 5 Turkish turkish8 HP TURKISH8 Table 7 13 lists the Unicode character set Table 7 13 Unicode character set Character set Unilib required Description utf8 X Unicode UTF 8 encoding Table 7 14 lists the Vietnamese character set Table 7 14 Vietnamese character set Character set Unilib required Description cp1258 X Microsoft Windows Vietnamese Table 7 15 lists the Western European character set Table 7 15 Western European character set Character set Unilib required Description ascii8 X US ASCII with 8 bit data ISO 646 cp437 IBM CP437 U S code set cp850 IBM CP850 European code set cp860 X PC Portuguese cp858 X cp850 with Euro support cp1252 X Microsoft Windows US ANSI iso_l ISO 8859 1 Latin 1 roman8 HP ROMAN8 isol5 X ISO 8859 15 Latin 1 with Euro support roman9 X HP ROMANS with Euro support 88 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Character set conversion Backup Server passes
4. e Each element on the line must be separated by a single space e Each entry is separated by a blank line e You can add comments to an interfaces file by adding a pound sign at the beginning of the line and a line break at the end There are two interfaces file entry formats TLI and TCP A TLI style entry looks like Configuration Guide 55 Understanding the format of the interfaces file servername retry attempts delay _interval lt newline gt lt tab gt service type api protocol device address filter lt newline gt lt tabsha_failover servername lt newline gt A TCP style entry looks like servername retry attempts delay _interval lt newline gt lt tab gt service type protocol network machine port filter lt newline gt lt tab gt ha_failover servername lt newline gt Components of an interfaces file entry Table 5 2 describes the components of an interfaces file entry Table 5 2 Components of an interfaces file Component Value servername Name of Adaptive Server or Backup Server Requirements for a server name are The name cannot be more than 30 characters long The first character must be a letter 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 initial failure Default is 0 delay_interval optional Number of seconds between co
5. sybsystemdb 5 sysprocsdev 5 6 databases 90 dbccdb 7 devices 109 master 5 6 model 5 sample 6 7 sizes of 13 specifications 13 sybsecurity 7 sybsystemprocs 6 13 tempdb 5 dataserver utility 27 dbcc checkstorage database for 7 dbcc error messages 45 dbccdb database 7 debug service type 56 Dec Kanji character set 89 default character set for Adaptive Server 83 character set changing 83 character sets installed by 83 language for Adaptive Server 83 language changing 83 sort order 83 delay_interval component in interfaces files 56 device component in interfaces files 57 devices files 109 dictionary sort orders 91 Scandinavian 92 Spanish 92 directories xv charsets 91 95 localization 94 runcontrol 22 directory schema LDAP 73 disk 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 Configuration Guide Index dsedit utility 12 creating master interfaces files with 58 DSLISTEN environment variable 3 DSQUERY environment variable 4 client connections and 60 described 51 multiple networks using different values 61 namingin 61 E enabling asynchronous I O 38 39 40 environment variables DSLISTEN 3 DSQUERY 4 51 61 LD_LIBRARY_PATH 4 LIBPATH 4 PATH 4 SYBASE 4 SYBASE_ASE 4 SYBASE FTS 4 SYBASE_OCS 4 SYBASE _SYSAM 4 error log paths 47 106 configuring 106 error logging
6. 113 Overview of audit installation 114 Pre installation tasks for auditing devices eee 115 Installing AUGITING ee eee eeeeeeeeeeeeeeeeeeeeeaeeeeaeeteeeeeneneeeaes 115 Installing online help for Transact SQL syntax ceeeeees 121 Online syntax help SP_SYNt AX ee eee eee neern 121 Default device for the sybsyntax database eee 122 Installing sybsyntaXx oo eee eee eeeeeeeeeeeeeeeeeeaeeeeeeseeeeeeeneenaes 122 gt e Se aS Sea SE ene EE ne on eee 125 vi Adaptive Server Enterprise About This Book Audience How to use this book Configuration Guide This manual the Configuration Guide provides instructions for performing specific configuration tasks for Sybase Adaptive Server Enterprise on UNIX platforms The operating system release levels for the UNIX platforms on which Adaptive Server is certified to execute is in the installation documentation or release bulletin for your platform This manual covers the following topics e Instructions for reconfiguring certain attributes of your existing Sybase Adaptive Server Enterprise Backup Server Adaptive Server Enterprise Monitor and XP Server to meet your specific needs e Creating network connections e Configuring optional functionality e Performing operating system administration tasks e Working with system administration issues that are relevant to Adaptive Server running on UNIX platforms This manua
7. 78 Migrating from the interfaces file to LDAP eceeeeeeeeees 79 CHAPTER 7 Customizing Localization for Adaptive Servet c scsseee 81 Overview of localization Support ee eee eeeeeeeeeeeeneeeeeeteneeeeaeees 81 LANGUAGE IMOGUIES asii eainiie aaae fescens cen aaie aang 82 Default character sets for Servers sseeeeereererrrerreereee 83 Supported character Sets ccccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 84 Character Set Conversion ccceeeceeeeeeeeeeeeeeeeeeeeeeeeeeeeeneeeteenaees 89 Conversions between server and Client n e 89 Sort order S iriarte iti eaaa a eE Eaa aiaia a ea ieiti 90 Configuration Guide v Contents Available Sort Orders eeceesceeseeeceenereenereseeeeseeersenerenerees 90 Language MOdUleS iieri cevedegs aaaea eaa naana teia raa ainan Eiei 93 Installing a new language module eeeeeeeeeeeeeeeeeeeeeereenen 93 Message languages cceseceessesserecesneceeneresneeeeneeeseneesaners 93 Kelor PA L aE E E A E EET icigwskhceseeets deaevibeeiens 94 Localization directories ss eesseesneesnssnesnnrrnnsrensrnnsrnerrneerneee 94 About the directory oeei eian eai late Geen deed 95 About the charsets directory eeeeeeeeeeeeereeerreereereereee 95 About the locales dat file eee eeeeeeneeeeneeeeeeeeeseeeeeneees 95 Changing the localization configuration eee eeeeeeeteeeereeee 97 Adaptive Server localization
8. Adaptive Server software includes some locale entries already defined in the locales dat file If these entries do not meet your needs you can either modify them or add new locale entries 96 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Editing the ocales dat file Before beginning the edit make a copy of the original file in case you have problems with the resulting edited version Changing the Configuration Guide To edit the locales dat file 1 2 Open the locales dat file copy in a text editor Find the section enclosed in brackets e For Sun Solaris sun_svr4 e For HP hp ux e For IBM aix Make sure the section contains an entry for the language syb_language and character set syb_charset combination that you want to use Note The value for platform_locale must match the value required by your operating system 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 appear in French and Adaptive Server is using the ROMAN8 character set you would check the locales dat entries for your platform and look for the following entry locale fr_ FR french romans Add the required entry or modify an existing entry Save the changes if any and exit the text editor localization configuration By default t
9. Adaptive Server start up If DSLISTEN is not set and no name is given during the Adaptive Server start up the Adaptive Server name defaults to SYBASE Environment variables DSQUERY defines the Adaptive Server name that client programs attempt to connect to if no Adaptive Server is specified with a command line option If DSQUERY is not set and you do not supply the Adaptive Server name with a command line option clients attempt to connect to SYBASE SYBASE defines the path of the Sybase installation directory The installation program sets up the variable SYBASE to point to the release directory specified during installation SYBASE_ASE defines the subdirectory of the Adaptive Server component SYBASE_OCS defines the subdirectory to which Open Client is set SYBASE_FTS defines the subdirectory for the full text search components SYBASE_SYSAM points to the license management software directory PATH specifies directory 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 PATH SSYBASE S SYBASE ASE bin S SYBASE S SYBASE OCS bin LD_LIBRARY_PATH this variable specifies the directory to search for shared libraries The Sybase shared libraries are located in the installed component s lib directory When using the source files SYBASE csh or SYBASE sh th
10. American locales Spanish dictionary order case insensitive Spanish case insensitive dictionary sort order Use with Spanish and for most Latin American locales Spanish dictionary order case insensitive accent insensitive Spanish case insensitive and accent insensitive dictionary sort order Use with Spanish and for most Latin American locales Scandinavian dictionary order case sensitive Case sensitive dictionary sort order Use with Scandinavian languages Scandinavian dictionary order case insensitive Case insensitive and accent insensitive dictionary sorting with uppercase preference Use with Scandinavian languages uppercase preference 92 To see the sort orders that are available use sqlloc to display the sort orders for the character sets you plan to use For more information on unicode sort orders for utf_8 see Chapter 7 Configuring Character Sets Sort Orders and Languages in the System Administration Guide Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Language modules If you want Adaptive Server error messages to be displayed in a language other than U S English us_english you must install the appropriate language module When you install a new language module installation automatically loads the language into the Sybase installation directory to support the new language For information about directories see Localiza
11. EBF Maintenance report or click the product description to download the software The following sections describe conventions used in this manual SQL is a free form language There are no rules about the number of words you can put on a line or where you must break a line However for readability all examples and most syntax statements in this manual are formatted so that each clause of a statement begins on a new line Clauses that have more than one part extend to additional lines which are indented Complex commands are formatted using modified Backus Naur Form BNF notation Table 1 shows the conventions for syntax statements that appear in this manual Table 1 Font and syntax conventions for this manual Element Example Command names procedure names utility names select and other keywords display in sans serif font sp_configure Database names and datatypes are in sans serif font master database Book names file names variables and path names are System Administration Guide in italics Configuration Guide sql ini file column_name SYBASE ASE directory xiii Element Example Variables or words that stand for values that you fill in when they are part of a query or statement are in italics in Courier font select column_name from table name where search conditions Type parentheses as part of the command compute row_aggregate column_name Double colon equals si
12. Installation Tasks For information about the contents of the sample databases see the Transact SQL User s Guide The sybsecurity device is created as part of the auditing installation process The sybsecurity device stores the sybsecurity database and the auditing system procedures with which you can configure auditing for your system The auditing system records system security information in 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 Adding Optional Functionality to Adaptive Server For information about installing and using the auditing system see Chapter 12 Auditing in the System Administration Guide The database consistency checker dbcc provides commands for checking the logical and physical consistency of a database The dbccdb database stores the results of docce when dbcc checkstorage or dbcc check verifying is used dbcc checkstorage records consistency information for the target database operation activity and the results of the operation in the dbccdb database Stored in the database are dbcc stored procedures for creating and maintaining dbccdb and for generating reports on the results of dbcc checkstorage operations For information on installing and using dbccdb see Chapter 25 Checking Database Consistency in the System Administration Gui
13. Server used by 53 address component for SPX 57 API component in 56 automatic creation of 50 client and server versions differences in 52 clients used by 49 contents of 51 creating automatically 50 creating master files with dscp 58 creating master files with dsedit 58 creating master files with text editor 58 creating for beginners 58 debug service type 56 default location 50 delay_interval component 56 described 49 device component 57 ether placeholder 56 heterogeneous environments and 51 homogeneous environments and 51 host component 56 location 50 loghost placeholder 59 machine component 57 master service type 56 multiple network listeners 59 multiple networks 51 59 network component 56 port component 57 protocol component 56 Adaptive Server Enterprise query port backup configuration 62 query service type 56 retry_attempt component 56 servername component 56 service_type component 56 spacesin 55 tab charactersin 55 unique elements inentries 59 used by clients 51 international systems support for 81 Sybase support for 81 interpubs sample database 7 iostat command IBM RS 6000 44 Sun Solaris 44 iso Latin character set 83 J Japanese sample database 7 jpubs sample database 7 K KEEPALIVE option TCP IP 41 kill command 26 28 Korean character sets 87 L language Modules 82 language modules 93 default 47 installing new 93 localization files 82 memory requirements for 98 languages changing 97 error
14. address for a TLI protocol entry Address consists of e Address prefix x for TLI e Network type always 0002 Port number converted to four digits hexadecimal Must be a unique number between 1025 and 65535 Check the etc services file on each machine on the network to see what port numbers 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 the presence of the port number in the file may prevent other users from using the port number IP network node address of the host machine converted to 8 digits hexadecimal e Trailing zeros optional 16 digits port ha_failover filter Configuration Guide A unique port number between 1025 and 65535 Check the etc services file on each machine on the network to see what port numbers 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 the presence of the port number in the file may prevent other users from using that port number An entry created in directory services or the interfaces file for high availability Adaptive Server supports Secure Socket Layers SSL as a filter which is appended to the master and query lines of the directory services SSL is
15. configured with these access restrictions e Anonymous authentication all data is visible to any user e Username and password authentication Adaptive Server uses the default user name and password for UNIX platforms SYBASE SYBASE_OCS config libtcl cfg on 32 bit platforms SYBASE SYBASE_OCS config libtcl64 cfg on 64 bit platforms User name and password authentication properties establish and end a session 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 Server Note LDAP user authentication is not supported on IBM AIX When an LDAP server is specified in the libtcl cfg or libtcl64 cfg file collectively the libtcl cfg file the server information is accessible only from the LDAP server Adaptive Server ignores the interfaces file If multiple directory services are supported in a server then the order in which they are searched is specified in libtcl cfg You cannot specify the search order with the dataserver command line option See Multiple directory services on page 77 LDAP directory services versus the Sybase interfaces file The LDAP driver implements directory services for use with an LDAP server LDAP directories are an infrastructure that provide 70 Adaptive Server Enterprise CHAPTER 6 Using the Lightweight Directory Access Protocol as a Dire
16. configuring 106 errors indbcc messages 45 ESPs See extended stored procedures ESPs etc services file 57 ether placeholder in interfaces files 56 EUC JIS character set 89 extended stored procedures ESPs 2 F file descriptors displaying current 34 file servers 61 files cshrce 29 Jogin 29 profile 29 common loc 95 127 Index device files 109 locales dat 95 localization 82 localized error messages loc 95 runserver 19 shared memory 27 sort order definition srt files 90 formatting for local date time and currency 95 French sample database 7 G German sample database 7 globalization support Sybase 47 81 94 97 Greek character sets 87 H hardware error messages 42 IBM RS 6000 42 UNIX 42 Hebrew character sets 87 heterogeneous environments 84 89 described 53 interfaces files and 53 homogeneous environments described 53 interfaces files and 53 host component in interfaces files 56 host name determining 56 HP UX netstatcommand 43 network protocol 56 pscommand 44 sar command 43 time command 44 timeout period 41 vmstat command 43 T O monitoring 43 128 IBM RS 6000 hardware error messages 42 iostat command 44 monitoring systems 44 netstatcommand 44 netstat v command 44 network protocol 56 no acommand 44 pscommand 44 time command 44 timeout period 41 vmstatcommand 44 installation directory Sybase xv interfaces file 11 interfaces files Adaptive Server namingin 56 Adaptive
17. device for the sybsyntax database The sybsyntax database requires 3MB on your database device By default the sybsyntax installation scripts install the sybsyntax database on the device that is designated as the default database device If you have not used sp_diskdefault 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 recommend this configuration because sybsyntax uses valuable space which is best left available for future expansion of the master database To avoid installing sybsyntax on the master device do one of the following Use sp_diskdefault to specify a default device other than the master device For information about sp_diskdefault see the Reference Manual e Modify each sybsyntax installation script that you plan to execute to specify a different device as explained in the following section Installing sybsyntax 122 For each sybsyntax installation script you want to execute 1 Determine the type raw partition logical volume operating system file and so on and location of the device where you plan to store the sybsyntax database You will need to provide this information later 2 Make a copy of the original script Be sure you can access this copy in case you experience problems with the edited script Adaptive Server Enterprise CHAPTER 10 Adding Optional Functionalit
18. e Procedures Transact SQL system procedures catalog stored procedures system extended stored procedures and dbcc stored procedures e Tables Transact SQL system tables and dbcc tables System Administration Guide provides in depth information about administering servers and databases This manual includes instructions and guidelines for managing physical resources security user and system databases and specifying character conversion international language and sort order settings System Tables Diagram illustrates system tables and their entity relationships in a poster format Available only in print version Transact SQL User s Guide documents Transact SQL Sybase s enhanced version of the relational database language This manual serves as a textbook for beginning users of the database management system This manual also contains descriptions of the pubs2 and pubs3 sample databases Using Adaptive Server Distributed Transaction Management Features explains how to configure use and troubleshoot Adaptive Server DTM features in distributed transaction processing environments Adaptive Server Enterprise About This Book Other sources of information Configuration Guide Using Sybase Failover in a High Availability System provides instructions for using Sybase s Failover to configure an Adaptive Server as a companion server in a high availability system Unified Agent and Agent Managem
19. ecceeceeeeeeeneeeeneeeeeeeeeeeeeeee 98 Backup Server localization ee ceeceseeeeeeeeeeneeeeseeeeeeneeeeaes 99 SOM OFGSNS sone nics oped 2a ied ea weet ete cas ew eed elated 100 Character sets s 03 03 iver lone alee a eve dee et 101 Charsebiwtility en ts car cesta Mela th lene ecis e ae aaea iE ets 102 CHAPTER 8 Logging Error Messages and Events eccseseseeeeeseeeeeneees 105 Adaptive Server error logging cesseeseeeeereeeeeeeteneeeeseeeeeeeene 105 Enabling and disabling error logging eeeeeeseeeeeteeee 106 Setting error log pathS we cceise beseedalecqensscveset seiane nnceduesek cance peadhausseed 106 Setting the Adaptive Server error log path eee 106 Managing messages ceeseceeeseeceenereseeeeseceseenecsanerseneeeneneesaners 107 Logging user defined MESSAGES eeeeeeeeeneeeceeeeteeeeeees 107 Logging auditing events 200 cece eeeeeeeeeeeeeeeeeeeteeeeenes 108 CHAPTER 9 Managing Adaptive Server Databases s ccessseeeerees 109 Managing database devices 0 0 eee cece ceeeeeeeereeeeeeeeeeeeeneeeeeees 109 Device requirements 00 eee eeeeeeeeeeeeeeeeneeeeseeeeeeeeeeneeeeeeeeaes 109 Creating files for database devices eee eee eeeeeeeeeeeeeeeeees 110 CHAPTER 10 Adding Optional Functionality to Adaptive Server 113 AddingauditiNg seei nenen na narea aara eaaa a eaei 113 Audit system devices and databases eeeeeeeeereeereeee
20. information for SQL Server and Adaptive Server Monitor Client Library Programmer s Guide describes how to write Monitor Client Library applications that access Adaptive Server performance data Monitor Server User s Guide describes how to use Monitor Server to obtain performance statistics from SQL Server and Adaptive Server Performance and Tuning Guide is a series of four books that explains how to tune Adaptive Server for maximum performance e Basics the basics for understanding and investigating performance questions in Adaptive Server e Locking describes how the various locking schemas can be used for improving performance in Adaptive Server e Optimizer and Abstract Plans describes how the optimizer processes queries and how abstract plans can be used to change some of the optimizer plans e Monitoring and Analyzing explains how statistics are obtained and used for monitoring and optimizing performance Quick Reference Guide provides a comprehensive listing of the names and syntax for commands functions system procedures extended system procedures datatypes and utilities in a pocket sized book Reference Manual is a series of four books that contains the following detailed Transact SQL information e Building Blocks Transact SQL datatypes functions global variables expressions identifiers and wildcards and reserved words e Commands Transact SQL commands
21. information on starting Monitor Server at operating system restart see the Monitor Server User s Guide Note The startup script must set up all the required Sybase environment variables or source SYBASE csh or SYBASE sh before starting the server Adaptive Server Enterprise CHAPTER 2 Starting and Stopping Servers For HP UX For IBM RS 6000 In HP UX versions 10 0 and later you cannot edit commands in the etc rc file so the System Administrator must create a script that executes when the operating system starts or shuts down For more information about rc 1M see the HP UX manual page You can model your script after the HP UX template file sbin init d template After creating the start up and shutdown script place it in the directory sbin init d Execution scripts placed in this directory have symbolic links to directories sbin rcn d where n is the system run level The linked scripts in sbin rcn d are used to control the sequencing order of the execution scripts On production systems you can restart Adaptive Server automatically whenever the UNIX operating system restarts To have Adaptive Server restart automatically place the 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_servername dev console 2 gt amp 1 Configuration Guide Where release_di
22. is booting Adaptive Server lt ugrp gt is the user group for the lt uid gt user ID Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System HP UX 11 23 HP UX on Itanium Configuration Guide 4 At the UNIX prompt execute the following statements as root The user ID of the user who is starting Adaptive Server and Backup Server must be the owner of the dev async directory This step is mandatory for HP users To improve I O performance on character or raw block devices enable asynchronous I O by installing the HP asynchronous I O driver from SAM For help with installing this driver contact your operating system administrator or HP technical support Note Before executing the following instructions shut down Adaptive Server or SQL Server nan A N To launch the Kernel Configuration use kcweb F Select Modules Select asyncdsk and change the next boot to static Rebuild the kernel and reboot the system Execute the following commands using the userid root etc mknod dev asynec c 101 4 chmod 0660 dev async chown lt uid gt dev async etc setprivgrp lt ugrp gt MLOCK Where lt uid gt is the identification user ID used by the user that is booting Adaptive Server lt ugrp gt is the user group for the sybase userid At the UNIX prompt execute the following statements as root The user ID of the user who is starting Adaptive Server and Backup Server
23. it requires Unilib conversion Unilib Required column e Check mark x the character set requires Unilib conversion e No check mark the character set may use either the Unilib conversion or the built in conversion For more information see Character set conversion on page 89 Table 7 1 lists the Arabic character set Table 7 1 Arabic character sets Character set Unilib required Description cp864 X PC Arabic cp1256 X Microsoft Windows Arabic iso88596 X ISO 8859 6 Latin Arabic Table 7 2 lists the Baltic character set Table 7 2 Baltic character sets Character set Unilib required Description cp1257 X Microsoft Windows Baltic Table 7 3 lists the simplified Chinese character set Configuration Guide 85 Overview of localization support Table 7 3 Simplified Chinese character sets Character set Unilib required Description eucgb X EUC GB encoding Simplified Chinese character sets cp936 X Microsoft Simplified Chinese character sets gb18030 X PRC 18030 standard Table 7 4 lists the traditional Chinese character set Table 7 4 Traditional Chinese character set Character set Unilib required Description cp950 X PC Microsoft Traditional Chinese euccns X EUC CNS encoding Traditional Chinese with extensions big5 X Big 5 Traditional Chinese big5hk X Big 5 with HKSCS extensions Table 7 5 lists the Cyrillic character set Table 7 5 Cyri
24. language encoded in a specific character set There are a variety of loc files in each subdirectory Most of these files contain translated error messages for a specific product or utility e The common loc file in each subdirectory contains localized information such as local date time and currency formatting that is used by all products e The locales dat file contains entries that associate platform specific locale names with Sybase language and character set combinations About the charsets directory The files in SYBASE charsets charset_name contain information related to each particular character set such as the definition of the character set and any sort orders available for that character set About the ocales dat file You can edit the locales dat file to e Change the default language or character set for a platform or e Add new associations between platform locale names and Sybase language and character set names Format of locales dat file entries Each entry in the locales dat file links a platform specific locale definition to a Sybase language and character set combination Each entry has the following format locale platform locale syb language syb charset where Configuration Guide 95 Localization platform_locale is the platform specific keyword for a locale For acceptable values see your operating system documentation When the locale being defined as the default for the site platf
25. language modules were unloaded from the distribution media onto your system All character sets are copied from the distribution media by default You can e Click No to accept the defaults e Click Yes to change the defaults The sqlloc menu is displayed sqlloc is the GUI utility used to change default languages character sets and sort orders By default when Adaptive Server and Backup Server are installed on IBM and SUN Solaris systems the installation installs the character set files for ISO 8859 1 which supports the Western European languages 83 Overview of localization support By default when Adaptive Server and Backup Server are installed on HP systems the installation installs the character set files for ROMAN8 which supports the Western European languages Changing the default character set for servers You can select any character set as the default on Adaptive Server including character sets that are not the platform default character sets Keep the following guidelines in mind when selecting a new default character set e To avoid conversion errors or overhead determine the default character set based on the character set used by your clients For example if most of your clients use ISO 8859 1 you can minimize the amount of data conversion that has to occur by specifying ISO 8859 1 e If your server is operating in a heterogeneous language environment choose a character set that works with all
26. least 15 minutes 41 Checking for hardware errors For Sun Solaris To display the timeout value enter usr sbin ndd get dev tcp tcp keepalive interval To reduce the timeout period to 15 minutes 900 000 ms enter usr sbin ndd set dev tcp tcp keepalive interval 900000 For Linux To display the timeout value enter sbin sysctl e net ipv4 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 messages indicate problems that may lead to database corruption e Disk read write or retry errors e Timeouts e System panics e Memory problems of any type For HP UX Check the var adm syslog syslog log file on a regular basis You can view the file directly or you can use the HP UX dmesg command See your operating system documentation for more information 42 Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System For IBM RS 6000 For Sun Solaris For Linux The errpt command includes several options for limiting the report to events that match certain criteria Use the errpt command on a regular basis If errors appear use the diagnostic tool diag to check your memory and disks Or use the System Management Interface Tool SMIT to run the errpt command This command may produce a lot of output Check the var adm messages file on a regular ba
27. logging of that message type sp_ configure log audit logon success 0 sp configure log audit logon failure 0 For more information about sp_configure see the System Administration Guide 108 Adaptive Server Enterprise CHAPTER 9 Managing Adaptive Server Databases The administration of Adaptive Server databases includes both routine tasks and performance and tuning considerations e The System Administration Guide discusses most of the administrative tasks in detail e The Performance and Tuning Guide provides in depth explanations of performance issues Topic Page Managing database devices 109 Managing database devices The term database device refers to a disk or a portion of a disk that stores Adaptive Server databases and database objects Device requirements Configuration Guide Adaptive Server devices and databases are subject to the following limits e The maximum device size is 4TB e The minimum usable device size depends on the servers logical page size Databases manage space in groups of 256 logical pages and the smallest specifiable disk piece size is 1MB so the smallest usable device is the larger of 1MB or 256 logical pages e The minimum device size for a 2K page server is IMB e The minimum device size for a 4K page server is IMB e The minimum device size for an 8K page server is 2MB 109 Managing database devices e The minimum device size for a 16K page server is 4MB The maximum
28. master database use master go dump database master to master dump go You may want to add appropriate 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 Administrator jones who then has a record of fatal dbcc errors and successful backups You can tailor the sample shell and isq scripts to suit the needs of your installation To have the scripts execute automatically edit the crontab file and add an entry similar to this 00 02 usr u sybase dbcc_ck 2 gt amp 1 This example executes a C shell script called dbcc_ck every morning at 2 00 a m 46 Adaptive Server Enterprise CHAPTER 4 Default settings Adaptive Server Default Configuration When you install or upgrade Adaptive Server it includes some default parameter settings and a few of its auxiliary programs After installing and testing this default Adaptive Server you can configure it to your system s needs and install other optional features For information about configuring Adaptive Server Backup Server and Monitor Server see the System Administration Guide For information about configuring languages character sets and sort orders as well as optional features see the System Administration Guide Topic Page Default settings 47 After installation Adaptive Server default settings are as list
29. messages to Adaptive Server in the client s language and in the Adaptive Server character set Adaptive Server then converts the messages and issues them in the client s language and character set Keep the following requirements in mind when selecting a character set e Inaheterogeneous environment Adaptive Server and Backup Server may need to communicate with clients running on different platforms and using different character sets To maintain data integrity the server converts the code between the character sets e To use the built in conversion you must install the character set definition files on the server for all the character sets being used by your clients Built in conversion support is available for many character sets e Unilib conversion support is available for all character sets supported by Sybase To enable Unilib conversion you must use sp_configure and 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 server issues a warning message Errors also occur when the Backup Server character set is not compatible with the Adaptive Server character set Character set conversion is supported only between character sets for the same language or between character sets in the same language group For example automatic character set conversion is supported between the character
30. module is installed and Spanish is specified as the Adaptive Server default language the client receives messages in Spanish By default the Adaptive Server and Backup Server configurations use the English locale settings which include e Character set definition files for Western European character sets e Sort order definition files for Western European character sets e US English system message files During the installation process or through reconfiguration you can specify a different language character set and sort order Localization directories 94 Sybase localization configuration involves the following directories e locales e charsets The table below illustrates the structure of the localization files It does not show a complete list of all the files SYBASE or charsets charset_name srt files SYBASE charset_name charset loc unicode uct files locales language_name charset_name language_name charset_name locales dat message language_name language_name Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server About the directory The SYBASE locales directory contains a subdirectory for each available language Each language subdirectory contains a subdirectory for each character set available with that language e The loc files in these subdirectories enable Adaptive Server or Backup Server to report errors in a specific
31. name matches the name of the server e Uses the network information provided by the directory services entry to connect to the 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 message is written to the client s standard error file If multiple networks are supported the client attempts to connect using the information in the second network address entry for the server The Open Client documentation discusses client connections in much greater detail See the Open Client Programmer s Supplement for your client platform or the appropriate Open Client documentation Creating a directory services entry Configuration Guide The installation program srvbuild automatically creates a directory services entry for each server installation You can also use the following Sybase utilities to edit the network information in directory services e dsedit an X Windows GUL utility e dscp a UNIX command line utility For details on using these utilities see the Adaptive Server Utility Guide 51 Supported directory drivers Supported directory drivers There are three supported drivers e interfaces driver e Lightweight Directory Services driver e Cell Directory Service CDS provided by Distributed Computing Environment DCE This remainder of this chapter describes the inter
32. on all networks and alter each network s interfaces file accordingly This method assumes that e You have complete control over what the Sybase installation clients see on each network e The interfaces file at the very least is not shared or copied among Sybase installations on different networks The interfaces file looks like the following example on the engineering network PRODUCTION lt tab gt 3 lt tab gt 3 lt newline gt lt tab gt query tcp ether SERV_ENGNET 5470 lt tab gt master tcp ether SERV_CORPNET 4559 lt tab gt master tcp ether SERV_ENGNET 5479 The interfaces file looks like the following example on the corporate network PRODUCTION lt tab gt 3 lt tab gt 3 lt newline gt lt tab gt query tcp ether SERV_CORPNET 4559 lt tab gt master tcp ether SERV_CORPNET 4559 lt tab gt master tcp ether SERV_ENGNET 5479 The query line in each file name is different depending on the network to be used The full master entry is present in both files This is allowed because only Adaptive Server will use the master lines Assuming that the server host machine can see both networks both host names are interchangeable it does not matter which interfaces file is used for Adaptive Server start up Using different DSQUERY names To use different DSQUERY names for each network listener 1 Choose an additional server name Configuration Guide 61 Configuring interfaces files for multiple netwo
33. or Monitor Server from the command line by using RUN_server_name files and startserver commands You can customize the starting options You can also customize the start up options by editing the RUN_server_name Server start up parameters The default start up parameters are stored under S SYBASE SYBASE_ASE install RUN_server_name where server_name is the name of the server you installed Backup Server Monitor Server and Historical Server server names are appended with _back _mon and _hs respectively Table 2 1 lists the default start up parameters for Adaptive Server Table 2 1 Default Adaptive Server start up parameters Switch Description d SYBASE data master dat Location of the master device file s server_name Name of the Adaptive Server e SYBASE SYBASE_ASE Location and name of the error log file install errorlog M SYBASE SYBASE_ASE Directory that stores shared memory files N SSYBASE SYBASE_ASE sysam Location and name of license cache file lt srv_name gt properties 18 Adaptive Server Enterprise CHAPTER 2 Starting and Stopping Servers Changing start up parameters You cannot change any of these default start up parameters unless you directly edit the SYBASE SYBASE_ASE install RUN_ server_name file You can also specify additional start up parameters within the SYBASE SYBASE_ASE install RUN_ server_name file Additional start up parameters include any vali
34. order Select any other languages you want to install You may select only languages that are supported by the default character set The Add and Remove Languages window lists all Sybase supported languages The Localization Summary window summarizes the configuration options you selected Click OK to confirm your selections The Status Output window notifies you upon completing the installation Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Backup Server localization You can change the Backup server language and character set by modifying the RUN_ lt backup_server_name gt file See the Utility Guide for more information on the backupserver command arguments Configuring Adaptive Server for other character sets Configuration Guide To configure Adaptive Server with the character set and sort order for your language complete the following steps Your system messages appear in the default language English 1 Use the charset utility to load the default character set and sort order To use charset the server must be running and you must have System Administrator privileges Use the file name of the sort order SSYBASE S SYBASE ASE bin charset Usa Ppassword Sserver_name sort_order_ file character set Replace sort_order_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
35. platform specific locale names 95 port component in interfaces files 57 port numbers and interfaces files 59 PPID See parent process identification privileges 10 procedure specifications 15 procedures Sybase extended stored process identification PID 27 profile file 29 protocol component in interfaces files 56 SPX 56 TCP IP 56 ps command HP UX 44 IBM RS 6000 44 Sun Solaris 45 pubs2 sample database 6 pubs3 sample database 6 pwdcrypt location of 78 password encryption 78 Q query port backup configuration 62 query service type 52 56 query specifications 14 R raw block devices 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 Configuration Guide Index romans character set 83 run control directory 22 runserver file 19 S sar command HP UX 43 Scandinavian dictionary sort orders 92 scripts Cshell 45 maintenance 45 sample maintenance 45 start up 21 22 security See auditing servername component in interfaces files 56 servers naming requirements 56 service types debug 56 listener 52 master 56 query 52 56 service_type component in interfaces file 56 setenv command 30 setperm_allcommand 34 shared memory files 27 shells Bourne 29 C 29 Shift JIS character set 89 shutdown command 25 26 size sybsystemprocs database minimum required for upgrade 13 slloc
36. reporting in specific 95 selecting message 93 translation support 81 Latin character sets 86 Configuration Guide Index LD_LIBRARY_PATH environment variable 4 LDAP access restrictions 70 adding a server 76 defined 69 directory definitions 71 directory schema 73 enabling 74 multiple directory services 77 sample entry 72 specifying in libtcl cfg 73 versus the interfaces file 70 LDAP libraries environment variables 75 location of 75 LDAP server using dsedit to add and modify 76 Idapurl defined 74 example 74 keywords 75 letter case in sort orders 91 LIBPATH environment variable 4 libtcl cfg file 73 format of 74 location of 74 purpose of 73 libtel cfg password 78 limits for file descriptors 35 listener service 52 loc files 95 local date time and currency formatting 95 locales directory 94 locales dat file 95 localization 81 changing the configuration 97 common information 95 localization support 47 loghost in interfaces files 59 login root 3 sa 3 superuser 3 sybase 3 login file 29 129 Index machine component in interfaces files 57 master interfaces file 51 58 service type 56 master database 5 master device 5 9 maxfiles kernel parameters 34 maxfiles_lim kernel parameters 34 mbuf pools 44 messages hardware errors 42 messages selecting language for 93 model database 5 Monitor Server default configuration for 48 monserver command 20 starting from UNIX command line 18 starting with operating system
37. script Configuration Guide Running dbcc checks and performing database backups protect the integrity and recoverability of your Adaptive Server databases The following sample C shell script calls several 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 lt i gt dbcc_out if grep c Msg 25 0 9 0 9 dbcc_ out then echo There are errors in i gt gt dbcc_mail out cat dbcc_out gt gt dbcc_mail out else echo Backing up i r gt gt dbcc_mail out isql Usa Ppassword lt i r backup endif end mail s Backup Report jjones lt dbcc_mail out The first set of scripts one for each database with a file name appended with dbcc runs dbcc checkalloc and dbcc checkdb for each database and sends the messages to an output file called dbcc_out For example the script master dbcc runs dbcc to check the master database dbcec checkalloc master go dbcc checkdb master go The C shell script then runs the grep command to find 2500 level error messages in the dbcc output The results of the grep command go into an output file called dbcc_mail out 45 A sample C shell maintenance script Next the script invokes an isql backup script for each database for which no 2500 level errors occurred and adds the Backing up database_name line to dbcc_mail out For example the script master backup backs up the
38. srt For more information about localization files see Localization directories on page 94 Table 7 16 describes the sort orders that you can specify at installation time or at a later time using the sqlloc utility Table 7 16 Sort orders available in Adaptive Server Description Sorts all data according to numeric byte 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 arbitrary All character sets have binary order as the default If binary order does not meet your needs you can specify one of the other sort orders either at installation or at a later time by using the sqlloc utility Dictionary order case sensitive accent sensitive Case sensitive Sorts each uppercase letter before its lowercase counterpart including accented characters Recognizes the various accented forms of a letter and sorts them after the associated unaccented letter Dictionary order case insensitive accent sensitive Case insensitive dictionary sort order Uppercase letters are equivalent to their lowercase counterparts and are intermingled in sorting results Dictionary order case insensitive accent insensitive Configuration Guide Case insensitive dictionary sort order Diacritical marks are ignored 91 Sort orders Sort order name Dictionary order case Desc
39. start up parameter and value in the dataserver command to start Adaptive Server Note Multiple Adaptive Servers cannot share the same error log If you install multiple Adaptive Servers specify a unique error log file name for each server Setting the Adaptive Server error log path 106 You can change the error log path by editing the SYBASE SYBASE_ASE install RUN_server_name file For example to change the error log path from S SYBASE SYBASE_ASE bin dataserver d Devices ASE_2K dat sASE_2K W ASE_150 e SYBASE SYBASE_ASE install ASE_2K log M ASE_150 to the SYBASE directory type SSYBASE ASE 15 0 bin dataserver d Devices ASE 2K dat SASE 2K i ASE_150 eSSYBASE ASE 2K log M ASE_150 For information about using the RUN_server_name file see Starting and Stopping Servers on page 17 Adaptive Server Enterprise CHAPTER 8 Logging Error Messages and Events Managing messages When event logging is enabled you can manage its functions in the following ways e Use sp_addmessage or sp_altermessage to control whether a specific user defined message is logged in the Adaptive Server error log For the complete syntax for sp_addmessage and sp_altermessage see the Reference Manual e Use configuration parameters to specify whether auditing events are logged Auditing events pertain to a user s success log audit logon success or failure log audit logon failure in logging in to Adaptive Server Logging
40. the delay should not be noticeable During high system load with many connections especially repeated connections with short duration the overall performance difference of using an LDAP server versus the traditional interfaces file might be noticeable 78 Adaptive Server Enterprise CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service Migrating from the interfaces file to LDAP Configuration Guide There is no direct method to upgrade an existing server using the interfaces file to one that uses lightweight directory services To upgrade a previous release of Adaptive 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 2 Starting and Stopping Servers 2 Edit the SYBASE SYBASE_OCS config libtcl cfg or libtcl64 cfg file to add the directory service See Enabling LDAP directory services on page 74 3 Use dsedit and add the server entry to directory service See Adding a server to the directory services on page 76 4 Restart your server 79 Migrating from the interfaces file to LDAP 80 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server This chapter provides information about Sybase localization support for international installations including configuring languages character sets an
41. user defined messages New messages Existing messages Configuration Guide You can specify whether a user defined message is logged to the Adaptive Server error log Adaptive Server lets you make this determination for e New messages sp_addmessage e Existing messages sp_altermessage For more information about these commands and their parameters see sp_addmessage and sp_altermessage in the Reference Manual Include the with_log option in sp_addmessage when you add a new user defined message to sysusermessages This parameter sets the Adaptive Server to log the message each time that the message appears Include the with_log option in sp_altermessage to change an existing user defined message This parameter alters the reporting status of that message e TRUE to enable logging e FALSE to disable logging 107 Managing messages Logging auditing events By default Adaptive Server does not log auditing events However you can use sp_configure parameters to specify whether Adaptive Server is to log auditing events such as logins to the Adaptive Server error log Possible parameters and values are e log audit logon success at 1 to enable logging of successful Adaptive Server logins sp_ configure log audit logon success 1 e log audit logon failure at 1 to enable logging of unsuccessful Adaptive Server logins sp configure log audit logon failure 1 e Either parameter at 0 to disable
42. 0 00000 00002 2003 09 22 12 37 23 68 server Error 1602 Severity 18 State 66 Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network 2 00 00000 00002 00 00000 00002 listeners hav 2003 09 22 12 37 23 68 server Unable to initialize network 0 2003 09 22 12 37 23 68 kernel ninit All master network failed 00 00000 00002 2003 09 22 16 11 35 46 server SQL Server shutdown by request 00 00000 00016 Shutting down 2003 09 22 12 37 23 68 kernel ueshutdown exiting v Investigating the port assignment 1 Look in the interfaces file to identify the port number assigned to the server Determine whether another process is using the same port number by entering netstat a If the port number is presented as a local address in the netstat output you cannot use that port for the server Another process is already using that port 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 installation documentation for your platform and the Adaptive Server Utility Guide v Ifa stale server process is retaining use of the port number 1 Do one of the following e Use the operating system kill command to terminate the process e Use another port number for the server by modifying the interfaces file Start the server manually to confirm th
43. 1 sybsecurity physical device name 2 Logical name of the device 3 Size of the device Meg 4 Device size for auditing Adaptive Server Enterprise CHAPTER 10 Adding Optional Functionality to Adaptive Server 2 Select Sybsecurity Physical Device Name To create a device for an audit table 1 Enter the full path of the physical device raw partition that you located in Pre installation tasks for auditing devices on page 115 Enter the physical name of the device to use for the audit database default is dev path_to_partition where path_to_partition is the path to the raw partition for the device If you specify an operating system file the following warning appears WARNING secret1 sybase dr install audl dat is a regular file which is not recommended for a Server device 2 Press Return to acknowledge the warning auditinit redisplays the Add 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 secretl sybase_dr install audl dat 2 Logical name of the device 3 Size of the device 4 Device size for auditing 3 Proceed through the remaining items on this menu Note The Size of the Device value must be equal to or greater than the Device Size for Auditing value The Device Size for Auditing must be equal to the device size If you are following Sybase auditing guidelines you do
44. 101 Use charset utility to load any additional character sets See charset utility on page 102 for more about this utility To use the Adaptive Server built in character set conversions you must load the character set definition files for all the characters set on your client platforms If you are using the Unilib character set conversions you do not need to do this Using isql log in to your server as sa and select the master database 1 gt use master 2 gt go Use the ID of the sort order to configure your server for the new character set and sort order 1 gt sp_configure default sortorder_id 2 gt sort_order_id character_set 3 gt go Replace sort_order_id with the ID for your sort order 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 Shut down the server to start the reconfiguration process 99 Changing the localization configuration 6 Use your normal process on your UNIX system to reboot the server usually by invoking one of the RUN_xxx scripts from SYBASE SYBASE_ASE install 7 The server starts rebuilds all the system indexes then shuts down Restart a second time to bring the server up in a stable state Sort orders Table 7 17 describes the available sort orders If your language does not appear then there is no language specific sort order for your language use a binary sort order Table 7 17 Availabl
45. 20 monitoring VO 43 network status 43 44 operating system resources 43 virtual memory usage 43 monitoring systems IBM RS 6000 44 NCR 44 monserver command 20 multiple directory services LDAP 77 multiple installations affecting interfaces files 53 creating one interfaces file 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 monitoring systems 44 130 netstart v command IBM RS 6000 44 netstat command HP UX 43 IBM RS 6000 44 Sun Solaris 44 network component in interfaces files 56 network protocols Digital UNIX 56 HP UX 56 IBM RS 6000 56 SPX 11 Sun Solaris 56 TCP IP 11 UnixWare 56 network support default configuration 47 48 networks backup connections and 63 DSQUERY and 61 failure of 63 interfaces files 49 monitoring status 43 44 multiple 51 no a command IBM RS 6000 44 O online syntax help 121 operating system administrator 3 resources 43 starting servers with 20 P parent process identification PPID 27 parentheses in SQL statements xiv partition map avoiding damage to 10 password encryption for libtcl cfg 78 pwdcrypt 78 PATH environment variable 4 Adaptive Server Enterprise paths error log 106 permissions 34 required in environment variables 29 restoring of 34 PID See process identification platforms supported vii
46. 5 1 Establishing network connections in a heterogeneous environment Harpo SQL SENSI Make a remote procedure call to Chico interfaces PC clients T sql ini Get Harpo s Harpo address and xxxxx connect Harpo XXXXX Chico XXXXX Chico SQL PC clients Chico server Get Chico s address and connect If both a client and a server are running under UNIX the same interfaces file is valid for both Figure 5 2 illustrates how clients and Adaptive 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 use the same interfaces file or exact copies of the same file 54 Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network Figure 5 2 Establishing network connections in a homogeneous environment Harpo SQL Levene Get Chico s address and Homogeneous make an RPC clients Get Harpo s address and connect Chico SQL server Get Chico s address and connect Understanding the format of the interfaces file The following rules apply to the format of interfaces file entries e Each Adaptive Server has only one entry although there may be multiple lines in the entry e Each line that follows the servername line must begin with a space or a character tab
47. 99 23 Starting XP Server after initial installation Starting XP Server after initial installation If you install Adaptive Server and XP Server in the same build session srvbuild automatically adds information about the XP Server to the sysservers table of Adaptive Server If you install XP Server in a different build session than the Adaptive Server installation you are prompted during the XP Server installation process to supply the name of the related Adaptive Server and the System Administrator s name and password This information is required by Adaptive Server to start XP Server If you do not supply this information during the installation process XP Server cannot run When 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 this required information to the sysservers table manually enter sp_addserver servername_XP NULL servername_XP where servername is the name of the Adaptive Server Stopping servers Only the System Administrator has permission to issue a shutdown command Using a shutdown command minimizes the amount of work that automatic recovery needs to do when the servers are restarted The preferred method of stopping Adaptive Server or Backup Server is to use the Transact SQL shutdown command For Monitor Server use the sms_shutdown command
48. Economy PowerScript PowerSite PowerSocket Powersoft PowerStage PowerStudio PowerTips Powersoft Portfolio Powersoft Professional PowerWare Desktop PowerWare Enterprise ProcessAnalyst Pylon Pylon Anywhere Pylon Application Server Pylon Conduit Pylon PIM Server Pylon Pro QAnywhere Rapport Relational Beans RemoteWare RepConnector Report Workbench Report Execute Replication Agent Replication Driver Replication Server Replication Server Manager Replication Toolkit Resource Manager RFID Anywhere RW DisplayLib RW Library SAFE SAFE PRO Sales Anywhere Search Anywhere SDF Search Anywhere Secure SQL Server Secure SQL Toolset Security Guardian ShareSpool ShareLink SKILS smart partners smart parts smart script SOA Anywhere Trademark SQL Advantage SQL Anywhere SQL Anywhere Studio SQL Code Checker SQL Debug SQL Edit SQL Edit TPU SQL Everywhere SQL Modeler SQL Remote SQL Server SQL Server Manager SQL SMART SQL Toolset SQL Server CFT SQL Server DBM SQL Server SNMP SubAgent SQL Station SQLJ Stage III Engineering Startup Com STEP SupportNow S W LF T Message Format Libraries Sybase Central Sybase Client Server Interfaces Sybase Development Framework Sybase Financial Server Sybase Gateways Sybase IQ Sybase Learning Connection Sybase MPP Sybase SQL Desktop Sybase SQL Lifecycle Sybase SQL Workgroup Sybase Synergy Program Sybase Virtual Server Architecture Sybase User Workbench SybaseWare Syber Finan
49. Enterprise 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 The online help for this product is also provided in HTML which you can navigate using a screen reader 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 Consult the documentation for your tool XV For information about how Sybase supports accessibility see Sybase Accessibility at http Awww sybase com accessibility The Sybase Accessibility site includes links 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 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 xvi Adaptive Server Enterprise CHAPTER 1 Introduction Sybase Adaptive Server Enterprise for UNIX is a full featured Adaptive Server that runs on the fo
50. IME TTY TIME COMD 10 31 40 pts 4 302 15 dataserver dteamster 10 31 45 pts 4 324 47 dataserver ONLINE 1 10 31 45 pts 4 326 02 dataserver ONLINE 2 10 31 45 pts 4 328 56 dataserver ONLINE 3 This example shows four running dataserver processes with operating system process identifications PID 3320 3321 3322 and 3323 dataserver is the executable form of the Adaptive Server program Child engine processes for the dataserver have the ONLINE argument Each child engine has a parent process identification PPID that is equal to the process identification PID of the parent In the example above the PID of the parent server is 3320 The other three engines spawned by the parent process have the same PPID If the PPIDs appear to be unrelated and there is more than one dataserver process then more than one Adaptive Server is running on the system Shutdown and shared memory files Configuration Guide When Adaptive Server starts it creates SERVER_NAME krg file in SYBASE SYBASE_ASE directory to store information about shared memory segments that it uses 27 Stopping servers 28 If Adaptive Server is configured with a memory size that is greater than the MAXSHMSEGSIZE parameter in the operating system then Adaptive Server may create additional shared memory segments and for every additional shared memory segment that it creates an additional file with SERVER_NAME srg N where N ranges from 0 N is created u
51. ODUCTION snra aaa aaa Aea 1 About Adaptive Server cesceceseeeesneeeseeeceeneresneresneeereneseenesenerens 1 SysteM specific iSSUCS ccccceeeecceeeeeeeeeeeeeeeeeeeeeneeeeeseeeeeeesnneeess 2 SYSTEM User rolg Siia eaa aE naa aa ea EE aaier 3 Environment variables ccccccsccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 3 Adaptive Server devices and system databaseS cere 5 The master device ccceeeescceeeeeeeeeeeeceeeeeeeeeeeeeeaeeeeeeeeeeteees 5 The sybsystemdb device eee esse eeeneeeeneeeeneeeeeeteseeeeeneeeed 6 The sysprocsdev device ooo eee eee ceeteeeeeeeeeeeeeneeteaeeeeeeeeeneeeed 6 Optional devices and databases cccccceceeeeeeeeeeeeeeteeeeeeee 6 dsync option on by default for database device files 8 Determining the location type and size of a database device 9 Client server communication ccceeceeeeeeeeeeeeeeeeeeeeeeeneeeeeeenees 11 Changing Adaptive Server configuration ccssseeeeeeeeees 12 Languages other than U S English eee eee eeeeeeeereeeeneeeeaes 13 Adaptive Server specifications ccccseececeeeeeeeeeeneeeeeeeeeeeteee 13 Starting and Stopping Servers cccsssccceesssseeeeeeesseeeeenenees 17 OVOCIVIOW fcc EE E E 17 Requirements for starting Servers seseeeeeeeeerreereereeree 17 Starting Ee E E E 18 Server start up parameters sssesssessrsesrssnrsrnnsrnnrrnnsrnesr
52. SYBASE Configuration Guide Adaptive Server Enterprise 15 0 UNIX DOCUMENT ID DC35823 01 1500 04 LAST REVISED March 2007 Copyright 1987 2007 by Sybase Inc All rights reserved This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes Information in this document is subject to change without notice The software described herein is furnished under a license agreement and it may be used or copied only in accordance with the terms of that agreement To order additional documents U S and Canadian customers should call Customer Fulfillment at 800 685 8225 fax 617 229 9845 Customers in other countries with a U S license agreement may contact Customer Fulfillment via the above fax number All other international customers should contact their Sybase subsidiary or local distributor Upgrades are provided only at regularly scheduled software release dates No part of this publication may be reproduced transmitted or translated in any form or by any means electronic mechanical manual optical or otherwise without the prior written permission of Sybase Inc Sybase SYBASE logo ADA Workbench Adaptable Windowing Environment Adaptive Component Architecture Adaptive Server Adaptive Server Anywhere Adaptive Server Enterprise Adaptive Server Enterprise Monitor Adaptive Server Enterprise Replication Adaptive Server Everywhere Advantage Data
53. Servers to proceed with the servers configuration srvbuild displays the configuration status as it builds the servers you selected After the server configuration completes click Exit to quit srvbuild Using the sity setting Setting the stty tostop option causes a background Adaptive Server to stop as soon as it tries to write to the terminal To avoid this error execute the following command before starting Adaptive Server stty tostop If you are redirecting all Adaptive Server output to files you do not have to change the stty setting Configuration Guide 33 Restoring correct permissions Restoring correct permissions Sybase software files and directories are installed with the correct access permissions If you notice that the permissions are no longer correct you can restore the correct permissions with the script setperm_all located in the SYBASE SYBASE_ASE install directory File descriptors and user connections For HP UX For AIX 34 The number of user connections used by Adaptive Server cannot exceed the number of file descriptors available to Adaptive Server on the operating system When configuring user connections on Adaptive Server the System Administrator should take into account the number of file descriptors available per process Although most of the open file descriptors are available for user connections a few are used by Adaptive Server for opening files and devices The kernel paramete
54. Stopping Adaptive Server To shut down Adaptive Server 1 Use isq to log in to an Adaptive Server account with System Administrator privileges isql Usa Ppassword Sserver_name 24 Adaptive Server Enterprise CHAPTER 2_ Starting and Stopping Servers 2 Enter 1 gt shutdown 2 gt go The default for shutdown uses the with wait option which allows Adaptive Server to finish executing SQL statements or procedures perform a checkpoint in each database disable new logins and perform other shutdown tasks Issuing the shutdown command prints a message like this to the sterr file Server SHUTDOWN by request The SQL Server is terminating this process CT LIBRARY error This is normal behavior If the message indicates that Adaptive Server is 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 checkpoints in every database Note Using the shutdown with nowait command is not recommended use it only when necessary Stopping Backup Server To shut down a Backup Server 1 Use isql to log in to a server with System Administrator privileges 2 Enter 1 gt shutdown SYB BACKUP 2 gt go After you shut down a Backup Server you must wait at least 30 seconds before restarting it Issuing the shutdown command prints a message similar to the following to the stderr file Backup Serv
55. at the port number is available For information on starting servers manually see the installation documentation for your platform and the Utility Guide Error when executing an ESP If you attempt to execute an ESP extended stored procedure you may see the following error 00 00000 00008 1997 09 10 12 52 53 03 kernel XP Server failed to start Try bringing up XP Server manually Check SQL Server documentation for more Configuration Guide 67 Troubleshooting information on how to bring XP Server up 68 XP Server cannot start because the port number may be in use by another process Use the netstat command described in the previous section to determine if the port number specified for XP Server is in 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 same port number you can do one of the following e Change the interfaces file to use a new port number for the XP Server e Stop the process using the port number allotted to XP Server Restart Adaptive Server and execute the ESP that you attempted earlier XP Server should start automatically Adaptive Server Enterprise CHAPTER 6 Overview Configuration Guide Using the Lightweight Directory Access Protocol as a Directory Service Adaptive Server uses directory services to establish client and RPC
56. ata page tables Maximum DOL table Number of Column size Columnsize Column size Column size limits columns 2K page 4K page 8K page 16K page Fixed length column 1024 1958 bytes 4006 bytes 8102 bytes 16294 bytes Variable length column 1024 1954 bytes 4002 bytes 8089 bytes 16290 bytes Database space requirements depend upon the logical page size of the server If your model database is larger than the minim size listed below then the minimum size of the database is equal to the model database Table 1 4 lists the minimum size for each database Table 1 4 Database requirements for varying page sizes Databases 2K page 4K page 8K page 16K page master database 13MB 26MB 52MB 104MB Configuration Guide 15 Adaptive Server specifications Databases 2K page 4K page 8K page 16K page model database 3MB 6MB 12MB 24MB tempdb database 4MB 6MB 12MB 24MB sybsystemdb database 3MB 6MB 12MB 24MB Larger logical page sizes can contain more data Table 1 5 lists the maximum data for each logical page size Table 1 5 Data limits for tables according to page size Tables 2K page 4K page 8K page 16K page Bytes per index key 600 1250 2600 5300 User visible row length 1958 4006 8102 16294 DOL table User visible row length 1960 4008 8104 16296 APL table 16 Adaptive Server Enterprise CHAPTER 2 Starting and Stopping Servers This chapter describes how to start and stop Adaptive Server Backup Server Monit
57. base Server Afaria Answers Anywhere Applied Meta Applied Metacomputing AppModeler APT Workbench APT Build APT Edit APT Execute APT Translator APT Library ASEP Avaki Avaki Arrow Design Avaki Data Grid AvantGo Backup Server BayCam Beyond Connected Bit Wise BizTracker Certified PowerBuilder Developer Certified SYBASE Professional Certified SYBASE Professional Logo ClearConnect Client Library Client Services CodeBank Column Design ComponentPack Connection Manager Convoy DM Copernicus CSP Data Pipeline Data Workbench DataArchitect Database Analyzer DataExpress DataServer DataWindow DataWindow NET DB Library dbQueue Dejima Dejima Direct Developers Workbench DirectConnect Anywhere DirectConnect Distribution Director Dynamic Mobility Model e ADK E Anywhere e Biz Integrator E Whatever EC Gateway ECMAP ECRTP eFulfillment Accelerator EII Plus Electronic Case Management Embedded SQL EMS Enterprise Application Studio Enterprise Client Server Enterprise Connect Enterprise Data Studio Enterprise Manager Enterprise Portal logo Enterprise SQL Server Manager Enterprise Work Architecture Enterprise Work Designer Enterprise Work Modeler eProcurement Accelerator eremote Everything Works Better When Everything Works Together EWA ExtendAssist Extended Systems Extend View Financial Fusion Financial Fusion and design Financial Fusion Server Formula One Fusion Powered e Finance Fusion Powered Financ
58. base Transaction Log auditinit displays the Add Change a New Device for Auditing menu ADD CHANGE A NEW DEVICE FOR AUDITING 1 sybsecurity physical device name 2 Logical name of the device 3 Size of the new device Meg 4 Device size for auditing Select Sybsecurity Physical Device Name auditinit prompts for the physical name and supplies you with a default if available Enter the physical name of the device to use for the sybsecurity database default is dev path_to_partition Adaptive Server Enterprise CHAPTER 10 Adding Optional Functionality to Adaptive Server where path_to_partition is the path to the raw partition for the device 3 Enter the full path name of a physical device If you enter an operating system file name the following warning appears WARNING secret1 sybase_dr install audlog is a regular file which is not recommended for a Server device 4 Press Return to acknowledge this warning auditinit displays the Add Change a New Device for Auditing menu and the value you selected for the physical name of the device ADD CHANGE A NEW DEVICE FOR AUDITING 1l sybsecurity physical device name secret1 sybase_ dr install auditlog dat 2 Logical name of the device 3 Size of the device 4 Device size for auditing 5 Proceed through the remaining items on this menu As you do so be aware of the following e Sybase recommends a minimum size of 2MB for the size of the transaction
59. ces files difference between client and server versions 52 heterogeneous 53 homogeneous 53 clients Adaptive Server communications with 49 applications and locales dat file 96 conversion between and server 89 default character set 84 DSQUERY and 60 file servers 61 code conversion between character sets 89 collating sequences See sort orders 90 comma in SQL statements xiv commands disk init 10 iostat 44 maxfiles 34 maxfiles_lim 34 126 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 common loc file 95 communications between client and Adaptive Server 49 configurations default 47 48 configurations default 48 configuring Backup Server 94 97 character sets 99 conventions See also syntax Transact SQL syntax xiii used in the Reference Manual xiii conventions in this book xv conversions Unicode character 85 converting between character sets 89 create database command system tables created by 5 creating interfaces files 51 58 interfaces files automatically 50 interfaces files for beginners 58 master interfaces files with dscp utility 58 master interfaces files with dsedit 58 master interfaces files with text editor 58 cshre file 29 curly braces in SQL statements xiv customizing installations 47 Cyrillic character sets 86 D data translation 81 database devices master 5 preparing raw partitions for 10 sybsyntax 122 Adaptive Server Enterprise
60. cial SyberAssist SybFlex SybMD SyBooks System 10 System 11 System XI logo SystemTools Tabular Data Stream The Enterprise Client Server Company The Extensible Software Platform The Future Is Wide Open The Learning Connection The Model For Client Server Solutions The Online Information Center The Power of One TotalFix TradeForce Transact SQL Translation Toolkit Turning Imagination Into Reality UltraLite UltraLite NET UNIBOM Unilib Uninull Unisep Unistring URK Runtime Kit for UniCode Viafone Viewer VisualWriter VQL WarehouseArchitect Warehouse Control Center Warehouse Studio Warehouse WORKS Watcom Watcom SQL Watcom SQL Server Web Deployment Kit Web PB Web SQL WebSights WebViewer WorkGroup SQL Server XA Library XA Server XcelleNet XP Server XTNDAccess and XTNDConnect are trademarks of Sybase Inc or its subsidiaries 01 06 Unicode and the Unicode Logo are registered trademarks of Unicode Inc All other company and product names used herein may be trademarks or registered trademarks of their respective companies Use duplication or disclosure by the government is subject to the restrictions set forth in subparagraph c 1 ii of DFARS 52 227 7013 for the DOD and as set forth in FAR 52 227 19 a d for civilian agencies Sybase Inc One Sybase Drive Dublin CA 94568 Contents About This Book CHAPTER 1 CHAPTER 2 Configuration Guide LESELE A cand EE E ectbe si conte E E vii ITR
61. client program and you want to connect with a particular server the client program looks up the server name in the directory services and connects to that server 49 How Adaptive Server determines which directory service entry to use Servers also need network information When a server starts up it looks in its interfaces file to determine where to listen for client connection requests In addition Adaptive Server can take on a client role when it makes remote procedure calls to other Adaptive Servers Table 5 1 shows where to find more information on server and client interfaces file tasks and topics Table 5 1 Where to find interfaces file tasks and topics Type of interfaces file Task or topic See UNIX server or Adding entries for multiple Chapter 7 Customizing Localization for Adaptive client Adaptive Server installations Server Creating a master interfaces file Creating a master interfaces file on page 58 for multiple installations Configuring for multiple networks Configuring interfaces files for multiple networks on page 59 Reference information Understanding the format of the interfaces file on page 55 PC client Configuring a client Installation Guide for your platform Reference information and Open Client and Open Server Programmer s Supplement instructions for advanced tasks for your PC client platform or the appropriate Open Client documentation Client platforms Conf
62. connections A server needs both master and query lines in its interfaces file since servers sometimes act as clients to other servers Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network If your site has multiple installations A client s interfaces file does not need a master line It functions correctly with only a query line If you have more than one Adaptive Server installation each server s interfaces file should contain information about all servers on the network If all of your server products are running on the same platform you can create one master interfaces file and copy that file to each 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 Heterogeneous and homogeneous environments Configuration Guide You can run Adaptive Server and clients on the same platform or on different platforms If the platforms are different each platform may require a different format and configuration for its interfaces file Figure 5 1 illustrates how a PC client uses network information in its interfaces file sql ini to connect to Adaptive Server running under UNIX and how Adaptive Server uses its interfaces file to connect to another server during a remote procedure call 53 Heterogeneous and homogeneous environments Figure
63. connections e Maximum number of server connections e Transport type e Host name 31 Configuring new servers with srvbuild 32 e Port number To configure Monitor Server select the following information in the Monitor Server screen e Maximum number of connections e Error log e Configuration file e Shared memory directory e Transport type e Host name e Port number In the XP Server type screen select e Transport type e Host name e Port number In the Full Text Search SDS type screen select e Error log e Collection directory e Default database e Language e Character set e Minimum number of sessions e Maximum number of sessions e Transport type e Host name e Port number To configure Job Scheduler enter the following information in the Job Scheduler type screen e Sybmgmtdb device path e Sybmgmtdb device size Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System 11 12 13 e Sybmgmtdb database size e Transport type e Host name e Port number In the Configure Self Management screen you can enter e Enable Self Management e Self Management user name e Self Management user password If you change the Self Management user password after configuring the Self Management you need to rerun sp _addexternlogin loopback lt Self Management user name gt lt Self Management user name gt lt new Self Management user password gt Click Build
64. connections over the Internet This chapter provides information about using LDAP directory services to establish connections Topic Page Overview 69 LDAP directory services versus the Sybase interfaces file 70 The libtcl cfg file 73 Enabling LDAP directory services 74 Adding a server to the directory services 76 Multiple directory services 77 Encrypting the password 78 Performance 78 Migrating from the interfaces file to LDAP 79 Lightweight Directory Access Protocol LDAP is an industry standard for accessing directory services Directory services allow components to look up information by a distinguished name DN from an LDAP server that stores and manages server 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 running LDAP defines the communication protocol and the contents of messages exchanged between clients and servers Messages are operators such as client requests for read write and query and server responses including data format information 69 LDAP directory services versus the Sybase interfaces file The LDAP server stores and retrieves information about e Adaptive Server such as IP address port number and network protocol e Security mechanisms and filters e High availability companion server name The LDAP server can be
65. cp ether SERV_ENGNET 5479 lt tab gt query tcp ether SERV_CORPNET 4559 When Adaptive Server restarts it spawns a network handler process for each master line in the entry that corresponds to the server s DSLISTEN value Connections made on each interface are handled equally as peers Configuring the client connections When an Adaptive Server client scans the interfaces file for a server name the client uses the first query entry it encounters for the server s entry This makes configuring clients to use multiple network connections less straightforward than configuring the server ports You have two choices e Use the same DSQUERY name for all clients The interfaces files on the different machines contain different network names e Use different DSQUERY names for the clients The interfaces files on all the machines are the same but they contain multiple DSQUERY names 60 Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network Using one network independent DSQUERY name If uniform client DSQUERY naming is important you can make the necessary changes in the network addressing of the clients in the interfaces file You can install separate Sybase installation directories and distinct interfaces files on client file servers on each network to allow users to connect to the correct network address Instead of altering the DSQUERY name the clients use you maintain one DSQUERY name for all clients
66. ctory Service interfaces file Platform specific e A network based alternative to the traditional Sybase interfaces file e A single hierarchical view of information including users software resources networks files and so on Table 6 1 highlights the differences between the Sybase interfaces file and an LDAP server Table 6 1 interfaces file versus LDAP directory services Directory services Platform independent Specific to each Sybase installation Centralized and hierarchical Contains separate master and query entries One entry for each server that is accessed by both clients and servers Cannot store metadata about the server Stores metadata about the server LDAP directory services support more attributes than the Sybase interfaces file These attributes can include server version server status and so on See Table 6 2 for a list of attributes Note LDAP is only supported with reentrant libraries You must use isql_r instead of isql when connecting to a server using LDAP directory services Table 6 2 lists the Sybase LDAP directory entries Table 6 2 Sybase LDAP directory definitions Attribute name Value type Description ditbase interfaces file DIT base for object tree If the libtcl cfg file is specified the or libtcl cfg interfaces file is ignored The libtcl cfg file can be overridden with ct_con_prop for a specified connection dn Character Distinguis
67. d 1 Source SYBASE csh or SYBASE sh file in SYBASE to setup the environment variables 2 Run SYBASE SYBASE_ASE bin srvbuild 3 The Select Servers to Build 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 name Note The list of Server type available for you to choose depends on what you have installed in SYBASE 4 When you have selected the servers you want to build click OK The next screen or screens displays information depending on what you chose to configure Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System Configuration Guide In the Adaptive Server type screen select the e Server page size e Master device path e Master device size e Master database size e Sybsystemprocs device path e Sybsystemprocs device size e Sybsystemprocs database size e Error log e Transport type e Host name e Port number In the Edit Advance Adaptive Server Attributes tab enter e Adaptive Server configuration file e Sybsystemdb device path e Sybsystemdb device size e Sybsystemdb database size e Share memory file directory e Default backup server To configure Backup Server in the Backup Server configuration screen select the e Error log e Tape configuration file e Language e Character set e Maximum number of network
68. d server command line options listed for the databaserver and backupserver descriptions in the Utility Guide For a description of start up parameters for Monitor Server and Historical Server see the Adaptive Server Enterprise Monitor documentation Using a RUN_server_name file Configuration Guide Each time anew Adaptive Server Backup Server or Monitor Server is created the srvbuild program creates a RUN_server_name file that contains the 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 servername is the name of the server For example the RUN_server_name file name for an Adaptive Server named TEST is RUN_TEST For Backup Server and Monitor Server the RUN_server_name files are named RUN_servername_back and RUN_servername_mon respectively where servername is the name of the server Warning Do not delete the RUN_server_name file that is created in SYBASE SYBASE_ASE install This file is used to restart servers when you customize your installation If you need the RUN_server_name file in another location make a copy of the original RUN_server_name file in the new location The RUN_server_name file for a server named SYBASE is named RUN_SYBASE If the RUN_server_name file for your current Adaptive Server is named RUN_server_name you must change the name to RUN_SYBASE duri
69. d sort order For more information see the System Administration Guide Topic Page Overview of localization support 81 Character set conversion 89 Sort orders 90 Language modules 93 Localization 94 Changing the localization configuration 97 Overview of localization support Configuration Guide Localization is the process of setting up an application to run in a particular language or country environment including translated system messages and correct formats for date time and currency Adaptive Server supports localization for international customers and for customers with heterogeneous environments This support includes e Data processing support Adaptive Server comes with character set and sort order definition files it uses to process the characters used in different languages Sybase provides support for the major languages in e Western Europe e Eastern Europe e Middle East 81 Overview of localization support e Latin America e Asia e Translated system messages Adaptive Server includes language modules for e Brazilian Portuguese e Chinese Simplified e French e German e Japanese e Korean e Polish e Spanish e Thai e Translated documentation translated documentation is available in e Chinese Simplified e French e German e Japanese e Korean Language modules Adaptive Server stores its localized software messages in separate language modules Whe
70. de sybmgmtdb is a Job Scheduler database Adaptive Server devices and system databases All the job schedule and scheduled job information and data needed by the Job Scheduler task for internal processing is stored in the sybmgmtdb database Most access to data in the sybmgmtdb database is via stored procedures The stored procedures make the data available to the GUI the JS Agent and the command line interface Only the Job Scheduler task accesses data directly from the sypbmgmtdb database For more information about syomgmtdb and Job Scheduler see Job Scheduler User s Guide dsync option on by default for database device files The dsync option ensures Adaptive Server can recover 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 write activity The dsync option can be set or reset using the disk init disk reinit and sp_deviceattr commands Note The dsync option is ignored for raw devices When installing a new Adaptive Server by default dsync is set on for all file system devices When upgrading from ASE 12 0 or earlier releases on a UNIX server that stored databases on UNIX file system devices by default dsync is set e on for the master device e off for all other devices Immediately after upgrade set the dsync option for the file system devices See also
71. disk 4TB file sizes up to 4TB then Adaptive partition Server supports file system devices up to 4TB Maximum number of 231 database devices per server Maximum number of Unlimited Limited by available memory devices or device pieces per database Maximum number of 31 segments per database Maximum number of login 2147516416 IDs per server Configuration Guide 13 Adaptive Server specifications Maximum number of users 2146484223 per database Maximum number of 1032193 groups per database Table specifications User objects per database 231 255 Indexes per table 250 one clustered index Rows per table Limited by available Maximum 2 storage Columns per composite 31 index Creation of clustered index 1 2 x y For sorted data approximately 20 x total data space in percent of the table size needed table y sum of space of all nonclustered indexes on table and 20 percent overhead for logging Maximum size of object 255 name Query specifications Maximum number of tables 64 Maximum of 50 user tables participating in a query for a query without a union or for each side of a union in a query including result tables tables referenced by views the view itself is not counted correlations and self joins maximum of 14 worktables Maximum number of tables ina 256 union query Includes up to 50 user tables and 14 work tables on every side of the union fo
72. e Creating or converting for IPv6 aware applications The following matrix lists the platform run time requirements and the specific product and its release version Table 5 3 IPv6 support Adaptive Server IPv6 Open Client Server Platform awareness IPv6 awareness Sun Solaris 8 32 and 64 12 5 3a and 15 0 12 5 and 15 0 bit HP UX 11i v1 32 and 12 5 3a and 15 0 12 5 and 15 0 64 bit Microsoft Server 2003 12 5 3a and 15 0 12 5 and 15 0 Linux RHEL 3 0 15 0 12 5 and 15 0 Many 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 Layer CTlib gt NETIib which is IPv6 aware for network socket operations An important note is that any DBlib based Open Client product is not IPv6 aware For Adaptive Server Enterprise being IPv6 aware is a complex issue because some components within the ASE are 3rd party components and are not yet IPv6 aware To understand how this impacts Adaptive Server Enterprise the following list shows all functional mechanisms of Adaptive Server Enterprise that are IPv6 aware with respect to the platform release matrix above e Connection Handler Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network e RPC mechanisms e Job Scheduler Task Agent session connection e Network Host API e UDP Message support for syb
73. e What s New in Adaptive Server Enterprise describes the new features in Adaptive Server version 15 0 the system changes added to support those features and changes that may affect your existing applications ASE Replicator User s Guide describes how to use the Adaptive Server Replicator feature of Adaptive Server to implement basic replication from a primary server to one or more remote Adaptive Servers Component Integration Services User s Guide explains how to use the Adaptive Server Component Integration Services feature to connect remote Sybase and non Sybase databases The Configuration Guide for your platform provides instructions for performing specific configuration tasks for Adaptive Server Full Text Search Specialty Data Store User s Guide describes how to use the Full Text Search feature with Verity to search Adaptive Server Enterprise 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 stored procedures in the Adaptive Server database Messaging Service User s Guide describes how to useReal Time Messaging Services to integrate Java Message Service and IBM WebSphere MQ messaging services with all Adaptive Server database applications Monitor User s Guide Historical Server describes how to use Historical Server to obtain performance
74. e Adaptive Server to use network appliance filers NFS mounted devices have been tested on Solaris HP UX IBM AIX and Linux For All Platforms Configuration Guide You may need to repartition the disk you choose Contact your operating system administrator for assistance Adaptive Server devices and system databases When preparing a raw partition device follow these guidelines Do not initialize a database device on the partition that contains your Sybase installation software Doing so destroys all existing files on that partition A raw partition designated for use by Sybase cannot be mounted for use by the operating system for any other purpose such as for file systems or swap space After a Sybase configuration utility or the disk init command has initialized a portion of a partition as a database device the entire partition cannot be used for any other purpose Any space left on the partition 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 device on the same machine To avoid any possibility of using a partition that contains the partition map do not use cylinder 0 v Choosing a raw partition 1 2 10 Determine which raw partitions are available Determine the sizes of the raw partitions From the list of available raw partitions select a raw partitio
75. e 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 Script Product ins_syn_cl Open Client Client Library ins_syn_esq Embedded SQL ins_syn_os Open Server ins_syn_sql Transact SQL 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 Configuration Guide 121 Installing online help for Transact SQL syntax You can install any of these scripts depending on the need for Sybase information on your server The first script you execute creates the sybsyntax database and the needed tables and indexes Any scripts that you execute after the first one add to the existing information in the database If you execute a script that was executed previously the previously installed rows of information are deleted from the table in the database and then reinstalled Warning The ins_syn_cl and ins_syn_os scripts conflict If you execute both scripts errors occur Default
76. e IPv6 connection handler requires adding an additional DCL entry A single Adaptive Server configuration can typically carry up to 32 connection handler assignments within the DCL For example if you have a Site local setup with two domains administrated under the nameserver setup sybase com being responsible for all IPv4 networking applications v6 sybase com being responsible for all IPv6 networking applications The DCL entry for Adaptive Server to start named SYBASE on the host revival for 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 sybase com 17100 In the above example when Adaptive Server is started with IPv6 awareness it creates two connection handlers One listens on port 17100 for incoming IPv4 Clients connection requests and the other listens on port 17100 for incoming IPv6 Clients connection requests Troubleshooting This section describes how to correct some common situations that may cause a server to not start Server fails to start If a server fails to start with the following message the port number specified in the interfaces file may be in use 00 00000 00002 2003 09 22 12 37 23 63 kernel network name SERV_CORPNET type ether port 4559 filter NONE 00 00000 00002 2003 09 22 12 37 23 65 kernel ninit bind Address already in use 0
77. e following paths are prepended to the LD_LIBRARY_PATH environment variable SSYBASE SSYBASE ASE 1lib SYBASE S SYBASE OCS lib SYBASE SYBASE FTS lib etc LIBPATH on the IBM RS 6000 platform this variable specifies which directory to search for libraries When using the source files SYBASE csh or SYBASE sh the following paths are prepended to the LIBPATH environment variable SSYBASE SSYBASE ASE 1lib SYBASE SSYBASE_ OCS lib S SYBASE SYBASE FTS lib etc SHLIB_PATH on HP UX platforms this variable specifies which directory to search for libraries Adaptive Server Enterprise CHAPTER 1 Introduction When using the source files SYBASE csh or SYBASE sh the following paths are prepended to the LIBPATH environment variable SYBASE SYBASE_ASE lib SYBASE SYBASE_OCS lib SYBASE SYBASE_FTS lib etc Adaptive Server devices and system databases Devices are files or portions of a disk that are used to store databases and database objects You can initialize devices using raw disk partitions or operating system files Adaptive Server requires the following devices e master to store system databases e sybsystemdb to store information about distributed transaction e sysprocsdev to store system procedures The master sybsystemdb and sysprocsdev devices are created when you create a new Adaptive Server The master device Configuration Guide The master device contains the followin
78. e line ldap libsydblad so ldap host port ditbase scope bindname username password libtcl6 4 cfg ldap libsydbldap64 so ldap host port ditbase scope bindname username password For example DIRECTORY ldap libsydbldap so ldap huey 11389 dc sybase dc com one bindname cn Manager dc sybase dc com secret one indicates the scope of a search that retrieves entries one level below the DIT base Table 6 3 defines the keywords for the dapurl variables Table 6 3 Idapurl variables Keyword Description Default host required The host name or IP address of the machine running None the LDAP server port The port number that the LDAP server is listening on 389 ditbase required The default DIT base None username Distinguished name DN of the user to authenticate NULL anonymous authentication password Configuration Guide Password of the user to be authenticated NULL anonymous authentication 4 Verify that the appropriate environment variable points to the required third party libraries The Netscape LDAP SDK libraries are located in SYBASE SYBASE_OCS ib3p or lib3p64 The Unix load library path environment variable must point to this directory 5 Add your server entry to the LDAP server using dscp or dsedit See Adding a server to the directory services on page 76 75 Adding a server to the directory services Adding a server to the directory s
79. e sort orders Language or script Sort orders File name ID All languages Binary order binary srt 50 Cyrillic Dictionary order case sensitive accent sensitive cyrdict srt 63 Dictionary order case sensitive accent sensitive cyrnocs srt 64 English Dictionary order case sensitive accent sensitive dictiona srt 51 French Dictionary order case insensitive accent sensitive nocase srt 52 German Dictionary order case insensitive accent sensitive nocasepr srt 53 These sort orders work with all with preference Western European character sets Dictionary order case insensitive accent insensitive noaccent srt 54 English Alternate dictionary order case sensitive altdict srt 45 French Alternate dictionary order case sensitive accent altnoacc srt 39 German insensitive These sort orders work only with CP Alternate dictionary order case sensitive with altnocsp srt 46 850 preference Greek Dictionary order case sensitive accent sensitive elldict srt 65 This sort order works only with ISO 8859 7 Hungarian Dictionary order case sensitive accent sensitive hundict srt 69 These sort orders work only with Dictionary order case insensitive accent sensitive hunnoac srt 70 ISO 8859 2 Dictionary order case insensitive accent insensitive hunnocs srt 71 Russian Dictionary order case sensitive accent sensitive rusdict srt 58 This sort order works with all Dictionary order case insensitive accent s
80. ects to that server as shown in Figure 1 1 You can supply the name of the server by using the DSQUERY environment variable On TCP IP networks the port number gives clients a way to identify the Adaptive Server Open Server Backup Server or Monitor Server to which they want to connect It also tells the server where to listen for incoming connection attempts from clients The server uses a single port for these two services referred to as query service and listener service 11 Changing Adaptive Server configuration Figure 1 1 Communicating with a server using interfaces file During installation you use the srvbuild utility to create and configure a new server The srvbuild process adds entries to the interfaces file for your new Adaptive Server Backup Server Monitor Server and XP Server For instructions on how to modify existing interfaces file entries using dsedit and dscp or to create new interfaces file entries for existing servers Chapter 6 Using the Lightweight Directory Access Protocol as a Directory Service Changing Adaptive Server configuration 12 Use sp_configure to change the configuration of Adaptive Server To change the configuration of several servers enter the sp_configure information in a script For details on using sp_configure see the System Administration Guide and the Reference Manual For information about configuring languages character sets and sort orders see Chapter 7 Cus
81. ed in Table 4 1 You may need to configure these settings to suit your computer and database needs Table 4 1 Defaults for Adaptive Server parameter settings Item Default value Name Servername Transport Type TCP IP Port number 5000 Error log path SYBASE SYBASE_ASE install servername log Event logging Not configured International support Localization Configuration Guide Language us_english 47 Default settings 48 Item e Character set Sort order Default value HP Roman8 amp IBM ISO 8859 1 Sun ISO 8859 1 Linux iso_1 Linux Binary ordering Login security mode Standard Table 4 2 lists the default settings for the Backup Server Monitor Server and XP Server For more information about these servers see Introduction on page 1 Table 4 2 Defaults for Backup Monitor and XP Servers Server Backup Server Item Default value Name AdaptiveServername_back Network support TCP IP Socket number 5001 Error log path SYBASE SYBASE_ASE install AdaptiveS ervername_back log Monitor Server Name AdaptiveServername_mon Network support TCP IP Socket number 5002 Error log path SSYBASE SYBASE_ASE install AdaptiveS ervername_back log XP Server Name SYBASE SYBASE_ASE ADAPTIVESER VERNAME_XP Network support TCP IP Socket number 5003 Error log path N A Adaptive Server Enterprise CHAPTER 5 Configuratio
82. edecteny 43 For IBM RS 6000 2 ce ccceeeceeeeeeeeeeeeeeceeeeeeteeeeeeeseesseeeeseees 44 For Sun Solaris and Linux ccccccceeeeeeceeeeeeeeeeeeeeeeeeeeneeeees 44 A sample C shell maintenance script 0 0 0 eeeeeeeeeeeeeeereeeereeeeaes 45 Adaptive Server Default Configuration ccsscseeseseeeeseees 47 Default Settings vic ac ania fies aaae a aaae tne ia eda aaa 47 Setting Up Communications Across the Network 00 49 How Adaptive Server determines which directory service entry to use Adaptive Server Enterprise Contents 50 How a client uses directory services 00 eee eee eeeeeeeeeeteereeeeneetenes 51 Creating a directory services CNtry ccccceccceeeeeeeeeeeteeeeeeneeees 51 Supported directory drivers ccccccccceeseceeeeeeneeeeeeeeeeeeesneeeeeenaees 52 Contents of an interfaces file cccceceeseeeeeeneeeeeeeeeeeeeeneeeeeesaees 52 Heterogeneous and homogeneous environment 000 53 Understanding the format of the interfaces file eeeee 55 Components of an interfaces file entry 0 0 eeeeeeeeeeeeee eee 56 Creating a master interfaces file cceeecceeeeeeeeeeeeeeeeeeeeeeees 58 Using dsedit or dscp to create a master interfaces file 58 Using a text editor to create a master interfaces file 58 Configuring interfaces files for multiple networkS c eee 59 Configuring the server
83. edit this interfaces file 3 Add entries for any Adaptive Servers or Backup Servers that are not listed in this file For details on using these utilities see the Adaptive Server Utility Guide Using a text editor to create a master interfaces file To construct a single master interfaces file from several individual interfaces files 58 Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network 1 Concatenate the individual interfaces files 2 Make a copy of the file 3 Use an ASCII text editor to modify the copy of the concatenated file Note When you manually edit an interfaces file be sure that for each entry each line following the first line begins with a lt tab gt character The following elements must be correct and unique in the resulting file e servername each server entry in the interfaces file must be unique During the srvbuild session you had the choice of entering a server name or accepting the default server name SYBASE for those servers If you accepted the default name find any duplicate SYBASE entries in your merged file and rename them e A combination of the host machine s network name or address and Adaptive Server s port or object number e Ifthe original interfaces file was created when there was only one machine on the network its entries may have the word loghost in place of the machine name address If loghost is present replace it with
84. em This individual has superuser or root privileges e System Administrator the individual in charge of Adaptive Server system administration creating user accounts assigning permissions on databases and creating new databases At installation time the System Administrator s login name is sa The sa login is not a UNIX login The sa login is specific to Adaptive Server and is used to log in to Adaptive Server using the isql command e sybase login the sybase login is 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 preferred but not required Environment variables Configuration Guide It is crucial to the operation of Sybase 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 ogin and cshrc files for C shell or profile file for Bourne shell The installation instructions in this guide explain when to set these variables Note As part of the installation the installer setup these environment variables in SYBASE csh and SYBASE sh files You can source the file to set their environment e DSLISTEN defines the name Adaptive Server uses to listen for client connections if no name is given during the
85. en the installation completes successfully the following messages are displayed Running task install auditing capabilities Auditing capability installed Task succeeded install auditing capabilities Configuration completed successfully Press lt return gt to continue Enabling auditing After auditing is installed no auditing occurs until a System Security Officer enables auditing with sp_configure For more information see the System Administration Guide v Deleting a device entry 1 Select Delete a Device Entry from the Configure Auditing menu 2 Enter the number of the device to delete 3 Press return v Changing a device entry 1 Select Change a Device Entry from the Configure Auditing menu 2 Enter the number of the device to change auditinit displays the Add Change a New Device for Auditing menu with information on the device you selected ADD CHANGE A NEW DEVICE FOR AUDITING 1 sybsecurity physical device name secret1 sybase_ dr install audlog 2 Logical name of the device aud log 120 Adaptive Server Enterprise CHAPTER 10 Adding Optional Functionality to Adaptive Server 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 Th
86. eneseenereeeeeesneeenees 33 Restoring correct PermMiSSiONS ceecceeeeeeeeseeeeeeeeeeeeeeeneeesaeeeees 34 File descriptors and user CONNECTIONS 2 ceeecceeeeeeeeeeeeeteeeees 34 FOR UKs species E E easels daendens he cGlstelacett 34 For AlX aaaeeeaei enean aaea Weeds aenant heat en eas Muelle 34 For LINUKS i eiaa e eieaa aeea nanat aee dished lela 35 For Sun Solari Sen casi e a eana trenne aeaa heist 35 Displaying current soft and hard limits ccceeeeeeeeees 35 Increasing the Soft limit eeeeeeeeeeeeeeeeereeereesrrerrrerrrerrrernenen 35 Increasing the hard limit ee eee eeeeeeeeeeeeeeeeeneeeeneeeeeees 36 Sample programis sienai iea aan aa ea deste cetaceans 37 Enabling asynchronous disk 0 essesseseeseerererrereerrerresrrrerree 38 Adjusting the client connection timeout period c ceeee 41 Zelal SUX E E E E A ETE 41 For IBM RS 6000 2 cceecceeeeceeeceeeeceeeeeeeeceeteneeeeeeessneeesnees 41 FORSUN Solais mae aa a e Ea 42 FOP aN aT y E E EE E E EE A 42 Checking for hardware errorS sssseseeseeereerieerieerierrierrierrrernere 42 Zelal a i E E dcustateceesiebezcasveiaceauveneas 42 For IBM RS 6000 2 ccecccceeceeeeceeeeeeeeeceeeeeeeeeeeeesseeesaeeeseees 43 For S n Solari Ssss ai ii ianei 43 FOr LINUX eeii neek iea ia EE EEEE Ei E iT aE aiei 43 Monitoring the use of operating system resources 000 43 For HP UX rinni cdeeeetacaere he teeve eeee
87. ensitive rusnocs srt 59 Cyrillic character sets except for CP 855 100 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Language or script Sort orders File name ID Scandinavian Dictionary order case sensitive accent sensitive scandict srt 47 These sort orders work only with CP Dictionary order case insensitive with preference scannocp srt 48 850 Spanish Dictionary order case sensitive accent sensitive espdict srt 55 Dictionary order case insensitive accent sensitive espnocs srt 56 Dictionary order case insensitive accent insensitive espnoac srt 57 Thai Dictionary order dictionary srt 51 Turkish Dictionary order case sensitive accent sensitive turdict srt 72 These sort orders work only with Dictionary order case insensitive accent insensitive turnoac srt 73 ISO 8859 9 Dictionary order case insensitive accent sensitive turnocs srt 74 Character sets Table 7 18 lists the supported character sets and their Sybase name Table 7 18 Sybase character set names Character sets Sybase name ASCII 8 acsii_8 Big 5 big5 Big 5HK big5hk CP 437 cp437 CP 850 cp850 CP 852 cp852 CP 855 cp855 CP 857 cp857 CP 858 cp858 CP 860 cp860 CP 864 cp864 CP 866 cp866 CP 869 cp869 CP 874 cp874 CP 932 cp932 CP 936 cp936 CP 950 cp950 CP 1250 cp1250 CP 1251 cp1251 CP 1252 cp1252 Config
88. ent Console Describes the Unified Agent which provides runtime services to manage monitor and control distributed Sybase resources Utility Guide documents the Adaptive Server utility programs such as isql and bcp which are executed at the operating system level Web Services User s Guide explains how to configure use and troubleshoot Web Services for Adaptive Server XA Interface Integration Guide for CICS Encina and TUXEDO provides instructions for using the Sybase DTM XA interface with X Open XA transaction managers XML Services in Adaptive Server Enterprise describes the Sybase native XML processor and the Sybase Java based XML support introduces XML in the database and documents the query and mapping functions that comprise XML Services 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
89. er 3 48 1 1 The Backup Server will go down immediately Terminating sessions Configuration Guide 25 Stopping servers This is normal behavior If a message indicates that Adaptive Server or Backup Server is waiting for processes to complete and you must stop Adaptive Server or Backup Server immediately use shutdown with nowait which neither waits for currently executing statements to finish nor performs checkpoints in every database Using shutdown with nowait for Backup Server can cause inconsistent or incomplete dumps and loads Use this command only when necessary For more information on the shutdown command see the Reference Manual Stopping Monitor Server To release resources you must shut down Monitor Server before you restart Adaptive Server If Adaptive Server stops make sure that Monitor Server is shut down before you restart Adaptive Server Otherwise Adaptive Server may not be able to allocate enough resources to restart 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 attempting to restart Adaptive Server after a shutdown either wait for the automatic shutdown of Monitor Server to occur or explicitly stop Monitor Server For more information on stopping Monitor Server see the Monitor Server User s Guide Using the kill command 26 Warning Use the k
90. ervices 76 Warning Most LDAP servers have an Idapadd utility for adding directory entries Sybase recommends you use dsedit instead since it has built in semantic checks that generic tools do not provide Each server entry is made up of a set of attributes When you add or modify a server entry you are prompted for information about server attributes Some attributes are provided by default others require user input When a default value is provided it appears in brackets See Table 6 2 for accepted values You can use srvbuild to add entries but not modify or delete them 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 file on page 73 Use dsedit to add a server to the directory service 1 Source SYBASE csh or SYBASE sh to set the environment variables cd to SYBASE SYBASE_OCS bin Execute dsedit Select LDAP from the list of servers and click OK Click Add New Server Entry nH nn A W N Enter e The server name this is required e The security mechanism optional This is the name of the high availability failover server if you have one 7 Click Add New Network Transport and e Select the transport type from the drop down list e Enter the host name e Enter the port number 8 Click OK two times to edit dsedit To view the server entries e
91. es 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 site However the server can support only one sort order at a time so select a sort order that will work for all of your clients Warning Make all changes to the default character set and sort order for a new Adaptive Server before creating any user databases or making any changes to the Sybase supplied databases Changing the character set and sort order after data or data structures have been added to Adaptive Server may cause incorrect behavior To change the character set or sort order after you have added data see the System Administration Guide Available sort orders 90 The sort order determines the collating sequence Adaptive Server uses to order compare and index character data Each character set comes with one or more sort orders Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Sort order name Binary order Sort orders are located in sort order definition files srt files that accompany your character set definition files Note Available sort orders vary according to the character set installed on Adaptive Server You can see the available sort orders for your character set by looking in the srt file for your language Sort orders are stored in SYBASE charsets lt charset_name gt
92. faces file and provides specific configuration information for each supported UNIX platform For information about LDAP drivers Cell Directory Services and for a comparison between interfaces files and LDAP directory services see the Open Client Server Configuration Guide for your platform Contents of an interfaces file 52 An interfaces file contains network information about all servers on your network including Adaptive Server Backup Server and XP Server plus any other server applications such as Monitor Server Replication 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 on the network protocol on which the server listens for queries See Understanding the format of the interfaces file on page 55 for the specific makeup of the interfaces file entry Each entry in an interfaces file can contain two types of lines e Master lines which are used by server applications to listen for queries over the network This information is called a listener service e Query lines which are used by client applications to connect to servers over the network This information is called a query service The network information contained in the master and query lines for a server is identical because a server listens for connection requests on the same port that clients use to request
93. for multiple network handlers 59 Configuring the client CONNECTIONS ccceeeeteeeeeeeteeeteees 60 Configuring for query port backup ee eee eeeeeeeeeeeeeeeeeeeeeee 62 IPv6 SUpport ec eect sthieepeepleden stot cgat ees Hh aie eth sget ress 63 Understanding IPV6 ec eeeeeeeeeeseeeeeneeeeneeeeaeeseseeseeeeeeeaeenaes 63 IPV6 infrastructure cececcceeeeeceeeeeeeeeeeeeeeeeeeeeaeeeeeeneeeeeteneeeees 64 Starting Adaptive Server Enterprise as IPv6 aware 65 Troubleshoot Ne i e eeeeeeeeeeceeeceeneeeseeeesaeessanecsanersneeeeneteneeeetaners 66 Server fails to start ccceccscceeeseeceeeeeeeeeeeeeeeeeeeseeeeeeeeseeeeeeees 66 Error when executing an ESP ssssssseeeieereerierrierrierrrerreee 67 CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Se VICE aeieea reae anpe aooaa aeien p aaa pa cctcaerbacetteqncdouessessouceseste 69 OVEIVICW oreraa aae Ea a Aa A a a a a a aia 69 LDAP directory services versus the Sybase interfaces file 70 The libtel cfg file ncis dees gen neta etl eeh wee eetc dee ieee 73 Enabling LDAP directory services e ee eeeeeeeeeereeeeeneeeeneeeeeneeees 74 Adding a server to the directory services s 76 Multiple directory Services 0 00 eee eeeeeeeeeeeeeeeeeeeeteaeeeeeeeeneeeeeneeees 77 Encrypting the password 0 00 eeeeeeeeeeseeeeneeeeeeeeseeseeeeeeeeeeeeaeeseaes 78 Performancea ves dedevde a aiaa aT a E ia aaia
94. for starting network operations Slow start up of network operations may prevent servers from starting even if commands are in the correct order in the rc directory You may want to designate a period of time for your server to wait before starting by inserting a sleep 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 with contents like the following SSYBASE SSYBASE ASE install startserver SSYBASE SSYBASE ASE install RUN_servername where SYBASE SYBASE_ASE install startserver is the full path name of the startserver utility and S SYBASE SYBASE_ASE install RUN_servername is the full path name of the RUN_server_name file for the server Copy the script to the etc init d directory using syntax like the following cp script_name etc init d script_name Review the contents of the etc inittab file to determine the default run level for your operating system The initdefault entry specifies the default run level which is usually 2 or 3 for Sun Solaris and 5 for Linux Use the In command to create a hard link from the RUN_server_name file to the appropriate run control rc directory rc where is the default run level obtained in step 2 Use syntax like the following for Sun Solaris Adaptive Server Enterprise CHAPTER 2 Starting and Stopping Servers In etc init d scri
95. g databases e master controls the operation of Adaptive Server as a whole and stores information about all users user databases devices objects and system table entries The master database is contained entirely on the master device and cannot be expanded onto any other device e model provides a template for new user databases The model database contains required system tables which are copied into a new user database with the create database command e tempdb the work area for temporary databases in Adaptive Server Adaptive Server supports multiple tempdbs See create temporary database in the T SQL User s Guide Each time Adaptive Server is started the tempdb database is cleared and rebuilt from the model database Adaptive Server devices and system databases e The sample databases pubs2 and pubs 3 are stored on the master device at installation but should be moved to a user defined device after installation Note For recovery purposes Sybase recommends that you do not create other system or user databases or user objects on the master device The sybsystemdb device For new installations the master device also contains the sybsystemdb database The sybsystemdb device stores the sybsystemdb database which stores information about transactions in progress and which is also used during recovery The sybsystemdb database is required to support distributed transaction management DTM fea
96. gn indicates that the syntax is written 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 to choose one or more of the enclosed options is optional Do not type the brackets cash check credit The comma means you may choose as many of the options shown as you want Separate your choices with commas as part of the command cash check credit The pipe or vertical bar means you may select only one of the options shown cash check credit An ellipsis means that you can repeat the last unit as many times as you like buy thing price cash check credit thing price cash check credit You must buy at least one thing and give its price You may choose a method of payment one of the items enclosed in square brackets You may also choose to buy additional things as many of them as you like For each thing you buy give its name its price and optionally a method of payment e Syntax statements displaying the syntax and all options for a command appear as follows sp_dropdevice device_name For a command with more options select column_name from table_name where search_conditions In syntax statements keywords commands are in normal font and identifiers are in lowercase Italic font show
97. he sa password on the command line If not specified the user is prompted for the sa password S Specifies the name of the server If not specified charset uses the DSQUERY environment variable to identify the server name If there is no DSQUERY environment variable charset attempts to connect to a server named SYBASE Specifies the interfaces file to use If not specified charset uses the interfaces file in the SYBASE directory v Causes the Sybase version string to be printed then exits Use with no other options specified sort_order When charset is used to load the default character set and sort order sort_order is a mandatory parameter specifying the name of the sort order file to be used by Adaptive Server When loading additional character sets use charset loc to indicate the name of the character set files charset Specifies the directory of the character set to be used by Adaptive Server Configuration Guide 103 Changing the localization configuration 104 Adaptive Server Enterprise CHAPTER 8 Logging Error Messages and Events This chapter describes how to use the error logging features of Adaptive Server Topic Page Adaptive Server error logging 105 Setting error log paths 106 Managing messages 107 Adaptive Server error logging Configuration Guide Each time Adaptive Server starts it writes information to a local error log file called the Adaptive Server e
98. he Adaptive Server and Backup Server configurations uses the English locale settings localization which include Character set definition files for Western European character sets Sort order definition files for Western European character sets us_english system message files 97 Changing the localization configuration During the installation process and through reconfiguration you can specify a different language character set and sort order Adaptive Server localization Each language uses about 2MB of database space per module If necessary use the alter database command to increase the size of the master database before adding another language 98 Note If you want to install more than one language on Adaptive Server and the master database is not large enough to manage more than one language the transaction log may become too full You can expand the master database only on the master device For more information see the System Administration Guide Nn nr A Q Source SYBASE csh or SYBASE sh if you have not set up the Sybase environment variables To configure localization for Adaptive Server on the server start sqlloc SSYBASE SSYBASE ASE bin sqlloc Select Localize an Existing Server From the Adaptive Server selection window select the server Supply the user name and password The user must have sa privileges Next supply e the default language e the default character set e default sort
99. he secondary port occurs only if the corporate network is disabled or if the corporate network interface on the host machine fails or is shut down due to a network related failure Adaptive Server supports IPv6 technology IPv6 addressing terminology Link local address an IPv6 address that is usable only over a single link Site local address an IPv6 address that can be used within a single site Global address an IPv6 address that can be used across the global Internet IPv6 application types IPv6 unaware an application that cannot handle IPv6 addresses IPv6 aware an application that can communicate with nodes that do not have IPv4 addresses In some cases this might be transparent to the application for instance when the API hides the content and format of the actual addresses 63 IPv6 support e Pv6 enabled an application that in addition to being IPv6 aware takes advantage of some IPv6 features e Pv6 required an application that requires some IPv6 features and cannot operate over IPv4 IPv6 Infrastructure IPv6 infrastructure 64 Dual Stack infrastructure implements both IPv4 and IPv6 This is the recommended infrastructure implementation for using Adaptive Server Enterprise as an IPv6 aware server Sybase applications are IPv6 aware All code to turn Sybase Adaptive Server and the Open Client Server components IPv6 aware was done using the IETF designed primitives se
100. hed name Must be unique name that identifies the object string sybaseVersion Integer Server version number sybaseServername Character Server name string sybaseService Character Service type Sybase Adaptive Server or Sybase SQL Server string sybaseStatus Integer Status 1 Active 2 Stopped 3 Failed 4 Unknown Configuration Guide 71 LDAP directory services versus the Sybase interfaces file Attribute name sybaseAddress Value type Description String Each server address includes e Protocol TCP NAMEPIPE SPX DECNET entry is case sensitive e Address any valid address for the protocol type Note dscp splits this attribute into Transport type and Transport address sybaseSecurity optional String Security OID object ID sybaseRetryCount Integer This attribute is mapped to CS_RETRY_COUNT which specifies the number of times that ct_connect retries the sequence of network addresses associated with a server name sybaseRetryDelay Integer This attribute is mapped to CS_LOOP_DELAY which specifies the delay in seconds that ct_connect waits before retrying the entire sequence of addresses sybaseHAservername String A secondary server for failover protection optional The traditional interfaces file with TCP connection and a failover machine looks like master tcp ether huey 5000 query tcp ether huey 5000 hafailover secondary An example of an LDAP entry with TCP and a fai
101. how CPU time is spent e The vmstat command monitors virtual memory usage e The netstat command monitors network status e netstart v displays Transmit Receive Statistics It is also used to determine if enough buffers have been configured for network traffic e no a command displays current network options It is also used for tuning mbuf pools e The ps command provides a snapshot of accumulated CPU time and usage for individual processes e The time command determines the various user system and real time resources during a complete run For details about these tools see your operating system documentation For Sun Solaris and Linux 44 Sun Solaris and Linux supplies the following tools to help monitor performance e The iostat command reports the amount of I O on terminals and hard disks and how CPU time is spent e The vmstat command monitors virtual memory usage e The netstat command monitors network status Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System e The ps command gives you an accurate snapshot of accumulated CPU time and usage for individual processes This can be very helpful in determining the dataserver engine and process specific loading e The time command can be useful in determining the various user system and real time resources used over a complete run For details about these tools see your operating system documentation A sample C shell maintenance
102. ial Destinations Fusion Powered STP Gateway Manager GeoPoint GlobalFIX iAnywhere iAnywhere Solutions ImpactNow Industry Warehouse Studio InfoMaker Information Anywhere Information Everywhere InformationConnect InstaHelp Intelligent Self Care InternetBuilder iremote irLite iScript Jaguar CTS jConnect for JDBC KnowledgeBase Legion Logical Memory Manager M2M Anywhere Mach Desktop Mail Anywhere Studio Mainframe Connect Maintenance Express Manage Anywhere Studio MAP M Business Anywhere M Business Channel M Business Network M Business Suite MDI Access Server MDI 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 Learning Next Generation Learning Studio O DEVICE OASIS OASiS logo ObjectConnect ObjectCycle OmniConnect OmniQ OmniSQL Access Module OmniSQL Toolkit OneBridge Open Biz Open Business Interchange Open Client Open ClientConnect Open Client Server Open Client Server Interfaces Open Gateway Open Server Open ServerConnect Open Solutions Optima Partnerships that Work PB Gen PC APT Execute PC DB Net PC Net Library Pharma Anywhere PhysicalArchitect Pocket PowerBuilder PocketBuilder Power Power Through Knowledge power stop PowerAMC PowerBuilder PowerBuilder Foundation Class Library PowerDesigner PowerDimensions PowerDynamo Powering the New
103. ient connection timeout period For HP UX For IBM RS 6000 Configuration Guide Adaptive Server uses the KEEPALIVE option of the TCP IP protocol to detect clients that are no longer active When a connection to a client is inactive for a period of time the timeout period the operating system sends KEEPALIVE packets at regular intervals If it does not receive a response from the client machine for any of these packets the operating system notifies Adaptive Server that the client is no longer responding Adaptive Server then terminates the client s connection The KEEPALIVE default timeout period is 2 hours 7 200 000 ms To display the current time value use the command for your platform as shown in the following sections To display the current timeout period enter usr contrib bin nettune 1 Note The switch is a lowercase L not the number one 1 The tcp_keepstart parameter specifies the length of time measured in seconds to keep an idle connection active before the system checks to see if the connection died To change the timeout period use the nettune s command To display the current timeout value enter usr sbin no o tcp_keepidle The tcp_keepidle parameter specifies the length of time measured in half seconds to keep an idle connection active before the system checks to see if the connection died The default is 14 400 half seconds 7200 seconds or 2 hours IBM recommends a value of at
104. iguring reference Open Client and Open Server Programmer s Supplement not listed information and instructions for for your PC client platform or the appropriate Open advanced tasks Client documentation How Adaptive Server determines which directory service entry to use Adaptive Server uses directory services to determine the address at which it should listen for clients When you start Adaptive Server it performs the 50 following steps 1 It looks for the server name supplied in the command line s option If the server name is not supplied in the command line 2 It determines 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 Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network 3 Looks in directory services for an entry whose name matches the name found in the steps above 4 It uses the network information provided by the directory services entry it has found to listen for client connections How a client uses directory services When a client connects to a server it e Determines the name of the server either programmatically or by referring to the DSQUERY environment variable If the application user has not set DSQUERY the runtime value for the server name defaults to the SYBASE environment variable e Looks in directory services for an entry whose
105. ill command to stop Adaptive Server and Backup Server only as a last resort When possible use the Transact SQL shutdown or shutdown with nowait command Do not use kill with the 9 flag because it exits the server without running a checkpoint to ensure that all database changes are written to the database device Adaptive Server may also exit without removing associated shared memory files and network handlers Because Adaptive Server and Backup Server are background processes they can be killed from the operating system by their owner or by root with the UNIX kill command The syntax is Adaptive Server Enterprise CHAPTER 2 Starting and Stopping Servers showserver UID jorge jorge jorge jorge PID PPID 3320 1 3321 3320 3322 3320 3323 3320 80 80 80 80 kill pid where pid is the process identification of any dataserver or backupserver process as determined by the showserver command Killing one engine for a particular Adaptive Server kills all engines for that server If more than one Adaptive Server is running on the same system be careful that the engine you kill is associated with the correct Adaptive Server If your Adaptive Server is configured to use multiple engines CPUs each engine has an associated operating system process The correct way to kill a multi engine server is to specify the process ID for engine 0 This showserver output shows the processes for a four engine server ST
106. l supplements the System Administration Guide and the Performance and Tuning Guide Note Before configuring Adaptive Server according to the instructions in this book you should have a newly installed or upgraded Adaptive Server on your system If you do not follow the installation and upgrade instructions in the installation documentation for your platform This manual is for System Administrators or other qualified installers who are familiar with their system s environment networks disk resources and media devices This manual contains the following chapters e Chapter 1 Introduction is an overview of Adaptive Server and the configuration changes you might want to make to Adaptive Server after installing or upgrading the server Vii Related documents viii Chapter 2 Starting and Stopping Servers describes how to start and stop Adaptive Server Backup Server Monitor Server and XP Server Chapter 3 Configuring the Operating System describes how to set up your operating system to work with Adaptive Server Chapter 4 Adaptive Server Default Configuration provides information about the default parameter settings of Adaptive Server Chapter 5 Setting Up Communications Across the Network describes how to use the interfaces file to establish network connections for servers and clients Chapter 6 Using the Lightweight Directory Access Protocol as a Directory Service provide
107. l Server obtains performance data from Monitor Server and saves the data in files for use at a later time XP Server stores the extended stored procedures ESPs that allow Adaptive 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 basic functionality of Adaptive Server but there are differences among platform implementations These differences may include Adaptive Server configuration Changes to the operating system that enable or enhance Adaptive Server performance The structure of entries in the interfaces file Options for selecting database devices Operating system commands or utilities that simplify or automate routine system administration tasks Operating system utilities for monitoring Adaptive Server performance System specific issues are described in this document For more information about system specific issues see the Installation Guide and release bulletin for your platform Adaptive Server Enterprise CHAPTER 1 Introduction System user roles The Adaptive Server installation and setup process defines various user roles Different user roles have different responsibilities and privileges These user roles clarify the way Adaptive Server is to be integrated into your system e Operating system administrator the individual who maintains the operating syst
108. libtcl cfg file are in human readable format Sybase provides a pwdcrypt utility for basic password encryption pwdcrypt is a simple algorithm that when applied to keyboard input generates an encrypted value that can be substituted for the password pwdcrypt is located in SYBASE SYBASE_OCS bin From the SYBASE SYBASE_OCS directory enter bin pwdcrypt Enter your password twice when prompted pwdcrypt generates an encrypted password For example 0x01312a775ab9d5c71 99 05 7712d2cded2i8d0aelce78868d0e8669313d1bc4c706 Copy and paste the encrypted password into the libtcl cfg file using any standard ASCII text editor Before encryption the file entry appears as ldap libsybdldap so ldap 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 Manager dc sybase dc com 0x01312a775ab9d5c71 99 05 7712d2cded2i8d0aelce78868d0e8669313d1bc4c706 Warning Even if your password is encrypted you should still protect it using file system security Performance Performance when using an LDAP server may be slower than when using an interfaces file because the LDAP server requires time to make a network connection and retrieve data Since this connection is made when Adaptive Server is started changes in performance will be seen at login time if at all During normal system load
109. llic character sets Character set Unilib required Description cp855 IBM PC Cyrillic cp866 PC Russian cp1251 Microsoft Windows 3 1 Cyrillic iso88595 ISO 8859 5 Latin Cyrillic koi8 KOI 8 Cyrillic Table 7 6 lists the Eastern European character set Table 7 6 Eastern European character sets Character set Unilib required Description cp852 PC Eastern Europe cp1250 Microsoft Windows 3 1 Eastern European iso88592 ISO 8859 2 Latin 2 Table 7 7 lists the Greek character set 86 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Table 7 7 Greek character sets Character set Unilib required Description cp869 IBM PC Greek cp1253 MS Windows Greek greek8 HP GREEK8 iso88597 ISO 8859 7 Latin Greek Table 7 8 lists the Hebrew character set Table 7 8 Hebrew character sets Character set Unilib required Description cp1255 X Microsoft Windows Hebrew iso88598 X ISO 8859 8 Hebrew Table 7 9 lists the Japanese character set Table 7 9 Japanese character sets Character set Unilib required Description cp932 X IBM J DBCS CP897 CP301 Shift JIS eucjis EUC JIS encoding sjis Shift JIS no extensions Table 7 10 lists the Korean character set Table 7 10 Korean character sets Character set Unilib required Description eucksc X EUC KSC Korean encoding CP949 Table 7 11 lists the Thai character set Table 7 11
110. llowing platforms HP UX IBM AIX Sun Solaris Linux 32 bit Note The instructions in this book assume that Adaptive Server is installed and running For information about installing and starting Adaptive Server as well as for an overview of Adaptive Server see the Adaptive Server 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 Topic Page About Adaptive Server gt o System specific issues 2 System user roles 3 Environment variables 3 Adaptive Server devices and system databases 5 Client server communication 11 Changing Adaptive Server configuration 12 Languages other than U S English 13 Adaptive Server specifications 13 About Adaptive Server Adaptive Server performs data management and transaction functions independent of client applications and user interface functions Configuration Guide System specific issues Adaptive Server also Manages multiple databases and multiple users Keeps track of the data s location on disks Maintains the mapping of logical data description to physical data storage Maintains data and procedure caches in memory Adaptive Server uses these auxiliary programs to perform dedicated tasks Backup Server manages database load dump backup and restoration activities Monitor Server keeps track of performance data Historica
111. log e auditinit displays the size in both Size of the Device and in Device Size for Auditing in the Add Change a New Device for Auditing menu e The Device Size for Auditing default value is equal to the size of the device based on the assumption that you may want to devote the entire device to log for the auditing task If you want to use only a subset of the device you can edit the Size of the Device value 6 Press Ctrl A to accept the settings displayed in the Add Change a New Device for Auditing menu auditinit returns to the Configure Auditing menu and displays all the devices you have created CONFIGURE AUDITING 1 Configure auditing yes Add a device for audit table s Add a device for the audit database transaction log Delete a device entry Change a device entry Oo WN List of devices for the audit tables Configuration Guide 119 Adding auditing Logical name Physical name Segment name Table name Size 6 Audit _01 secretl sybase_ dr install audl dat sysaudits_ 01 5 Audit _02 secretl sybase_ dr install aud2 dat sysaudits 02 8 auditlog secret1 auditlog dat logsegment syslogs 2 uo 7 When you are ready to execute the audit configuration press Ctrl A auditinit returns you to the Sybase Server Configuration screen 8 Press Ctrl A again auditinit prompts with Execute the Sybase Server Configuration now 9 Enter y yes auditinit executes the tasks to install auditing Wh
112. lover machine looks like dn sybaseServername foobar dc sybase dc com objectClass sybaseServer sybaseVersion 1500 sybaseServername foobar sybaseService ASE sybaseStatus 4 sybaseAddress TCP 1 foobar 5000 sybaseRetryCount 12 sybaseRetryDelay 30 sybaseHAServernam secondary All entries in the LDAP directory service are called entities Each entity has a distinguished name DN and is stored in a hierarchical tree structure based on its DN 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 72 Adaptive Server Enterprise CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service In the example above the entry describes an Adaptive Server named foobar listening on a TCP connection with a port number of 5000 This entity also specifies a retry count of 12 times and a retry delay of 30 seconds Once a client has found an address where a server responds the login dialog between the client and the server begins You can find a complete list of Sybase s LDAP directory schema in UNIX SYBASE SYBASE_OCS config In the same directory there is also a file called sybase schema conf which contains the same schema but uses a Netscape specific syntax Since LDAP supports multiple entries for each attribute each address attribute must contain the address of a single server including pr
113. mber of open file desriptors to MAX CONNECTIONS if setrlimit RLIMIT_NOFILE amp rlp 1 perror setrlimit exit 1 reset the user id to disable superuser privileges uid getuid Configuration Guide 37 Enabling asynchronous disk I O setuid uid run the program indicated as arguments to this program execv argv argv For additional information on user connections see the System Administration Guide Enabling asynchronous disk I O For HP UX 38 This step is mandatory for HP users To improve I O performance on character or raw and block devices enable asynchronous I O by installing the HP asynchronous I O driver from SAM For help with installing this driver contact your operating 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 menu choose Drivers and set the Pending State for asyncdisk to In by adding the driver An alternate step could be done by adding the asyncdsk subsystem keyword to stand system 2 Rebuild the kernel and reboot the system 3 Execute the following commands using the userid root etc mknod dev asyne c 101 4 chmod 0660 dev async chown lt uid gt dev async etc setprivgrp lt ugrp gt MLOCK Where lt uid gt is the identification user ID used by the user that
114. must be the owner of the dev async directory To verify that the async I O is active on the Itanium machine 1 2 Log in as root Issue the command kcmodule a grep aync Result asyncdsk static required or you can also use the following 39 Enabling asynchronous disk I O For IBM AIX 40 ls dev asyn idev async dev asyncdsk Enable asynchronous disk I O This step is mandatory for IBM users Enable asynchronous I O by adjusting the kernel parameters using the System Management Interface Tool SMIT 1 Enter smit at the UNIX prompt 2 From the Devices menu select Asynchronous I O 3 Select Change Show Characteristics of Asynchronous I O 4 Enter the values from Table 3 2 Table 3 2 SMIT parameters for asynchronous I O Values for RS 6000 AIX SMIT parameter 4 3 3 MINIMUM number of servers 1 MAXIMUM number of servers 10 MAXIMUM number of REQUESTS I O 4096 Server PRIORITY 39 ASYNC I O STATE Available to be configured at system restart If your system uses more than seven disks at the same time for Asynchronous I O increase the MAXIMUM number of servers value by 1 for every active device Note Setting the minor device number on dev async to 4 reduces or eliminates transient 605 errors in Adaptive Server If you are using LVM mirroring set the minor device number to 0x0 Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System Adjusting the cl
115. n Guide Setting Up Communications Across the Network Adaptive Server can communicate with other Adaptive Servers Open Server applications and client software across a network Clients can communicate with one or more servers and servers can communicate with other servers via remote procedure calls Topic Page How Adaptive Server determines which directory service entry to 50 use How a client uses directory services 51 Creating a directory services entry 51 Supported directory drivers 52 Contents of an interfaces file 52 Heterogeneous and homogeneous environments 53 Understanding the format of the interfaces file 55 Creating a master interfaces file 58 Configuring interfaces files for multiple networks 59 IPv6 support 63 Troubleshooting 66 Directory services contains information about the network locations of servers Directory services contain entries for all Adaptive Servers Backup Servers and other server products on the network In the Sybase client server environment a client can connect with Adaptive Server if it knows where the server resides on the network and if the server supports the client 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 every server including Backup Server Monitor Server and XP Server When you are using a
116. n for each device based on the size recommendations in Table 1 1 on page 9 Verify with the operating System Administrator that the partition you have chosen is available Make sure the sybase user has read and write privileges to the raw partition Note For more information on choosing a raw partition see your operating system documentation Adaptive Server Enterprise CHAPTER 1 Introduction Client server communication Configuration Guide Adaptive Server communicates with other Adaptive Servers Open Server applications such as Backup Server and client software on your network Clients can talk to one or more servers and servers can communicate with other servers by remote procedure calls For Sybase products to interact with one another each product needs to know where the others reside on the network Names and addresses of every known server are listed in a directory services file This information can be stored in a directory services file two different ways e In an interfaces file named interfaces on UNIX platforms located in the SYBASE installation directory or e Inan 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 directory services When you are using a client program and you want to connect with a particular server the client program looks up the server name in the directory services and conn
117. n you install a language module the installation program loads the messages character set and sort order files that support the new language in the correct locations When you install Adaptive Server and Backup Server system messages in English are installed by default 82 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Default character sets for servers The default character set is the character set in which data is encoded and stored on the Adaptive Server databases Changing the default language and character set Configuration Guide Warning Make all changes to the character set and sort order for a new Adaptive Server before creating any user databases or making any changes to the Sybase supplied databases Changing the character set and sort order after data or data structures have been added to Adaptive Server may require additional steps To change the character set or sort order after you have added data see the System Administration Guide After srvbuild configures a new Adaptive 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 srvbuild creates an Adaptive Server with the following defaults e us_english language e iso_l character set on HP UX platforms use Roman8 e Binary sort order Valid language options depend on what
118. nder SYBASE SYBASE_ASE When Adaptive Server is shut down in 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 these files to restart Adaptive Server after a crash or a kill 9 command because Adaptive Server must be able to overwrite the previously created shared memory files If Adaptive Server or Backup Server is killed abnormally it also leaves shared memory segments Use the ipcs and ipcrm commands to identify and remove these shared memory segments that have NATTACH count as 0 See the UNIX man pages for more information about ipcs and ipcrm Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System This chapter discusses the operating system configuration settings that you can adjust after installing or upgrading Adaptive Server Unless stated otherwise the information pertains to all supported UNIX platforms Topic Page Setting environment variables 29 Configuring new servers with srvbuild 30 Using the stty setting 33 Restoring correct permissions 34 File descriptors and user connections 34 Enabling asynchronous disk I O 38 Adjusting the client connection timeout period 41 Checking for hardware errors 42 Monitoring the use of operating system resources 43 A sample C shell maintenance script 45 Setting environment
119. ng the upgrade process 19 Starting servers when the operating system restarts Using the startserver command To start a server from the command line enter SSYBASE SSYBASE ASE install startserver f RUN_server_name file where SYBASE SYBASE_ASE install startserver is the full path name of the startserver utility and RUN_server_name file is the full path name of the RUN_server_name file usually SSYBASE SYBASE_ASE install RUN_server_name If your Adaptive Server is named SYBASE the RUN_server_name file specification is optional You must have read and write permissions on the master device for an Adaptive Server to start it with startserver For more information about startserver see the Adaptive Server Utility Guide Using the 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 servers when the operating system restarts 20 This section describes how to configure your operating system for automatic restart of Adaptive Server and Backup Server On production systems Adaptive Server Backup Server and Monitor Server should restart automatically when the UNIX operating system starts This is accomplished by making an entry for the server in the operating system start up script Monitor Server must be listed after Adaptive Server in the start up script For more
120. nnection attempts Default is 0 service_type Type of service defined by entry Must be one of the following master e query api Application programming interface available to the network The supported value is tli protocol Name of the network protocol Protocol types available are TCP IP represented by the letters tcp network Name of the network not currently used by Adaptive Server srvbuild enters ether as a placeholder host Network name or address of server s host machine For TCP IP use either the host name or Internet address Maximum size of entry is 32 bytes To determine the host name of a machine log in to that machine and enter bin hostname 56 Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network Component machine Value Network name or address of server s host machine You can use either the host name or Internet address Maximum size of entry is 32 bytes To determine the host name of a machine log in to that machine and enter bin hostname device The network device endpoint For TCP networks the device varies according to the vendor supplying the networking software Check the vendor specific documentation for the name of the device Your network may provide multiple stream devices corresponding to different protocols in the TCP protocol suite Choose the TCP streams device Common TCP streams devices is dev tcp
121. nnernees 18 Using a RUN_server_name fil cceeeeceeeeeeeeeeeeeeeees 19 Using the startserver command c c cceeeeceeeeeeeeeeeeeteees 20 Using the monserver and backupserver commands 20 Starting servers when the operating system restarts 20 For HP UX iien eve gis etc evasted eaaa ia EEEE aaia 21 For IBM RS 6000 22 ccescceeeceeeeceeeeeeeeeeeeeeaeeteeeeseeeeeseeeesaes 21 For Sun Solaris and Linux 2 cccceeeceeeeeeeeeeeeeeeeeeeeesneeeeeees 22 Starting XP Server after initial installation ceeseeeeeeeeees 24 Stopping Servers ccccceeecccceeeeeeeeeeeeeeeeeeaeeeeeeeeeeeseaeeeeeseaeeeeeeneeeees 24 iii Contents CHAPTER 3 CHAPTER 4 CHAPTER 5 Stopping Adaptive Serve ccccsceccceeeeeeeeeeeeeeeeeeeeeeeeeeeees 24 Stopping Backup Servel c ccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 25 Stopping Monitor Servel ccceseeceeeeeeeeeeeeeeeeeeeeeeeeeeesenees 26 Using the kill command 0 eee cece eeeee eset eeeeeeeeeeeteneeteeeeeaeees 26 Shutdown and shared memory files eee eeeeeeeeeeeeereeeeees 27 Configuring the Operating System ccssccseseeeeeeeeeseeeeeeeeeees 29 Setting environment Variables ccccccceeeeeeeeeeeeeeeeeesneeeeeeeaees 29 Configuring new servers with SrvbUIIC 2 cceeeceeeeeeeeeeeeeeeees 30 Using the stty Setting ee eeeeeeeseeeseeeeeeeeesenecs
122. not need to change the value displayed in Device Size for Auditing 4 Press Ctrl A to accept the settings auditinit returns to the Configure Auditing menu and displays the device you have created CONFIGURE AUDITING T U BF WN Configure auditing yes Add a device for audit table s Add a device for the audit database transaction log Delete a device entry Change a device entry Configuration Guide 117 Adding auditing 118 List of devices for the audit tables Logical name Physical name Segment name Table name Size 6 Audit_01 secret1 sybase dr install audl dat sysaudits 01 5 5 To add multiple audit devices repeat steps 1 6 You can add as many as eight devices Sybase recommends adding three or more audit table devices After adding a device auditinit returns to the Configure Auditing menu and displays all the devices you have created CONFIGURE AUDITING 1 Configure auditing yes OF WN Add a device for audit table s Add a device for the audit database transaction log Delete a device entry Change a device entry List of devices for the audit tables Logical name name Size 6 Audit_01 7 Audit_02 Physical name Segment name Table secret1 sybase dr install audl dat sysaudits 01 5 secret1 sybase dr install aud2 dat sysaudits 02 5 v Creating a device for the audit database transaction log 1 From the Configure Auditing menu select Add a Device for the Audit Data
123. nter the following URL in Netscape http host port ditbase one Adaptive Server Enterprise CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service For example ldap huey 11389 dc sybase dc com one Note Microsoft Internet Explorer does not recognize LDAP URLs For more information about dscp see the Open Client Server Configuration Guide in the 11 1 x Generic Collection at http www sybase com support manuals Multiple directory services DIRECTORY ldap libsydbladp so ldap libsybdldap so Configuration Guide Any type of LDAP service whether it is an actual server or a gateway to other LDAP services is called an LDAP server 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 ldap test 389 dc sybase dc com ldap huey 11389 dc sybase dc com In this example if the connection to test 389 fails the connection fails over to the DCE driver with the specified DIT base If this also fails a connection to the LDAP server on huey 11389 is attempted Different vendors employ different DIT base formats Note For more information see the Open Client Client Library C Programmer s Guide and the Open Client Client Library C Reference Manual at http Awww sybase com support manuals 77 Encrypting the password Encrypting the password Entries in the
124. nterfaces file is not used Note Open Client Open Server applications that use the I option at start up override the libtcl cfg file and use the interfaces file In its simplest form the libtcl cfg file is in this format DIRECTORY ldap libsybdldap dll ldapurl where the dapurl is defined as ldap host port ditbase The 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 specify a user name and password in the libtcl cfg file as extensions to the LDAP URL to enable password authentication at connection time Enabling LDAP directory services 74 To use a directory service you must 1 Configure the LDAP server according to the vendor supplied documentation 2 Add the location of the LDAP libraries to the Unix load library path environment variable for your platform 3 Configure the ibtcl cfg file to use directory services Use any standard ASCII text editor to e Remove the semicolon comment markers from the beginning of the LDAP URL lines in the libtcl cfg file under the DIRECTORY entry Adaptive Server Enterprise CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service libtcl cfg e Add the LDAP URL under the DIRECTORY entry See Table 6 3 for supported LDAP URL values Warning The LDAP URL must be on a singl
125. number of database devices is 2 147 483 647 However Adaptive Server must retain a description of each device in memory so in practice this number is limited by your system s memory Your operating system also limits how many devices one program can open simultaneously A database can contain up to 2 147 483 648 logical pages so its maximum size depends on its logical page size e The maximum database size on a 2K page server is 4TB e The maximum database size on a 4K page server is 8TB e The maximum database size on an 8K page server is 16TB e The maximum database size on a 16K page server is 32TB The minimum database size is the size of the installation s model database Each database is stored 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 databases so in practice this number is also limited by your operating system memory Note By default srvbuild creates the devices in SYBASE data directory Creating files for database devices You can create new database devices using the disk init command You can specify a raw partition or operating system file When using a raw partition you must specify the full path to the partition When using an operating system file you may use the full path or a relative path Path names are relative to your server s current working directory
126. on sybase com Either select the product family and product under Search by Product or select the platform and product under Search by Platform 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 2 Point your Web browser to Technical Documents at http www sybase com support techdocs Click MySybase and create a MySybase profile Adaptive Server Enterprise About This Book Sybase EBFs and software maintenance Conventions Finding the latest information on EBFs and software maintenance 1 Point your Web browser to the Sybase Support Page at http www sybase com support 2 Select EBFs Maintenance If prompted enter your MySybase user name and password 3 Select a product 4 Specify a time frame and click Go A list of EBF Maintenance releases is displayed Padlock icons indicate that you do not have download authorization for certain EBF Maintenance releases because you are not registered as a Technical Support Contact If you have not registered but have valid information provided by your Sybase representative or through your support contract click Edit Roles to add the Technical Support Contact role to your MySybase profile 5 Click the Info icon to display the
127. or Server and XP Server Topic Page Overview 17 Starting servers 18 Starting servers when the operating system restarts 20 Starting XP Server after initial installation 24 Stopping servers 24 Overview The methods described in this chapter are used to start Adaptive Server Backup Server and Monitor Server after a shutdown for database maintenance because of an operating system crash or for other reasons XP Server is not started by the installation process XP Server is started by Adaptive Server when an XP command is issued through isa You can use Sybase Central to start and stop servers manually or automatically For more information about Sybase Central see Chapter 1 Overview of System Administration in the System Administration Guide Requirements for starting servers To start a server your user account must have e Anyone with access to the database servers execute privileges and database devices read write privileges e Access to Adaptive Server distribution files Configuration Guide 17 Starting servers e The system environment variables discussed in Chapter 1 Introduction e Access to SySAM licenses For more information see the Sybase Software Asset Management User s Guide The installation program creates the interfaces file and system environment variables when you install servers on your computer Starting servers You can start Adaptive Server Backup Server
128. orm_locale is default syb_language is the name of the language directory to be used from within SYBASENocales language_name syb_charset is the character set name that determines the character set conversion method and identifies the directory location of the message files for clients from within SYBASENocales language_name charset_name For example the following entry specifies that the default locale uses us_english for the language and iso_1 for the character set locale default us_english iso_1 How client applications use ocales dat Client applications use the locales dat 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 the locales dat file to see if that setting is appropriate for Adaptive Server For example a locale entry for French can look like the following locale fr_FR french iso 1 When the client connects to Adaptive Server the language and character set information is passed to Adaptive Server in the login record Adaptive Server then uses e The character set information for example iso_1 to identify the client s character set and verify whether it can convert character data to this character set e The language in the preceding example French and character set information to see if it has messages in the client s language Note
129. otocol access type and address See sybaseAddress 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 sybase query Note Each entry in the address field is separated by the character You can edit these entries with dsedit See Adding a server to the directory services on page 76 To ensure cross platform compatibility for all Sybase products the protocol and address attribute fields should be in a platform and product independent format The ibtcl cfg file Configuration Guide You use the libtcl cfg file to specify the LDAP server name port number DIT base user name and password to authenticate the connection to an LDAP server The purpose of the Jibtcl cfg file is to provide configuration information such as driver directory and security services for Open Client Open Server and Open Client Open Server based applications 32 bit utilities such as dsedit and srvbuild look up the libtcl cfg while 64 bit applications use the libtcl64 cfg file for configuration information 73 Enabling LDAP directory services You should edit both the libtcl cfg and the libtcl64 cfg files to ensure compatibility between 32 and 64 bit applications The default libtcl cfg file is located in SYBASE SYBASE_OCS config If LDAP is specified in the libtcl cfg file the i
130. plays the following menu AUDITINIT 115 Adding auditing 116 1 Release directory usr u sybase 2 Configure a Server product Select Configure a Server Product Select Adaptive Server Select Configure an Existing Sybase Server Select the server to configure Provide the SA password for the server you selected o n A a A WwW From the Sybase Server Configuration screen select Configure Auditing As you proceed through the menus in auditinit you can change any default values that appear As you finish each menu press Ctrl A to accept the defaults or changed values and move to the next menu CONFIGURE AUDITING 1 Configure auditing no Add a device for audit table s Add a device for the audit database transaction log Delete a device entry Change a device entry U e WN List of devices for the audit tables Logical name Physical name Segment name Table name Device for the audit datbase transaction log Logical name Physical name Segment name Table name Size Size 9 From the Configure Auditing screen select Configure Auditing auditinit redisplays the Configure Auditing menu with the value yes displayed for Configure Auditing 10 Restart Adaptive Server for the changes to take effect v Creating a device for an audit table 1 From the Configure Auditing screen select Add a Device for Audit Table s auditinit displays the following menu ADD CHANGE A NEW DEVICE FOR AUDITING
131. pt_name etc rc d S script name For Linux Use In s to create symbolic links from the script name to the appropriate run control rc directory rc where is the run level Use syntax like the following In s etc init d script name etc rc d S script_ name Configuration Guide When you type the command to create this link add an uppercase S and a two digit sequence number preceding the name of the script file S indicates a start up file The sequence number is necessary because files in the rc directory are executed in order of their numbers This file should be executed last so you should use a sequence number that follows all existing numbers in ASCII order You can perform an Is command on the rc directory to view existing sequence numbers For example ls etc rc3 d S returns etc rc3 d S1l0syslog etc rce3 d S15nfs server etc re3 d S21rfs If your script is named sybstart type the following ln etc init d sybstart etc rc3 d S77sybstart In this example you can use any number greater than 27 in place of 77 For Linux You can perform an ls command on the rc directory to view existing sequence numbers For example ls fete rc5 d S returns etc rc5 d S12syslog Jetc rce5 d S14nfslock etc rc5 d S27ypbind and so on If your script is named sybstart type the following ln s etc init d sybstart etc rc5 d S99sybstart In this example you can use any number greater than 27 in place of
132. r a total of up to 256 tables across all sides of the union Maximum number of databases Unlimited participating in one transaction 14 Includes database where transaction began all databases changed during transaction and tempdb if it is used for results or worktables Adaptive Server Enterprise CHAPTER 1 Introduction Practical number of databases 16 Includes each occurrence of each participating in one query database queried and tempab if it is used for results or worktables Maximum number of tables with 192 referential integrity constraints for a query Procedure specifications Number of buffers and Configurable Limited by amount of RAM and procedure buffers maximum size of shared memory segment Minimum memory required per 2K stored procedure Maximum number of parameters 2048 per stored procedure Adaptive Server extended limit capabilities vary by type of table and the database logical page size Table 1 2 lists the column and row limits for allpages locked APL tables Table 1 2 Allpages locked APL tables Maximum APL table Number of Column size Columnsize Column size Column size limits columns 2K page 4K page 8K page 16K page Fixed length column 1024 1960 bytes 4008 bytes 8104 bytes 16296 bytes Variable length column 254 1948 bytes 3988 bytes 8068 bytes 16228 bytes Table 1 3 lists the column and row limits for data only locked DOL tables Table 1 3 Data row and d
133. rectory is the full path to the Sybase installation directory specified as the SYBASE environment variable and RUN_servername is the RUN_server_name file for the server you are starting Make sure that the entry for starting Adaptive Server follows any entry for etc rc tcpip and etc rc nfs in the etc inittab file All network resources must be available before you start Adaptive Server otherwise Adaptive Server does not start Also your server does not start if the network is not running Slow start up of network operations can also prevent Adaptive Server from starting even when the commands in the etc rc tcpip file are in the correct order You can designate a period of time for Adaptive Server to wait before starting by inserting a sleep command before the server start up command in the RUN_server_name file The sleep command is in the form 21 Starting servers when the operating system restarts sleep seconds_of_rest Note To enable restart of a Backup Server when the operating system starts add a Backup Server start up command to etc inittab Use the path of the Backup Server RUN_server_name file in this command For Sun Solaris and Linux 22 Before you set Adaptive Server or Backup Server to start automatically make sure that all network resources are available Your server does not start if the network is not running Be sure that the entry for restarting the server follows any commands in the rc directory
134. rface Tool SMIT 40 system messages translated 82 system procedures storage location of 6 T tab characters in interfaces files 55 table specifications 14 TCP IP 41 56 KEEPALIVE option 41 TCP IP network protocol 11 tempdb database 5 Thai character sets 87 time command HP UX 44 IBM RS 6000 44 Sun Solaris 45 TLI protocol 56 translated messages error loc files 95 system 82 Turkish character sets 88 U Unicode character conversion 85 UNIX hardware error messages 42 network protocol 56 UnixWare network protocol 56 us_english language 83 user connections 34 Adaptive Server Enterprise 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 17 xp_cmdshell command 17 Configuration Guide Index 133 Index 134 Adaptive Server Enterprise
135. ription Case insensitive dictionary sort order with case preference for collating purposes A insensitive with preference word written with uppercase letters is equivalent to the same word written with lowercase letters Uppercase and lowercase letters are distinguished only when you use an order by clause The order by clause sorts uppercase letters before it sorts lowercase Note Do not select this sort order unless your installation requires that uppercase letters be sorted before lowercase letters in otherwise equivalent strings for order by clauses Using this sort order may reduce performance in large tables when the columns specified in an order by clause match the key of the table s clustered index Alternate dictionary order case sensitive Case sensitive 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 insensitive and accent insensitive alternate dictionary sort order Use with several of the Western European languages Alternate dictionary order case insensitive uppercase preference Case insensitive alternate dictionary sort order with uppercase preference Use with several of the Western European languages Spanish dictionary order case sensitive Case sensitive Spanish dictionary sort order Use with Spanish and for most Latin
136. rks You can concatenate the original server name and the network name For example if your server is named PRODUCTION you could choose the names PRODUCTION_ network and PRODUCTION_network2 Do one of the following For PC clients use sqledit to create multiple sql ini file entries for the server one for each network In the following example you create one entry for PRODUCTION_network 1 and one for PRODUCTION_network2 For more information see the Open Client documentation for your client platform For UNIX clients you can edit the interfaces files with an ASCII text editor From the server s interfaces files copy the server name line and the master line for each network into the client interfaces file Add the appropriate server name for each entry and change master to 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 entry for PRODUCTION on network1 PRODUCTION networkl lt tab gt 3 lt tab gt 3 lt newline gt lt tab gt query tcp ether serv_corpnet 4559 Client entry for PRODUCTION on network2 PRODUCTION network2 lt tab gt 3 lt tab gt 3 lt newline gt lt tab gt query tcp ether serv_engnet 5479 Configuring for query port backup Another use for multiple network interfaces is to provide a backup in case of network failure If a client is connec
137. rror log SYBASE SYBASE_ASE install server_name log This file e Stores information about the success or failure of each start up attempt e Logs error and informational messages generated by the server during its operations e Remains open until you stop the server process e Contains startup messages from Adaptive Server Note When you want to make more disk space available by reducing the size of the error log stop Adaptive Server before deleting logged messages The log file cannot release its memory space until Adaptive Server has stopped 105 Setting error log paths Enabling and disabling error logging Logging to the Adaptive Server error log is always enabled However when you create or modify a specific user defined message you can set it to be omitted from the log See Logging user defined messages on page 107 Setting error log paths The installation program sets the error log location in the Sybase installation directory when you configure a new Adaptive Server Backup Server and Monitor Server each have their own error logs The default location for each server s error log is e Adaptive Server SYBASE SYBASE_ASE install servername log e Backup Server SYBASE SYBASE_ASE install servername_back log e Monitor Server SYBASE SYBASE 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
138. rs maxfiles and maxfiles_lim control the number of file descriptors available to any one process The limit is 10 000 for HP UX on a 32 bit system and 60 000 on a 64 bit system To obtain the current values on the file descriptors use the Korn or Bourne shell ulimit command ulimit n The number of file descriptors per process is determined by the operating system parameter open_max The default value of open_max is 32767 Adaptive Server can use a maximum of 2000 file descriptors per engine regardless of the value of open_max For more information on setting open_max see the AIX operating system documentation To obtain the current value of the open_max parameter use the Korn or Bourne shell ulimit command ulimit n Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System For Linux The number of file descriptors per process is limited to 10 000 You can set the number of file descriptors using ulimit For Sun Solaris For Sun Solaris you can set both soft and hard limits for file descriptors The soft limit can be increased up to the hard limit by the user but the hard limit can be increased only by someone with root permissions The soft limit determines the number of open file 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 opening files and devices
139. s information about using LDAP directory services to establish connections Chapter 7 Customizing Localization for Adaptive Server provides background information about Sybase s localization support as well as task information for reconfiguring character 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 provides information about the administration of Adaptive Server databases including both routine tasks and performance and tuning considerations Chapter 10 Adding Optional Functionality to Adaptive Server provides instructions for adding optional functionality such as auditing and the sample databases The Sybase Adaptive Server Enterprise documentation set consists of the following The release bulletin for your platform contains last minute information that was too late to be included in the books A more recent version of the release bulletin may be available on the World Wide Web To check for critical product or document information that was added after the release of the product CD use the Sybase Technical Library The Installation Guide for your platform describes installation upgrade and configuration procedures for all Adaptive Server and related Sybase products Adaptive Server Enterprise About This Book Configuration Guid
140. s user supplied words e Examples showing the use of Transact SQL commands are printed like this select from publishers Xiv Adaptive Server Enterprise About This Book e Examples of output from the computer appear as follows pub name city state New Age Books Boston MA Binnet amp Hardley Washington DC Algodata Infosystems Berkeley CA 3 rows affected Terms Accessibility features Configuration Guide In this manual most of the examples are in lowercase However you can disregard case when typing Transact SQL keywords For example SELECT Select and select are the same Adaptive Server s sensitivity to the case of database objects such as table names depends on the sort order installed on Adaptive Server You can change case sensitivity for single byte character sets by reconfiguring the Adaptive Server sort order For more information see the System Administration Guide The following terms appear repeatedly throughout this book For more detailed information about these and other terms see the Glossary e work sybase is given as an example of the Sybase installation directory e Text editor refers to an ASCII text editor or any editor that can save files to text format 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 Adaptive Server
141. sendmsg e Component Integration Services connectivity e Host name resolving e XML URL connection handler e Auditing for client address data The following functional mechanisms in Adaptive Server Enterprise do not support IPv6 These mechanisms in Adaptive Server Enterprise are Pv6 unaware They will gradually over time be become IPv6 aware in follow on releases e Java support e License Management Server e LDAP driver Starting Adaptive Server Enterprise as IPv6 aware Configuration Guide Adaptive Server is IPv6 unaware by default To make Adaptive Server IPv6 aware you must start Adaptive Server with trace flag 7841 This causes Adaptive Server to determine IPv6 availability and makes Adaptive Server IPv6 aware See your Network or IT specialist to configure your platforms and Network Infrastructure correctly for IPv6 support A second trace flag 7815 can be set when you start Adaptive Server which captures and logs address connection requests and host name lookups The IPv6 Adaptive Server traceflags e 17841 Enable Adaptive Server IPv6 awareness e T7815 Report all Adaptive Server IPv4 amp IPv6 Client address connect requests 65 Troubleshooting Before starting Adaptive Server for IPv6 aware operations make sure that your infrastructure is correctly set up Once your operating system is correctly configured an IPv6 connection handler can be configured and enabled Configuring and enabling th
142. sets for the Western European languages ASCII 8 CP 437 CP 850 CP 860 CP 863 CP 1252 ISO 8859 1 ISO 8859 15 and ROMANS Similarly conversion is supported between the character sets for Japanese CP 932 EUC JIS Shift JIS and DEC Kanji However code conversion is not supported between any of the Western European language character sets and the Japanese character sets For more information about supported conversions see the System Administration Guide Conversions between server and client If Adaptive Server does not support the client s language or character set the client can connect with the server but no character conversions occur Configuration Guide 89 Sort orders Sort orders When a localized client application connects to Adaptive Server the server checks to see if it supports the client s language and character set e If Adaptive Server supports the language it automatically performs all character set conversions and displays its messages in the client s language and character set e If Adaptive Server does not support the language it uses the user s default language or Adaptive Server s default language e If Adaptive Server does not support the character set it issues a warning to the client turns conversion off and sets the language to U S English Each character set comes with one or more sort orders collating sequences which are located in the sort order definition files srt fil
143. sis If any of the types of hardware errors described in the beginning of this section appear use the Sun Microsystems diagnostic tool sundiag to check memory and disks See the operating system documentation for more information Check the var log messages file on a regular basis See the operating system documentation for more information Monitoring the use of operating system resources For HP UX Configuration Guide The System Administration Guide discusses maintaining the optimal number of Adaptive Server engines for your workload and system configuration To determine the optimal number monitor system and CPU usage HP UX supplies many tools to help monitor performance some of which are described as follows e The sar command reports relative and absolute I O throughput rates to each disk and controller e The vmstat command monitors virtual memory usage e The netstat command monitors network status 43 Monitoring the use of operating system resources For IBM RS 6000 e The ps command provides a snapshot of accumulated CPU time and usage for individual processes e The time command can be useful in determining the various user system and real time resources used over a complete run For details about these tools see your operating system documentation IBM RS 6000 supplies the following tools for monitoring performance e The iostat command reports the amount of I O on terminals and hard disks and
144. sp_deviceattr and sp_helpdevice in the Reference Manual Warning Data corruption may occur if dsync option is not set immediately after upgrade 8 Adaptive Server Enterprise CHAPTER 1 Introduction Determining the location type and size of a database device Adaptive Server requires several database devices Table 1 1 below shows baseline values for each of the devices See the release bulletin for any last minute changes to these values Table 1 1 Adaptive Server database devices Minimum Minimum Device Purpose size recommended size master Stores system 24MB for 2K pages 30MB databases 45MB for 4K pages 60MB 120MB 89MB for 8K pages 240MB 177MB for 16K pages sysprocsdev Stores the 120MB 120MB plus any also called the sybsystemprocs space for holding sybsystemprocs database stored procedures that device you have created sybsystemdb Transaction 3MB for 2K pages 5 24MB processing 6MB for 4K pages 12MB for 8K pages 24MB for 16K pages sybsecurity optional Required for SMB 7MB more for auditing specialized auditing For Solaris HP UX IBM AIX and Linux For all databases you can use either a raw partition or a file Sybase Adaptive Server supports the database devices on NFS and CIFS mounted devices with Network Appliance Filers for storing data Network appliance filers provide the same performance and data integrity as raw devices There are no changes needed to the operating system or to Sybas
145. ss audit data Audit system devices and databases Configuration Guide The audit system includes several components The main components are e The sybsecurity device and the sybsecurity database which stores audit information 113 Adding auditing The sybsecurity device and database Tables and devices for the audit trail Device for syslogs systems table e The audit trail which consists of several audit devices and tables that you determine at configuration time e The syslogs transaction log device which stores transaction logs The sybsecurity device stores the sybsecurity database The sybsecurity database is created as part of the auditing configuration process It contains all the system tables in the model database as well as a system table for keeping track of server wide auditing options and system tables for the audit trail Adaptive Server stores the audit trail in system tables named sysaudits_01 through sysaudits_08 At any given time only one of the audit tables is current Adaptive Server writes all audit data to the current audit table A System Security Officer can use sp_configure to set or change which audit table is current When you 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 least two or three system tables for the audit trail and to put each
146. ss component in interfaces files TCP protocol entry 57 administrator operating system 3 Configuration Guide Sybase system 3 API component in interfaces file described 56 Arabic character sets 85 asynchronous I O AIO enabling 38 39 40 HP driver 38 39 audit system 113 audit trail overview 113 system audit tables 114 auditing database for 114 device for 114 global options 114 installing using the auditinit utility 114 installing using the installsecurity script 114 process 114 recommended database device size 9 tables for tracking 114 auditinit utility 7 B Backup Server character sets 89 99 configuring 94 97 default configuration 48 starting from UNIX command line 18 starting with operating system 20 Backup Server default for Adaptive Server 48 Backus Naur Form BNF notation xiii xiv binary sort order 91 BNF notation in SQL statements xiii xiv Bourne shell 29 brackets See square brackets buffer specifications 15 125 Index C C shell 29 case sensitivity inSQL xv changing character sets 83 97 languages 97 sort order 97 character devices improving I O performance on 38 39 character sets 89 accented lettersin 13 changing 83 84 97 client selection of 84 code conversions and 89 configuring 99 converting between 89 databases and 90 default 83 in a heterogeneous environment 89 sort orders and 90 U S English 13 charsets directory 91 94 about the 95 Chinese character sets 86 client interfa
147. system table on its own device separate from the master device If you do this you can use a threshold procedure that archives the current audit table automatically before it fills up and switches to a new empty table for subsequent audit records During auditing configuration you must specify a separate device for the syslogs system table which contains the transaction log The syslogs table which exists in every database contains a log of transactions that are executed in the database Overview of audit installation 114 There are two methods for installing auditing for the first time in Adaptive Server e Use the installsecurity script For information see the System Administration Guide e Use the auditinit utility Tasks that you must perform before installing auditing and instructions on using the auditinit utility follow Adaptive Server Enterprise CHAPTER 10 Adding Optional Functionality to Adaptive Server Pre installation tasks for auditing devices Determine the location of the raw devices for the sybsecurity syslogs and sysaudits table devices You will need to provide this information later Sybase recommends that you Installing auditing Configuration Guide Configure your system with the minimum number of auditing devices you require you must configure at least three devices You can add more auditing devices later with sp_addaudittable For information see the Reference Manual Install audi
148. t make a device on a UNIX raw partition larger if you have already allocated the full defined size of that partition For more information about sp_helpdevice and disk init command see the System Administration Guide and the Reference Manual For more information about device files see the Performance and Tuning Guide 111 Managing database devices 112 Adaptive Server Enterprise CHAPTER Adding auditing 10 Adding Optional Functionality to Adaptive Server This chapter provides instructions for adding optional functionality to Adaptive Server Topic Page Adding auditing 113 Installing online help for Transact SQL syntax 121 After you have installed the Sybase products on your system see the product documentation for configuration and administration issues Auditing is an important part of security in a database management system Security related system activity is recorded in an audit trail which can be used to detect penetration of the system and misuse of 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 specific users enabling the audit system to act as a deterrent to users who are attempting to misuse the system A System Security Officer manages the audit system and is the only user who can start and stop auditing set up auditing options and proce
149. ted to a server via two networks the client can establish a connection via the second network if the first one goes down 62 To configure Adaptive Server for query port backup 1 Install multiple master and query lines in a server entry in the interfaces file Adaptive Server listens for connections at both ports Clients looking for a host name and a port number for a connection to an Adaptive Server try the port on each query line in order until they establish a connection Adaptive Server Enterprise CHAPTER 5_ Setting Up Communications Across the Network The following example shows how to configure a backup network that will be used only if the normal connection fails The primary network is corporate network and backup is engineering network PRODUCTION server with two network listeners PRODUCTION lt tab gt 3 lt tab gt 3 lt newline gt lt tab gt master tcp ether SERV_CORPNET 4559 lt tab gt master tcp ether SERV_ENGNET 5479 lt tab gt query tcp ether SERV_CORPNET 4559 lt tab gt query tcp ether SERV_ENGNET 5479 IPv6 support Understanding IPv6 Configuration Guide 3 Configure PC client interfaces files with the appropriate multiple query entries as described in the Open Client documentation For client interfaces files in a homogeneous environment you can copy the entire interfaces file entry for the Adaptive Server into the client interfaces file A connection on t
150. the standard for securing the transmission of sensitive information 57 Creating a master interfaces file Creating a master interfaces file A master interfaces file contains entries for all Sybase servers on the network It can be used with every server and client connected to the network By distributing copies of a master interfaces file you can ensure that all Sybase products on the network interact with one another Distributing copies of one interfaces file a master file with entries for all Adaptive Servers is the easiest way to maintain consistency in the interfaces files in a homogeneous environment on a network You can make all changes to one version of the file and then copy the updated master file to all appropriate Sybase directories You can make a master file in one of two ways e Using dsedit or dscp e 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 to all servers If you are not an experienced Sybase user you may find that using dsedit or dscp is easier than using a text editor Using dsedit or dscp also ensures that your interfaces file is consistent in format To create a master interfaces file with dsedit or dscp 1 Select the interfaces file that contains the most complete up to date information 2 Begin a dsedit or dscp session in your latest Sybase installation to
151. the character sets needed Often this is Unicode UTF 8 Warning Make all changes to the default character set and sort order for a new Adaptive Server before creating any user databases or making any changes to the Sybase supplied databases Changing the character set and sort order after data or data structures have been added to Adaptive Server can cause incorrect behavior To change the character set or sort order after you have added data see the System Administration Guide Supported character sets 84 The following language scripts and character sets are supported by Adaptive Server e Arabic see Table 7 1 on page 85 e Baltic see Table 7 2 on page 85 e Chinese Simplified see Table 7 3 on page 86 e Chinese Traditional see Table 7 4 on page 86 e Cyrillic see Table 7 5 on page 86 e Eastern European see Table 7 6 on page 86 e Greek see Table 7 7 on page 87 Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server e Hebrew see Table 7 8 on page 87 e Japanese see Table 7 9 on page 87 e Korean see Table 7 10 on page 87 e Thai see Table 7 11 on page 87 e Turkish see Table 7 12 on page 88 e Unicode which supports over 650 languages see Table 7 13 on page 88 e Vietnamese see Table 7 14 on page 88 e Western European see Table 7 15 on page 88 The tables define each character set and indicate information on whether
152. the machine name Configuring interfaces files for multiple networks On some platforms Adaptive Server can accommodate multiple networks This allows Adaptive Server to listen for clients over multiple network interfaces You must add an entry for each network interface to the interfaces file Configuring the server for multiple network handlers To configure multiple network listeners 1 Define a unique host name for each network interface in your operating system s host database Configuration Guide 59 Configuring interfaces files for multiple networks 2 In your interfaces file use a text editor to add copies of the master line for your Adaptive Server one for each additional interface you want the server to listen on 3 Include a unique host name on each line to configure a network handler for each network interface 4 Port numbers within the interface need not be the same but they can be They fall under the same rules for naming and numeric range as the primary network interface Sample interfaces files for multiple network handlers The following example shows an interfaces file for an Adaptive Server with two network interfaces The server host machine is known as SERV_CORPNET on the corporate network and SERV_ENGNET on the engineering network PRODUCTION server with two network listeners PRODUCTION lt tab gt 3 lt tab gt 3 lt newline gt lt tab gt master tcp ether SERV_CORPNET 4559 lt tab gt master t
153. ting tables and devices in a one to one ratio Tables that share the same device will share the same upper threshold limit These tables cannot be used sequentially when a device fills up because they both reside on the same device Install each auditing table on its own device This enables you to set up a smoothly running auditing system with no loss of auditing records With 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 device rotation to skip the broken device until the device is repaired Make the device larger than the table When you use only three auditing tables and devices the size of the table and the size of the device can be similar because you can obtain more auditing capacity by adding more auditing tables and devices up to eight When you are working toward the upper table and device limit six to eight you may want to make the device considerably larger than the table Then you can expand the table size later towards the upper size of the device when a larger auditing capacity is desired and few or no device additions are available v Configuring Adaptive Server for auditing 1 Source SYBASE csh or SYBASE sh file if you have not setup the Sybase environment variables Start auditinit at the UNIX prompt SSYBASE S SYBASE ASE install auditinit auditinit dis
154. tion directories on page 94 Installing a new language module A full Adaptive Server installation includes all the language components automatically If you did not select a full install you must install additional language modules manually Message languages Configuration Guide To install a new language module 1 Load the language module software from the distribution media You must load this software into the same directory in which you loaded Adaptive Server Reconfigure the language and if necessary the character set and sort order for Adaptive Server For instructions see Changing the localization configuration on page 97 For messages U S English is installed as the default language in Adaptive Server The following rules apply to language modules During Adaptive Server installation or reconfiguration you can specify a default language other than U S English However you must have installed the language module for the language you specify If your clients require Adaptive Server messages in a language other than U S English you must load the language module for those languages Then you can configure Adaptive Server to the language used by your clients If Adaptive Server does not support messages in a client s language these clients receive messages in the server default language 93 Localization Localization For example if your client s language is Latin the Spanish language
155. tomizing Localization for Adaptive Server For information about configuring Adaptive Server to use high availability features see Using Sybase Failover in a High Availability Environment For information about configuring Adaptive Server for distributed transaction management two phase commit see the Using Adaptive Server Distributed Transaction Management Features Adaptive Server Enterprise CHAPTER 1 Introduction Languages other than U S English If you are running srvbuild in a language other than U S English verify that any input you provide uses a character set that is supported by the us_english character set Note The us_english character set does not support accent marks such as tildes and umlauts This prevents srvbuild from supporting the character sets that use these characters For more information about languages character sets and sort orders see the Installation Guide for your platform For more information 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 e 2K page server 4TB e 4K page server 8TB e 8K page server 16TB e 16K page server 32TB Minimum allowable sybsystemprocs database 124MB Required for an upgrade Maximum size of a 224 If the Operating System supports database device
156. tures Before installation make sure you have enough space available on the default segment to support sybsystemdb The sysprocsdev device The sybprocsdev devices stores the sybsystemprocs database which contains most of the Sybase supplied system procedures System procedures are a collection of SQL statements and flow of control statements that perform system tasks for example sp_configure The system procedures that are needed during recovery situations are stored in the master database Note sysprocsdev is the default system name for this device However it is frequently referred to as the sybsystemprocs device since it stores the sybsystemprocs database Optional devices and databases The devices and databases described in the following sections are optional The sample The sample databases are databases 6 Adaptive Server Enterprise CHAPTER 1 Introduction The sybsecurity device and database dbccdb database sybmgmtdb database Configuration Guide e pubs2 and pubs3 provided as learning tools for Adaptive Server pubs2 is used for most of the examples in the Adaptive Server documentation other examples use the pubs3 database Both are available in U S English versions of Adaptive Server e interpubs contains French and German data e jpubs contains Japanese data For information about installing the sample databases see the Installation Guide for your platform Chapter 3 Post
157. uration Guide 101 Changing the localization configuration charset utility 102 Character sets Sybase name 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 EUC JIS eucjis EUC KSC eucksc GB 18030 gb18030 GREEK8 greek8 ISO 8859 1 iso_l ISO 8859 2 iso88592 ISO 8859 5 iso88595 ISO 8859 6 iso88596 ISO 8859 7 iso88597 ISO 8859 8 iso88598 ISO 8859 9 iso88599 ISO 8859 15 isol5 Koi8 koi8 ROMANS8 roman ROMAN9 roman9 Shift JIS sjis TIS 620 tis620 TURKISH8 turkish8 UTF 8 utf8 Use the charset utility to load character sets and sort orders into Adaptive Server If you are using charset to load the default character set and sort order this should be done only at the time of installation To change the default character set and sort order of Adaptive Server see the System Administration Guide Adaptive Server Enterprise CHAPTER 7 Customizing Localization for Adaptive Server Syntax charset U username P password S server I interfaces v version sort order charset Table 7 19 Keywords and options for charsets Keywords and options Description U If you are not already logged in to your operating system as sa you must specify Usa or fasername sa in the command line P Specifies t
158. 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 xi Sybase certifications on the Web xii 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 at http www sybase com support manuals Technical documentation at the Sybase Web site is updated frequently Finding the latest information on product certifications 1 a A N Point your Web browser to Technical Documents at http www sybase com support techdocs Select Products from the navigation bar on the left Select a product name from the product list and click Go Select the Certification Report filter specify a time frame and click Go Click a Certification Report title to display the report Finding the latest information on component certifications 1 Point your Web browser to Availability and Certification Reports at http certificati
159. utility 91 SMIT See System Management Interface Tool Sort order changing 83 sort order default for Adaptive Server 83 Sort orders changing 84 lettercasein 91 131 Index sort orders 90 binary 91 changing 97 character sets and 90 databases and 90 definition files 90 dictionary 91 spaces in interfaces files 55 Spanish dictionary sort orders 92 SPX network protocol 11 56 square brackets in SQL statements xiv srt files 90 srvbuild utility 12 starting servers from UNIX command line 18 with operating system 20 startserver utility 20 start up script 21 stty settings 33 Sun Solaris iostatcommand 44 netstatcommand 44 network protocol 56 pscommand 45 time command 45 timeout period 42 vmstat command 44 sundiag system diagnostic tool 43 supported platforms vii SYBASE environment variable 4 SYBASE environment variable as default server name 59 Sybase globalization support 81 94 97 Sybase installation directory xv SYBASE_ASE environment 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 for 9 purpose of 5 132 sybsystemprocs database 6 symbols in SQL statements xiii xiv syntax conventions Transact SQL xiii sysprocsdev device minimum size for 9 purpose of 5 6 system audit tables 114 system databases where stored 9 System Management Inte
160. variables Configuration Guide Note As part of the installation the installer creates SYBASE sh and SYBASE csh files in SYBASE directory for user to source to setup all the environment variables It is crucial to the operation of Sybase 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 for C shell or profile file for Bourne shell Only the file owner or the root user can edit a user s login cshrc or profile file 29 Configuring new servers with srvbuild You may want to verify that the Adaptive Server environment variables in Table 3 1 are set correctly To check the current value of environment variables enter the following command at the operating system prompt env Table 3 1 describes the system environment variables for Adaptive Server Table 3 1 System environment variables Variable Sample value Function DSLISTEN TEST Used at Adaptive Server start up enables the specified Adaptive Server to listen for input from front end software DSQUERY TEST Defines the Adaptive Server to which local client applications connect PATH usr bin etc Appends the full path to the Adaptive Server Jusr sbin bin subdirectories usv ucb usr bin X11 sbin Configuring new servers with srvbuild 30 To configure new servers with srvbuil
161. word is the System Administrator s password and servername is the Adaptive Server where you plan to install the database Configuration Guide 123 Installing online help for Transact SQL syntax If you have set the DSQUERY environment variable to the servername you can replace the server name with DSQUERY 5 To ensure that you have installed the sybsyntax database and that it is working correctly use isq to log in to the server on which you installed the database and execute sp_syntax For example isql Usa Ppassword Sservername l gt sp syntax select 2 gt go Adaptive Server displays a list of commands that contain the word or word fragment select 124 Adaptive Server Enterprise Index Symbols BNF notation in SQL statements xiv comma in SQL statements xiv curly braces in SQL statements xiv parentheses in SQL statements xiv square brackets in SQL statements xiv A accented letters 13 91 Adaptive Server character set changing 83 character sets 89 client communications with 49 conversions between and clients 89 customizing features 47 database device requirements 9 default character set 83 default configuration 47 48 default sort order 83 error log path 106 language changing 83 naming in interfaces file 56 shutting down 24 sort order 83 starting from UNIX command line 18 starting with operating system 20 start up script 22 adding aserver LDAP 76 addre
162. y to Adaptive Server 3 Useatext editor to edit the script if necessary to change the default device from the master device to the device created in step 1 For information on the default device see Default device for the sybsyntax database on page 122 e Comment out the following section which specifies the default device create the database if it does not exist if not exists select name from sysdatabases where name sybsyntax begin create the sybsyntax table if it doesn t exist is the space left on the default database devices gt size of model if select sum high low 1 from sysdevices where status amp 1 1 select sum size from sysusages sysdevices where vstart gt sysdevices low and vstart lt sysdevices high and sysdevices status amp l 1 gt select sum sysusages size from sysusages where dbid 3 begin create database sybsyntax end else begin print There is not enough room on the default devices to create the sybsyntax database return end end e After you have commented out this entire section add a line like this to the script create database sybsyntax on device name where device_name is the name of the device where you want to install sybsyntax 4 Execute the script with a command like the following isql Usa Ppassword Sservername lt SSYBASE SSYBASE ASE scripts ins syn_sql where sa is the user ID of the System Administrator pass
163. you want to give the program 3 Change the program s permissions and ownership so that it will execute as root chmod 755 program _ name chown root program name where program_name is the name of the compiled program 4 The root user can use the program to start Adaptive Server with increased user connections by typing the following command at the operating system prompt program_name dataserver d master_device_name 36 Adaptive Server Enterprise CHAPTER 3 Configuring the Operating System where program_name is the name of the compiled program and master_device_name is the full path of Adaptive Server s master device Instead of typing the command at the operating system prompt you can add program_name preceding the dataserver command line in the Adaptive Server RUN_server_name file Sample program Note This is an sample script modify it as necessary The following example shows the source code that you can use to increase the hard limit include lt sys time h gt include lt sys resource h gt include lt sys types h gt define MAX CONNECTIONS to a number less than 10000 The number defined will then become the maximum number of connections allowed by an Adaptive Server define MAX CONNECTIONS 9999 extern int errno main argc argv char argv struct rlimit rlp uid_t uid rlp rlim_cur MAX CONNECTIONS rlp rlim_max MAX CONNECTIONS set the nu

Download Pdf Manuals

Related Search

Related Contents

Leica Builder User Manual  regulación especial rdac 91n - Dirección General de Aviación Civil  EVGA GeForce GTX 470 GeForce GTX 470 1.25GB  Snapper 411SST User's Manual  Software Requirements Specification for Housing4U  Development of a Graphical User Interface for a  the human body.  Manual de Instalación de Firma Digital  Talking Pen Holder User Manual Item: TPH  Enseignements des présidents de l`Église : Brigham Young  

Copyright © All rights reserved. Failed to retrieve file