214 lines
7.2 KiB
HTML
214 lines
7.2 KiB
HTML
|
|
<!doctype html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
|
<html>
|
|
<head><META http-equiv="Content-Type" content="text/html; charset=utf-8">
|
|
<title>Add Host Database to DLFM (ADDHDBDLFM)</title>
|
|
<link rel="stylesheet" type="text/css" href="../rzahg/ic.css">
|
|
</head>
|
|
<body bgcolor="white">
|
|
<script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<a name="ADDHDBDLFM.Top_Of_Page"></a>
|
|
<h2>Add Host Database to DLFM (ADDHDBDLFM)</h2>
|
|
<table width="100%">
|
|
<tr>
|
|
<td valign="top" align="left"><b>Where allowed to run: </b>All environments (*ALL)<br>
|
|
<b>Threadsafe: </b>No
|
|
</td>
|
|
<td valign="top" align="right">
|
|
<a href="#ADDHDBDLFM.PARAMETERS.TABLE">Parameters</a><br>
|
|
<a href="#ADDHDBDLFM.COMMAND.EXAMPLES">Examples</a><br>
|
|
<a href="#ADDHDBDLFM.ERROR.MESSAGES">Error messages</a></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<div> <a name="ADDHDBDLFM"></a>
|
|
<p>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.
|
|
</p>
|
|
<p><b>Restrictions:</b>
|
|
</p>
|
|
<ul>
|
|
<li>To use this command, you must have input/output system configuration (*IOSYSCFG) special authority.
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<hr size="2" width="100%">
|
|
|
|
<div>
|
|
<h3><a name="ADDHDBDLFM.PARAMETERS.TABLE">Parameters</a></h3>
|
|
<table border="1" cellpadding="4" cellspacing="0">
|
|
<!-- col1="10" col2="15" col3="30" col4="10" -->
|
|
<tr>
|
|
<th bgcolor="aqua" valign="bottom" align="left">Keyword</th>
|
|
<th bgcolor="aqua" valign="bottom" align="left">Description</th>
|
|
<th bgcolor="aqua" valign="bottom" align="left">Choices</th>
|
|
<th bgcolor="aqua" valign="bottom" align="left">Notes</th>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top" rowspan="2"><a href="#ADDHDBDLFM.HOSTDBLIB"><b>HOSTDBLIB</b></a></td>
|
|
<td valign="top">Host database library</td>
|
|
<td valign="top">Values (up to 300 repetitions): <i>Element list</i></td>
|
|
<td valign="top" rowspan="2">Optional, Positional 1</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top">Element 1: Name</td>
|
|
<td valign="top">
|
|
<i>Character value</i></td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top"><a href="#ADDHDBDLFM.HOSTDBINST"><b>HOSTDBINST</b></a></td>
|
|
<td valign="top">Host database instance</td>
|
|
<td valign="top"><i>Character value</i>, <b><u>QSYS</u></b></td>
|
|
<td valign="top">Optional, Positional 2</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top"><a href="#ADDHDBDLFM.HOSTDB"><b>HOSTDB</b></a></td>
|
|
<td valign="top">Host database</td>
|
|
<td valign="top"><i>Character value</i></td>
|
|
<td valign="top">Optional</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top" rowspan="3"><a href="#ADDHDBDLFM.SRCFILE"><b>SRCFILE</b></a></td>
|
|
<td valign="top">Source file</td>
|
|
<td valign="top"><i>Qualified object name</i></td>
|
|
<td valign="top" rowspan="3">Optional</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top">Qualifier 1: Source file</td>
|
|
<td valign="top"><i>Name</i></td>
|
|
</tr><tr>
|
|
<td valign="top">Qualifier 2: Library</td>
|
|
<td valign="top"><i>Name</i>, <b><u>*LIBL</u></b>, *CURLIB</td>
|
|
</tr><tr>
|
|
<td valign="top"><a href="#ADDHDBDLFM.SRCMBR"><b>SRCMBR</b></a></td>
|
|
<td valign="top">Source member</td>
|
|
<td valign="top"><i>Character value</i></td>
|
|
<td valign="top">Optional</td>
|
|
</tr>
|
|
</table>
|
|
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
</div>
|
|
<div> <a name="ADDHDBDLFM.HOSTDBLIB"></a>
|
|
<h3>Host database library (HOSTDBLIB)</h3>
|
|
<p>Specifies one or more libraries on the host database that may contain database files with DataLinks. Up to 300 names can be specified.
|
|
</p>
|
|
<dl>
|
|
<dt><b><i>character-value</i></b></dt>
|
|
<dd>Specify the library name.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<div> <a name="ADDHDBDLFM.HOSTDBINST"></a>
|
|
<h3>Host database instance (HOSTDBINST)</h3>
|
|
<p>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 iSeries host systems, QSYS should be specified for this parameter.
|
|
</p>
|
|
<dl>
|
|
<dt><b><u>QSYS</u></b></dt>
|
|
<dd>The database instance is named QSYS.
|
|
</dd>
|
|
<dt><b><i>character-value</i></b></dt>
|
|
<dd>Specify the name of the database instance.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<div> <a name="ADDHDBDLFM.HOSTDB"></a>
|
|
<h3>Host database (HOSTDB)</h3>
|
|
<p>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.
|
|
</p>
|
|
<dl>
|
|
<dt><b><i>character-value</i></b></dt>
|
|
<dd>Specify the name of the host database.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<div> <a name="ADDHDBDLFM.SRCFILE"></a>
|
|
<h3>Source file (SRCFILE)</h3>
|
|
<p>Specifies the source file that will be used to provide host database information to be registered.
|
|
</p>
|
|
<p><b>Qualifier 1: Source file</b>
|
|
</p>
|
|
<dl>
|
|
<dt><b><i>name</i></b></dt>
|
|
<dd>Specify the name of the source file.
|
|
</dd>
|
|
</dl>
|
|
<p><b>Qualifier 2: Library</b>
|
|
</p>
|
|
<dl>
|
|
<dt><b><u>*LIBL</u></b></dt>
|
|
<dd>All libraries in the library list for the current thread are searched until the first match is found.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
<dt><b>*CURLIB</b></dt>
|
|
<dd>The current library for the job is used to locate the file. If no library is specified as the current library, QGPL is used.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
<dt><b><i>name</i></b></dt>
|
|
<dd>Specify the name of the library to be searched.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<div> <a name="ADDHDBDLFM.SRCMBR"></a>
|
|
<h3>Source member (SRCMBR)</h3>
|
|
<p>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.
|
|
</p>
|
|
<dl>
|
|
<dt><b><i>character-value</i></b></dt>
|
|
<dd>Specify the name of the source file member.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<hr size="2" width="100%">
|
|
<div><h3><a name="ADDHDBDLFM.COMMAND.EXAMPLES">Examples</a> </h3>
|
|
<p><b>Registering a Datalink File Manager Host Database</b>
|
|
</p>
|
|
<p>
|
|
<pre>
|
|
ADDHDBDLFM HOSTDBLIB(MYLIB TESTLIB PERSONNEL)
|
|
HOSTDBINST(QSYS) HOSTDB(RCHASXYZ)
|
|
</pre>
|
|
</p>
|
|
<p>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 iSeries 400 server.
|
|
</p>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<hr size="2" width="100%">
|
|
<div><h3><a name="ADDHDBDLFM.ERROR.MESSAGES">Error messages</a> </h3>
|
|
<p><b><u>*ESCAPE Messages</u></b>
|
|
</p>
|
|
<dl>
|
|
<dt><b>CPF3168</b></dt>
|
|
<dd>DataLink File Manager (DLFM) command failed.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#ADDHDBDLFM.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
</body>
|
|
</html>
|