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
Attach Database				✓
Checkpoint				✓	✓
Copy Schema	✓
DBCC				✓	✓
Detach Database				✓
Drop	✓	✓	✓	✓	✓
Drop Automatic Storage Path(s)	✓
Extract	✓	✓	✓	✓	✓
Hide Text					✓
Move Log					✓
Quiesce (Database)	✓
Rename				✓	✓
Report		✓		✓	✓
Resynchronize					✓
Set Online/Offline				✓	✓
Shrink				✓
Start Database		✓
Stop Database		✓
Unquiesce	✓
Update Statistics				✓

DBMS-specific information

• IBM DB2 for Linux, Unix, and Windows Instances
• Microsoft SQL Server Databases
• IBM DB2 for OS/390 and z/OS Instances
• Sybase ASE Databases