sybdiag

sybdiag is a Java-based tool that collects comprehensive SAP ASE 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 SAP ASE 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] 
    [-D user_data_directory
	[-v]

Parameters

Examples

Permissions

  • To gather all SAP ASE data, you must have permission to access all datasources used by sybdiag. In a default SAP ASE configuration, you must have sa_role and mon_role to collect SAP ASE 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:
    • SAP ASE error log

    • SAP ASE 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.
Related concepts
Utility Commands Reference
Utilities to Gather Information