Read syntax diagramSkip visual syntax diagram

Specifies a nickname for the Db2® system or group. This can be any value conforming to the rules for an SQL ordinary identifier. Examples include DEV, TEST, PROD, LA, NY.

The maximum length you can specify for nickname is 16 characters.

Note: The LOCATION_NICKNAME option is optional. If you specify a value for nickname for the Db2 system or group, you must also specify a value for the LOCATION option. Specifying a Db2 location nickname enables the use of that nickname (for example, DEV) as an alternative to the actual Db2 location name, for online functions only.