manualshive.com logo in svg

Sybase Adaptive Server 15.0.2, Руководство по установке

Поделиться
Скачать
Sybase Adaptive Server 15.0.2 Скачать руководство пользователя страница 155

APPENDIX C    Using sybsystemprocs

Installation Guide

141

1> create database sybsystemprocs on sysprocsdev = 

112

2> go

5

Run  the 

instmstr

 command in the old release directory. For version 12.0: 

isql -Usa -P

password

 -i%SYBASE%\%SYBASE_ASE%

\scripts\instmstr -oinstmster.out

For versions earlier than 12.0:

isql -Usa -P

password

 -i%SYBASE%\scripts\instmstr 

-oinstmster.out

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

Страница 1: ...Installation Guide Adaptive Server Enterprise 15 0 2 HP UX...

Страница 2: ...rver 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 Generati...

Страница 3: ...OLE DB and ODBC 10 PC Client product descriptions and directory layout 11 Separately installable PC Client products 12 CHAPTER 2 Installing Adaptive Server 13 Overview 13 System requirements 14 Pre i...

Страница 4: ...le databases 48 CHAPTER 4 Installing Sybase PC Client Products 49 Overview 49 Before you install the PC Client products 50 Installing PC Client products 50 Installing PowerDesigner PowerTransfer and I...

Страница 5: ...ling and changing e mail notifications 99 CHAPTER 7 Troubleshooting 101 Overview 101 Error log locations 103 Solutions to common installation problems 104 Adaptive Server fails to start 104 The Instal...

Страница 6: ...h Replicated Databases 131 Introduction 131 Suspending transaction processing and replication activities 132 Draining the transaction logs for primary databases 133 Draining the RSSD transaction log 1...

Страница 7: ...other qualified personnel who are familiar with their system s environment networks disk resources and media devices How to use this book This book contains the following chapters Chapter 1 Overview...

Страница 8: ...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 o...

Страница 9: ...s on how to install and configure and create and schedule jobs on a local or remote Adaptive Server using the command line or a graphical user interface GUI Messaging Service User s Guide describes ho...

Страница 10: ...ng 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...

Страница 11: ...plications that use FLEXnet licensing Other sources of information Use the Sybase Getting Started CD the SyBooks CD and the Sybase Product Manuals Web site to learn more about your product The Getting...

Страница 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: ...ion 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 EBF...

Страница 14: ...ation about how Sybase supports accessibility see Sybase Accessibility at http www sybase com accessibility The Sybase Accessibility site includes links to information on Section 508 and W3C standards...

Страница 15: ...iptions and directory lay outs see Chapter 1 Overview For information about installing Adaptive Server and its components see Chapter 2 Installing Adaptive Server and Chapter 4 Installing Sybase PC Cl...

Страница 16: ...ew the updated SySAM implementation and plan your SySAM deployment before you install Adaptive Server Enterprise For information about how to install and configure SySAM 2 0 enabled products see the f...

Страница 17: ...e services exported by the operating system to function Adaptive Server uses operating system services for process creation and manipulation device and file processing and inter process communication...

Страница 18: ...DML utility commands which are generally data definition statements DDL and administrative functions and performs stored procedure executions The DBMS engine uses the services provided by the resourc...

Страница 19: ...to establish a connection to the server submit requests to the server and receive results back from the server Figure 1 1 Adaptive Server system model Adaptive Server editions Adaptive Server is avai...

Страница 20: ...mmand to determine which edition of Adaptive Server your are running Enter sp_lmconfig edition go Adaptive Server returns value of EE SE DE or XE based on the edition it is running See the Reference M...

Страница 21: ...tions for Adaptive Server on Windows Table 1 2 Adaptive Server specifications on Windows Hardware and memory Processor 64 bit Minimum RAM for Adaptive Server 90MB 45 056 2K pages Number of shared memo...

Страница 22: ...y as a stand alone product Please contact customer service for more information Table 1 3 Product description Product Description Adaptive Server and Historical Server Installed into the ASE 15_0 dire...

Страница 23: ...ent JRE is a runtime Java virtual machine used to execute Java based programs such as Sybase Central Adaptive Server Plug in Installed into ASEP directory This plug in contains the management software...

Страница 24: ...th SDK 15 0 is version 15 0 0 51 Sybase recommends that you start your migration process the new ODBC and OLE DB drivers as soon as possible New features introduced in Adaptive Server 15 0 are support...

Страница 25: ...ADO NET Windows only a provider used to connect to Adaptive Server from NET based applications Windows Cluster Server Admin utilities Windows Cluster Administrator is a GUI tool for managing Microsoft...

Страница 26: ...censing Language Modules Installed into the locales directory Provides system messages and date time formats Character Sets Installed into the charsets directory Provides character sets available for...

Страница 27: ...rver is 1 Perform pre installation tasks related to license administration as described in Pre installation tasks for SySAM on page 15 Warning SySAM 2 0 enabled products work for an initial period wit...

Страница 28: ...Itanium platform Table 2 4 Server system requirements Hardware Operating system Supported protocols HP9000 700 or HP9000 800 or 64 bit HP9000 D K V Series The PA8000 chip is required HP UX 11 i runnin...

Страница 29: ...in the Sybase Software Asset Management User s Guide 2 If you plan to use a served license you need a license server Decide whether it will be an existing license server or a new license server The l...

Страница 30: ...er host see the Choosing a license server host section in Chapter 2 Choosing a License Model of the Sybase Software Asset Management User s Guide For information about license server administration se...

Страница 31: ...e platforms the host ID is derived from the network adapter address If your machine has multiple network adapters lmutil lmhostid returns one host ID for each network adapter The output may look simil...

Страница 32: ...or the operating system you are using 3 The license agreement displays You must agree to the terms and conditions in the license in order to generate a license To do so click I Agree Note The license...

Страница 33: ...ard to generate your license Generating a served license To generate a served license 1 Select Served License and click Next 2 Indicate the quantity of licenses you wish to generate and click Next 3 E...

Страница 34: ...ense server installation Note You must save your license files with a lic extension or SySAM 2 0 will not recognize them Sybase recommends that you setup the license server and required licenses befor...

Страница 35: ...em Installing a new license server Note If you have selected a served license model you must install a license server Recommended operating system patches are For HP UX 11 11 PHCO_25841 PHKL_26269 PHK...

Страница 36: ...enter SPDC at https sybase subscribenet com 5 Generate the licenses for the products you want to install For instructions on generating your licenses see Generating licenses at SPDC on page 18 6 From...

Страница 37: ...efore installing Adaptive Server 1 Read the release bulletins for the latest information on the products Adaptive Server Monitor Server and so on that you are installing See Special Installation Instr...

Страница 38: ...ling The options are Enterprise Edition Small Business Edition Developers Edition Express Edition If you are installing the Small Business or Enterprise Edition you must know the license type under wh...

Страница 39: ...n Manager SAM After you install Adaptive Server you can change any configuration parameter procedure cache and data cache size This may require that you increase the value of the configuration paramet...

Страница 40: ...he System Administration Guide for more information 16 17 To optimize asynchronous I O and to prevent the paging of shared memory you must grant MLOCK permissions before you install Adaptive Server To...

Страница 41: ...ory Adaptive Server version 15 0 2 should be installed last Installation methods The following instructions are for using the Installer in GUI mode You can also perform the installation in a non GUI t...

Страница 42: ...not start the setup program manually by selecting Start Run Browse to setup exe 3 The Welcome screen displays Click Next 4 When the license selection window displays select the most appropriate locati...

Страница 43: ...tion and select your components Full Custom 8 If you select Custom the Products and Features Selection window displays Select the products you want to install by checking the box next to each product...

Страница 44: ...running and the port number if you have used a non default port number If you answer No you will be using unserved licenses You will be reminded to download and install the license file after you have...

Страница 45: ...ver Configure new Monitor Server Configure new XP Server Configure new Job Scheduler Enable Self Management Configure Web Services Configure Unified Agent Select the servers you want to configure If y...

Страница 46: ...nitor Server Custom configure new XP Server Custom configure new Job Schedule Custom configure Self Management Custom configure Web Services Custom configure new Unified Agent The Custom Configure Inp...

Страница 47: ...page size server 3MB 4K page size server 6MB 8K page size server 12MB 16K page size server 24MB Once you have customized the Adaptive Server configuration select Next to record the input fields 19 The...

Страница 48: ...ing information Self Management user name Self Management password Note If you choose the default user name sa you cannot enter the password The sa default password is null 24 The Unified Agent Discov...

Страница 49: ...44 to begin experimenting with your servers or see the System Administration Guide at Sybase Product Manuals at http www sybase com support manuals for more advanced topics Adaptive Server You have a...

Страница 50: ...ve Server See Chapter 5 Upgrading Adaptive Server If your server is at a 15 x version level you can begin installing Adaptive Server 15 0 2 Backing up Adaptive Server Installing Adaptive Server versio...

Страница 51: ...ions InstallShield starts automatically For UNIX installations change to the CD drive and enter setup 5 Install Adaptive Server 15 0 2 over the SYBASE installation path Note Once files are loaded into...

Страница 52: ...pport techdocs You can downgrade to earlier 15 x versions of Adaptive Server but to do so you must take the precautions described in the technical note before using any of the new 15 0 2 features XML...

Страница 53: ...the Adaptive Server product Verify that the sybase user is a member of the Windows system defined group Administrators so the user has the access privileges that allow them to complete the steps desc...

Страница 54: ...uired Note cacls is a command line utility available on Windows 2000 and later versions On earlier Windows versions this utility is available from the NT Resource Kit 3 Adaptive Server services should...

Страница 55: ...he System Administrator s password See Setting the System Administrator password on page 42 The command prompt is displayed if the login is successful 2 To display the Adaptive Server version number e...

Страница 56: ...lt sa user name and leave the password blank After you log in for the first time change the System Administrator s password See Setting the System Administrator password on page 42 The Adaptive Server...

Страница 57: ...to have at least six characters with a combination of letters and numbers The SAMreport SAMreport is a SySAM 2 0 license reporting tool used in conjunction with the SySAM2 0 license server It is a re...

Страница 58: ...ains scripts for installing the us_english sample database foreign language sample databases and the image data associated with the U S English pubs2 sample database Script Description instpbs2 Instal...

Страница 59: ...etermine the type raw partition logical volume operating system file and so on and location of the device where you will be storing the pubs2 and pubs3 databases You will need to provide this informat...

Страница 60: ...ter set To display the French and German data correctly you must set up your terminal to display 8 bit characters v Installing the interpubs database 1 Be sure iso_1 iso15 Roman8 Roman 9 or UTF 8 is i...

Страница 61: ...character set or as an additional character set 3 Determine the type raw partition logical volume operating system file and so on and location of the device where you will be storing the jpubs databa...

Страница 62: ...d a list of guest permissions see the System Administration Guide Note Sybase recommends that you remove the guest user from user databases in production systems If possible and if space allows give e...

Страница 63: ...mote servers local servers installed on the same machine and multiple servers See Configuring network connections for client products on page 54 Before you use the plug in restart your computer to imp...

Страница 64: ...ory and that you have set the TEMP environment variable The installation program uses the extra space and directory to write files temporarily during the installation The installation program frees th...

Страница 65: ...ents are also installed as part of the Adaptive Server installation Warning If PC Client Components have been installed during the Adaptive Server installation do not re install them and do not instal...

Страница 66: ...he Welcome window displays Click next 7 When the Sybase license agreement displays select a country click Agreement then click Next 8 Enter the directory path and click Next If user has Sybase Central...

Страница 67: ...Click Next The Summary window displays every component to be installed by the Installer the required disk space and the available disk space If the target directory does not have enough free space th...

Страница 68: ...and password to connect to an LDAP server The default libtcl cfg file is located in SYBASE SYBASE_OCS ini In its simplest form on 32 bit LDAP drivers the libtcl cfg file is in this format DIRECTORY ld...

Страница 69: ...s x64 the dll file is called libsybdldap64 dll 2 Verify that the appropriate environment variable points to the required third party libraries The Netscape LDAP SDK libraries are located in SYBASE SYB...

Страница 70: ...base server through the interfaces file each server must be included in the interfaces file on the client computer To add a server entry to the interfaces file on your PC Client computer 1 From the Mi...

Страница 71: ...chine use ypmatch on a UNIX box ipconfig on Windows See your system administration guide for the commands on your system Note To connect to a UNIX server the entries you add to interfaces must match t...

Страница 72: ...ord 4 From the drop down list select the Adaptive Server to which you want to connect If Sybase Central is installed on the same computer as the server click the icon for the server If prompted to sta...

Страница 73: ...m a failed upgrade on page 106 in Chapter 7 Troubleshooting Topic Page Overview of the upgrade process 60 Pre upgrade tasks 62 Upgrading to Adaptive Server 15 0 2 68 Post upgrade tasks 71 Upgrading Ba...

Страница 74: ...the server schema from one page size to another is a database migration See sybmigrate in the Utility Guide for information about migration Upgrading Adaptive Server consists of three processes 1 Inst...

Страница 75: ...ccessfully Essentially syconfig exe or sybatch exe searches for the largest catalog then calculates the required free space by doubling the size of the largest catalog and adding approximately 10 perc...

Страница 76: ...onitor Server or XP Server those servers must not be running 4 Stored procedure text in the syscomments table is required for upgrade 5 Reserved words are resolved using quoted identifiers 6 Verify th...

Страница 77: ...g files from earlier versions of Adaptive Server to their corresponding Adaptive Server 15 x installation For UNIX platforms SYBASE interfaces SYBASE SYBASE_ASE servername cfg SYBASE SYBASE_OCS config...

Страница 78: ...To successfully upgrade to Adaptive Server version 15 0 2 Reinstall the procedures with text or Remove them and reinstall them after the upgrade You can also hide the text using the sp_hidetext store...

Страница 79: ...to verify that the old installation of Adaptive Server does not use any reserved words that have been introduced with the new server Server Config always discovers one reserved word conflict for each...

Страница 80: ...ing the database and devices for the upgrade If you ran the pre upgrade option in preupgrd exe the utility scanned the system catalogs and calculated how much additional space you need to perform the...

Страница 81: ...ust first increase the size of tempdb before increasing the size of the model database 3 Verify the size of each database Enter the following where database_name is the name of the system database you...

Страница 82: ...cs is 124MB or enough free space to accommodate the existing sybsystemprocs database and the largest catalog that is to be upgraded plus an additional 10 percent for logging upgrade changes You may ne...

Страница 83: ...functionality Note The installation procedure for Sybase Central and the Adaptive Server plug in for Sybase Central has changed Beginning with version 12 0 Adaptive Server uses the following locations...

Страница 84: ...all pre upgrade checks are successful the old server is shut down and the new Adaptive Server dataserver binary is started on the old master device sqlupgrade or the Server Config utility internally r...

Страница 85: ...follow the instructions in Removing Adaptive Server on page 119 Post upgrade tasks After you have upgraded to the new version of Adaptive Server perform the following tasks to make sure your new Adap...

Страница 86: ...the procedure and data caches in terms of megabytes During the upgrade process Adaptive Server converts the procedure cache percent to an absolute value and sets procedure cache size based on this va...

Страница 87: ...rify data cache allocation after upgrading This section is for information only Adaptive Server ensures that all the data cache sizes after upgrading are the same as before upgrade In pre 12 5 version...

Страница 88: ...unmirrored devices remirror them using the disk remirror command 8 For information about upgrading compiled objects see Upgrading compiled objects with dbcc upgrade_object on page 109 9 If you used t...

Страница 89: ...1 use database 2 go 1 dbcc settrunc ltm valid 2 go 5 Restart the Replication Servers and LTMs 6 Resume the DSI connections that were suspended before the upgrade by executing the following Replicatio...

Страница 90: ...Replication Server connection to the RSSD by issuing the following command to the Replication Server 1 sysadmin hibernate_off Replication Server 2 go Make sure to specify the same string that was spec...

Страница 91: ...udit security global audit option server boot roles These options are turned off by default and are not turned on even if you used sp_auditoption all on to turn on all global audit options in a versio...

Страница 92: ...de process Note Back up all databases including master after successfully upgrading Adaptive Server and Backup Server v Upgrading Backup and Monitor Servers The instructions for upgrading Backup Serve...

Страница 93: ...er perform the following steps to upgrade Job Scheduler Note You must have SYBASE SYBASE_OCS bin directory in PATH so the isql executable is accessible v Upgrading Job Scheduler 1 Copy the directory s...

Страница 94: ...ript that is included with this release and save the output to a file isql Usa Psa_password Sservername n i SYBASE SYBASE_ASE scripts installjsdb ooutput_file 10 Enable Job Scheduler to start when Ada...

Страница 95: ...r yet rename your modified templates Note Sybase recommends that if you modify Sybase supplied templates that you save the changes under new names and in new files 5 You may need to make minor modific...

Страница 96: ...re 15 0 1 servers you must use the 2 1 or 2 2 versions for pre 15 0 1 servers Table 5 2 Modified Job Scheduler templates rebuild indexes SybRebuildIndexTemplate xml jst_reorg_rebuild_indexes Changed t...

Страница 97: ...ame password language_code update statistics SybUpdateStatsTemplate xml jst_update_statistics Added ptn_name as fifth parameter and datachg_threshold as the 10th parameter and added reference Required...

Страница 98: ...rading to Adaptive Server 15 0 2 on page 68 to upgrade each of the Adaptive Servers separately 4 Run the new Adaptive Server installmaster script against the newly upgraded Adaptive Servers 5 Run the...

Страница 99: ...mpcfgvrfy Line 102 Database svr2_db1 a user database exists Drop this database and retry the configuration again 12 Use the cluster command to offline and then online resource associated with Adaptive...

Страница 100: ...w Adaptive Server installation location 7 Manually restart Adaptive Server 8 Use the cluster system command to restart monitoring resource associated with Adaptive Server 9 Use the cluster command to...

Страница 101: ...new If you do not have DDL scripts use the ddlgen utility to re create the schema for the Adaptive Server you are about to upgrade See the Utility Guide 1 Run dbcc checks on databases to verify data i...

Страница 102: ...the dbccdb and you may lose history data 12 Drop and re create all your compiled objects such as stored procedures triggers views and defaults 13 If you have partitioned tables update partition statis...

Страница 103: ...ing Adaptive Server Installation Guide 89 isql alter database dbname on device_name 2m Note In 15 0 2 Adaptive Server alter database allows you to specify the size to alter the database with the unit...

Страница 104: ...Recovering from a failed upgrade 90 Adaptive Server Enterprise...

Страница 105: ...ncludes information about troubleshooting the most common SySAM 2 0 related errors Calling Sybase technical support for SySAM related issues If you call Sybase technical support for SySAM related issu...

Страница 106: ...lmutil binary is located in the bin directory under SYSAM 2_0 folder If you are using a served license model The licenses saved in the SYBASE SYSAM 2_0 licenses directory of the license server The lic...

Страница 107: ...license types If you are using a legacy license or a new license type your license may not be listed by the installation program If you do not find the license type you need select Unknown or Other fr...

Страница 108: ...to the date the update was released Adaptive Server provides a grace period for updating the licenses after support is renewed The date based version of the license can be determined from the Version...

Страница 109: ...t ID for the machine where license server will be running The license server does not recognize the license files If the license server refuses to serve the licenses this may be because The license wa...

Страница 110: ...If sysam status f feature_name indicates that no licenses are available obtain additional licenses or shutdown existing instances of Adaptive Server If you are using an unserved model The license for...

Страница 111: ...ed licenses even after the issue has been fixed Adaptive Server performs license checks periodically and the license status is not immediately updated It is updated only after the next heartbeat cycle...

Страница 112: ...available licenses on the license server and so on Because what edition and license type is granted cannot be guaranteed Sybase recommends that you set the edition and license type configuration para...

Страница 113: ...fixed within that time Adaptive Server itself shuts down if the graced license is ASE_CORE Enabling and changing e mail notifications You can configure the e mail notification setup using sp_lmconfig...

Страница 114: ...Enabling and changing e mail notifications 100 Adaptive Server Enterprise...

Страница 115: ...n error first look in the log file of the utility being used to identify the task the utility was performing when it failed Then check the server error log See Error log locations on page 103 Table 7...

Страница 116: ...r before restarting Adaptive Server Note Adaptive Server may not start if it cannot find a SySAM license and if the grace period has expired Check the Adaptive Server error log for the cause of the li...

Страница 117: ...each Sybase server Attempts to create a server at the network level Use the Open Client and Open Server configuration utility to edit SYBASE ini libtcl cfg The file should contain one of the followin...

Страница 118: ...rt the installation or upgrade process The Installer fails to start If the Installer does not start restart it using setupConsole exe This displays any error messages to the console which user can the...

Страница 119: ...ring utility for example the pview exe program included with the Microsoft Toolkit to stop the Adaptive Server process Recovering from a failed installation If the installation does not succeed the in...

Страница 120: ...ect Exit 4 Examine the log file created in the SYBASE SYBASE_ASE init logs directory to find out why Adaptive Server failed the pre upgrade eligibility test After you resolve any problems shut down Ad...

Страница 121: ...roblem The most common cause of failure is running out of some resource space either data or log locks auxiliary scan descriptors You can add space to the database using the alter database command Oth...

Страница 122: ...min name from master sysdatabases while dbname is not null begin online database dbname select dbname min name from master sysdatabases where name dbname end Note There are certain upgrade failures f...

Страница 123: ...again and you cannot determine the cause of failure check the error log file to find out when and where the upgrade failed and contact Sybase Technical Support By default the log file is located in SY...

Страница 124: ...ou are upgrading from 32 bit installations to use a 64 bit Adaptive Server the size of each 64 bit compiled object in the sysprocedures table in each database increases by approximately 55 percent whe...

Страница 125: ...e command returns an error because although lock was not reserved in version 11 5 it became a reserved word in version 11 9 2 With this advance notice you can change the stored procedure and any relat...

Страница 126: ...then execute dbcc upgrade_object again You need not do this if the compiled object is upgraded automatically when it is invoked select potential problem areas In Adaptive Server version 11 9 3 and lat...

Страница 127: ...than the view and retaining the pre upgrade results of the select statement is important change the select statement to a select statement with specific column names If the view was created from mult...

Страница 128: ...command procedure upgrades all stored procedures rule upgrades all rules and check constraints trigger upgrades all triggers view upgrades all views The keywords check default procedure rule trigger a...

Страница 129: ...ues must match dbcc upgrade_object master listdb jkarrik list_proc Permissions Only the Database Owner or a System Administrator can execute dbcc upgrade_object The Database Owner can upgrade his or h...

Страница 130: ...be uncommon you can use alter database to extend the free space in the event of insufficient space errors After reloading an older dump run sp_checkreswords from the new installation on the loaded da...

Страница 131: ...sysprocedures version column If the object was upgraded this column will contain the number 12500 If you are upgrading to a 64 bit pointer size in the same version look at the sysprocedures status col...

Страница 132: ...Upgrading compiled objects with dbcc upgrade_object 118 Adaptive Server Enterprise...

Страница 133: ...remove Adaptive Server This does not remove some of the shortcuts created by the Adaptive Server version 15 0 1 installer you must manually remove those shortcuts Uninstalling Adaptive Server 15 0 2...

Страница 134: ...modified after it was installed and requesting confirmation that it should be deleted 8 If there are any user created files left over from the uninstall the uninstaller will prompt user if it can rem...

Страница 135: ...emoving Adaptive Server Installation Guide 121 5 Click Remove Adaptive Server This displays an Existing Servers window 6 Select the server you remove and click OK 7 Restart the computer to reset regis...

Страница 136: ...Removing an old server 122 Adaptive Server Enterprise...

Страница 137: ...nd line argument In cases where the Installer launches automatically select Cancel to cancel the GUI install and then launch the setup program from a terminal or console Then 1 Change the default dire...

Страница 138: ...ered by reading from the response file To perform the silent installation using the resource file that you created by running the Installer through the installation process 1 Change default directory...

Страница 139: ...install or when files have been modified by the user Set the following options at the command line level to specify actions to take when installing in silent mode replaceExistingResponse stores your r...

Страница 140: ...tiple systems from the same resource file by editing a few values in that file Within a single resource file you can create only one server at a time The server files must already exist on the compute...

Страница 141: ...server name To create a server with a different name change the Adaptive Server name and use the new name with the _BK extensions for Backup Server For example the Backup Server for PIANO should be PI...

Страница 142: ...SHOULD BE 30MB The master device size such as 30 for 30MB PATH AND NAME OF YOUR SYBSYSTEMPROCS DEVICE HERE The system procedures path name and file name such as C sybase data sybprocs dat SIZE OF YOUR...

Страница 143: ...the network such as 5001 CHARACTERSET Backup Server The character set used by Backup Server such as CP 850 PUT THE PATH AND NAME OF THE MONITOR ERRORLOG Monitor Server The path in which Monitor Server...

Страница 144: ...Configuration using resource files 130 Adaptive Server Enterprise...

Страница 145: ...get the replicated data into the Replication inbound queue you cannot rebuild the inbound queue after the upgrade The procedures described here do not upgrade Replication Server itself For informatio...

Страница 146: ...o 3 If the command returns 1 for ltm_trunc_state in any database replication is enabled in that database Suspending transaction processing and replication activities To suspend replication of and tran...

Страница 147: ...r each database 1 suspend connection to dataserver database 2 go 6 Leave the DSI connections to the RSSD databases running Draining the transaction logs for primary databases For each primary database...

Страница 148: ...ver execute the admin who sqm command until the last segment block entry for the inbound queue changes 7 Execute the following Replication Server command to dump the last block of the inbound queue to...

Страница 149: ...RSSD When the replication definition is in the replicate RSSD you can assume that the log is processed fully To ensure that the RSSD log is processed 1 Log in to the primary Replication Server and cre...

Страница 150: ...LTM must not be running and the secondary truncation point should be turned off for the duration of the upgrade The Rep Agent or Log Transfer Manager should already be shut down from the previous step...

Страница 151: ...percent of the largest catalog s size The additional 10 percent is for logging upgrade changes You may need more space if you are adding user defined stored procedures 120MBs accommodate additional in...

Страница 152: ...old device alone and add a new device large enough to hold the additional megabytes and alter the sybsystemprocs onto the new device Sybase recommends that you expand the current device v Enlarging t...

Страница 153: ...r system procedures If you cannot fit the enlarged sybsystemprocs database on the system procedures device increase the size of the device and create a new database This procedure involves dropping th...

Страница 154: ...tive Server Enterprise prior to 15 0 you use sysdevices to determine which device has a low through high virtual page range that includes the vstart from Step 2 The device fragment whose vstart you us...

Страница 155: ...sybsystemprocs on sysprocsdev 112 2 go 5 Run the instmstr command in the old release directory For version 12 0 isql Usa Ppassword i SYBASE SYBASE_ASE scripts instmstr oinstmster out For versions earl...

Страница 156: ...Increasing device and database capacity for system procedures 142 Adaptive Server Enterprise...

Страница 157: ...lling via resource file 126 more information about 35 batch installation of servers 126 C commands alter database 137 connectivity 56 conventions used in this manual xiii D database devices 44 databas...

Страница 158: ...mple 54 libtcl cfg file format of 54 location of 54 listen port number finding 57 login sybase 24 administrator Windows NT 52 M Monitor Server entries in sql ini 56 more information about 35 N named p...

Страница 159: ...se device size if adding user defined 137 Sybase installation directory 24 Sybase products installing 39 45 46 Open Client C for Windows 49 sybatch utility 129 sybsystemprocs database preparing for up...

Страница 160: ...Index 146 Adaptive Server Enterprise...

Отзывы:

Нет отзывов

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

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

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