About this guide
Derby Tools and Utilities Guide
10
About this guide
For general information about the Derby documentation, such as a complete list of books,
conventions, and further reading, see Getting Started with Derby.
Purpose of this document
This book describes how to use the Derby tools and utilities. The tools and utilities
covered in this book include:
·
ij
·
sysinfo
·
dblook
·
SignatureChecker
·
PlanExporter
Audience
This book is for:
· Developers, who might use the tools when developing applications
· System administrators, who might use the tools to run scripts that perform
administrative tasks such as backups or importing and exporting data
· End-users, who might use one of the tools to run ad-hoc queries against a database
How this guide is organized
This guide includes the following sections:
·
Overview of the tools and utilities, and Derby and JDBC basics for new or infrequent
users.
·
How to get started with
ij
, a JDBC and SQL scripting tool.
·
Reference for
ij
properties.
·
Reference for
ij
commands and errors.
·
Reference information on the utility that provides information about your Derby
environment.
·
Reference information for a utility that dumps the DDL of a user-specified database
to either a console or a file.
·
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.
·
Reference information for a tool that exports query plan data for further analysis.
