Database reference

This collection of information is the principal set of database reference documentation for Db2® Warehouse.

Standards compliances for Db2 Warehouse
Db2 Warehouse complies with standards for its SQL, connection protocols, data formats, and client interfaces.
SQL reference
SQL is a standardized language for defining and manipulating data in a relational database.
Messages
Messages convey event information to users. A message describes the cause of an event and any action you can take in response to an event.
Command line processor plus (CLPPlus)
Command line processor plus (CLPPlus) provides a command-line user interface that you can use to connect to databases and to define, edit, and run statements, scripts, and commands.
System commands
Use these commands to control the operation of your database system.
Analytic stored procedures
Use this information to learn about analytic stored procedures.
SQL PL Support
The SQL Procedural Language (SQL PL) is a language extension of SQL that consists of statements and language elements that can be used to implement procedural logic in SQL statements.
PL/SQL Support
PL/SQL (Procedural Language/Structured Query Language) statements can be compiled and executed using DB2®® interfaces. This support reduces the complexity of enabling existing PL/SQL solutions so that they will work with the DB2 data server.
Modules
A module is a database object that is a collection of other database objects such as functions, procedures, types, and variables.
Database monitoring
Examine the operational status of your database.
Built-in routines and views
Built-in administrative routines and views provide a simplified programmatic interface to administer and use databases and database objects through structured query language (SQL).
Configuration parameters
When you create a database or database instance, a configuration file is created and filled with default parameter values. You can modify these values to improve performance and other characteristics of the database or database instance.
Registry and environment variables
Registry and environment variables control your database environment.