Cataloging and uncataloging instances and databases
In the previous recipe, we covered how to set up communication for a newly created instance. Cataloging instances and databases is the next important task after you install and configure a DB2 client or DB2 Connect product. It is very important to ensure that you have correctly cataloged a remote or a local system to be able to connect and work with it.
Getting ready
For this recipe, we'll create a new database under instance db2inst3
, and further we'll catalog the instance and the database at the DB2 client installed in the Creating and configuring a client instance recipe in Chapter 1, DB2 Instance—Administration and Configuration.
How to do it...
As a
db2inst3
instance owner, create a sample database using db2sample script:[db2inst3@nodedb21 ~]$ db2sampl Creating database "SAMPLE"... Connecting to database "SAMPLE"... Creating tables and data in schema "DB2INST3"... Creating tables with XML columns and XML data in schema "DB2INST3...