IBM Developer Advocacy

Manage data with dashDB Support Tools

The IBM dashDB Support Tools (also referred to as the dbtoolkit) are a collection of scripts and utilities based on similar scripts delivered for the IBM PureData System for Analytics appliances and Netezza databases. The dbtoolkit can be used to migrate data from Netezza databases to dashDB, to connect to the dashDB database, and to run queries and reports on the migrated data.

Download the IBM dashDB Support Tools (~35MB)

By clicking the download link, you agree to these terms and conditions.

Download IBM dashDB Support Tools

Refer to the readme inside the support tools package for more information about prerequisites, installation steps, and how to use the tools.

Utilities in the dbtoolkit package

dbsql
Connect to a dashDB database and run queries. This is based on an IBM Netezza command called nzsql

Scripts in the dbtoolkit package

db_ddl_database
Display the SQL DDL statement that was used to create a database
db_ddl_function
Display the SQL DDL statement that was used to create a
user-defined function
db_ddl_procedure
Display the SQL DDL statement that was used to create a
user-defined procedure
db_ddl_security
Display the SQL DDL statements that were used to create
security objects
db_ddl_sequence
Display the SQL DDL statement that was used to create a
sequence
db_ddl_synonym
Display the SQL DDL statement that was used to create a
synonym (alias)
db_ddl_table
Display the SQL DDL statement that was used to create a table
db_ddl_view
Display the SQL DDL statement that was used to create a view
db_genstats
Generate statistics on those tables that don’t have up-to-date
statistics
db_getstats
Get and display the statistics for a user table or a system table
db_migrate
Copy one or more database tables from an IBM Netezza Platform
Software (NPS) database to a dashDB database
db_size
Display the amount of storage space that is used by each table
db_tables
List all tables in a database, along with other useful pieces of
information
blog comments powered by Disqus