sybdiag connects to an Adaptive Server and executes stored procedures such as sp_configure, and queries to tables like monLicense. It collects operating system and platform diagnostic information by executing commands such as ps, vmstat, and netstat.
The output of sybdiag is a compressed ZIP file containing HTML and data files that can be uncompressed and viewed in a Web browser. The information collected includes operating system and environment data, Adaptive Server configuration and monitoring data, and Adaptive Server files and scripts.
sybdiag does not collect Adaptive Server or operating system data for logins, passwords, or user lists, and does not collect information from application database tables.
sybdiag_start.html – an HTML file with links to diagnostic data files in the output directory. To view sybdiag output, open this file in any Web browser.
Operating system information, including process status, physical and virtual memory, interprocess communication, disk usage, I/O, and network information.
Adaptive Server configuration data, including server version, platform and license information, configuration values, remote server configuration data, and so on. For the Cluster Edition, this also includes the cluster overview, cluster instances, and logical cluster information.
Adaptive Server monitoring data about processes, databases, devices, locks, and so on. For the Cluster Edition, this also includes cluster interprocess communication protocol information, cluster lock usage, and cluster quorum device dump information.
Adaptive Server files such as errorlog, interfaces, configuration file, SySAM properties file, and environment configuration scripts. For the Cluster Edition, a single report may contain information from many external files for several cluster instances.
Diagnostic data files – collected Adaptive Server and environment information organized under different directories. These are the files that sybdiag_start.html accesses.
Log file – by default, the ZIP file includes a log file called sybdiag.log that provides a log of the activities sybdiag performed.