Red Hat NETSCAPE ENTREPRISE SERVER 6.1 - INSTALLATION AND MIGRATION GUIDE Guide d'installation

Adaptive Server® EnterpriseDocument Version: 16.0 - 2014-09-19Installation Guide for Linux

SAP ASE returns a value of EE, SE, or DE based on the edition that is currently running. See the Reference Manual for more information about sp_lmconf

Related InformationPostupgrade Tasks [page 83]Restoring Functionality in SAP ASE After Upgrading [page 84]10.9.6.1 Finding Compiled Object Errors Bef

10.9.6.1.1 Quoted Identifier ErrorsQuoted identifiers are not the same as literals enclosed in double quotes. The latter do not require you to perfor

In this example, you have the following statement:create view all_emps as select * from employeesCautionDo not execute a select * statement from the v

11 Downgrading SAP ASEYou cannot downgrade SAP ASE version 16.0 to an earlier version of SAP ASE.NoteDo not run the sp_downgrade system procedure. Th

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

12.2 Error Logs for SAP ASE ServersThe information in the error logs may help to determine the reason and possible solution for an error message.Serv

Problem ResolutionClient not authorized to connect to server.This error message means a remote machine does not have permission to display the user in

12.3.1 If the Installation Quits While You Are Configuring an SAP ASE ServerPerform specific steps if the installation suddenly quits.Procedure1. Vie

12.5 If SAP ASE Fails the Preupgrade Eligibility TestExamine the log file to determine why SAP ASE is ineligible for an upgrade.ContextIf SAP ASE fai

Procedure1. Exit the sqlupgrade program.2. Perform the necessary actions to fix the problem.For example, if the error log indicates that the upgrade f

In addition, you must also install the SCC Management User Interface for SAP ASE in the custom installation option by selecting the SAP Control Center

Procedure● If the upgrade failed because the process ran out of some resource, such as data or log space, locks, or auxiliary scan descriptors, add sp

NoteWhen a server fails during an upgrade process, it attempts to upgrade the databases when it restarts. When the installation is fully recovered, re

13 [conref] ASE Installation GuideSAP® Adaptive Server® Enterprise is a high-performance relational database management system for mission-critical,

Important Disclaimers and Legal InformationCoding SamplesAny software coding and/or code lines / strings ("Code") included in this documenta

www.sap.com/contactsap© 2014 SAP SE or an SAP affiliate company. All rights reserved.No part of this publication may be reproduced or transmitted in a

4.4 Client Components and UtilitiesThere are several components that you can install onto a PC client to support the SAP ASE server, which are downlo

Product Descriptionjutils-3_0 utilitiesA collection of SAP ASE utility programs that includes ribo, a tool to trace TDS traffic between a client progr

5 System RequirementsBefore installing SAP ASE version 16.0, ensure that your system is updated with the latest patches and system requirements. Do n

Required Files Description● libXp-devel● libX11-devel● libSM-devel● libICE-develThese files should be compatible with RHEL5.3 or later.There is a know

5.1 Memory RequirementsEach operating system has a default maximum shared-memory segment. Configure your operating system to allow the allocation of

6 Planning Your SAP ASE InstallationBefore you install or upgrade, prepare your environment.Procedure● Identify the components and options to install

Procedure1. Choose a SySAM license model.License Model DescriptionUnserved license model Licenses are obtained directly from the license file. If you

6.2.1 Comparing License Deployment ModelsLearn about license deployment models.Unserved Licenses Served LicensesLicenses can be used only on the mach

Table of Contents1 Installation Guide for Linux...52 Conventions...

6.2.2 SySAM License ServerIf you choose to use the served licensed model, make sure you have installed the required SySAM license server version.The

To determine the host ID of the machine, run the lmutil utility from a terminal window or the Windows command prompt. For example:lmutil lmhostidNoteY

6.2.3.2 Using Alternate Host IDs on WindowsIf your Windows machine does not have a network adapter, SySAM allows you to use an alternate host ID base

Required Information or ActionLicense Model DescriptionServed UnservedLicense server TCP/IP port numbersX Determine the two port numbers on which the

6.2.5.1 Optional Feature LicensesSome SAP ASE applications are offered as base products with optional features that require a separate license.Custom

Vendor Product Platform Support Virtualization Type Secure Resource Partitions OS containersIBM LPAR AIX 6.1, AIX 7 Virtual partition dLPAR Virtual pa

Although the installation media includes a copy of the most recent SySAM license server, we recommend that you periodically check for updates at http:

Product DescriptionNoteThe SAP ASE typical installation option installs only the SCC Remote Command and Control (RCC) agent. To use a GUI-based connec

6.4 Creating the Sybase User AccountTo ensure that SAP ASE product files and directories are created with consistent ownership and privileges, create

3. Verify that you can uncompress files on your UNIX machine. To uncompress:Option Description.zip files Use the unzip command.tgz files Use gzip or G

7.5 Uninstalling SAP ASE...487.5.1 Removing an Existing SAP ASE Server...

SAP ASE and client applications use network software even when they are installed on a machine that is not connected to a network.If you are having co

NoteThe default operating system shared memory for some older Linux releases is 32MB. The minimum required by SAP ASE is 64MB for a default server wit

3> physname = "${SYBASE}/data/sybpcidb_dev.dat",4> size = "48M"5> go1> create database sybpcidb on sybpcidb_dev = 482&

● Solaris – Multiplexed I/O (MPxIO)● AntemetA Multipathing Software for HP EVA Disk Arrays● Bull StoreWay Multipath● NEC PathManager● EMC PowerPath● F

Enterprise Linux 4 in Update 2 and into Novell SUSE Linux Enterprise Server 9 in Service Pack 2. To setup multipathing on Linux:Procedure1. Edit the /

7 Installing SAP ASEInstall SAP ASE using your chosen method.PrerequisitesComplete installation planning tasks.Procedure1. Choose an installation met

SAP ASE version 15.5 and later uses InstallAnywhere for its installation, while versions earlier than 15.5 and other products use InstallShield Multip

If you see Choose Update Installation, this means that there is an older version of SAP ASE in the directory you specified for the installation, and y

○ Message severity that triggers e-mail messages12. In the preinstallation summary, verify the installation type and that you have enough disk space f

Related InformationSAP ASE Upgrades [page 65]Managing SAP ASE with SAP Control Center [page 10]7.2 Installing SAP ASE in Console ModeChoose command l

10.7.4 Reenabling Replication Server After the Dataserver Upgrade...8610.8 Migrate...

7.3 Minimally Configuring an SAP ASE ServerUse GUI mode to minimally configure an SAP ASE server and related products for use.PrerequisitesThe Config

Option Description○ (Default) 4KB○ 8KB○ 16KBThe default page size selection changed from 2KB to 4KB in SAP ASE version 15.5. If you plan to load datab

Configuration Valuemaster Database Size (MB) The minimum and default sizes are:○ 2KB page size – 18MB○ 4KB page size – 26MB○ 8KB page size – 52MB○ 16K

Configuration ValueAllow Hosts Comma-separated lists of hosts that are allowed to connect to this Backup Server. When null, only the dataserver runnin

9. Set the SAP Control Center – Configure RMI Port option with a port number (1025 to 65535) that is not used by another application or service on the

7.4 Installing SAP ASE Using a Response FileUnattended or silent installations are typically used to update multiple systems across the enterprise.Pr

NoteThe directory path you specify must already exist.2. Verify that the response file includes the passwords for the SAP ASE sa login, SAP Control Ce

NoteMake sure that the user you specify in this property setting has read/write/modify permissions to access the data directory.7.4.2 Installing in S

○ SY_CFG_ASE_PASSWORD○ CONFIG_SCC_CSI_SCCADMIN_PWD○ CONFIG_SCC_CSI_UAFADMIN_PWD○ CONFIG_SCC_REPOSITORY_PWDNoteFor security purposes, treat response fi

Procedure1. Execute:$SYBASE/sybuninstall/ASESuite/uninstall2. Click Next in the Uninstall Welcome window.3. Choose one of the following, then click Ne

1 Installation Guide for LinuxSAP® Adaptive Server® Enterprise is a high-performance relational database management system for mission-critical, data

8 Starting and Stopping SAP Control CenterSAP Control Center (SCC) for SAP ASE is a Web-based tool for monitoring the status and availability of SAP

You should see a status message similar to:Agent Home: /remote/perf_archive/mymachine/Install_Testing/157CE_C3/SCC-3_3/instances/solstrs3 Connection U

9 Postinstallation TasksAfter you install the server, set it up.The SAP ASE installation includes directories that contain sample client library appl

Procedure1. From a UNIX command line, set the environment variables.○ In the C shell:source <ASE_install_location>/SYBASE.csh○ In the Bourne she

(such as Backup Server), and client software on your network. Clients can talk to one or more servers, and servers can communicate with other servers

CautionEnsure that the LDAP URL is on a single line.ldap=libsybdldap.dllldap://<host>:<port>/ditbase??scope??bindname=username?passwordFor

9.4 The System Administrator PasswordWhen you install SAP software, the software creates a system administrator account called "sa," which

9.5.1 Default Devices for Sample DatabasesThe SAP ASE installation includes scripts for installing the us_english sample database, foreign language s

The pubs3 database does not use image data.For more information about running these scripts, see the Configuration Guide for UNIX.9.5.3 Installing th

Procedure1. Set your terminal to display 8-bit characters.2. Verify that the EUC-JIS, Shift-JIS, or the UTF-8 character set is installed either as the

2 ConventionsThese style and syntax conventions are used in SAP® Adaptive Server® Enterprise (SAP® ASE) documentation.● In a sample window display, c

● After users have finished updating one of the sample databases, instruct them to issue the rollback transaction command to undo the changes.9.6 Raw

9.6.2 Examples for Creating Raw PartitionsSpecific system administration is required before you can enable and use raw devices. The available tools t

4. Use the t command, enter 5 at this prompt:Partition number (1-8): 55. Enter 60 at this prompt:Hex code (type L to list codes): 60The output is:Chan

d) To make sure the raw device binding runs whenever you restart the system, enter:# /sbin/chkconfig rawdevices on● If you are using Red Hat Enterpris

9.6.4 Accessing Raw Devices from the ServerAfter you create partitions and bind the devices for raw disk I/O, Adaptive Server can use them.Prerequisi

10 SAP ASE UpgradesYou can upgrade to SAP ASE version 16.0 from versions 12.5.4 or later.Upgrades are supported only between nonclustered editions of

An upgrade is done by:● Upgrading your entire installation by switching binaries.● Upgrading a single database using online database, having first loa

10.2 Considerations for Component Integration ServicesIf you have both a local and a remote server running on SAP ASE version 15.x and are upgrading

Manually drop objects before you execute procedures for the first time. The first time you run the server after an upgrade, the server internally rebu

Component LocationLanguage settings (locales)● 12.5.4 and 15.0.2 locations – $SYBASE/locales● 15.0.3, 15.5, 15.7 GA, and 15.7 ESD #1, ESD #2, ESD #3,

3 Installation Task OverviewTo successfully install and configure SAP ASE, use the configuration guide along with this installation guide.The SAP ASE

ContextNoteFollow these steps only if you are performing a major upgrade from an SAP ASE version earlier than 16.0.Skip these preparatory tasks if you

f) Disable disk mirroring.g) Verify that your SYBASE environment variable points to the location of the new server software files you just installed.F

If you change an object name, also change applications and stored procedures that refer to that object. Conflicts between object names do not prevent

10.5.2.2 Addressing Reserved Words ConflictsChange any database names that are reserved words.Procedure1. Use sp_dboption to set the database to sing

stored procedures or compiled objects in any database, the syscomments and sysprocedures system tables require additional space.The preupgrade utility

10.5.4 The sybprocsdev deviceSybase system procedures are stored in the sybsystemprocs database, which is stored in the sysprocsdev device. You may n

Procedure1. In isql, use alter database to increase the size of the sybsystemprocs database. For example:1> use master2> go1> alter database

Procedure1. Determine which device you must remove:select <d.name>, <d.phyname> from sysdevices d, sysusages u where u.vstart between d.lo

If any of the named devices are OS files rather than raw partitions, use the appropriate OS commands to remove those files.4. Remove all files that we

10.6 Upgrade to SAP ASE 16.0If you are performing a major upgrade from a version earlier than 16.x, you are ready to upgrade SAP ASE after you succes

Uninstalling SAP ASESee Uninstalling SAP ASE.8© 2014 SAP SE or an SAP affiliate company. All rights reserved.Installation Guide for LinuxInstallation

○ The full path of the data directory for the new SAP ASE release directory. This field allows you to specify a working directory that differs from th

● select @@version – SAP ASE should return 16.0.● sp_configure "upgrade version" – SAP ASE should return 16000000 (16 million).10.6.2 Upgra

○ <server_name> – is the server you are upgrading.○ <MM> – is the month.○ <DD> – is the date.○ <NNN> – is a three-digit number

3. Copy the <server_name>.cfg file from old directory to the new $SYBASE directory.4. Start the 16.0 server with the old master device from the

10.7.1 Restoring Functionality in SAP ASE After UpgradingRestore functionality in the server after an upgrade.Procedure1. If you changed any configur

10.7.2 Reenabling AuditingIf the server you upgraded from was configured for auditing, reenable auditing in the upgraded server.Procedure1. Enter:sp_

10.7.3 Restoring PermissionsIf the server you upgraded from had site-specific permissions on system stored procedures, restore those permissions in t

10.7.4.1 Restoring Replication on Replicate DatabasesRestore replication if you have upgraded a destination-only dataserver in a replication system.C

10.7.4.2 Restoring Replication on Primary DatabasesRestore replication if you have upgraded a source database, or primary database, in a Replication

10.8 MigrateYou can migrate from 32-bit to 64-bit versions on different computers or partitions.To migrate SAP ASE from the 32-bit to the 64-bit vers

4 SAP ASE ComponentsSAP ASE is based on a client/server model, communicating with its clients over the network via the Tabular Data Stream™ (TDS) pro

10.8.2 Using bcp to Migrate DataIf you use DDL scripts to create devices, databases, tables, rules, stored procedures, triggers, and views, you can u

5. Copy the 32-bit $SYBASE/$SYBASE_ASE/install/RUN_<server> file to the equivalent 64-bit $SYBASE/$SYBASE_ASE/install directory.6. Edit the RUN_

2. Make sure the new server is running.3. Ensure that at least 9000 locks are configured. If the number of locks on the server is fewer than 9000, inc

10.9.1.1 Upgrading Job Scheduler TemplatesAfter upgrading to the new server, upgrade the templates and jobs created by Job Scheduler.ContextNoteSever

Template Modified Files Datatype for <parameter> Changed from varchar(5) to intrebuild tablejst_reorg_rebuild_tables@dump_flagreclaim indexesjst

7. Install the template stored procedures and and move them to the Job Scheduler template stored procedure directory. For example:cd $SYBASE/$SYBASE_A

There are two ways to upgrade a cluster subsystem:Procedure● Perform a major upgrade, which involves cluster downtime, then shut down and restart all

10.9.3 Upgrading Java in the DatabaseIf Java in the database functionality is currently enabled, you must run the installpcidb script, which creates

10.9.4 Upgrading Backup ServerYou can upgrade Backup Server at any point after you upgrade SAP ASE using similar steps. XP Server does not have a for

10.9.6 How Compiled Objects Are Handled When Upgrading SAP ASESAP ASE upgrades compiled objects based on their source text.Compiled objects include:●