44 lines
3.0 KiB
HTML
44 lines
3.0 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="Cleanup SQL packages" />
|
||
|
|
<meta name="abstract" content="The packages used for DRDA functions are created automatically on your system as needed. You might want to periodically cleanup these packages. To delete the packages, use the Delete SQL Package (DLTSQLPKG) command." />
|
||
|
|
<meta name="description" content="The packages used for DRDA functions are created automatically on your system as needed. You might want to periodically cleanup these packages. To delete the packages, use the Delete SQL Package (DLTSQLPKG) command." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzaiimst38.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="rzaiimstsqlclean" />
|
||
|
|
<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>Cleanup SQL packages</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzaiimstsqlclean"><a name="rzaiimstsqlclean"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Cleanup SQL packages</h1>
|
||
|
|
<div><p>The packages used for DRDA<sup>®</sup> functions are created automatically
|
||
|
|
on your system as needed. You might want to periodically cleanup these packages.
|
||
|
|
To delete the packages, use the Delete SQL Package (DLTSQLPKG) command.</p>
|
||
|
|
<p>Delete the packages only if they are not used often. The package is created
|
||
|
|
again if needed, but performance noticeably decreases when a package is created
|
||
|
|
a second time.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaiimst38.htm" title="SQL packages bind SQL statements in an application program to a relational database. They are used to enhance the performance of applications that use dynamic SQL support by allowing the application to reuse information about the SQL requests.">SQL packages</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|