Page History

...

1. Open the command prompt and run the following command:
   "%SYBASE%\%SYBASE_OCS%\bin\isql" -v
   This shows the PC Open Client version.
2. Click Setting>Control Panel>Administrative Tools>Data Sources(ODBC).
   This shows the ODBC driver version.

...

1. In Sybase ASE configuration, set the "enable stmt cache monitoring" value to "1."
2. In the Collector registry file, add the following entry:
   <pss_exec_proc>YES</pss_exec_proc>

The following table specifies the parameter values for ASE version 12.5.0.3 and higher.

...

To grant the mon_role and sa_role server roles, run the following command:

grant role mon_role to user name
grant role sa_role to user name

For example, if you connect as system administrator, run the command as:

grant role mon_role to sa grant role sa_role to sa

Activating tables in ASE versions lower than 12.5.0.3

...

For instructions on how to activate these tables, see Sybase’s Sybase's book Performance Tuning: Monitoring and Analyzing (for ASE version 15.0) at:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monito ring/monitoring61.htm

...

Verify that the master.sysservers table includes the following entry:

sp_addserver logical name,’local’'local',physical name

where:

• logical name is the name used to address the server on your system
• physical name is the name of the instance as it appears in the interface file (this file is usually located in the sybase root dir/ini/sql.ini folder or the sybase root dir/interfaces folder)

The entry points to the Sybase instance as the local server (srvclass=0). If this entry does not exist, add it to the table.

...

• ASE versions lower than 12.5.3:

Do not run the sp_sysmon system stored procedure.

• ASE 12.5.3 and higher:

Run the sp_sysmon system stored procedure with the noclear option set only. For example: sp_sysmon "00:01:00", noclear

Otherwise, incorrect and illogical data will occur in the time slice following the execution of this procedure.

...

1. From StartPoint, click the AdminPoint tab.
2. Click the Setup tab.
3. From the drop-down menu, select Instances & Clusters.
4. Click the All instances tree item
5. At the bottom of the Display Instances & Clusters screen, click Add Instance. An Add New Instance dialog box appears.
6. Select the required technology from the list.
7. Select the application from the list. If the desired application is not on the list, follow steps a-d:
   1. Click Add.
   2. In the Application Name field, type in the new application name.
   3. On the Application System field, select the system application from the list.

   4. Click OK.

      Info
      To install an instance in an application, you must have ADMINISTRATE.INSTALL permission for the application in which you want to install the instance. If you only have permission for a specific technology, you will only be able to install in an application that is either empty, or is comprised of only the same technology.

8. Select a Tier from the list.

9. Click OK to view the next screen.

   Info
   Always refresh AdminPoint after adding an instance.

...

If the PMDB is using Windows Authentication, clicking Next in the Properties screen will take you to the Windows Authentication Settings screen. On this screen enter accounts with the following permissions:

...

When the Sybase Tier Collectors have been installed, you might need to perform post-installation tasks. Follow any instructions that appear on the screen.

Precise. Performance intelligence from click to storage. Learn more > >

...