Databases
Go Up to Supported Objects
Databases are a collection of tables, or a collection of index spaces and tablespaces. The goals of a database system are straightforward but challenging. In general, a database aims to manage large amounts of data in a multi-user environment. It should achieve high performance while letting many users access the same information concurrently without compromising data integrity. A database also must protect against unauthorized access and provide reliable solutions for failure recovery.
Creating and editing
- Databases Wizard (DB2 LUW) and Databases Editor (IBM DB2 LUW)
- Databases Wizard (DB2 Z/OS) and Databases Editor (IBM DB2 Z/OS)
- Databases Wizard (SQL Server) and Databases Editor (SQL Server)
- Databases Wizard (Sybase ASE) and Databases Editor (Sybase ASE)
- Note: Objects of this type cannot be created or edited against PostgreSQL datasources.
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
DB2 LUW | DB2 z/OS | PSTGRS * | SQL SVR | SYB ASE | |
---|---|---|---|---|---|
✓ |
|||||
✓ |
✓ | ||||
✓ |
|||||
✓ |
✓ | ||||
✓ |
|||||
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ |
|||||
✓ |
✓ |
✓ |
✓ |
✓ | |
✓ | |||||
✓ |
✓ |
✓ |
✓ | ||
✓ | |||||
✓ |
|||||
✓ |
✓ | ||||
✓ |
✓ |
✓ | |||
✓ | |||||
✓ |
✓ | ||||
✓ |
|||||
✓ |
|||||
✓ |
|||||
✓ |
|||||
✓ |
DBMS-specific information