How this guide is organized

This guide includes the following sections.

• What are the Derby tools and utilities?

  Overview of the tools and utilities, and Derby and JDBC basics for new or infrequent users.

• Using ij

  How to get started with ij, a JDBC and SQL scripting tool.

• ij properties reference

  Reference for ij properties.

• ij commands and errors reference

  Reference for ij commands and errors.

• sysinfo

  Reference information on the utility that provides information about your Derby environment.

• dblook

  Reference information for a utility that dumps the DDL of a user-specified database to either a console or a file.

• SignatureChecker

  Reference information for a tool that identifies any SQL functions and procedures in a database that do not follow the SQL Standard argument matching rules.

• PlanExporter

  Reference information for a tool that exports query plan data for further analysis.

• Optional tools

  Reference information for optional tools.