Configuring Sybase Control Center Logging for Performance Diagnostics

Change the logging behavior for Sybase Control Center (SCC) to better capture events for the administration framework.

Only enable SCC logging to diagnose performance. To enable logging:

Open <SCC_HOME>\conf \log4j.properties.
Edit following properties as desired:
- log4j.appender.agent.File
- log4j.appender.agent.MaxFileSize
- log4j.appender.agent.MaxBackupIndex

If you need to diagnose SCC performance issues, review performance data with the <SCC_HOME>\log\executionTime.log:

Open SCC_HOME\plugins\com.sybase.supadminplugin\agent-plugin.xml.

Add the following line to the file under the <properties> element:

<set-property property="log_MO_method_execution_time" value="enable_log_mo_method_execution_time" />

Open SCC_HOME\conf\log4j.properties.

If you are experiencing log truncation issues, edit the following lines to change the default values for maximum file size (default: 25MB) and maximum backup index (default: 20 files) to the values shown in this example:

## file appender (size-based rolling)
log4j.appender.executionTime=org.apache.log4j.RollingFileAppender
log4j.appender.executionTime.File=${com.sybase.ua.home}/log/executionTime.log
log4j.appender.executionTime.layout=org.apache.log4j.PatternLayout
log4j.appender.executionTime.layout.ConversionPattern=%d [%-5p] [%t] %c.%M(%L) - %m%n
log4j.appender.executionTime.MaxFileSize=50MB
log4j.appender.executionTime.MaxBackupIndex=20
## log MO method execution time
log4j.logger.com.sybase.uep.sysadmin.management.aop=INFO,executionTime

Restart Sybase Control Center.
The executionTime.log file now appears in the SCC_HOME\log folder.

Alternately, you can use the Adobe Flex log to track performance in Sybase Control Center:

Modify the SCC_HOME\plugins\com.sybase.supadminplugin\agent-plugin.xml file as indicated in step 2, above.
Restart Sybase Control Center.
Log in and perform your regular administrative tasks.

View the execution time indicators for these operations in the cookie file supatcookie.sol. The location of this file varies depending on your operating system:

Operating System	Location
Windows XP	C:\Documents and Settings\`<username>`\Application Data\Macromedia\Flash Player\#SharedObjects
Windows Vista	C:\Users\`<username>`\AppData\Roaming\Macromedia\Flash Player\#SharedObjects
Macintosh OS X	/Users/`<username>`/Library/Preferences/Macromedia/Flash Player/#SharedObjects
Linux	/home/`<username>`/.macromedia/Flash_Player/#SharedObjects

Analyze the log using your preferred method of data analysis.