LOCATION


1 LOCATION=location_name
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.