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:

To add information for discovering Sybase Adaptive Server Enterprise:

1.Select Options > Protocol Settings > Storage Essentials > System Application Discovery Settings.

To select a target, you must have at least one element designated as a server, workstation or desktop. If you see the message, “No Targets Currently Selected,” change your element from unknown to either a server, workstation or desktop. See the documentation for HP Systems Insight Manager. Select a target, and then, click Run Now.

2.Click the Create button for the Database Information table.

3.In the Host IP/DNS Name box, enter the IP address or DNS name of the host running Sybase.

4.You can leave the Management IP/DNS Name box blank. This box is for Oracle clusters. When you leave the Management IP/DNS Name box blank the management server automatically lists the DNS name or IP address of the host under the Host IP/DNS Name column and Management IP/DNS Name column.

HP Storage Essentials SRM 6.0 User Guide 111