Add Host Database to DLFM (ADDHDBDLFM)
| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Add Host Database to DLFM (ADDHDBDLFM) command registers a host database with the DataLink File Manager (DLFM). This host database can then be used to call the DLFM to link files.
Restrictions:
- To use this command, you must have input/output system configuration (*IOSYSCFG) special authority.
| Top |
Parameters
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| HOSTDBLIB | Host database library | Values (up to 300 repetitions): Element list | Optional, Positional 1 |
| Element 1: Name | Character value | ||
| HOSTDBINST | Host database instance | Character value, QSYS | Optional, Positional 2 |
| HOSTDB | Host database | Character value | Optional |
| SRCFILE | Source file | Qualified object name | Optional |
| Qualifier 1: Source file | Name | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB | ||
| SRCMBR | Source member | Character value | Optional |
| Top |
Host database library (HOSTDBLIB)
Specifies one or more libraries on the host database that may contain database files with DataLinks. Up to 300 names can be specified.
- character-value
- Specify the library name.
| Top |
Host database instance (HOSTDBINST)
Specifies the database instance to be registered with the DataLink File Manager. This is used to specify the installation path of the DB2 product on the host system. For IBM i host systems, QSYS should be specified for this parameter.
- QSYS
- The database instance is named QSYS.
- character-value
- Specify the name of the database instance.
| Top |
Host database (HOSTDB)
Specifies the host database name to be registered. This is the remote relational database (or server) that will be connecting to the local DataLink File Manager (DLFM) for link and unlink requests of DataLinks.
- character-value
- Specify the name of the host database.
| Top |
Source file (SRCFILE)
Specifies the source file that will be used to provide host database information to be registered.
Qualifier 1: Source file
- name
- Specify the name of the source file.
Qualifier 2: Library
- *LIBL
- All libraries in the library list for the current thread are searched until the first match is found.
- *CURLIB
- The current library for the job is used to locate the file. If no library is specified as the current library, QGPL is used.
- name
- Specify the name of the library to be searched.
| Top |
Source member (SRCMBR)
Specifies the source member that contains the host database information to be registered. Each row of the source member must contain a host database library, a host database instance, and a host database server name, with each value being separated by a space.
- character-value
- Specify the name of the source file member.
| Top |
Examples
Registering a Datalink File Manager Host Database
ADDHDBDLFM HOSTDBLIB(MYLIB TESTLIB PERSONNEL)
HOSTDBINST(QSYS) HOSTDB(RCHASXYZ)
This command registers RCHASXYZ as a valid system for calling the DataLink File Manager with a link request. Libraries MYLIB, TESTLIB, and PERSONNEL are libraries (or collections) on the host database system that can have database files containing DataLinks. QSYS is used as the host database instance, since the system is an IBM i server.
| Top |
| Top |