Sybase Adaptive Server Скачать руководство пользователя страница 9 | Manualshive

Страница: 9 / 150

background image

About This Book

Configuration Guide

ix

•

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 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:

•

Basics – the basics for understanding and investigating performance
questions in Adaptive Server.

«
...
7
8
9
10
11
...
»

Содержание Adaptive Server

Страница 1: ...Configuration Guide Adaptive Server Enterprise 15 0 UNIX...

Страница 2: ...DI Database Gateway media splash Message Anywhere Server MetaWorks MethodSet mFolio Mirror Activator ML Query MobiCATS MobileQ MySupport Net Gateway Net Library New Era of Networks Next Generation Lea...

Страница 3: ...ize of a database device 9 Client server communication 11 Changing Adaptive Server configuration 12 Languages other than U S English 13 Adaptive Server specifications 13 CHAPTER 2 Starting and Stoppin...

Страница 4: ...hard limits 35 Increasing the soft limit 35 Increasing the hard limit 36 Sample program 37 Enabling asynchronous disk I O 38 Adjusting the client connection timeout period 41 For HP UX 41 For IBM RS...

Страница 5: ...t backup 62 IPv6 support 63 Understanding IPv6 63 IPv6 infrastructure 64 Starting Adaptive Server Enterprise as IPv6 aware 65 Troubleshooting 66 Server fails to start 66 Error when executing an ESP 67...

Страница 6: ...disabling error logging 106 Setting error log paths 106 Setting the Adaptive Server error log path 106 Managing messages 107 Logging user defined messages 107 Logging auditing events 108 CHAPTER 9 Man...

Страница 7: ...em administration tasks Working with system administration issues that are relevant to Adaptive Server running on UNIX platforms This manual supplements the System Administration Guide and the Perform...

Страница 8: ...cter sets sort orders and language modules Chapter 8 Logging Error Messages and Events describes how to use the error logging features of Adaptive Server Chapter 9 Managing Adaptive Server Databases p...

Страница 9: ...rprise data Glossary defines technical terms used in the Adaptive Server documentation Java in Adaptive Server Enterprise describes how to install and use Java classes as data types functions and stor...

Страница 10: ...nsact SQL system procedures catalog stored procedures system extended stored procedures and dbcc stored procedures Tables Transact SQL system tables and dbcc tables System Administration Guide provide...

Страница 11: ...ase and documents the query and mapping functions that comprise XML Services Other sources of information Use the Sybase Getting Started CD the SyBooks CD and the Sybase Product Manuals Web site to le...

Страница 12: ...on the left 3 Select a product name from the product list and click Go 4 Select the Certification Report filter specify a time frame and click Go 5 Click a Certification Report title to display the r...

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

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

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

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

Страница 17: ...erver Installation Guide for your platform This chapter provides an overview of how to configure Adaptive Server and the steps you need to take to customize it for your use About Adaptive Server Adapt...

Страница 18: ...Server to run operating system and user defined commands System specific issues Adaptive Server runs on a variety of hardware and operating system platforms System specific issues do not affect the b...

Страница 19: ...a UNIX login that owns all the Sybase installation directories and files sets permissions on those directories and files and performs the installation and upgrading of Adaptive Server This login is p...

Страница 20: ...y path to search for executables The Sybase executables are located in the installed_components bin directory When using the source files SYBASE csh or SYBASE sh the following paths are prepended to P...

Страница 21: ...stemdb and sysprocsdev devices are created when you create a new Adaptive Server The master device The master device contains the following databases master controls the operation of Adaptive Server a...

Страница 22: ...rt distributed transaction management DTM features Before installation make sure you have enough space available on the default segment to support sybsystemdb The sysprocsdev device The sybprocsdev de...

Страница 23: ...n an Adaptive Server audit trail You can use this audit trail to monitor the use of Adaptive Server or system resources For instructions on configuring Adaptive Server for auditing see Chapter 10 Addi...

Страница 24: ...r data from devices on the file systems By default Adaptive Server enables dsync for file system devices However dsync may cause performance degredation for file system devices that experience high wr...

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

Страница 26: ...rtition beyond the size specified for the device becomes inaccessible unless you drop and re create the device For best performance place the Sybase software and all disk devices including the master...

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

Страница 28: ...tory Service Changing Adaptive Server configuration Use sp_configure to change the configuration of Adaptive Server To change the configuration of several servers enter the sp_configure information in...

Страница 29: ...ormation on srvbuild see the Utility Guide Adaptive Server specifications Database specifications Databases per Adaptive Server A maximum of 32 767 databases per server Maximum database size 2K page s...

Страница 30: ...able size needed Maximum size of object name 255 Query specifications Maximum number of tables participating in a query for a query without a union or for each side of a union in a query 64 Maximum of...

Страница 31: ...ried and tempdb if it is used for results or worktables Maximum number of tables with referential integrity constraints for a query 192 Procedure specifications Number of buffers and procedure buffers...

Страница 32: ...ta limits for tables according to page size model database 3MB 6MB 12MB 24MB tempdb database 4MB 6MB 12MB 24MB sybsystemdb database 3MB 6MB 12MB 24MB Databases 2K page 4K page 8K page 16K page Tables...

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

Страница 34: ...editing the RUN_server_name Server start up parameters The default start up parameters are stored under SYBASE SYBASE_ASE install RUN_server_name where server_name is the name of the server you insta...

Страница 35: ...information required to restart that server RUN_server_name files are created in the SYBASE SYBASE_ASE install directory For Adaptive Server the RUN_server_name file is named RUN_server_name where ser...

Страница 36: ...he monserver and backupserver commands Use the monserver command to start Monitor Server from the UNIX command line For details see the Adaptive Server Enterprise Monitor Server User s Guide Starting...

Страница 37: ...startserver command in the etc inittab file Here is a suggested format for an Adaptive Server start up command to add to etc inittab sybase 2 wait release_directory install startserver f RUN_serverna...

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

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

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

Страница 41: ...s waiting for processes to complete and you must stop Adaptive Server immediately you can use shutdown with nowait which neither waist for currently executing statements to finish nor performs checkpo...

Страница 42: ...art If the Monitor Server heartbeat feature is in effect Monitor Server automatically detects the termination of Adaptive Server within the specified period and shuts itself down Therefore before atte...

Страница 43: ...321 3320 80 10 31 45 pts 4 324 47 dataserver ONLINE 1 jorge 3322 3320 80 10 31 45 pts 4 326 02 dataserver ONLINE 2 jorge 3323 3320 80 10 31 45 pts 4 328 56 dataserver ONLINE 3 This example shows four...

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

Страница 45: ...e products that the system environment variables be set correctly Environment variables are set in the user s environment either interactively or by including them in the user s login and cshrc files...

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

Страница 47: ...sport type Host name Port number In the Edit Advance Adaptive Server Attributes tab enter Adaptive Server configuration file Sybsystemdb device path Sybsystemdb device size Sybsystemdb database size S...

Страница 48: ...nsport type Host name Port number 8 In the XP Server type screen select Transport type Host name Port number 9 In the Full Text Search SDS type screen select Error log Collection directory Default dat...

Страница 49: ...e Self Management user name new Self Management user password 12 Click Build Servers to proceed with the servers configuration srvbuild displays the configuration status as it builds the servers you s...

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

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

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

Страница 53: ...The following example shows the source code that you can use to increase the hard limit include sys time h include sys resource h include sys types h define MAX_CONNECTIONS to a number less than 10000...

Страница 54: ...ing system administrator or HP technical support Note Before executing the following instructions shut down Adaptive Server or SQL Server To enable asynchronous I O 1 From the SAM Kernel Configuration...

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

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

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

Страница 58: ...tcp_keepalive_time To reduce the timeout period to 15 minutes 900 seconds enter sbin sysctl w net ipv4tcp_keepalive_time 900 Checking for hardware errors The following types of hardware error message...

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

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

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

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

Страница 63: ...ministration Guide For information about configuring languages character sets and sort orders as well as optional features see the System Administration Guide Default settings After installation Adapt...

Страница 64: ...rder Linux Binary ordering Login security mode Standard Item Default value Server Item Default value Backup Server Name AdaptiveServername_back Network support TCP IP Socket number 5001 Error log path...

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

Страница 66: ...its own name by checking the value of the DSLISTEN environment variable If the DSLISTEN environment variable is not set then it assumes that the server name is SYBASE Type of interfaces file Task or t...

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

Страница 68: ...Server and any other Open Server applications The network information in the file includes the server name network name or address of the host machine and the port object or socket number depending o...

Страница 69: ...ch machine For more information see Creating a master interfaces file on page 58 If the host machine supports multiple networks see Configuring interfaces files for multiple networks on page 59 Hetero...

Страница 70: ...ptive Servers running in a homogeneous environment can use copies of the interfaces file to establish connections Because the two Adaptive Servers are running under the same operating system they can...

Страница 71: ...e that follows the servername line must begin with a space or a character tab Each element on the line must be separated by a single space Each entry is separated by a blank line You can add comments...

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

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

Страница 74: ...Using dsedit or dscp Using a text editor Using dsedit or dscp to create a master interfaces file You can use the dsedit or dscp utility to create a master interfaces file which you can then distribute...

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

Страница 76: ...ODUCTION server with two network listeners PRODUCTION tab 3 tab 3 newline tab master tcp ether SERV_CORPNET 4559 tab master tcp ether SERV_ENGNET 5479 tab query tcp ether SERV_CORPNET 4559 When Adapti...

Страница 77: ...mong Sybase installations on different networks The interfaces file looks like the following example on the engineering network PRODUCTION tab 3 tab 3 newline tab query tcp ether SERV_ENGNET 5470 tab...

Страница 78: ...query Clients on each network must use the DSQUERY value that corresponds to the network the client is on In the following example either PRODUCTION_network1 or PRODUCTION_network2 can be used Client...

Страница 79: ...erfaces file entry for the Adaptive Server into the client interfaces file 4 A connection on the secondary port occurs only if the corporate network is disabled or if the corporate network interface o...

Страница 80: ...Sybase products that are Open Client Server based like XP Server Backup Server Replication Server and Open Switch became automatically IPv6 aware due to the layered Open Client Transport Control Laye...

Страница 81: ...ava support License Management Server LDAP driver Starting Adaptive Server Enterprise as IPv6 aware Adaptive Server is IPv6 unaware by default To make Adaptive Server IPv6 aware you must start Adaptiv...

Страница 82: ...port 17100 would typically look like SYBASE master tcp ether revival sybase com 17100 query tcp ether revival sybase com 17100 master tcp ether revival v6 sybase com 17100 query tcp ether revival v6...

Страница 83: ...t 3 To verify that the server port is in use start the server manually The server does not start if its assigned port number is already in use For information on starting servers manually see the inst...

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

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

Страница 86: ...ssion connection to an LDAP server Note The user name and password that are passed to the LDAP server for user authentication purposes are distinct and different from those used to access Adaptive Ser...

Страница 87: ...ybase LDAP directory entries Table 6 2 Sybase LDAP directory definitions interfaces file Directory services Platform specific Platform independent Specific to each Sybase installation Centralized and...

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

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

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

Страница 91: ...fines the keywords for the ldapurl variables Table 6 3 ldapurl variables 4 Verify that the appropriate environment variable points to the required third party libraries The Netscape LDAP SDK libraries...

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

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

Страница 94: ...ap seashore dc sybase dc com one bindname uid Manager dc sybase dc com password Replace the password with the encrypted string ldap libsybdldap so ldap seashore dc sybase dc com one bindname uid Manag...

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

Страница 96: ...Migrating from the interfaces file to LDAP 80 Adaptive Server Enterprise...

Страница 97: ...nt including translated system messages and correct formats for date time and currency Adaptive Server supports localization for international customers and for customers with heterogeneous environmen...

Страница 98: ...ion translated documentation is available in Chinese Simplified French German Japanese Korean Language modules Adaptive Server stores its localized software messages in separate language modules When...

Страница 99: ...ve Server it displays a message box asking if you want to localize your Adaptive Server to a language other than us_english and if you want to use a character set or sort order other than the default...

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

Страница 101: ...equires Unilib conversion Unilib Required column Check mark x the character set requires Unilib conversion No check mark the character set may use either the Unilib conversion or the built in conversi...

Страница 102: ...X EUC GB encoding Simplified Chinese character sets cp936 X Microsoft Simplified Chinese character sets gb18030 X PRC 18030 standard Character set Unilib required Description cp950 X PC Microsoft Tra...

Страница 103: ...sets Table 7 12 lists the Turkish character set Character set Unilib required Description cp869 IBM PC Greek cp1253 MS Windows Greek greek8 HP GREEK8 iso88597 ISO 8859 7 Latin Greek Character set Unil...

Страница 104: ...kish cp1254 Microsoft Windows Turkish iso88599 ISO 8859 9 Latin 5 Turkish turkish8 HP TURKISH8 Character set Unilib required Description utf8 X Unicode UTF 8 encoding Character set Unilib required Des...

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

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

Страница 107: ...values for that character set Binary order sorts all ASCII uppercase letters before lowercase letters Accented or ideographic multibyte characters sort in their respective standards order which may be...

Страница 108: ...alternate dictionary sort order with lowercase variants sorted before uppercase Use with several of the Western European languages Alternate dictionary order case insensitive accent insensitive Case i...

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

Страница 110: ...finition files for Western European character sets U S English system message files During the installation process or through reconfiguration you can specify a different language character set and so...

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

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

Страница 113: ...If the locales definitions in your system configuration files do not match the Sybase locale definitions your applications will not run properly For example if you want your Open Client messages to a...

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

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

Страница 116: ...e accent sensitive dictiona srt 51 Dictionary order case insensitive accent sensitive nocase srt 52 Dictionary order case insensitive accent sensitive with preference nocasepr srt 53 Dictionary order...

Страница 117: ...nocs srt 56 Dictionary order case insensitive accent insensitive espnoac srt 57 Thai Dictionary order dictionary srt 51 Turkish These sort orders work only with ISO 8859 9 Dictionary order case sensit...

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

Страница 119: ...e DSQUERY environment variable to identify the server name If there is no DSQUERY environment variable charset attempts to connect to a server named SYBASE I Specifies the interfaces file to use If no...

Страница 120: ...Changing the localization configuration 104 Adaptive Server Enterprise...

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

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

Страница 123: ...erver Logging user defined messages You can specify whether a user defined message is logged to the Adaptive Server error log Adaptive Server lets you make this determination for New messages sp_addme...

Страница 124: ...parameters and values are log audit logon success at 1 to enable logging of successful Adaptive Server logins sp_configure log audit logon success 1 log audit logon failure at 1 to enable logging of...

Страница 125: ...n of a disk that stores Adaptive Server databases and database objects Device requirements Adaptive Server devices and databases are subject to the following limits The maximum device size is 4TB The...

Страница 126: ...tored on one or more database devices in one or more disk pieces The maximum number of disk pieces in one database is 8 388 608 However Adaptive Server must retain a description of all active database...

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

Страница 128: ...Managing database devices 112 Adaptive Server Enterprise...

Страница 129: ...resources By examining the audit trail the System Security Officer can inspect patterns of access to objects in databases and can monitor the activity of specific users Audit records can be traced to...

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

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

Страница 132: ...dit table s 3 Add a device for the audit database transaction log 4 Delete a device entry 5 Change a device entry List of devices for the audit tables Logical name Physical name Segment name Table nam...

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

Страница 134: ...ce entry List of devices for the audit tables Logical name Physical name Segment name Table name Size 6 Audit_01 secret1 sybase_dr install aud1 dat sysaudits_01 5 7 Audit_02 secret1 sybase_dr install...

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

Страница 136: ...capabilities Done Auditing capability installed Task succeeded install auditing capabilities Configuration completed successfully Press return to continue Enabling auditing After auditing is installed...

Страница 137: ...se sybsyntax You can retrieve this data with sp_syntax For more information on sp_syntax see the Reference Manual The scripts directory contains one or more of the sp_syntax scripts shown in Table 10...

Страница 138: ...iskdefault to change the status of the master device which is installed as the default disk or to specify another default device the scripts install sybsyntax on the master device Sybase does not reco...

Страница 139: ...where status 1 1 select sum size from sysusages sysdevices where vstart sysdevices low and vstart sysdevices high and sysdevices status 1 1 select sum sysusages size from sysusages where dbid 3 begin...

Страница 140: ...server name with DSQUERY 5 To ensure that you have installed the sybsyntax database and that it is working correctly use isql to log in to the server on which you installed the database and execute sp...

Страница 141: ...omponent in interfaces files TCP protocol entry 57 administrator operating system 3 Sybase system 3 API component in interfaces file described 56 Arabic character sets 85 asynchronous I O AIO enabling...

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

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

Страница 144: ...nd 44 monitoring systems 44 netstat command 44 netstat v command 44 network protocol 56 no a command 44 ps command 44 time command 44 timeout period 41 vmstat command 44 installation directory Sybase...

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

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

Страница 147: ...evices See character devices raw partitions availability of 10 minimum size for database devices 10 referential integrity constraint 15 retry_attempts component in interfaces files 56 roman8 character...

Страница 148: ...ment variable 4 SYBASE_FTS environment variable 4 SYBASE_OCS environment variable 4 SYBASE_SYSAM environment variable 4 sybsecurity database 7 114 device 7 9 sybsyntax database 121 sybsystemdb device...

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

Страница 150: ...Index 134 Adaptive Server Enterprise...

Отзывы:

Нет отзывов

Похожие инструкции для Adaptive Server

DRAGON NATURALLYSPEAKING 7

Бренд: ScanSoft Страницы: 222

GHOST IMAGING FOUNDATION 7.1

Бренд: Symantec Страницы: 189

CX-SUPERVISOR V3

Бренд: Omron Страницы: 5

COLDFUSION 5-ADVANCED ADMINISTRATION

Бренд: MACROMEDIA Страницы: 372

Бренд: Primera Страницы: 19

Бренд: Allied Telesis Страницы: 46

Бренд: Crestron Страницы: 230

User Access Control (UAC) in Windows® Vista

Бренд: Alarm Lock Страницы: 2

DIMAGE VIEWER 2.1

Бренд: Minolta Страницы: 84

Бренд: Kenwood Страницы: 40

Бренд: Mitsubishi Electric Страницы: 92

Бренд: Mitsubishi Electric Страницы: 51

Бренд: Mitsubishi Electric Страницы: 57

Бренд: Mitsubishi Electric Страницы: 29

Modero NXD-1000Vi

Бренд: AMX Страницы: 2

Бренд: Agilent Technologies Страницы: 9

Бренд: UNIBLUE Страницы: 3

Бренд: FieldServer Страницы: 34

Бренды по названию

0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Популярные бренды

Загрузить еще бренды