sybdiag

sybdiag is a Java-based tool that collects comprehensive Adaptive Server configuration and environment data. Technical Support uses this information to diagnose server issues, thus expediting customer cases.

Note: Run sybdiag on the same machine as the monitored Adaptive Server.

Syntax

sybdiag -U username
    [-P password]
     -S [server_name | host:port]
	[-I interfaces_file] 
	[-L log_file] 
	[-N num_threads]
	[-O output_directory] 
	[-R resource_file] 
	[-T feature_list]
	[-h]
	[-m message_level] 
	[-v]

Parameters

Examples

Permissions

  • To gather all Adaptive Server data, you must have permission to access all datasources used by sybdiag. In a default Adaptive Server configuration, you must have sa_role and mon_role to collect Adaptive Server configuration and monitoring data. Use sp_role to grant sa_role and mon_role to the sybdiag user:
    sp_role "grant", sa_role, sybdiag_user
go
sp_role "grant", mon_role, sybdiag_user
go

    You may need other permissions to access database objects if your system administrator has changed the default access restrictions. If you have insufficient permission to access certain database objects, you see an error message that lists the database objects that you cannot access.

  • To gather all environment data, you must have authorized access to operating system and device files.

    Note: On Linux, you must have read permission to access operating system messages in /var/log/messages.
  • You must have read permissions on these files:

    • Adaptive Server error log

    • Adaptive Server configuration file

    • Environment scripts such as SYBASE.csh, SYBASE.sh or SYBASE.bat

  • You must have write permissions on an output directory specified by the -O parameter.

Note: If you do not have the required permissions on a file, sybdiag displays an error message does not process that file.
Parent topic: Utility Commands Reference