91 lines
6.5 KiB
HTML
91 lines
6.5 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="reference" />
|
||
|
|
<meta name="DC.Title" content="Verify the performance of SQL applications" />
|
||
|
|
<meta name="abstract" content="You can verify the performance of an SQL application by using commands." />
|
||
|
|
<meta name="description" content="You can verify the performance of an SQL application by using commands." />
|
||
|
|
<meta name="DC.subject" content="command, DSPJOB (Display Job), Display Job (DSPJOB), command (CL), command (CL), locks, analyzing, commitment control, displaying, Print SQL Information (PRTSQLINF), STRDBMON (Start Database Monitor), Start Database Monitor (STRDBMON), STRDBMON (Start Database Monitor), Start Database Monitor (STRDBMON), CHGQRYA (Change Query Attributes), Change Query Attributes (CHGQRYA), QRYTIMLMT parameter" />
|
||
|
|
<meta name="keywords" content="command, DSPJOB (Display Job), Display Job (DSPJOB), command (CL), command (CL), locks, analyzing, commitment control, displaying, Print SQL Information (PRTSQLINF), STRDBMON (Start Database Monitor), Start Database Monitor (STRDBMON), STRDBMON (Start Database Monitor), Start Database Monitor (STRDBMON), CHGQRYA (Change Query Attributes), Change Query Attributes (CHGQRYA), QRYTIMLMT parameter" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="queryopt.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/dspjob.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/prtsqlinf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/strdbmon.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/chgqrya.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/strdbg.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="qoptcmds" />
|
||
|
|
<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>Verify the performance of SQL applications</title>
|
||
|
|
</head>
|
||
|
|
<body id="qoptcmds"><a name="qoptcmds"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Verify the performance of SQL applications</h1>
|
||
|
|
<div><p>You can verify the performance of an SQL application by using commands.</p>
|
||
|
|
<div class="section"><p>The commands that can help you to verify performance are:</p>
|
||
|
|
<dl><dt class="dlterm"><span class="cmdname">Display Job (DSPJOB)</span></dt>
|
||
|
|
<dd>You can use the <span class="cmdname">Display Job (DSPJOB)</span> command with the
|
||
|
|
OPTION(*OPNF) parameter to show the indexes and tables being used by an application
|
||
|
|
that is running in a job. <p>You can also use <span class="cmdname">DSPJOB</span> with
|
||
|
|
the OPTION(*JOBLCK) parameter to analyze object and row lock contention.
|
||
|
|
It displays the objects and rows that are locked and the name of the job holding
|
||
|
|
the lock.</p>
|
||
|
|
<p>Specify the OPTION(*CMTCTL) parameter on the <span class="cmdname">DSPJOB</span> command
|
||
|
|
to show the isolation level that the program is running, the number of rows
|
||
|
|
being locked during a transaction, and the pending DDL functions. The isolation
|
||
|
|
level displayed is the default isolation level. The actual isolation level,
|
||
|
|
used for any SQL program, is specified on the COMMIT parameter of the CRTSQLxxx
|
||
|
|
command.</p>
|
||
|
|
</dd>
|
||
|
|
<dt class="dlterm"><span class="cmdname">Print SQL Information (PRTSQLINF)</span></dt>
|
||
|
|
<dd>The <span class="cmdname">Print SQL Information (PRTSQLINF)</span> command lets
|
||
|
|
you print information about the embedded SQL statements in a
|
||
|
|
program, SQL package, or service program. The information includes the SQL
|
||
|
|
statements, the access plans used during the running of the statement, and
|
||
|
|
a list of the command parameters used to precompile the source member for
|
||
|
|
the object.</dd>
|
||
|
|
<dt class="dlterm"><span class="cmdname">Start Database Monitor (STRDBMON)</span></dt>
|
||
|
|
<dd>You can use the <span class="cmdname">Start Database Monitor (STRDBMON)</span> command
|
||
|
|
to capture to a file information about every SQL statement that runs.</dd>
|
||
|
|
<dt class="dlterm"><span class="cmdname">Change Query Attribute (CHGQRYA)</span></dt>
|
||
|
|
<dd>You can use the <span class="cmdname">Change Query Attribute (CHGQRYA)</span> command
|
||
|
|
to change the query attributes for the query optimizer. Among the attributes
|
||
|
|
that can be changed by this command are the predictive query governor, parallelism,
|
||
|
|
and the query options.</dd>
|
||
|
|
<dt class="dlterm"><span class="cmdname">Start Debug (STRDBG)</span></dt>
|
||
|
|
<dd>You can use the <span class="cmdname">Start Debug (STRDBG)</span> command to put
|
||
|
|
a job into debug mode and, optionally, add as many as 20 programs and 20 class
|
||
|
|
files and 20 service programs to debug mode. It also specifies certain attributes
|
||
|
|
of the debugging session. For example, it can specify whether database files
|
||
|
|
in production libraries can be updated while in debug mode. </dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="queryopt.htm" title="Query optimization is an iterative process. You can gather performance information about your queries and control the processing of your queries.">Optimizing query performance using query optimization tools</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relinfo"><strong>Related information</strong><br />
|
||
|
|
<div><a href="../cl/dspjob.htm">Display Job (DSPJOB) command</a></div>
|
||
|
|
<div><a href="../cl/prtsqlinf.htm">Print SQL Information (PRTSQLINF) command</a></div>
|
||
|
|
<div><a href="../cl/strdbmon.htm">Start Database Monitor (STRDBMON) command</a></div>
|
||
|
|
<div><a href="../cl/chgqrya.htm">Change Query Attributes (CHGQRYA) command</a></div>
|
||
|
|
<div><a href="../cl/strdbg.htm">Start Debug (STRDBG) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|