100 lines
7.7 KiB
HTML
100 lines
7.7 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="concept" />
|
||
|
|
<meta name="DC.Title" content="Administration" />
|
||
|
|
<meta name="abstract" content="As an administrator for a distributed relational database, you are responsible for work being done on several servers." />
|
||
|
|
<meta name="description" content="As an administrator for a distributed relational database, you are responsible for work being done on several servers." />
|
||
|
|
<meta name="DC.subject" content="Distributed Relational Database, administration and operation, administration and operation, operation and administration" />
|
||
|
|
<meta name="keywords" content="Distributed Relational Database, administration and operation, administration and operation, operation and administration" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1kickoff.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1rdbactv.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1opremote.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1ddmcnv.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1dpref.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1dcoll.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1jobact.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1mtserv.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1audit.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1setddm.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rbal1admin" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Administration</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1admin"><a name="rbal1admin"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Administration</h1>
|
||
|
|
<div><p>As an administrator for a distributed relational database, you
|
||
|
|
are responsible for work being done on several servers.</p>
|
||
|
|
<p>Work that originates on your local system as an application requester (AR)
|
||
|
|
can be monitored in the same way as any other work is monitored on an <span class="keyword">iSeries™ server</span>.</p>
|
||
|
|
<p>When you are tracking units of work being done on the local system as an
|
||
|
|
application server (AS), you use the same tools but look for different kinds
|
||
|
|
of information.</p>
|
||
|
|
<p>This topic discusses ways that you can administer the distributed relational
|
||
|
|
database work being done across a network. Most of the commands, processes,
|
||
|
|
and other resources discussed here do not exist just for distributed relational
|
||
|
|
database use, they are tools provided for the operation of any <span class="keyword">iSeries server</span>.
|
||
|
|
All administration commands, processes and resources discussed here are included
|
||
|
|
with the <span class="keyword">i5/OS™</span> licensed
|
||
|
|
program, along with all of the DB2 Universal Database™ for iSeries functions.
|
||
|
|
Work management functions on the <span class="keyword">iSeries server</span> provide
|
||
|
|
effective ways to track work on several servers.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1rdbactv.htm">Monitor relational database activity</a></strong><br />
|
||
|
|
You can rely on control language (CL) commands, all of which provide
|
||
|
|
similar information, but in different ways, to give you a view of work on
|
||
|
|
an <span class="keyword">iSeries server</span>. </li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1opremote.htm">Operate remote iSeries servers</a></strong><br />
|
||
|
|
As an administrator in a distributed relational database you might
|
||
|
|
have to operate a remote <span class="keyword">iSeries server</span>.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1ddmcnv.htm">Control DDM conversations</a></strong><br />
|
||
|
|
The term <em>connection</em> in this topic collection refers to the
|
||
|
|
concept of an SQL connection. An SQL connection lasts from the time an explicit
|
||
|
|
or implicit SQL CONNECT is done until the logical SQL connection is terminated
|
||
|
|
by such means as an SQL DISCONNECT, or a RELEASE followed by a COMMIT.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1dpref.htm">Display objects used by programs</a></strong><br />
|
||
|
|
You can use the <span class="cmdname">Display Program References (DSPPGMREF)</span> command
|
||
|
|
to determine which tables, data areas, and other programs are used by a program
|
||
|
|
or SQL package. This information is only available for SQL packages and compiled
|
||
|
|
programs and can be displayed, printed, or written to a database output file.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1dcoll.htm">Drop a collection from a distributed relational database</a></strong><br />
|
||
|
|
Attempting to delete a collection that contains journal receivers might cause an inquiry message to be sent to the QSYSOPR message queue for the application server (AS) job. The AS and application requester (AR) job wait until this inquiry is answered.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1jobact.htm">Job accounting in a distributed relational database</a></strong><br />
|
||
|
|
The job accounting function on the <span class="keyword">iSeries server</span> gathers
|
||
|
|
data so you can determine who is using the server and what server resources
|
||
|
|
they are using. Typical job accounting provides details on the jobs running
|
||
|
|
on a server and resources used, such as use of the processing unit, printer,
|
||
|
|
display stations, and database and communications functions.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1mtserv.htm">Manage the TCP/IP server</a></strong><br />
|
||
|
|
This topic collection describes how to manage the DRDA/DDM server jobs that communicate using sockets over TCP. It describes the subsystem in which the server runs, the objects that affect the server and how to manage those resources.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1audit.htm">Audit the relational database directory</a></strong><br />
|
||
|
|
This topic discusses how to audit program access to the relational database directories.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1kickoff.htm" title="Distributed database programming describes the distributed relational database management portion of the i5/OS licensed program. Distributed relational database management provides applications with access to data that is external to the applications and typically located across a network of computers.">Distributed database programming</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="reltasks"><strong>Related tasks</strong><br />
|
||
|
|
<div><a href="rbal1setddm.htm" title="The implementation of DRDA support on the iSeries server uses Distributed Data Management (DDM) conversations for communications. Because of this, you can use DDM in conjunction with distributed relational database processing.">Set up DDM files</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|