Sybase ADAPTIVE 15.0.2 User Manual

Installation GuideAdaptive Server® Enterprise15.0.2[ Sun Solaris ]

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

Upgrading high availability 84 Adaptive Server Enterprise10 Use the cluster system command to restart monitoring resources associated with Adaptive

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 853 Follow the upgrade steps provided in “To assist with the upgrade process, Sybase recommen

Migrating from 32-bit to 64-bit versions 86 Adaptive Server Enterprise3 Create devices and databases to match those in the 32-bit server. Make sure

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 875 Copy the 32-bit $SYBASE/$SYBASE_ASE/install/RUN_<server> file to the equivalent 64-

Recovering from a failed upgrade 88 Adaptive Server Enterpriseisql> dump tran dbname with no_logThis frees the log space, and allow the upgrade p

Installation Guide 89CHAPTER 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 90 Adaptive Server Enterprise• If Adaptive Server has started in grace mode – the output from the sp_lmconfig

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

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

CHAPTER 6 Troubleshooting SySAM IssuesInstallation Guide 93The 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 94 Adaptive Server EnterpriseAdaptive Server cannot check out a license and starts with graced license insteadExecute the sysa

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

SySAM grace mode 96 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 97SySAM grace periodTypically, you get a 30-day grace period to resolve any SySAM-related

Enabling and changing e-mail notifications 98 Adaptive Server Enterprise

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

Error log locations 100 Adaptive Server EnterpriseTable 7-1: Troubleshooting guidelines for UNIX platformsError log locationsThe information in the

CHAPTER 7 TroubleshootingInstallation Guide 101Logs for Sybase serversTable 7-3 lists the default error log locations for each Sybase server.Table

Solutions to common installation problems 102 Adaptive Server Enterprise% foreach i(*) ? cat $i | sed -e "s/140/100/g" | sed -e "s/^#

CHAPTER 7 TroubleshootingInstallation Guide 103xhost: unable to open display "host_name"To correct the problem:1 Enter the following comm

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 104 Adaptive Server EnterpriseMsg 11018, Level 16, State 1:Procedure "xp_cmdshell", Line 2:XP Se

CHAPTER 7 TroubleshootingInstallation Guide 105Recovering from a failed installationIf the installation does not succeed, the installation program

Solutions to common installation problems 106 Adaptive Server Enterprise1 From the Upgrade window, select Exit.2 Examine the log file created in the

CHAPTER 7 TroubleshootingInstallation Guide 1071 If an individual database fails to upgrade, you can retry that upgrade manually. Begin by correcti

Solutions to common installation problems 108 Adaptive Server Enterprisewhile @dbname is not null begin online database @dbname select @dbname = min

CHAPTER 7 TroubleshootingInstallation Guide 109If the cause of the failure is unknownIf the upgrade process fails again, and you cannot determine t

Upgrading compiled objects with dbcc upgrade_object 110 Adaptive Server EnterpriseCompiled objects for which the source text was hidden using sp_hid

CHAPTER 7 TroubleshootingInstallation Guide 111Reserved word errorsIf dbcc upgrade_object finds a reserved word used as an object name in a compile

Upgrading compiled objects with dbcc upgrade_object 112 Adaptive Server EnterpriseFor compiled objects created in version 11.9.2 or later, the upgra

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

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

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 existing Adaptive Server 120 Adaptive Server Enterprise4 The component selection window displays with everything selected. Deselect comp

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

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

APPENDIX A Alternative Installation MethodsInstallation Guide 123Except for the absence of the GUI screens all actions of the Installer are the sam

xiv Adaptive Server Enterprise• Commands for both the C shell and the Bourne shell are provided in this document, when they differ. The initializat

Configuration using resource files 124 Adaptive Server EnterpriseConfiguration using resource filesYou can create an Adaptive Server or Backup Serve

APPENDIX A Alternative Installation MethodsInstallation Guide 125• To create a server with a different name, change the Adaptive Server name and us

Configuration using resource files 126 Adaptive Server EnterpriseTable A-1: Resource file attributes for Adaptive ServerResource file attributes for

APPENDIX A Alternative Installation MethodsInstallation Guide 127Table A-2: Resource file attributes for Backup ServerTable A-3: Resource file attr

Configuration using resource files 128 Adaptive Server EnterpriseUsing srvbuildresNote When building a new sever with srvbuild or srvbuildres, conf

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

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

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

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

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

About This BookInstallation Guide xvFor information about how Sybase supports accessibility, see Sybase Accessibility at http://www.sybase.com/ac

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

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

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

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

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

APPENDIX C Using sybsystemprocsInstallation Guide 139If any of the named devices are OS files rather than raw partitions, use the appropriate OS co

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

Installation Guide 141AAdaptive Serverdescribed 8installing multiple 124installing via resource file 124language, changing 35more information

Index142 Adaptive Server EnterpriseHhardware requirements 7Iidentifiersconflicting with reserved words 61installation directoryfor unloading produ

IndexInstallation Guide 143renaming objects 61replicated databaseschecking for 130restoring 74Replication Server 73draining logs for Adaptive

xvi Adaptive Server Enterprise

Index144 Adaptive Server Enterprise

Installation Guide 1CHAPTER 1OverviewThis chapter introduces important concepts about the product and installation of Adaptive Server and Adaptive Ser

Product licensing with SySAM 2.0 2 Adaptive Server EnterpriseProduct licensing with SySAM 2.0Starting with Adaptive Server Enterprise version 15.0,

CHAPTER 1 OverviewInstallation Guide 3Product componentsAdaptive Server Enterprise is based on the client/server model. Each Adaptive Server user i

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

Product components 4 Adaptive Server EnterpriseThe heart of Adaptive Server is the SQL/DBMS engine. The SQL/DBMS engine processes data manipulation

CHAPTER 1 OverviewInstallation Guide 5Figure 1-1: Adaptive Server system modelAdaptive Server editionsAdaptive Server is available in the following

Adaptive Server editions 6 Adaptive Server EnterpriseUse the sp_lmconfig command to determine which edition of Adaptive Server your are running. Ent

CHAPTER 1 OverviewInstallation Guide 7Adaptive Server specificationsTable 1-1 provides Adaptive Server specifications for Sun Solaris.Table 1-1: Ad

Product descriptions and directory layout 8 Adaptive Server EnterpriseTable 1-2: Product descriptionProduct DescriptionAdaptive Server and Historica

CHAPTER 1 OverviewInstallation Guide 9PC-Client product descriptions and directory layoutThe following products are installed as Adaptive Server PC

PC-Client product descriptions and directory layout 10 Adaptive Server EnterpriseTable 1-3: Products and platformsProduct DescriptionSoftware Develo

CHAPTER 1 OverviewInstallation Guide 11Separately installable PC-Client productsThe PC-Client CD also contains the following products, which are se

PC-Client product descriptions and directory layout 12 Adaptive Server Enterprise

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

ContentsInstallation Guide iiiAbout This Book ...

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 15For information about served and unserved licenses, and which model is best suited for you

Pre-installation tasks for SySAM 16 Adaptive Server EnterpriseTo access SPDC when you have purchased Sybase products from Sybase:1 Once you have ord

CHAPTER 2 Installing Adaptive ServerInstallation Guide 174 Save the host ID so you can use it later at SPDC. Your host ID is platform-specific, but

Pre-installation tasks for SySAM 18 Adaptive Server Enterprise7 Step one of the SySAM license generation wizard asks you to choose between a served

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

Pre-installation tasks for SySAM 20 Adaptive Server Enterprise6 Once you have generated all the licenses you need, save them to the specific locatio

CHAPTER 2 Installing Adaptive ServerInstallation Guide 214Go to the Sybase Product Download Center (SPDC) at https://sybase.subscribenet.com.5 Gene

Pre-installation tasks for Adaptive Server 22 Adaptive Server EnterprisePre-installation tasks for Adaptive ServerBefore installing Adaptive Server:

CHAPTER 2 Installing Adaptive ServerInstallation Guide 237 Decide where the Adaptive Server software will be installed. Make sure there is sufficie

ContentsivAdaptive Server EnterpriseInstalling the Adaptive Server version 15.0.2 binary overlay... 36Backward compatibility with previous Adaptive Se

Pre-installation tasks for Adaptive Server 24 Adaptive Server Enterprise12 Verify that your network software is configured.Sybase software uses netw

CHAPTER 2 Installing Adaptive ServerInstallation Guide 25project-sybase:200:For use by Sybase:sybase:sybase:project.max-shm-memory=\(privileged,171

Installing server components 26 Adaptive Server EnterpriseTo adjust shared memory segments of the operating system, add the following line to the co

CHAPTER 2 Installing Adaptive ServerInstallation Guide 27Installation methodsThe following instructions are for using the Installer in GUI mode. Yo

Installing server components 28 Adaptive Server EnterpriseNot every country is listed in the drop-down list. If the country you are located in is no

CHAPTER 2 Installing Adaptive ServerInstallation Guide 298 If you select Custom, the Products and Features Selection window displays. Select the pr

Installing server components 30 Adaptive Server EnterpriseIf you answer No, you will be using unserved licenses. You will be reminded to download an

CHAPTER 2 Installing Adaptive ServerInstallation Guide 31• Configure new Backup Server• Configure new Monitor Server• Configure new XP Server• Conf

Installing server components 32 Adaptive Server Enterprise• Custom configure new Job Schedule• Custom configure Self Management• Custom configure We

CHAPTER 2 Installing Adaptive ServerInstallation Guide 33• 4K page size server – 6MB• 8K page size server – 12MB• 16K page size server – 24MB• Syst

ContentsInstallation Guide vReenabling auditing... 75Shutting down SySAM servers...

Installing server components 34 Adaptive Server Enterprise23 Custom configure Self Management by entering the following information:• Self Managemen

CHAPTER 2 Installing Adaptive ServerInstallation Guide 3530 The Installation Complete window is the last window. If you encounter any errors, see t

Installing version 15.0.2 over an existing 15.x Adaptive Server 36 Adaptive Server EnterpriseInstalling version 15.0.2 over an existing 15.x Adaptiv

CHAPTER 2 Installing Adaptive ServerInstallation Guide 37This document may also contain last minute installation information for the 15.0.2 install

Installing version 15.0.2 over an existing 15.x Adaptive Server 38 Adaptive Server EnterpriseYou can downgrade to earlier 15.x versions of Adaptive

Installation Guide Evaluation Version 39CHAPTER 3Post-Installation TasksAfter the installation process, you have a minimally configured Adaptive Serve

Connecting to Adaptive Server via Sybase Central 40 Adaptive Server Enterpriseisql -Usa -P<password or leave it blank>-Sserver_namewhere serve

CHAPTER 3 Post-Installation TasksInstallation Guide Evaluation Version 415 Click OK.The Adaptive Server plug-in to Sybase Central does not display

Installing sample databases 42 Adaptive Server EnterpriseThe reports provided by SAMreport belong to three report families:• Summary reports – summa

CHAPTER 3 Post-Installation TasksInstallation Guide Evaluation Version 43Default devices for sample databases The %SYBASE%\SYBASE_ASE%\scripts dire

ContentsviAdaptive Server EnterpriseUninstalling Adaptive Server 15.0.2... 119Removing an existing Adaptive

Installing sample databases 44 Adaptive Server EnterpriseFrom the Adaptive Server scripts directory ($SYBASE/$SYBASE_ASE/scripts), use isql to log i

CHAPTER 3 Post-Installation TasksInstallation Guide Evaluation Version 452 Determine the type (raw partition, logical volume, operating system file

Installing sample databases 46 Adaptive Server Enterpriseisql -Usa -Ppassword -Sservername -Jeucjis \ -i $SYBASE/$SYBASE_ASE/scripts/eucjis/installj

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

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

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

Installing PC-Client products 50 Adaptive Server Enterprise7 When the Sybase license agreement displays, select a country, click Agreement, then cli

CHAPTER 4 Installing Sybase PC-Client ProductsInstallation Guide 51If the target directory does not have enough free space, the available space app

Configuring network connections for client products 52 Adaptive Server EnterpriseFor a 64-bit LDAP driver, the format is:[DIRECTORY]ldap=libsybdldap

CHAPTER 4 Installing Sybase PC-Client ProductsInstallation Guide 53• Select the transport type from the drop-down list.• Enter the host name.• Ente

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 54 Adaptive Server EnterpriseIf prompted to start Adaptive Server, click OK. When the traffic li

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

Overview of the upgrade process 56 Adaptive Server Enterprise•12.5.xNote Adaptive Server version 15.0.2 does not support upgrade from Adaptive Serv

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

Pre-upgrade tasks 58 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 59You also can set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS environment variables to t

Pre-upgrade tasks 60 Adaptive Server Enterprise4 Verify that you unloaded Adaptive Server 15.0.2 in a different directory than your previous Adaptiv

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 61Reserved wordsReserved words are pieces of SQL syntax that have special meaning when used a

Pre-upgrade tasks 62 Adaptive Server EnterpriseIf you use either sqlupgrade or sqlupgraderes, they automatically install new reserved words and sp_c

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 63To avoid reserved word conflicts, all users on the server must invoke the quoted_identifier

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

Pre-upgrade tasks 64 Adaptive Server Enterprise2> goNote The model database cannot be larger than the tempdb. If your changes cause the model da

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 65sybsystemprocssybprocsdev is the default name for the device-holding database sybsystemproc

Pre-upgrade tasks 66 Adaptive Server EnterpriseTo upgrade using sqlupgrade: 1 Make sure your current server is running.2 Verify that you have perfor

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 67sqlupgrade displays the Status Output window.View the Status Output window for the completi

Pre-upgrade tasks 68 Adaptive Server EnterpriseUsing sqlupgraderesYou can upgrade Adaptive Server in noninteractive mode by using values from a reso

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 69Table 5-1: Resource file attributes for upgrading Adaptive ServerUpgrading using sqlupgrade

Post-upgrade tasks 70 Adaptive Server EnterpriseRun the instmsgs.ebf scriptYou must run the instmsgs.ebf script after you upgrade from a 15.0 Adapt

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 71For example, if procedure cache percent is configured as 20 percent of 200MB of memory, the

Post-upgrade tasks 72 Adaptive Server EnterpriseIn pre-12.5 versions of Adaptive Server, the default data cache available depended on the amount of

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 73Reenabling Replication ServerIf you disabled replication before the upgrade, you must reena

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

Post-upgrade tasks 74 Adaptive Server Enterprise6 Resume the DSI connections that were suspended before the upgrade by executing the following Repli

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 755 Log in to the Replication Server, and resume the Log Transfer connection for each replica

Upgrading Backup Server, Monitor Server, and XP Server 76 Adaptive Server Enterprise1> sp_audit "security", "all", "all&

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 77XP Server does not have a formal upgrade process. Note Back up all databases, including ma

Upgrading Job Scheduler 78 Adaptive Server EnterpriseUpgrading Job SchedulerAfter upgrading to the new Adaptive Server, perform the following steps

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 79goalter database sybmgmtdb LOG on sybmgmtdev=20go9 Upgrade the sybmgmtdb. Using isql, run t

Upgrading Job Scheduler 80 Adaptive Server Enterprise4 If you have modified any of the Sybase-supplied templates stored procedures or XML documents,

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 816 Some Job Scheduler templates were modified to support new 15.0.2 Adaptive Server function

Upgrading Job Scheduler 82 Adaptive Server Enterprise7 Install the Template stored procedures. • Move to the JS template stored procedure directory.

CHAPTER 5 Upgrading Adaptive ServerInstallation Guide 83Upgrading high availabilityUsing the following steps to upgrade high availability-enabled A