summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorVrishali Doke2012-12-31 02:09:12 (EST)
committer Stephan Born2013-01-25 07:35:58 (EST)
commitd3f3808b93754b61528d7b06c0123d960c2bde06 (patch)
tree4a19ee6101117bb0e7ab21657ad81c2ca1827170
parent2a78c5b285441d752ecf23b925a7e2f7630d44c5 (diff)
downloadorg.eclipse.stardust.documentation-d3f3808b93754b61528d7b06c0123d960c2bde06.zip
org.eclipse.stardust.documentation-d3f3808b93754b61528d7b06c0123d960c2bde06.tar.gz
org.eclipse.stardust.documentation-d3f3808b93754b61528d7b06c0123d960c2bde06.tar.bz2
CRNT-25660 - Added ddl option details
git-svn-id: http://emeafrazerg/svn/ipp/product/trunk/stardust/documentation@61725 8100b5e0-4d52-466c-ae9c-bdeccbdeaf6b
-rw-r--r--org.eclipse.stardust.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm60
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>