Starting DB2 - Revision history

Connor: Created page with "

Name of the client db2 - also known as the Command Line Processor (CLP)

Typical command line to start the client
2012-07-19T10:37:08Z

Created page with " <table border="1"> <tr> <th>Name of the client</th> <td>db2 - also known as the Command Line Processor (CLP)</td> </tr> <tr> <th>Typical command line to start the client</th..."

New page

<table border="1">
<tr>
<th>Name of the client</th>
<td>db2 - also known as the Command Line Processor (CLP)</td>
</tr>

<tr>
<th>Typical command line to start the client</th>
<td><pre>. /home/db2inst1/sqllib/db2profile
db2
connect to scott</pre><br/>
<dl>
<dt><p>db2inst1</p>
<dd><p>This is the "instance" - a unix user account. The super user who
owns all the files and processes.</p>
<dt><p>scott</p>
<dd><p>scott is a unix account name and the name of the database.
The instance user can issue <tt>create database scott</tt>
(this takes nearly 3 minutes to complete on my superfast machine.)
The database scott seems to be owned by the unix user scott without
any further action.</p>
<dt><p>no passwords</p>
<dd><p>The system seems to rely on unix user accounts.</p>
</dl>
</td>
</tr>

<tr>
<th>Useful commands</th>
<td><pre>list tables
describe table cia
?
</pre></td>
</tr>

<tr>
<th>Beware!</th>
<td>
<p>
No semi colons.
</p>
</td>
</tr>

<tr>
<th>
</th>
<td>

</td>
</tr>
</table>