Installation Manual

HP Storage Essentials SRM 6.0 Installation Guide 321
IMPORTANT: Before you begin these steps, make sure you purchased Sybase IQ, which is the
module that lets you monitor Sybase Adaptive Server Enterprise. Contact your customer support if
you are unsure if you purchased this module.
Step A — Create the APPIQ_USER account for Sybase
The management server accesses Sybase through the APPIQ_USER account. This account is
created when you run the CreateSybaseAct.bat script on the computer running the Sybase
database you want to monitor. The account has create session and select dictionary privileges to
be used with the management server.
NOTE: To create the APPIQ_USER with a custom password, run
CreateSybaseActCustomPwd.bat. For more information, see ”Creating Custom Passwords on
Managed Database Instances” on page 303.
Keep in mind the following:
• The script must run under SA user.
• Obtain the Sybase server name before you run the script
• Create APPIQ_USER account on Sybase Database you want to monitor.
• You should have already installed the database for the management server.
• Make sure you have all the necessary information before you begin the installation. Read
through the following steps before you begin.
To create the APPIQ_USER account for the Sybase server:
1. Do one of the following:
• To run the script on IBM AIX, SGI IRIX, or Sun Solaris, log into an account that has
administrative privileges, mount the CIM Extensions CD-ROM (if not auto-mounted), and go
to the /DBIQ/sybase/unix directory by typing the following:
# cd /cdrom/cdrom0/DBIQ/sybase/unix
where /cdrom/cdrom0 is the name of the CD-ROM drive
• To run the script on Microsoft Windows, go to the \DBIQ\sybase\win directory on the CIM
Extensions CD-ROM.
IMPORTANT: You must complete the following steps.
2. Verify you have the password to the SA user account.
You are prompted for the password for this user account when you run the script.
3. Run the CreateSybaseAct.bat script on the computer with the Sybase database.
The script creates a user with login to master and select privilege on data dictionary tables on a
managed Sybase instance.