After determining the design of your database, you must create the database and the objects within it. These objects include schemas, nodegroups, table spaces, tables, views, aliases, user-defined types (UDTs), user-defined functions (UDFs), triggers, constraints, indexes, and packages. You can create these objects using SQL statements in the command line processor, from the Control Center (on the Windows 95, Windows NT, and OS/2 operating systems), or through APIs in applications.
For information on SQL statements, see the SQL Reference manual. For information on command line processor commands and user APIs, see the Command Reference and API Reference manuals respectively.
| Note: | Your platform may support a user interface where you can create database objects. This interface can be used instead of the SQL statements, command line processor commands, or user APIs. Check the Quick Beginnings manual for your platform to determine if you have this capability. |
The following topics are expanded and discussed in greater detail later in this chapter:
There may be operating system-specific differences with some of the topics discussed below in those areas where DB2 Universal Database interacts with the operating system. You may be able to take advantage of native operating system capabilities or differences beyond those offered by DB2 UDB. You should refer to your appropriate Quick Beginnings manuals and specific operating system documentation for precise differences.
As an example, Windows NT** supports an application type known as a "service". DB2 for Windows NT can have a DB2 instance defined as a service. A service can be started automatically at system boot, by a user through the Services control panel applet, or by a Win32-based application that uses the service functions included in the Microsoft** Win32** application programming interface (API). Services can execute even when no user is logged on to the system.