75 lines
5.1 KiB
HTML
75 lines
5.1 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="Implicit connection management for the default activation group" />
|
||
|
|
<meta name="abstract" content="The application requester can implicitly connect to an application server." />
|
||
|
|
<meta name="description" content="The application requester can implicitly connect to an application server." />
|
||
|
|
<meta name="DC.subject" content="connection management, implicit connection, default activation group, implicit disconnection, distributed relational database, implicit connection, default activation group, implicit disconnection, implicit connect, implicit disconnect, SET TRANSACTION statement, effect on implicit disconnect, CLOSQLCSR parameter" />
|
||
|
|
<meta name="keywords" content="connection management, implicit connection, default activation group, implicit disconnection, distributed relational database, implicit connection, default activation group, implicit disconnection, implicit connect, implicit disconnect, SET TRANSACTION statement, effect on implicit disconnect, CLOSQLCSR parameter" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyconnectmgmt.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydrdaconnect4.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="rbafyc1" />
|
||
|
|
<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>Implicit connection management for the default activation group</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafyc1"><a name="rbafyc1"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Implicit connection management for the default activation group</h1>
|
||
|
|
<div><p>The application requester can implicitly connect to an application
|
||
|
|
server.</p>
|
||
|
|
<div class="section"><p>Implicit SQL connection occurs when the application requester
|
||
|
|
detects the first SQL statement is being issued by the first active SQL program
|
||
|
|
for the default activation group and the following items are true:</p>
|
||
|
|
<ul><li>The SQL statement being issued is not a CONNECT statement with parameters.</li>
|
||
|
|
<li>SQL is not active in the default activation group.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>For a distributed program, the implicit SQL connection is to the
|
||
|
|
relational database specified on the RDB parameter. For a nondistributed
|
||
|
|
program, the implicit SQL connection is to the local relational database.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>SQL will end any active connections in the default activation
|
||
|
|
group when SQL becomes not active. SQL becomes not active when:</p>
|
||
|
|
<ul><li>The application requester detects the first active SQL program for the
|
||
|
|
process has ended and the following are all true: <ul><li>There are no pending SQL changes</li>
|
||
|
|
<li>There are no connections using protected connections</li>
|
||
|
|
<li>A SET TRANSACTION statement is not active</li>
|
||
|
|
<li>No programs that were precompiled with CLOSQLCSR(*ENDJOB) were run.</li>
|
||
|
|
</ul>
|
||
|
|
<p>If there are pending changes, protected connections, or an active
|
||
|
|
SET TRANSACTION statement, SQL is placed in the exited state. If programs
|
||
|
|
precompiled with CLOSQLCSR(*ENDJOB) were run, SQL will remain active for the
|
||
|
|
default activation group until the job ends.</p>
|
||
|
|
</li>
|
||
|
|
<li>At the end of a unit of work, if SQL is in the exited state. This occurs
|
||
|
|
when you issue a COMMIT or ROLLBACK command outside of an SQL program.</li>
|
||
|
|
<li>At the end of a job.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafyconnectmgmt.htm" title="SQL connections are managed at the activation group level. Each activation group within a job manages its own connections and these connections are not shared across activation groups.">Connection management and activation groups</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="rbafydrdaconnect4.htm" title="Because remote connections use resources, connections that are no longer going to be used should be ended as soon as possible. Connections can be ended implicitly or explicitly.">End connections</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|