CRNT-25660 - Added ddl option details

git-svn-id: http://emeafrazerg/svn/ipp/product/trunk/stardust/documentation@61725 8100b5e0-4d52-466c-ae9c-bdeccbdeaf6b

1 files changed, 60 insertions, 0 deletions

diff --git a/org.eclipse.stardust.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm b/org.eclipse.stardust.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm
index 58b62f8..565f56f 100644
--- a/org.eclipse.stardust.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm
+++ b/org.eclipse.stardust.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm
@@ -458,6 +458,7 @@ lock table and cluster table administration:</p>
     <li><a href="#proxyTableAdmin">Proxy Lock Tables Administration</a></li>

     <li><a href="#cluster">Cluster Table Administration</a></li>

     <li><a href="#run">Runtime Upgrade</a></li>
+    	<li><a href="#multistep">Step by step Runtime Upgrade</a></li>
 </ul>

 <h3 id="archive">Audit Trail Archive Administration</h3>

 <p>The archive command deletes or archives data from the audit trail. The deleted 

@@ -828,7 +829,66 @@ Finalize schema task:
 Default link types will be added.
 </pre>
 
+<h4 id="multistep">Step by step Runtime Upgrade</h4>
+<p>
+You can execute runtime upgrade step by step. 
+Suppose you want to upgrade from @productname@ 5.3 to @productname@ 7.0.
+Firstly, perform the upgrade using the option <tt>-ddl</tt> in combination with <tt>-step</tt> option.
+</p>
+
+<pre>
+sysconsole -p sysop upgraderuntime -verbose -step -ddl 5_3To6_0.txt
+</pre>
+
+<p>Following upgrade details are displayed in the 5_3To6_0.txt file. </p>
+
+<pre>
+// 6.0.0 schema upgrade DDL
+
+CREATE TABLE carnot.preferences (OWNERID NUMBER, OWNERTYPE VARCHAR2(32 CHAR), MODULEID VARCHAR2(255 CHAR), PREFERENCESID VARCHAR2(255 CHAR), PARTITION NUMBER, STRINGVALUE CLOB);
+CREATE UNIQUE INDEX carnot.preferences_idx1 ON carnot.preferences(OWNERID, OWNERTYPE, MODULEID, PREFERENCESID, PARTITION);
+DROP SEQUENCE carnot.message_store_seq;
+DROP TABLE carnot.message_store;
+CREATE TABLE carnot.model_ref (CODE INTEGER, MODELOID NUMBER, ID VARCHAR2(255 CHAR), REFOID NUMBER, DEPLOYMENT NUMBER);
+CREATE UNIQUE INDEX carnot.model_ref_idx1 ON carnot.model_ref(CODE, MODELOID, ID, DEPLOYMENT);
+CREATE UNIQUE INDEX carnot.model_ref_idx2 ON carnot.model_ref(CODE, MODELOID, REFOID, DEPLOYMENT);
+CREATE TABLE carnot.model_dep (OID NUMBER, DEPLOYER NUMBER, DEPLOYMENTTIME NUMBER, VALIDFROM NUMBER, DEPLOYMENTCOMMENT VARCHAR2(255 CHAR));
+CREATE UNIQUE INDEX carnot.model_dep_idx1 ON carnot.model_dep(OID);
+CREATE INDEX carnot.model_dep_idx2 ON carnot.model_dep(DEPLOYMENTTIME);
+CREATE INDEX carnot.model_dep_idx3 ON carnot.model_dep(DEPLOYER);
+CREATE SEQUENCE carnot.model_dep_seq;
+ALTER TABLE carnot.process_instance ADD DEPLOYMENT NUMBER;
+
+// 6.0.0 schema finalization DDL
+</pre>
+<p>The upgrade is performed till the version 6.0. Secondly, again execute the following
+command:</p>
 
+<pre>
+sysconsole -p sysop upgraderuntime -verbose -step -ddl 6_0To7_0.txt
+</pre>
+<p>Following upgrade details are displayed in the 6_0To7_0.txt file.</p>
+
+<pre>
+
+// 6.0.0 schema upgrade DDL
+
+CREATE TABLE carnot.preferences (OWNERID NUMBER, OWNERTYPE VARCHAR2(32 CHAR), MODULEID VARCHAR2(255 CHAR), PREFERENCESID VARCHAR2(255 CHAR), PARTITION NUMBER, STRINGVALUE CLOB);
+CREATE UNIQUE INDEX carnot.preferences_idx1 ON carnot.preferences(OWNERID, OWNERTYPE, MODULEID, PREFERENCESID, PARTITION);
+DROP SEQUENCE carnot.message_store_seq;
+DROP TABLE carnot.message_store;
+CREATE TABLE carnot.model_ref (CODE INTEGER, MODELOID NUMBER, ID VARCHAR2(255 CHAR), REFOID NUMBER, DEPLOYMENT NUMBER);
+CREATE UNIQUE INDEX carnot.model_ref_idx1 ON carnot.model_ref(CODE, MODELOID, ID, DEPLOYMENT);
+CREATE UNIQUE INDEX carnot.model_ref_idx2 ON carnot.model_ref(CODE, MODELOID, REFOID, DEPLOYMENT);
+CREATE TABLE carnot.model_dep (OID NUMBER, DEPLOYER NUMBER, DEPLOYMENTTIME NUMBER, VALIDFROM NUMBER, DEPLOYMENTCOMMENT VARCHAR2(255 CHAR));
+CREATE UNIQUE INDEX carnot.model_dep_idx1 ON carnot.model_dep(OID);
+CREATE INDEX carnot.model_dep_idx2 ON carnot.model_dep(DEPLOYMENTTIME);
+CREATE INDEX carnot.model_dep_idx3 ON carnot.model_dep(DEPLOYER);
+CREATE SEQUENCE carnot.model_dep_seq;
+ALTER TABLE carnot.process_instance ADD DEPLOYMENT NUMBER;
+
+// 6.0.0 schema finalization DDL
+</pre>