LOCATION
- LOCATION
- Specifies the Db2® location
name for the Db2® system or group.
This is the LOCATION value entered in the DDF statement (Db2® change log inventory utility), when Db2® was installed. Alternatively
you can specify the value returned by the following SQL statement:
SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1.
The maximum length you can specify for location_name is 16 characters, and must conform to the naming conventions for a "location-name" as documented in the SQL Reference manual for your Db2® system.
Note: The LOCATION option is optional. FM/Db2 does not require the specification of the location name in the FMN2SSDM macro for successful access to remote Db2® systems. Specifying a Db2® location name enables the use of the Db2® subsystem or group identifier (for example, DSNA) as an alternative to the actual Db2® location name, for online functions only.