Red Hat NETSCAPE ENTREPRISE SERVER 6.0 - INSTALLATION AND MIGRATION GUIDE Installationsanleitung

Installation GuideAdaptive Server® Enterprise15.7 ESD #2Linux

Contentsx Adaptive Server Enterprise

Reenabling AuditingIf the server you upgraded from was configured for auditing, reenable auditing in the upgradedserver.1.Enter:sp_configure 'aud

1> dump transaction sales with truncate_only2> go3.Reenable replication.Restoring Replication on Replicate DatabasesRestore replication if you h

1> rs_zeroltm dataserver, database2> go2.Log in to each replicated primary, and replicated RSSD and issue:1> use database2> go1> dbcc s

2.Create a 64-bit server in a new directory.3.Create devices and databases to match those in the 32-bit server. Make sure the sysusagesmapping is corr

4.Copy the interfaces file and the configuration file from the 32-bit $SYBASEdirectory to the 64-bit $SYBASE directory.5.Copy the 32-bit $SYBASE/$SYBA

1> sp_configure "number of locks", 90002> go5.Upgrade the internal Job Scheduler SQL code using:1> use sybmgmtdb2> go1> dbcc

4.If you modified Sybase-supplied templates, stored procedures, or XML documents, do notoverlay the new templates with your modified versions. If you

Template Modified Files Datatype for <parameter>Changed from varchar(5)to intreclaim tablesSybReclaimTableTem-plate.xmljst_reclaim_table_space@r

Template Modified File Change Descrip-tionJob Modificationsreclaim in-dexesSybReclaimIndex-Template.xmljst_reclaim_in-dex_spaceAdded @ptn_name asthird

• HP-UX – MCSG 11.17• HPIA – MCSG 11.18• IBM AIX – HACMP 5.4• Sun Solaris – VCS4.0, SunCluster 3.2• Linux-AMD – VCS4.1• Win2003 – Cluster Manager 5.2T

CHAPTER 1ConventionsThese style and syntax conventions are used in Sybase® documentation.• In a sample window display, commands to be entered exactly

2.Upgrade the cluster subsystem on N2 following the upgrade instructions from thevendor.3.Start ASE2 by bringing the secondary resource group online t

3.Perform the upgrade steps as prompted.See also• Upgrade to Adaptive Server 15.7 ESD #2 on page 83Upgrading Databases Using Dump and LoadWhen you upg

Compiled objects for which the source text was hidden using sp_hidetext are upgraded in thesame manner as objects for which the source text is not hid

Problem Description SolutionReserved word er-rorsIf you load a database dump from an earlierversion of Adaptive Server into Adaptive Serv-er 15.7 or l

select name from syscolumns where id = object_id("employees")3.Compare the output of the two queries by running sp_help on both the view a

CHAPTER 11Adaptive Server DowngradesAn Adaptive Server that has been upgraded to 15.7 or later requires specifics tasks before itcan be downgraded.Eve

alter table @tablename set compression = nonereorg rebuild @tablename• If any table uses LOB compression or in-row LOBs:a) Copy the data from that tab

2.Make sure Adaptive Server 15.7 ESD #2 is prepared for downgrade by executing thiscommand from the master database:sp_downgrade 'prepare',

and print on the console. Save the output of sp_downgrade 'downgrade', <version> into afile, so the passwords are not lost. To regener

where:•@db_name – is the name of the database you are downgrading•@esd – is the ESD number you are downgrading to. The valid options are:• "ESD1&

CHAPTER 1: Conventions2 Adaptive Server Enterprise

Dumping a 15.7 ESD #2 Database to Load into a 15.7 or 15.7ESD #1 Adaptive ServerUsing sp_downgrade_esd on an Adaptive Server 15.7 ESD #2 database allo

Additional Considerations for New Features UsedAdditional downgrade steps may be necessary due to Adaptive Server 15.7 or later featuresthat are unava

Feature ConsiderationsUnicode non-charactersIf you used sp_configure to enable functionality group or permissive Unicode inAdaptive Server 15.7 ESD #2

See also• Downgrading from Adaptive Server 15.7 ESD #2 on page 106Downgrading an Adaptive Server That Uses EncryptionDowngrade an Adaptive Server vers

Downgrade Considerations for Adaptive Server withReplicated DatabasesSpecial considerations exist for downgrading Adaptive Server version 15.7 that us

stored procedures introduced in releases subsequent to the downgraded server are notremoved.Warning! Executing new stored procedures against an older

CHAPTER 11: Adaptive Server Downgrades116 Adaptive Server Enterprise

CHAPTER 12Troubleshooting SySAM ErrorsTroubleshoot the most common SySAM errors.See your Sybase product documentation for product-specific information

Error Possible Causes SolutionUpdating an ExistingInstallationIf you are updating an existinginstallation, make sure your li-cense authorizes you to i

Error Possible Causes SolutionLicense Server Doesnot Recognize the Li-cense Files• The license was generatedfor a different machine orgenerated using

CHAPTER 2Installation Task OverviewTo successfully install and configure Adaptive Server® Enterprise, use the configurationguide along with this insta

Error Possible Causes SolutionProduct Does notStart, License Check-out Error• You have not generatedand deployed the valid li-censes for the product r

Error Possible Causes SolutionProduct CannotCheck Out a Licenseand Starts in GracePeriodTo help you determine the pos-sible causes when your productca

Error Possible Causes SolutionProduct Obtains theWrong LicenseThese locations are searched,in the order specified, until asuitable license is found. W

Installing for the First TimeThe installer or product cannot find a valid license and issues a warning.1.If the installation fails, go to SPDC or SMP

• The licenses on one machine were generated for a different machine – examine the host IDrecorded next to the value in the license file host name in

Possible Causes SolutionsThe available licenses are for a different operatingsystem or architecture than the machine on whichyou are running your prod

Served License Deployment ModelsLearn about license checkout problems for served licenses.Possible Cause SolutionThe license server may not be running

Possible Cause SolutionCannot connect to the license server Ensure that the client can connect to both TCP/IPports used by the license server. If ther

• The output from:sysam diag feature_name• The license server software version• The license server debug log file• The licenses that are saved in the

CHAPTER 13Troubleshoot the ServerDetermine the cause of problems and apply the recommended solution.To determine the cause of an error, first look in

Upgrading to a New Version1.Determine your upgrade eligibility, plan your installation, and review systemrequirements.2.Run the preupgrade utility to

Error Logs for Installation UtilitiesThe information in the error logs may help determine the reason and possible solutions forproblems with installat

Troubleshooting Common Installation ProblemsIdentify the cause of installation problems and apply the recommended solutions.Problem ResolutionCannot u

Problem ResolutionClient not au-thorized to con-nect to server.This error message means the remote machine does not have permission to displaythe user

Stopping Adaptive Server After a FailureIf the installation or upgrade session fails after you start Adaptive Server for any reason, usethe shutdown c

2.Examine the log file in $SYBASE/$SYBASE_ASE/init/logs.After you resolve any problems, shut down Adaptive Server and use sqlupgrade tocomplete the up

• If you are concerned about the possible corruption of your databases, exit Server Config,but do not attempt to restart the upgrade session until you

online database @dbname select @dbname = min(name) from master..sysdatabases where name > @dbname end• Reinstall system stored procedures using the

2.Contact Sybase Technical Support with the information.See also• Chapter 14, Obtaining Help and Additional Information on page 139CHAPTER 13: Trouble

CHAPTER 13: Troubleshoot the Server138 Adaptive Server Enterprise

CHAPTER 14Obtaining Help and AdditionalInformationUse the Sybase Getting Started CD, Product Documentation site, and online help to learnmore about th

CHAPTER 3Adaptive Server ComponentsAdaptive Server® Enterprise is based on a client/server model, communicating with its clientsover the network via t

c) If prompted, enter your MySybase user name and password.d)(Optional) Select a filter, a time frame, or both, and click Go.e) Select a product.Padlo

generally also meet non-U.S. accessibility guidelines, such as the World Wide WebConsortium (W3C) guidelines for Web sites.Note: You may need to confi

CHAPTER 14: Obtaining Help and Additional Information142 Adaptive Server Enterprise

IndexAaccounts, creating sybase user 30Adaptive Serverinstalling in command line mode 47installing in silent mode, unattended 47Adaptive Server compon

errorinformation, finding 117license checkout 117error log filestroubleshooting and 133Ffails preupgrade eligibility 133features, separately licensed

Mmemory requirements 11methods of installationAdaptive Server 37migratingdump and load method 92methods 92minimal configurationAdaptive Server 41minim

SCCstarting 55scriptsinstallpix 62installpubs2 62installpubs3 62location 61security servicesdescribed 6separately licensed optional features 19served

upgradingAdaptive Server 69entire installations 69failure 134Java in the database 100single databases 69tasks after you upgrade 87using bcp 93upgradin

Index148 Adaptive Server Enterprise

Determining the Edition You HaveIf you already use Adaptive Server, use the sp_lmconfig system procedure to identify theversion.Enter:sp_lmconfig &apo

console, agents, common services, and tools for managing and controlling Sybase products. Itincludes historical monitoring, threshold-based alerts and

• QPTune• jConnect™ for JDBC™ 7.0• SySAM License Utilities• SDC Administration UtilityIn addition to the SDK, the PC-Client CD includes PowerDesigner

CHAPTER 4System RequirementsBefore installing Adaptive Server, ensure that your system is updated with the latest patchesand system requirements. Do n

DOCUMENT ID: DC30119-01-1572-01LAST REVISED: July 2012Copyright © 2012 by Sybase, Inc. All rights reserved.This publication pertains to Sybase softwar

Required files DescriptionRequired libraries for Linux• openmotif-2.3.1-2.el5• libXp-1.0.0-8.1.el5• libXt-1.0.2-3.1.fc6• libXtst-1.0.1-3.1• libXi-1.6.

Product Linux X64 Require-mentsLinux X64 PSeriesRequirementsDefault databases created during in-stallation306MB 164MBTotal1071MB 1256MBBefore you can

CHAPTER 4: System Requirements12 Adaptive Server Enterprise

CHAPTER 5Planning Your Adaptive ServerInstallationBefore you install or upgrade, prepare your environment.• Identify the components and options to ins

• If you ordered your product under an SAP® contract and were directed to download fromSAP Service Marketplace (SMP), you can use SMP at http://servic

Sybase recommends that you use a license server if you run products on more than severalmachines, as this simplifies and centralizes license administr

Unserved Licenses Served LicensesUnserved Standalone Seat (SS) licenses do not allowproduct use via Remote Desktop Connection or otherterminal service

License ServersThe license server is a lightweight application that serves licenses to products running on anyoperating system.A license server can ru

Determining Host IDs for Machines with Multiple Network AdaptersOn some platforms, the host ID is derived from the network adapter address.If the mach

Your account can have the same product licensed under multiple license types. Make sure youselect the correct license type when you generate your SySA

ContentsCHAPTER 1: Conventions...1CHAPTER 2: Installation Task Overview...3Installation

Required Informa-tion or ActionLicense Model DescriptionServed Un-servedProduct machine host IDXDetermine the host ID of the machine, or ma-chine part

• At the Web Key Registration page, enter your account information, then click one ofthese options:•Submit My Registration Information – to register y

Generating Unserved LicensesGenerate and download an unserved license for your product.1.Enter the number of machines (up to 10) for which to generate

If you are unsure of the license quantity, select How Many Licenses Should IGenerate?.2.Select an existing license server host, or enter the host ID,

Warning! If you do not save the license files with a .lic extension, SySAM does notrecognize the licenses.7.After you save the license files to the li

Modifying Individual LicensesLearn about modifying individual licenses.1.Follow instructions in Logging in to SPDC and Beginning License Generation in

Required Informa-tion or ActionLicense Model DescriptionServed Un-servedLicense server host IDXDetermine the host ID of the machine where thelicense s

Product DescriptionSoftware Devel-oper Kit (SDK)Installed into the OCS-15_0 directory.• Open Client (Client Library, dblib)• ESQL/C• ESQL/COBOL• XA• O

Product DescriptionCharacter sets Installed into the charsets directory. Provides character sets available foruse with Adaptive Server.Collation seque

PC-Client Product Descriptions and LayoutAn Adaptive Server installation includes additional products that are installed into specificdirectories.Prod

Determining Host IDs ...17Determining Host IDs for Machines with MultipleNetwork Adapters ...

Product DescriptionUninstaller Installed into the sybuninstall/PCClient directory.InteractiveSQLInteractive SQL is a GUI tool that allows you to execu

Preparing to Install Adaptive ServerPrepare your system before starting the installation.1.Ensure that the account used to start the server has read a

• E-mail return address• Recipients of the notifications• Severity level of an event that triggers mail. Your choices are:• None• Informational• Warni

# /sbin/sysctl -w kernel.shmmax=nnnNote: The default operating system shared memory for some older Linux releases is32MB. The minimum required by Adap

1> sp_configure 'enable java', 12> goMultipathingMultipathing is the ability of a server to communicate with the same physical or logi

• NCR UNIX MP-RAS EMPATH for EMC Disk Arrays• NCR UNIX MP-RAS RDAC for Engenio Disk Arrays• ONStor SDM multipath• IBM System Storage Multipath Subsyst

For example:• /usr2/sybase/ASE1503/dev/wdb_data – is a symbolic link pointing to /dev/raw/raw73• /dev/raw/raw73 – is a raw character device mapped to

CHAPTER 6Installing Adaptive ServerInstall Adaptive Server using your chosen method.PrerequisitesComplete installation planning tasks.Task1.Choose an

the same directory with existing products should not impact the existing products. However,installing other products on top of Adaptive Server version

8.Select the type of installation:Option DescriptionTypical (Default) Installs the default components. This is recommended for most users.Full Install

Uninstalling Adaptive Server ...48Removing an Existing Adaptive Server ... 49CHAPTER 7

• Recipient e-mail addresses• Message severity that triggers e-mail messagesIn the summary window, click Next.12.In the preinstallation summary, verif

Installing Adaptive Server in Console ModeChoose command line installation if you prefer a nonwindowing interface, or for developingcustom installatio

Task1. Set the Configure new Adaptive Server option:Option DescriptionAdaptive ServernameDefault is the machine name.Port number Default is 5000.Error

Option DescriptionCreate sampledatabasesCreate or install sample databases. Make sure you calculate the additionalspace for your master device.After c

Configuration ValueTemporary database devicesizeDefault is 100MB for all page sizes.Temporary database size Default is 100MB for all page sizes.Enable

5. Set the Configure self management option:• Self management user name – default is "sa".• Self management password – prompted only if you

Adaptive Server and related products have been successfully installed, and minimallyconfigured for use. See Installing Sample Databases on page 60, to

Each password must be at least six characters long. The sccadmin and uafadmin loginsneed not be the same as the sa password.Installing in Silent ModeT

Option Purpose-i console Uses the console interface mode, where messages appear on the Java console andthe wizard runs in console mode.-i silent Insta

Note: You may need to confirm the deletion of some files that have been modified sinceinstallation.4. When you see the final window, click Done to exi

CHAPTER 10: Adaptive Server Upgrades...69Upgrading Adaptive Server ...69Considerations fo

CHAPTER 6: Installing Adaptive Server50 Adaptive Server Enterprise

CHAPTER 7Installing Components from thePC-ClientThe PC-Client CD contains several components that are each packaged with their owninstaller. When you

Creating a Response File for the ClientBy saving installation configuration information into a response file during the initial GUIinstallation, you c

The only difference when you install the client in silent mode is the absence of the GUIscreens. All actions and responses are the same as using Insta

CHAPTER 7: Installing Components from the PC-Client54 Adaptive Server Enterprise

CHAPTER 8Starting and Stopping SybaseControl Center AgentSybase Control Center (SCC) for Adaptive Server is a Web-based tool for monitoring thestatus

CHAPTER 8: Starting and Stopping Sybase Control Center Agent56 Adaptive Server Enterprise

CHAPTER 9Postinstallation TasksAfter you install the server, set it up.The Adaptive Server installation includes directories containing sample client

Verifying Your Connection to the ServersVerify your connection to the servers.Use isql to perform a quick test:• At the command prompt, enter the foll

Configuring libtcl.cfg for LDAPUse the libtcl.cfg file to specify an LDAP server name, port number, DIT base, username, and password to connect to an

Updating Threshold Procedures for AuditSegments ...90Reenabling Replication Server After the Data

3. Click Add New Server Entry, and enter:• Server name• Security mechanism – (Optional) there is a list of security mechanism OIDs in%SYBASE%\ini\obje

Database Descriptioninstall-pubs2Installs the pubs2 sample database. This database contains data that represents apublishing operation. Use this datab

Running the Database ScriptsAfter you determine your default device, run the scripts to install the sample databases.PrerequisitesBack up the original

The interpubs database contains 8-bit characters and is available for use at AdaptiveServer installations using the ISO 8859-1 (iso_1), ISO 8859-15 (i

Maintaining Sample DatabasesThe sample databases contain a guest user option that allows authorized users to access thedatabase. Guest users have a wi

Choosing a Raw PartitionSelect a raw partition on which to create and mount database devices.1.Determine which raw partitions are available.2.Determin

1.Use the n command to create a new partition, and enter l at this prompt for "logical":Command (m for help): nCommand actionl logical (5 o

/dev/raw/raw2: bound to major 3, minor 6/dev/raw/raw3 --> /dev/sdd7 /dev/raw/raw3: bound to major 3, minor 7/dev/raw/raw4 --&g

Accessing Raw Devices from the ServerAfter you create partitions and bind the devices for raw disk I/O, Adaptive Server can usethem.PrerequisitesConfi

CHAPTER 10Adaptive Server UpgradesYou can upgrade to Adaptive Server 15.7 from Adaptive Server versions 15.0 through 15.0.3,with the exception of vers

Downgrading an Adaptive Server That Uses Encryption...113Downgra

and later (nonclustered editions). See the following table for all possible combinations ofupgrades.An upgrade is done by:• Upgrading your entire inst

CurrentVersionUpgrad-ing toSpecial Upgrade InformationAdaptiveServerClusterEdition15.5.x orlaterAdaptiveServerClusterEdition15.7.xIn the installer des

Considerations for Component Integration ServicesIf you have both a local and a remote server running on Adaptive Server version 15.x and areupgrading

4.Enter preupgrade to run the preupgrade utility.Changes in Adaptive Server DirectoriesThe directory structures for Adaptive Server installations diff

Component 12.5.4 Loca-tion15.0.2 Loca-tion15.0.3 Loca-tion15.5, 15.7, and15.7 ESD #1and ESD #2 Lo-cationsJob Scheduler$SYBASE/JS-12_5$SYBASE/ASE-15_0/

The default RUN_servername file for a server SYBASE is called RUN_SYBASE. If theRUN_servername file for your current server is named differently, use

•$SYBASE/interfaces• $SYBASE/$SYBASE_ASE/servername.cfg – where servername is yourserver name.•$SYBASE/$SYBASE_OCS/config/libtcl.cfg•$SYBASE/SYSAM-2_0

Note: Before upgrading, use sp_renamedb to change the name of any user database that is areserved word.If you change an object name, also change appli

create table [table] ( [int] int, [another int] int )3.Run sp_checkreswords in master and in each user database to display the names andlocations of c

1> sp_create_syscoordinations2> goAdaptive Server uses this database for tracking transactions and during recovery. It is alsoused by applicatio

CHAPTER 14: Obtaining Help and AdditionalInformation...139Technical Support ...

1> sp_helpdb sybsystemprocs2> goUse sp_helpdevice to determine the size of the sysprocsdev device:1> sp_helpdevice sysprocdev2> goIf the d

Increasing Device and Database Capacity for System ProceduresIf you cannot fit the enlarged sybsystemprocs database on the system procedures device,in

3.Remove the device:1> sp_configure "allow updates", 12> go1> delete sysdevices where name in ("devname1", "devna

Upgrade to Adaptive Server 15.7 ESD #2After you successfully run the preupgrade utility, you are ready to upgrade Adaptive Server.Upgrading Interactiv

Warning! Do not interrupt the upgrade, connect to Adaptive Server, or run any storedprocedures while the upgrade is in progress.You can also check pro

If the resource file you are modifying was created by sqlupgrade, the prefix of the attributename may vary. sqlupgraderes ignores this prefix when pro

See also• Managing Java in the Database During Installations and Upgrades on page 33Determining the Adaptive Server VersionBefore using the binary ove

the initial and final steps. Doing so flushes free space accounting figures, object statistics,and runs checkpoint on the database to minimize recover

upgrade_object to upgrade compiled objects such as check constraints, rules, triggers,and views.4.Run the scripts for different options or licensed fe

If you run instmsgs.ebf after installing the 15.7 ESD #2 localized message, this script maydelete some new messages.Restoring Functionality in Adaptiv