Installation Manual

Discovering Applications, Backup Hosts and Hosts322
NOTE: You can use a remote Sybase isql to run this script.
4. Enter the Sybase instance name, which must be visible to the client, as the first input when
running the script. The script prompts you for the name of the sybase server on which to create
user for Sybase management packages and the password of the SA account.
5. Repeat the previous step for each Sybase server you want to manage.
This script does the following in order:
• Creates the APPIQ_USER account.
• Grant create session and select on dictionary tables privileges to APPIQ_USER enabling
management server to view statistics for the Sybase server.
Removing the APPIQ_USER Account for Sybase
IMPORTANT: Before you remove the APPIQ_USER account for the Sybase databases on a host,
make sure no processes are running APPIQ_USER for that Sybase database. The management
server uses APPIQ_USER to obtain information about a Sybase database.
To remove the APPIQ_USER account for the Sybase databases on a host:
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 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
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 UninstallSybaseAct.bat script on the computer with the Sybase database.
4. Enter the name of the Sybase server.
5. Enter the password for the SA account.
The account for APPIQ_USER is removed. The management server can no longer monitor the
Sybase databases on this host.
Step B — Provide the Sybase Server Name and Port Number
You must provide the Sybase server name and port number for managing the Sybase database in
the following steps: