7.17. Case Study
You have been given the task to create several DB2 database objects for a proof-of-concept exercise on a single-partition environment. You start by creating the database testdb on your Windows server's E: drive as follows:
CREATE DATABASE testdb ON E:
This command takes a few minutes to complete as it creates several default database objects, including the default table spaces (SYSCATSPACE, TEMPSPACE1, and USERSPACE1) and the default buffer pool (IBMDEFAULTBP). Because this is just a test database, you decide to use the USERSPACE1 default table space for your user tables and the default buffer pool.
After the database is created, before you can create any object, you need to connect to the database; thus you perform this operation: ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
