Chapter 2

A1: They are classified in two categories: DB2 system commands and DB2 CLP commands.
A2: For DB2 system commands use command -h. For DB2 CLP commands use db2 ? command.
A3: The Information Center provides a fast search engine that lets you search all the manuals based on a keyword.
A4: The db2icrt command creates a DB2 instance on the server where the command is run.
A5: Every database has three default table spaces created automatically by DB2. These table spaces are:
  • SYSCATSPACE

  • TEMPSPACE1

  • USERSPACE1

A6: The db2ilist command lists all instances that exist on a server, whether they are active or not.
A7: When you install DB2 on a Windows server, the installation program will automatically create an instance named DB2 on the server.
A8: No. The ...

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.