Administering your database

Some database tasks have an administrative character.

Connecting to your Db2 database
You can connect command-line interfaces, IBM® or third-party applications and tools, or apps that you create to your database.
Loading your data
You can load data from a data file on a local network, an object store (Amazon S3 or Swift), or a Db2® server. You can load data from a file in a delimited format such as CSV.
Database objects
Physical database design consists of defining database objects and their relationships.
Designing your database
You can use IBM InfoSphere® Data Architect to create a new database design or duplicate an existing database design. InfoSphere Data Architect is available for download from the web console.
Creating tables in an IBM Db2 Warehouse on Cloud Enterprise MPP or IBM Db2 Warehouse MPP database
You can create tables in a IBM Db2 Warehouse on Cloud Enterprise MPP or IBM Db2 Warehouse MPP database by using the web console or through an application that is connected to the database. When you create a table, you must decide how to distribute the table data.
Schema-level and table-level backup and restore
You can use the Db2 logical schema backup and restore features to do full, cumulative incremental, or delta incremental backups of a schema, followed by full restore of the schema or one or more tables within the schema.
Workload management
Manage your query workload.