<![CDATA[
<H1> XTSOFT - DB2 for Vse and VM utility
<a href="ADOCTORDB2/adoctor_DB2_home.php">DOCTOR DB2</a> </h1>
<p>Every month,<STRONG> Doctor DB2</strong> processes a performance problem analysis on a <strong>DB2 for VSE & VM</strong> request.</p>
<p>
This month, the problem concerns the following request :</p>
<a href="adoctor_db2.php#debut"></p>
<h1 CLASS ="pieddepage" >SELECT * FROM SYSTEXT1 A ,SYSTEXT2 B <br/>WHERE TOPIC BETWEEN :VAR1 AND :VAR2 AND A.ITEM=B.ITEM</h1></a>
<H2> SQLTUNE - tuning - statistics - dbspaces <a href ="ASQLTUNE/"></a></h2>
<p> SQLTUNE is an xtsoft tuning utility to optimize SQL request. to get best performance on DB2 for VSE & VM application, SQLTUNE collect statistics. Access path is displayed by sqltune depending on existing indexes on tables. sqltune allows request simulation to get the most efficiency from your db2 server
</p>
<H2> SQLREORG - reorg - reorganization - indexes <a href ="aSQLREORG/"></a></h2>
<p>
SQLREORG is an xtsoft reorg utility to optimize dabatase organization. to get best performance on DB2 for VSE & VM application, SQLREORG analyze and reorganize dbspaces requiring reorganization to get the most efficiency from your db2 server.
</p>
<H2> SQLeditor - online table editing <a href ="aSQLEDITOR/"></a></h2>
<p>
SQLeditor is an xtsoft editor utility to edit online db2 for vse & vm tables to get the most efficiency from your db2 server. SQleditor for CICS and SQleditor for VM are available .
</p>
<H2> SQL Transparency for VSAM batch & cics - <a href ="aSQLTRA NSPARENCY/"></a></h2>
<p>
SQL transparency is an xtsoft transparency utility for VSAM including migration utility and conversion to get the most efficiency from your db2 server.
</p>
<H2> Backstore fast backup & restore - table level recovery - <a href ="aBACKSTORE/"></a></h2>
<p>
backstore is an xtsoft fast backup & restore utility for DB2 for VSE & VM including incremental backup, table level recovery,fast unload to get the most efficiency from your db2 server.
</p>
]]>