ASA Database Administration Guide
Database Administration Utilities
The Ping utility
Troubleshooting connections using the dbping command-line utility
Connection parameters (-c) For a description of the connection parameters, see Connection parameters. If the connection parameters are not specified, connection parameters from the SQLCONNECT environment variable are used, if set.
Make database connection (-d) Ping the database, not just the server.
If you do not supply the -d option, then dbping reports success if it finds the server specified by the -c option. If you do supply the -d option, then dbping reports success only if connects to the server and also connect to a database.
For example, if you have a server named blair running the database sample, the following succeeds:
dbping -c "eng=blair;dbn=asademo"
The following command fails, with the message Ping database failed -- specified database not found:
dbping -c "eng=blair;dbn=sample"
Load specified library (-l) Specify the library to use (without its file extension). This option avoids the use of the ODBC driver manager, and so is particularly useful on UNIX operating systems.
For example, the following command loads the ODBC driver directly:
dbping -m -c "dsn=ASA 9.0 Sample" -l dbodbc9
On UNIX, if you wish to use a threaded connection library, you must use the threaded version of the Ping utility, dbping_r.
Use ODBC to connect (-m) Establish a connection using ODBC. By default, the utility connects using the embedded SQL interface.
Report connection properties (-pc) Upon connection, display the specified connection properties. Supply the properties in a comma-separated list. You must specify enough connection information to establish a database connection if you use this option.
For a list of connection properties, see Connection-level properties.
For example, the following command displays the DIVIDE_BY_ZERO_ERROR option setting, which is available as a connection property.
dbping -c ... -pc Divide_by_zero_error
Report database properties (-pd) Upon connection, display the specified database properties. Supply the properties in a comma-separated list. You must specify enough connection information to establish a database connection if you use this option.
For a list of database properties, see Database-level properties.
For example, the following command displays the Java version in use by the database:
dbping -c ... -pd JDKVersion
Report database server properties (-ps) Upon connection, display the specified database server properties. Supply the properties in a comma-separated list.
For a list of database server properties, see Server-level properties.
For example, the following command displays the number of licensed seats for the database server:
dbping -c ... -ps LicenseCount
Log output messages to file (-o) Write output messages to the named file.
Operate quietly (-q) If dbping fails, a message is always displayed. If dbping succeeds, no message appears if -q is specified.
Display debugging information (-z) This option is available only when an embedded SQL connection is being attempted. That is, it cannot be combined with -m or -l. It displays the network communication protocols used to attempt connection, and other diagnostic messages.