<div>
I don't know anything about DB2, but I found this: <a href="http://blog.netnerds.net/2009/02/ibm-db2-five-ways-to-discover-the-hostname-of-an-iseries-server-for-use-in-a-four-part-table-name/" rel="ugc">http://blog.netnerds.net/2009/02/ibm-db2-five-ways-to-discover-the-hostname-of-an-iseries-server-for-use-in-a-four-part-table-name/</a><br />
<br />
I hope this helps.
</div>


I don't know anything about DB2, but I found this: http://blog.netnerds.net/2009/02/ibm-db2-five-ways-to-discover-the-hostname-of-an-iseries-server-for-use-in-a-four-part-table-name/ [http://blog.netnerds.net/2009/02/ibm-db2-five-ways-to-discover-the-hostname-of-an-iseries-server-for-use-in-a-four-part-table-name/]

I hope this helps.

<div>
The netnerds article is perhaps only partially correct. Apparently, what it's a solution for is the 'database name' rather than the hostname. Although those names are often the same, they're also often different. (The SQL0114 at the end of the article seems to reach the goal.)<br />
<br />
So, please clarify _exactly_ what name is being sought.<br />
<br />
A hostname would be useful for DNS resolution to an IP address. A database name would be useful for remote SQL requests.<br />
<br />
Tom<br />

</div>


The netnerds article is perhaps only partially correct. Apparently, what it's a solution for is the 'database name' rather than the hostname. Although those names are often the same, they're also often different. (The SQL0114 at the end of the article seems to reach the goal.)

So, please clarify _exactly_ what name is being sought.

A hostname would be useful for DNS resolution to an IP address. A database name would be useful for remote SQL requests.

Tom


<div>
<div class="content wysiwyg-content">
i've created a view on a db2 v9.1 on AIX<br />
i need to extract the hostname in a variable, and use that variable in a query instead of hardcoding the hostname<br />
how do i get the hostname (actual machine name) in sql?<br />

<pre><code id="code-304523">select col1, 'MY_HARDCODED_HOST_NAME' as hostName, col2, etc
</code></pre>
</div>
</div>


i've created a view on a db2 v9.1 on AIX
i need to extract the hostname in a variable, and use that variable in a query instead of hardcoding the hostname
how do i get the hostname (actual machine name) in sql?

how do i get the hostname in sql?

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.