manualshive.com logo in svg

Sybase Adaptive Server 15.0.2, Installation Manual

Share
Download
Sybase Adaptive Server 15.0.2 Installation Manual Download Page 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

Summary of Contents for Adaptive Server 15.0.2

Page 1: ...Installation Guide Adaptive Server Enterprise 15 0 2 HP UX...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

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

Page 13: ...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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 104: ...Recovering from a failed upgrade 90 Adaptive Server Enterprise...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 114: ...Enabling and changing e mail notifications 100 Adaptive Server Enterprise...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 132: ...Upgrading compiled objects with dbcc upgrade_object 118 Adaptive Server Enterprise...

Page 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...

Page 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...

Page 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...

Page 136: ...Removing an old server 122 Adaptive Server Enterprise...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 144: ...Configuration using resource files 130 Adaptive Server Enterprise...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 156: ...Increasing device and database capacity for system procedures 142 Adaptive Server Enterprise...

Page 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...

Page 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...

Page 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...

Page 160: ...Index 146 Adaptive Server Enterprise...

Reviews:

No comments

Brands by name

Popular brands

Load more brands