Model 204 SQL Server installation - Revision history

JAL: link repair

2018-04-27T22:29:10Z

link repair

← Older revision		Revision as of 22:29, 27 April 2018
Line 180:		Line 180:

	==SQL Server size==		==SQL Server size==
	The minimum SQL Server size requirements are listed below. The actual server size requirements might vary slightly because of server table settings in the local Online Model 204 region, and because of slight differences between <var>[[UTABLE ~~parameter~~\|UTABLE]]</var> requirements in different versions of Model 204.		The minimum SQL Server size requirements are listed below. The actual server size requirements might vary slightly because of server table settings in the local Online Model 204 region, and because of slight differences between <var>[[UTABLE command\|UTABLE]]</var> requirements in different versions of Model 204.

	<table class="thJustBold">		<table class="thJustBold">

JAL: restore ★

2017-08-11T18:21:57Z

restore <span class="superstar">★</span>

← Older revision		Revision as of 18:21, 11 August 2017
Line 1:		Line 1:
	==Overview==		==Overview==
	Model 204 provides industry standard SQL access to Model 204 data through client-server technology. <var class="product">[[SQL Server overview\|Model 204 SQL Server]]</var> provides full SQL processing in the basic Model 204 address space or virtual machine (ONLINE module) in the IBM z/OS, z/VSE, and z/VM operating systems. The [[Connect*\|Connect<~~sup~~>★</~~sup~~>]] client-server architecture allows the Model 204 SQL Server to service networked PC clients.		Model 204 provides industry standard SQL access to Model 204 data through client-server technology. <var class="product">[[SQL Server overview\|Model 204 SQL Server]]</var> provides full SQL processing in the basic Model 204 address space or virtual machine (ONLINE module) in the IBM z/OS, z/VSE, and z/VM operating systems. The [[Connect*\|Connect<span class="superstar">★</span>]] client-server architecture allows the Model 204 SQL Server to service networked PC clients.

	Installing <var class="product">SQL Server</var> requires the following actions: downloading the <code>M204PROC</code> file and restoring it to your environment, setting up some subsidiary <var class="product">Model 204</var> files, and verifying that the environment has the appropriate parameter settings.		Installing <var class="product">SQL Server</var> requires the following actions: downloading the <code>M204PROC</code> file and restoring it to your environment, setting up some subsidiary <var class="product">Model 204</var> files, and verifying that the environment has the appropriate parameter settings.
Line 125:		Line 125:
	If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>		If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>

	<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the [[Connect*\|Connect<~~sup~~>★</~~sup~~>]] product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>		<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the [[Connect*\|Connect<span class="superstar">★</span>]] product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>
	</ol>		</ol>

Line 176:		Line 176:
	If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>		If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>

	<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the [[Connect*\|Connect<~~sup~~>★</~~sup~~>]] product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>		<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the [[Connect*\|Connect<span class="superstar">★</span>]] product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>
	</ol>		</ol>

Line 225:		Line 225:
	<li>Bring up the Online and verify that the link opened.</li>		<li>Bring up the Online and verify that the link opened.</li>

	<li>Install one or more of the Connect<~~sup~~>★</~~sup~~> connectivity drivers:		<li>Install one or more of the Connect<span class="superstar">★</span> connectivity drivers:
	<ul>		<ul>
	<li>[[Connect* for ODBC\|Connect<~~sup~~>★</~~sup~~> for ODBC]]</li>		<li>[[Connect* for ODBC\|Connect<span class="superstar">★</span> for ODBC]]</li>
	<li>[[Connect* for JDBC\|Connect<~~sup~~>★</~~sup~~> for JDBC]]</li>		<li>[[Connect* for JDBC\|Connect<span class="superstar">★</span> for JDBC]]</li>
	<li>[[Connect* for .NET Framework\|Connect<~~sup~~>★</~~sup~~> for .NET Framework]]</li>		<li>[[Connect* for .NET Framework\|Connect<span class="superstar">★</span> for .NET Framework]]</li>
	</ul></li>		</ul></li>

JAL: add links

2017-08-02T20:02:19Z

add links

← Older revision		Revision as of 20:02, 2 August 2017
Line 125:		Line 125:
	If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>		If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>

	<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the Connect<sup>★</sup> product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>		<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the [[Connect*\|Connect<sup>★</sup>]] product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>
	</ol>		</ol>

Line 176:		Line 176:
	If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>		If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>

	<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the Connect<sup>★</sup> product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>		<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the [[Connect*\|Connect<sup>★</sup>]] product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>
	</ol>		</ol>

JAL: /* Verifying the installation (IBM z/OS only) */ add link

2017-08-02T19:59:13Z

Verifying the installation (IBM z/OS only): add link

← Older revision		Revision as of 19:59, 2 August 2017
Line 195:		Line 195:
	If you are on an IBM z/OS system, you can use the following steps to verify that the SQL Server installation or reinstallation was successful, enabling you to connect to the Online and access data.		If you are on an IBM z/OS system, you can use the following steps to verify that the SQL Server installation or reinstallation was successful, enabling you to connect to the Online and access data.
	<ol>		<ol>
	<li>Define the SQL Link, ProcessGroup, and Process to the Online. <br />An example with minimal security settings is shown here:		<li>Define the SQL [[SQL network entities\|Link, ProcessGroup, and Process]] to the Online. <br />An example with minimal security settings is shown here:
	<p class="code">* DEFINE SQL LINK LINKTCP *		<p class="code">* DEFINE SQL LINK LINKTCP *

JAL: link repair

2017-08-02T19:28:38Z

link repair

← Older revision		Revision as of 19:28, 2 August 2017
Line 125:		Line 125:
	If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>		If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>

	<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the Connect<sup>★</sup> product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#~~Verifying the installation~~\|Verifying the installation]]. </li>		<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the Connect<sup>★</sup> product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>
	</ol>		</ol>

Line 176:		Line 176:
	If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>		If you want, set the <var class="product">SQL Server</var> APSYs to <code>AUTOSTART</code>.</p></li>

	<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the Connect<sup>★</sup> product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#~~Verifying the installation~~\|Verifying the installation]]. </li>		<li>Verify success of the installation by defining the SQL Link/ProcessGroup/Process and threads, then using the Connect<sup>★</sup> product suite to connect to the Online and issue SQL queries against the DEMO database. These steps are described in [[#VerifyInst\|Verifying the installation]]. </li>
	</ol>		</ol>

Line 192:		Line 192:
	</table>		</table>

	==<b id="~~Verifying~~"></b>Verifying the installation (IBM z/OS only)==		==<b id="VerifyInst"></b>Verifying the installation (IBM z/OS only)==
	If you are on an IBM z/OS system, you can use the following steps to verify that the SQL Server installation or reinstallation was successful, enabling you to connect to the Online and access data.		If you are on an IBM z/OS system, you can use the following steps to verify that the SQL Server installation or reinstallation was successful, enabling you to connect to the Online and access data.
	<ol>		<ol>

JAL: /* Verifying the installation (IBM z/OS only) */ add ID

2017-08-02T19:26:09Z

Verifying the installation (IBM z/OS only): add ID

← Older revision		Revision as of 19:26, 2 August 2017
Line 192:		Line 192:
	</table>		</table>

	==Verifying the installation (IBM z/OS only)==		==<b id="Verifying"></b>Verifying the installation (IBM z/OS only)==
	If you are on an IBM z/OS system, you can use the following steps to verify that the SQL Server installation or reinstallation was successful, enabling you to connect to the Online and access data.		If you are on an IBM z/OS system, you can use the following steps to verify that the SQL Server installation or reinstallation was successful, enabling you to connect to the Online and access data.
	<ol>		<ol>

JAL: misc formatting

2017-08-02T01:16:17Z

misc formatting

← Older revision		Revision as of 01:16, 2 August 2017
Line 206:		Line 206:
	LOGIN=NOTRUST GUESTUSER=REJECT LOOKUP=ANY		LOGIN=NOTRUST GUESTUSER=REJECT LOOKUP=ANY

	DEFINE PROCESS CCARSQL WITH SCOPE=SYSTEM DATALEN=32752 -		DEFINE PROCESS CCARSQL WITH SCOPE=SYSTEM DATALEN=32752 FROM=(T1)
	FROM=(T1)

	OPEN LINK LINKTCP</p></li>		OPEN LINK LINKTCP</p></li>

JAL: /* Overview */ add link

2017-08-01T19:17:45Z

Overview: add link

← Older revision		Revision as of 19:17, 1 August 2017
Line 1:		Line 1:
	==Overview==		==Overview==
	Model 204 provides industry standard SQL access to Model 204 data through client-server technology. <var class="product">[[SQL Server overview\|Model 204 SQL Server]]</var> provides full SQL processing in the basic Model 204 address space or virtual machine (ONLINE module) in the IBM z/OS, z/VSE, and z/VM operating systems. The client-server architecture allows the Model 204 SQL Server to service networked PC clients.		Model 204 provides industry standard SQL access to Model 204 data through client-server technology. <var class="product">[[SQL Server overview\|Model 204 SQL Server]]</var> provides full SQL processing in the basic Model 204 address space or virtual machine (ONLINE module) in the IBM z/OS, z/VSE, and z/VM operating systems. The [[Connect*\|Connect<sup>★</sup>]] client-server architecture allows the Model 204 SQL Server to service networked PC clients.

	Installing <var class="product">SQL Server</var> requires the following actions: downloading the <code>M204PROC</code> file and restoring it to your environment, setting up some subsidiary <var class="product">Model 204</var> files, and verifying that the environment has the appropriate parameter settings.		Installing <var class="product">SQL Server</var> requires the following actions: downloading the <code>M204PROC</code> file and restoring it to your environment, setting up some subsidiary <var class="product">Model 204</var> files, and verifying that the environment has the appropriate parameter settings.

JAL: add links

2017-08-01T18:57:04Z

add links

← Older revision		Revision as of 18:57, 1 August 2017
Line 106:		Line 106:
	</li>		</li>

	<li>Ensure that the Dictionary files METADATA, DATALINK, and CCASYS are available to the run.</li>		<li>Ensure that the [[Dictionary/204 overview\|Dictionary]] files METADATA, DATALINK, and CCASYS are available to the run.</li>

	<li>Start the Online, using an <var>ONLINE</var> load module that contains <var class="product">Model 204 Version 7.5 or higher</var>. </li>		<li>Start the Online, using an <var>ONLINE</var> load module that contains <var class="product">Model 204 Version 7.5 or higher</var>. </li>
Line 157:		Line 157:
	<li>Ensure that the existing SQL Server files (M204PROC, CCACAT, TSFDATA, and TSFTEMP) are available to the run, as well as the new M204PROC dump data set.</li>		<li>Ensure that the existing SQL Server files (M204PROC, CCACAT, TSFDATA, and TSFTEMP) are available to the run, as well as the new M204PROC dump data set.</li>

	<li>Ensure that the Dictionary files METADATA, DATALINK, and CCASYS are available to the run.</li>		<li>Ensure that the [[Dictionary/204 overview\|Dictionary]] files METADATA, DATALINK, and CCASYS are available to the run.</li>

	<li>Start the Online, using an <var>ONLINE</var> load module that contains <var class="product">Model 204 Version 7.5 or higher</var>. </li>		<li>Start the Online, using an <var>ONLINE</var> load module that contains <var class="product">Model 204 Version 7.5 or higher</var>. </li>

JAL: rephrase note and update download information

2017-07-28T00:22:12Z

rephrase note and update download information

← Older revision		Revision as of 00:22, 28 July 2017
Line 6:		Line 6:
	Upgrades to <var class="product">SQL Server</var> can almost always be handled by restoring a fresh copy of the <code>M204PROC</code> file.		Upgrades to <var class="product">SQL Server</var> can almost always be handled by restoring a fresh copy of the <code>M204PROC</code> file.

	<~~blockquote~~ class="~~warn~~">		<p class="note"><b>Note:</b>
	~~<p>~~		After Model 204 version 7.5, the next <code>M204PROC</code> file upgrade is part of the [[RKTools]] version 7.7 product family, under which it is downloaded. RKTools 7.7 and higher offers access to the SQL Server DDL-generation tools CCACATREPT and CCATSF from the RKTools TN3270 main menu and from the [[RKWeb]] interface. </p>
	<b>Note:</b> After Model 204 version 7.5, the next <code>M204PROC</code> file upgrade is part of the [[RKTools]] version 7.7 product family, under which it is downloaded. RKTools 7.7 and higher offers access to the SQL Server DDL-generation tools CCACATREPT and CCATSF from the RKTools TN3270 main menu and from the [[RKWeb]] interface. </p>
	~~<p>~~
	~~For post-7.5 SQL Server installation information, refer to [[RKTools installation]]. </p>~~
	~~</blockquote~~>

	==Preparing for Model 204 SQL Server installation==		==Preparing for Model 204 SQL Server installation==
Line 64:		Line 60:
	<ol type="a">		<ol type="a">
	<li>In the [https://m204.rocketsoftware.com/ Rocket M204 Customer Care] page of the Rocket website, go to the "Downloads and Uploads" section and select "Download SOUL files". </li>		<li>In the [https://m204.rocketsoftware.com/ Rocket M204 Customer Care] page of the Rocket website, go to the "Downloads and Uploads" section and select "Download SOUL files". </li>
	<li>After providing your registered customer login information, download the ~~latest~~ version of the <code>M204PROC</code> file. ~~This will be~~ in the ~~form of an~~ M204PROC file ~~dump~~.
			<li>After providing your registered customer login information, download the appropriate version of the <code>M204PROC</code> file dump:
			<ul>
			<li>For Model 204 version 7.5, this is the <code>M204PROC</code> <code>V7.5</code> file found in the <code>M204PROC</code> "Product" row. </li>
			<li>After Model 204 version 7.5, this is the <code>M204PROC</code> file found in the <code>RKTools</code> "Product" row. </li>
			</ul>
	<p>		<p>
	A "Click here" link above the product list provides Help on downloading, file formats, file sizing, uploading, and more.</p></li>		A "Click here" link above the product list provides Help on downloading, file formats, file sizing, uploading, and more.</p></li>
	<li>Upload the ~~M204PROC~~ dump as binary into the newly allocated dump data set.</li>
			<li>Upload the dump file as binary into the newly allocated dump data set.</li>
	</ol>		</ol>
	</li>		</li>
Line 141:		Line 143:
	<li>In the [https://m204.rocketsoftware.com/ Rocket M204 Customer Care] page of the Rocket website, go to the "Downloads and Uploads" section and select "Download SOUL files". </li>		<li>In the [https://m204.rocketsoftware.com/ Rocket M204 Customer Care] page of the Rocket website, go to the "Downloads and Uploads" section and select "Download SOUL files". </li>

	<li>After providing your registered customer login information, download the ~~latest~~ version of the <code>M204PROC</code> file. ~~This will be~~ in the ~~form of an~~ M204PROC file ~~dump~~.		<li>After providing your registered customer login information, download the appropriate version of the <code>M204PROC</code> file dump:
			<ul>
			<li>For Model 204 version 7.5, this is the <code>M204PROC</code> <code>V7.5</code> file found in the <code>M204PROC</code> "Product" row. </li>
			<li>After Model 204 version 7.5, this is the <code>M204PROC</code> file found in the <code>RKTools</code> "Product" row. </li>
			</ul>
	<p>		<p>
	A "Click here" link above the product list provides Help on downloading, file formats, file sizing, uploading, and more.</p></li>		A "Click here" link above the product list provides Help on downloading, file formats, file sizing, uploading, and more.</p></li>

	<li>Upload the ~~M204PROC~~ dump as binary into the newly allocated dump data set.</li>		<li>Upload the dump file as binary into the newly allocated dump data set.</li>
	</ol>		</ol>
	</li>		</li>