Browse DevX
Sign up for e-mail newsletters from DevX


Tuning DB2: Where Your Data Is and Why it Matters-2 : Page 2




Building the Right Environment to Support AI, Machine Learning and Deep Learning

Instances and DatabasesInstances
At the top of the DB2 hierarchy, is the instance or database manager. An instance is a complete environment for hosting databases, having a range of memory and CPU management policies and network port numbers for communication.

What you get by default:
DB2 Universal Database provides a default instance named 'DB2.'How to create a new instance:
DB2 provides a utility called db2icrt. The only mandatory parameter is a name for the new instance.

Why have more than one instance? A system can run multiple instances and each will have its own data, processes, I/O ports, and memory allocation, completely independent of any other instance. An instance can be started, stopped, and reconfigured, without directly affecting any other instance. Most situations will only require one instance.Databases
A database is a collection of relational data in tables, along with associated indices, triggers, stored procedures etc. The tables can be related and queried together. A database can be backed up and restored as a whole.

What you get by default:
The "DB2 First Steps" tool offers to create a database called SAMPLE, which contains tables used by sample programs in the application development client.How to create a new database:
Use the DB2 command: CREATE DATABASE or use the Control Center.

Why have more than one database? A single database may serve the purposes of a number of independent applications, or each application may use a separate database for isolation and independent backup and restore. Extra databases can also be created for development and troubleshooting, as an entire set of data can be reproduced numerous times without interfering with the main (or live) data.

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date