Sybase 15.0.2 User Manual

Installation GuideAdaptive Server® Enterprise15.0.2[ HP-UX ]

x Adaptive Server Enterprise• Monitoring and Analyzing – explains how statistics are obtained and used for monitoring and optimizing performance.•

Migrating from 32-bit to 64-bit versions 86 Adaptive Server Enterprise2 Use the cluster system command to stop monitoring resources associated with

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 873 Create devices and databases to match those in the 32-bit server. Make sure that the sysu

Recovering from a failed upgrade 88 Adaptive Server Enterprise5 Copy the 32-bit $SYBASE/$SYBASE_ASE/install/RUN_<server> file to the equivalen

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 89isql> alter database dbname on device_name = "2m"Note In 15.0.2 Adaptive Serv

Recovering from a failed upgrade 90 Adaptive Server Enterprise

Installation Guide 91CHAPTER 6Troubleshooting SySAM IssuesNote If SySAM 2.0 related errors are not addressed in a timely fashion, Adaptive Server may

Where to look for SySAM-related errors 92 Adaptive Server Enterprise• If Adaptive Server has started in grace mode – the output from the sp_lmconfig

CHAPTER 6 Troubleshooting SySAM IssuesInstallation Guide 93If you are using a served license model, the license server’s debug log located in the l

Troubleshooting SySAM 94 Adaptive Server EnterpriseThe installation program produces a warning about not finding a suitable licenseIf you select a s

CHAPTER 6 Troubleshooting SySAM IssuesInstallation Guide 95The license server does not startThe most common cause for the license server failing to

About This BookInstallation Guide xi• Web Services User’s Guide – explains how to configure, use, and troubleshoot Web Services for Adaptive Serv

Troubleshooting SySAM 96 Adaptive Server EnterpriseAdaptive Server cannot check out a license and starts with graced license insteadExecute the sysa

CHAPTER 6 Troubleshooting SySAM IssuesInstallation Guide 97Adaptive Server cannot checkout a license and starts with graced license instead (contin

SySAM grace mode 98 Adaptive Server EnterpriseSySAM grace modeIf Adaptive Server cannot find a required license, it continues to operate in grace mo

CHAPTER 6 Troubleshooting SySAM IssuesInstallation Guide 99SySAM grace periodTypically, you get a 30-day grace period to resolve any SySAM-related

Enabling and changing e-mail notifications 100 Adaptive Server Enterprise

Installation Guide 101CHAPTER 7TroubleshootingThis chapter provides instructions for troubleshooting installation error messages.If this chapter does

Overview 102 Adaptive Server EnterpriseTable 7-1: Troubleshooting guidelines for WindowsProblem Possible cause and solutionThe installation program

CHAPTER 7 TroubleshootingInstallation Guide 103Error log locationsThe information in the error logs helps you determine the reason and possible sol

Solutions to common installation problems 104 Adaptive Server EnterpriseTable 7-3: Default locations for error log filesSolutions to common installa

CHAPTER 7 TroubleshootingInstallation Guide 1051 From Windows, go to the MS-DOS command prompt window.2Start isql and connect to Adaptive Server: %

xii Adaptive Server Enterprise• The Sybase Product Manuals Web site is an online version of the SyBooks CD that you can access using a standard Web

Solutions to common installation problems 106 Adaptive Server Enterprise4 If the installation fails after the installation program starts the Adapti

CHAPTER 7 TroubleshootingInstallation Guide 107If you think the upgrade failure or its cause may have damaged your databases, restore the databases

Solutions to common installation problems 108 Adaptive Server Enterprise2 If the failure occurs after all databases have been upgraded, or if a fail

CHAPTER 7 TroubleshootingInstallation Guide 1092 Perform the necessary actions to fix the problem.For example, if the error log indicates that the

Upgrading compiled objects with dbcc upgrade_object 110 Adaptive Server EnterpriseFor example, if you have a user-defined stored procedure named lis

CHAPTER 7 TroubleshootingInstallation Guide 111After reviewing the errors and potential problem areas, and fixing those that need to be changed, yo

Upgrading compiled objects with dbcc upgrade_object 112 Adaptive Server EnterpriseIf quoted identifier errors occur, use the set command to activate

CHAPTER 7 TroubleshootingInstallation Guide 113Determining whether select * should be changed in viewsIf dbcc upgrade_object reports the existence

Upgrading compiled objects with dbcc upgrade_object 114 Adaptive Server Enterprise• dbid – specifies the database ID. If you do not specify dbid, al

CHAPTER 7 TroubleshootingInstallation Guide 115Example 2 Upgrades all stored procedures in the listdb database. Single quotes are used around proce

About This BookInstallation Guide xiiiSybase EBFs and software maintenancev Finding the latest information on EBFs and software maintenance1 Poin

Upgrading compiled objects with dbcc upgrade_object 116 Adaptive Server EnterpriseError reportingTo send all the output from dbcc upgrade_object to

CHAPTER 7 TroubleshootingInstallation Guide 117Determining whether a compiled object has been upgraded To determine whether a compiled object has b

Upgrading compiled objects with dbcc upgrade_object 118 Adaptive Server Enterprise

Installation Guide 119CHAPTER 8Removing Adaptive ServerOnly actions performed by the Installer are removed during an uninstallation process. This mean

Removing an old server 120 Adaptive Server Enterprise5 The component selection window displays with everything selected. Deselect components by clic

CHAPTER 8 Removing Adaptive ServerInstallation Guide 1215 Click Remove Adaptive Server. This displays an Existing Servers window.6 Select the serve

Removing an old server 122 Adaptive Server Enterprise

Installation Guide 123APPENDIX AAlternative Installation MethodsInstallation on consoles (non-GUI mode)In cases where there is no graphics display dev

Silent installation 124 Adaptive Server EnterpriseSilent installationA silent installation (sometimes referred to as an unattended install) is done

APPENDIX A Alternative Installation MethodsInstallation Guide 125In either case it is possible to custom configure the servers as well as being abl

xiv Adaptive Server EnterpriseTable 1: SQL syntax conventionsAccessibility featuresThis document is available in an HTML version that is specialize

Configuration using resource files 126 Adaptive Server Enterprise.\setupConsole -silent -options <responseFileName> -W SybaseLicense.agreeToLi

APPENDIX A Alternative Installation MethodsInstallation Guide 127Edit the resource file using a text editor such as Windows Notepad. You might want

Configuration using resource files 128 Adaptive Server EnterpriseResource file variablesTable A-1 lists the resource file variables. Before running

APPENDIX A Alternative Installation MethodsInstallation Guide 129Running the sybatch utilityTo configure Adaptive Server with the sybatch utility:

Configuration using resource files 130 Adaptive Server Enterprise

Installation Guide 131APPENDIX BUpgrading Servers with Replicated DatabasesIntroductionAfter you have upgraded, you will no longer be able to scan any

Suspending transaction processing and replication activities 132 Adaptive Server Enterprise• Disabling the log truncation point.After upgrading to v

APPENDIX B Upgrading Servers with Replicated DatabasesInstallation Guide 133The status of all existing routes should be “Active.” If any routes are

Draining the transaction logs for primary databases 134 Adaptive Server Enterprise5Use isql to update one row in a single replicated table in the pr

APPENDIX B Upgrading Servers with Replicated DatabasesInstallation Guide 1352> go12 If you are using LTM, shut down the LTM.After draining the t

Installation Guide Evaluation Version 1CHAPTER 1OverviewThis chapter introduces important concepts about the product and installation of Adaptive Serv

Disabling the secondary truncation point 136 Adaptive Server Enterprise3 Log in to the replicate Replication Server and suspend the Log Transfer con

Installation Guide 137APPENDIX CUsing sybsystemprocsIntroductionNote sysprocsdev is the default system name for this device. However, it is frequentl

Increasing the size of the sybsystemprocs database 138 Adaptive Server EnterpriseUse sp_helpdevice to determine the size of the sysprocsdev device:1

APPENDIX C Using sybsystemprocsInstallation Guide 139If there is space available on another device, you can expand sybsystemprocs to a second devic

Increasing device and database capacity for system procedures 140 Adaptive Server Enterpriseand not exists (select vstartfrom sysusages u2where u2.d

APPENDIX C Using sybsystemprocsInstallation Guide 1411> create database sybsystemprocs on sysprocsdev = 1122> go5Run the instmstr command in

Increasing device and database capacity for system procedures 142 Adaptive Server Enterprise

Installation Guide 143AAdaptive Serverdescribed 8entries in sql.ini 56installing multiple 126installing via resource file 126language, changin

Index144 Adaptive Server EnterpriseIidentifiersconflicting with reserved words 65installation directoryfor unloading products 24installingOpen Cli

IndexInstallation Guide 145draining logs for Adaptive Server 75, 133reserved wordschecking for conflicts 66using quoted identifiers 66resource f

Product licensing with SySAM 2.0 2 Adaptive Server Enterprise• For information about uninstalling Adaptive Server, see Chapter 8, “Removing Adaptive

Index146 Adaptive Server Enterprise

CHAPTER 1 OverviewInstallation Guide Evaluation Version 3The Adaptive Server Installation Guide (this document) has the following information about

Product components 4 Adaptive Server EnterpriseAll server processes share two distinct areas of shared memory: a kernel area and a DBMS area. The ke

CHAPTER 1 OverviewInstallation Guide Evaluation Version 5Stored proceduresStored procedures encapsulate a series of SQL commands that the server ca

DOCUMENT ID: 35890-01-1502-01LAST REVISED: April 2007Copyright © 1987-2007 by Sybase, Inc. All rights reserved.This publication pertains to Sybase sof

Adaptive Server editions 6 Adaptive Server Enterprise• Small Business Edition – has some limit on scalability, and can run a limited set of options

CHAPTER 1 OverviewInstallation Guide Evaluation Version 7Developer EditionThe Developer Edition (DE) is a competitively-priced version of Adaptive

Product descriptions and directory layout 8 Adaptive Server EnterpriseNote For more information about Adaptive Server specifications see Chapter 1,

CHAPTER 1 OverviewInstallation Guide Evaluation Version 9Software Developer Kit (SDK)Installed into the OCS-15_0 directory.• Open Client (Ctlib, db

Product descriptions and directory layout 10 Adaptive Server EnterpriseSybase support for ADO.NET, OLE DB, and ODBCAdaptive Server version 15.0.2 co

CHAPTER 1 OverviewInstallation Guide Evaluation Version 11Installing ODBC driver from ASE 15.x or SDK 15.x on top of an IQ 12.6 installation might

PC-Client product descriptions and directory layout 12 Adaptive Server EnterpriseSeparately installable PC-Client productsThe PC-Client CD also cont

Installation Guide 13CHAPTER 2Installing Adaptive ServerThis chapter provides instructions for installing a new Adaptive Server, Backup Server, and Mo

System requirements 14 Adaptive Server Enterprise3 Perform the installation using any of the methods described in “Installation methods” on page 27.

CHAPTER 2 Installing Adaptive ServerInstallation Guide 15Table 2-5: Disk space requirements for Windows platformsPre-installation tasks for SySAMBe

ContentsInstallation Guide iiiAbout This Book ...

Pre-installation tasks for SySAM 16 Adaptive Server Enterprise• For information about creating a new license server before installing Adaptive Serve

CHAPTER 2 Installing Adaptive ServerInstallation Guide 171 Once you have ordered a Sybase product you receive a welcome e-mail that contains a URL

Pre-installation tasks for SySAM 18 Adaptive Server Enterprise778DA450 or #2005771344 on HP-UX PA-RISC platforms, or ID_STRING=9c766319-db72-d411-af

CHAPTER 2 Installing Adaptive ServerInstallation Guide 196 Once you’ve determined the license you wish to generate, select it via the Generate radi

Pre-installation tasks for SySAM 20 Adaptive Server Enterprised You should have gotten your server host ID before you began the process of generatin

CHAPTER 2 Installing Adaptive ServerInstallation Guide 21• Download the license file by clicking the Download License File button.• Print a paper c

Pre-installation tasks for SySAM 22 Adaptive Server Enterprisee Enter or select the destination directory.f Select the Custom installation.g Select

CHAPTER 2 Installing Adaptive ServerInstallation Guide 23> sysam startStarting the SYSAM serviceThe SYSAM service is starting.The SYSAM service

Pre-installation tasks for Adaptive Server 24 Adaptive Server Enterprise4 Review the SySAM procedures and plan your client/server configuration usin

CHAPTER 2 Installing Adaptive ServerInstallation Guide 25• Severity level of an event that will trigger mail. Your choices are:• None• Informationa

ContentsivAdaptive Server EnterpriseBacking up Adaptive Server... 36Installing the Adaptive Server ve

Pre-installation tasks for Adaptive Server 26 Adaptive Server EnterpriseAdaptive Server may allocate shared memory segments after start-up if any re

CHAPTER 2 Installing Adaptive ServerInstallation Guide 27Installing server componentsFollow the instructions in this section to install Adaptive Se

Installing server components 28 Adaptive Server EnterpriseAt the end of the installation, you can verify the product installation. You may need to p

CHAPTER 2 Installing Adaptive ServerInstallation Guide 29installing Sybase Central and Adaptive Server plugin in?If you choose “no” to above questi

Installing server components 30 Adaptive Server Enterprise12 The Sybase Software Asset Management License Server screen allows you to designate wher

CHAPTER 2 Installing Adaptive ServerInstallation Guide 31• Small Business Edition• Developers Edition• Express EditionNote You must select only th

Installing server components 32 Adaptive Server Enterprise• Monitor Server – <host name>_MS• XP Server – <host name>_XP• Job Scheduler A

CHAPTER 2 Installing Adaptive ServerInstallation Guide 33• Master database size (MB). The minimum master database sizes are:• 2K page size – 13MB•

Installing server components 34 Adaptive Server EnterpriseOnce you have entered the appropriate information, click Next to record the information.22

CHAPTER 2 Installing Adaptive ServerInstallation Guide 35Select the Enable box to enable a login module. To order the modules according to priority

ContentsInstallation Guide vRun the instmsgs.ebf script... 71Restoring functionality in Adaptive Ser

Installing version 15.0.2 over an existing 15.x Adaptive Server 36 Adaptive Server EnterpriseUnified AgentUnified Agent and Agent Management Console

CHAPTER 2 Installing Adaptive ServerInstallation Guide 37Installing the Adaptive Server version 15.0.2 binary overlay1 Read “Special Installation I

Installing version 15.0.2 over an existing 15.x Adaptive Server 38 Adaptive Server EnterpriseBackward compatibility with previous Adaptive Server 15

Installation Guide 39CHAPTER 3Post-Installation TasksAfter the installation process, you have a minimally configured Adaptive Server. This chapter des

Verifying that servers are running 40 Adaptive Server Enterprise2 Identify the drives and folders where the Adaptive Server software is installed, a

CHAPTER 3 Post-Installation TasksInstallation Guide 41The Status column indicates if it is started. If it is not, select the server, then click Sta

Connecting to Adaptive Server via Sybase Central 42 Adaptive Server EnterpriseConnecting to Adaptive Server via Sybase CentralSybase Central provide

CHAPTER 3 Post-Installation TasksInstallation Guide 43The System Administrator should log in to the new Adaptive Server as “sa” and set a password

Installing sample databases 44 Adaptive Server EnterpriseInstalling sample databases This section describes how to install the U.S. English and inte

CHAPTER 3 Post-Installation TasksInstallation Guide 45If you have not used sp_diskdefault to change the status of the master device or to specify a

ContentsviAdaptive Server EnterpriseSilent installation ... 124Configuration us

Installing sample databases 46 Adaptive Server Enterprise-Sservername -i%SYBASE%\%SYBASE_ASE%\scripts\instpix2Note The image data requires a fair a

CHAPTER 3 Post-Installation TasksInstallation Guide 47For more information on the -J option in isql, see the Utility Guide.jpubs databaseIf you ins

Installing sample databases 48 Adaptive Server EnterpriseMaintaining the sample databasesThe sample databases contain a guest user that allows acces

Installation Guide 49CHAPTER 4Installing Sybase PC-Client ProductsAdaptive Server also includes PC-Client products, and this chapter describes how to

Before you install the PC-Client products 50 Adaptive Server Enterprise• Extended Architecture (XA)• jConnect for JDBC• ASE ODBC driver by Sybase• A

CHAPTER 4 Installing Sybase PC-Client ProductsInstallation Guide 51• Install PowerDesigner 12.0• Install PowerTransfer 15.0• Install InfoMaker 10.5

Installing PC-Client products 52 Adaptive Server EnterprisePC-Client Components are provided so they can be installed on client computers. You may i

CHAPTER 4 Installing Sybase PC-Client ProductsInstallation Guide 539 Select the type of installation to be performed.• Typical Install – installs t

Configuring network connections for client products 54 Adaptive Server EnterpriseConfiguring network connections for client productsAdaptive Server

CHAPTER 4 Installing Sybase PC-Client ProductsInstallation Guide 55• Remove the semicolon (;) comment markers from the beginning of the LDAP URL li

Installation Guide viiAbout This BookThe Installation Guide for Sybase Adaptive Server Enterprise for 15.0.2 provides: • An overview of the Sybase® Ad

Configuring network connections for client products 56 Adaptive Server Enterprise• HA server name – optional. This is the name of the high-availabil

CHAPTER 4 Installing Sybase PC-Client ProductsInstallation Guide 578 In the Network Address box, you can enter either the server name or the IP add

Configuring network connections for client products 58 Adaptive Server Enterprise• Historical Server User’s GuideTesting the Sybase Central installa

Installation Guide 59CHAPTER 5Upgrading Adaptive ServerThis chapter describes the various steps for upgrading Adaptive Server to version 15.0.2. If yo

Overview of the upgrade process 60 Adaptive Server EnterpriseOverview of the upgrade processYou can upgrade to Adaptive Server 15.0.2 from any of th

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 61c Run the upgrade process.Note Adaptive Server issues advisory warnings when configuration

Pre-upgrade tasks 62 Adaptive Server EnterprisePre-upgrade tasksNote Before you begin the upgrade process, install Adaptive Server 15.0.2 onto your

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 63You also can set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS environment variable to th

Pre-upgrade tasks 64 Adaptive Server EnterpriseNoting server and device names and locationsBy default, the master (master.dat) and system procedures

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 65As part of the pre-upgrade process, syconfig.exe or sybatch.exe can perform the reserved wo

viii Adaptive Server Enterprise• Chapter 5, “Upgrading Adaptive Server,” describes how to upgrade an existing Adaptive Server to the current versio

Pre-upgrade tasks 66 Adaptive Server EnterpriseRun sp_checkreswords in master and in each user database to display the names and locations of confli

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 671In isql, use alter database to increase the size of the master database. For example: 1>

Upgrading to Adaptive Server 15.0.2 68 Adaptive Server EnterpriseIf you do not have a sybsystemdb databaseIf you do not have a sybsystemdb, and will

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 69Set the OLDSYBASE_ASE variable to the SYBASE_ASE appropriate to your older server. If you a

Upgrading to Adaptive Server 15.0.2 70 Adaptive Server Enterprise6 In the Password window, enter the administrator login name and password.7 Choose

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 71After Adaptive Server starts, a green light appears next to the server name.3 When prompted

Post-upgrade tasks 72 Adaptive Server EnterpriseRestoring functionality in Adaptive Server To reset or enable options or functionality you had to ch

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 735 Check the procedure cache requirements.Stored procedures, triggers, and other compiled ob

Post-upgrade tasks 74 Adaptive Server EnterpriseIn pre-12.5 Adaptive Server, it meant all the memory left after allocating memory for other configur

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 752> goReenabling replicationFollow the steps in this section to reenable replication afte

About This BookInstallation Guide ix• Component Integration Services User’s Guide – explains how to use the Adaptive Server Component Integration

Post-upgrade tasks 76 Adaptive Server EnterpriseRestoring replication after upgrade Restore the replication functionality:1 Log in to the RSSD for

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 77Reenabling auditingReenable all auditing options for stored procedures using the audit opti

Upgrading Backup Server, Monitor Server, and XP Server 78 Adaptive Server Enterprisealter table MyPre15SysAuditHistoryTable add nodeid tinyint NULLS

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 797 Back up all existing databases before upgrading. Once you have done so, select Yes.8 When

Upgrading Job Scheduler 80 Adaptive Server EnterpriseThere is no need to specify any parameters.6 Restart Adaptive Server.7If the sybmgmtdev device

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 81v Upgrading Job Scheduler templates1 Disable Job Scheduler before ugrading Job Scheduler te

Upgrading Job Scheduler 82 Adaptive Server Enterprise6 Some Job Scheduler templates were modified to support new 15.0.2 Adaptive Server functionalit

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 837 Install the Template stored procedures. • Move to the JS template stored procedure direct

Upgrading high availability 84 Adaptive Server EnterpriseUse “en” for the language_code or you may omit the parameter completely as “en” is the defa

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 859 Manually restart Adaptive Server on each cluster node with trace flag 2209. Use the Adapt