MAXCURS (JANUS DEFINE parameter) - Revision history

JAL: remove displaytitle

2016-06-08T00:33:37Z

remove displaytitle

← Older revision		Revision as of 00:33, 8 June 2016
Line 1:		Line 1:
	~~{{DISPLAYTITLE:MAXCURS}}~~
	<span class="pageSubtitle">MAXCURS xxx — max number of cursors allowed for a single SDS connection</span>		<span class="pageSubtitle">MAXCURS xxx — max number of cursors allowed for a single SDS connection</span>

	<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.		<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

	This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[~~http~~:~~//sirius-software.com/maint/download/sdsr~~.pdf Janus Specialty Data Store]</var> connection. The default for <var>MAXCURS</var> is 5.		This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[[Media:JsdsrNew.pdf\|Janus Specialty Data Store]]</var> connection. The default for <var>MAXCURS</var> is 5.

	A <var class="product">Sybase Adaptive Server</var> or <var class="product">Omni SQL Server</var> will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a <var class="product">Sybase Adaptive Server</var> attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.		A <var class="product">Sybase Adaptive Server</var> or <var class="product">Omni SQL Server</var> will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a <var class="product">Sybase Adaptive Server</var> attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.

JALWiccan: Automatically generated page update

2013-04-16T22:18:48Z

Automatically generated page update

← Older revision		Revision as of 22:18, 16 April 2013
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXCURS}}		{{DISPLAYTITLE:MAXCURS}}
	<span class="pageSubtitle"~~><section begin="desc" /~~>MAXCURS xxx — max number of cursors allowed for a single SDS connection~~<section end="desc" />~~</span>		<span class="pageSubtitle">MAXCURS xxx — max number of cursors allowed for a single SDS connection</span>

	<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.		<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

JAL2 at 23:02, 1 March 2012

2012-03-01T23:02:37Z

← Older revision		Revision as of 23:02, 1 March 2012
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXCURS}}		{{DISPLAYTITLE:MAXCURS}}
	<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx &~~amp;~~mdash; max number of cursors allowed for a single SDS connection<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx — max number of cursors allowed for a single SDS connection<section end="desc" /></span>

	<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.		<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

JALWiccan: 1 revision

2012-02-29T22:33:23Z

1 revision

← Older revision	Revision as of 22:33, 29 February 2012
(No difference)

JAL2 at 22:33, 29 February 2012

2012-02-29T22:33:19Z

← Older revision		Revision as of 22:33, 29 February 2012
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXCURS}}		{{DISPLAYTITLE:MAXCURS}}
	<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx — max number of cursors allowed for a single SDS connection<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx &mdash; max number of cursors allowed for a single SDS connection<section end="desc" /></span>

	<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port~~. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]]~~.		<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port.

	This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[http://sirius-software.com/maint/download/sdsr.pdf Janus Specialty Data Store]</var> connection. The default for <var>MAXCURS</var> is 5.		This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[http://sirius-software.com/maint/download/sdsr.pdf Janus Specialty Data Store]</var> connection. The default for <var>MAXCURS</var> is 5.

JAL2 at 21:22, 29 February 2012

2012-02-29T21:22:47Z

← Older revision		Revision as of 21:22, 29 February 2012
Line 6:		Line 6:
	This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[http://sirius-software.com/maint/download/sdsr.pdf Janus Specialty Data Store]</var> connection. The default for <var>MAXCURS</var> is 5.		This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[http://sirius-software.com/maint/download/sdsr.pdf Janus Specialty Data Store]</var> connection. The default for <var>MAXCURS</var> is 5.

	A <var class="product">Sybase Adaptive Server</var> or <var class="product">Omni SQL Server/var> will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a <var class="product">Sybase Adaptive Server</var> attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.		A <var class="product">Sybase Adaptive Server</var> or <var class="product">Omni SQL Server</var> will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a <var class="product">Sybase Adaptive Server</var> attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.

	The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.		The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540, or 12,800 bytes.

	Valid only for <var>[[JANUS DEFINE#type\|SDS]]</var> (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and <var>[[JANUS DEFINE#type\|OAS]]</var>) ports.		Valid only for <var>[[JANUS DEFINE#type\|SDS]]</var> (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and <var>[[JANUS DEFINE#type\|OAS]]</var>) ports.

JAL2 at 21:21, 29 February 2012

2012-02-29T21:21:43Z

← Older revision		Revision as of 21:21, 29 February 2012
Line 1:		Line 1:
	{{DISPLAYTITLE:MAXCURS}}		{{DISPLAYTITLE:MAXCURS}}
	<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx -- max number of cursors allowed for a single SDS connection.<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx — max number of cursors allowed for a single SDS connection<section end="desc" /></span>

	<var>MAXCURS</var> is a parameter on [[JANUS DEFINE]], which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].		<var>MAXCURS</var> is a parameter on <var>[[JANUS DEFINE]]</var>, which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].

	This parameter specifies the maximum number of cursors that can be opened for a single ~~''[~~[Janus Specialty Data Store]~~]''~~ connection. The default for <var>MAXCURS</var> is 5.		This parameter specifies the maximum number of cursors that can be opened for a single <var class="product">[http://sirius-software.com/maint/download/sdsr.pdf Janus Specialty Data Store]</var> connection. The default for <var>MAXCURS</var> is 5.

	A Sybase Adaptive Server or Omni SQL Server will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a Sybase Adaptive Server attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.		A <var class="product">Sybase Adaptive Server</var> or <var class="product">Omni SQL Server/var> will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a <var class="product">Sybase Adaptive Server</var> attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.

	The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.		The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.

	Valid only for SDS (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and OAS) ports.		Valid only for <var>[[JANUS DEFINE#type\|SDS]]</var> (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and <var>[[JANUS DEFINE#type\|OAS]]</var>) ports.

	==~~References~~==		==See also==
			<ul>
			<li>[[List of Janus commands]]
			<li>[[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]]
			</ul>

	~~See: [[List of Janus commands]] \| [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].~~

	[[Category:JANUS DEFINE parameters\|MAXCURS]]		[[Category:JANUS DEFINE parameters\|MAXCURS]]

JALWiccan: 1 revision

2012-02-29T21:14:04Z

1 revision

← Older revision	Revision as of 21:14, 29 February 2012
(No difference)

JAL2 at 21:14, 29 February 2012

2012-02-29T21:14:02Z

← Older revision		Revision as of 21:14, 29 February 2012
Line 10:		Line 10:
	The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.		The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.

	Valid only for SDS (also known as OMNI and OAS) ports.		Valid only for SDS (also known as <var>[[JANUS DEFINE#type\|OMNI]]</var> and OAS) ports.

	==References==		==References==

JAL2 at 18:39, 27 February 2012

2012-02-27T18:39:25Z

← Older revision		Revision as of 18:39, 27 February 2012
Line 2:		Line 2:
	<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx -- max number of cursors allowed for a single SDS connection.<section end="desc" /></span>		<span class="pageSubtitle"><section begin="desc" />MAXCURS xxx -- max number of cursors allowed for a single SDS connection.<section end="desc" /></span>

	MAXCURS is a parameter on [[JANUS DEFINE]], which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].		<var>MAXCURS</var> is a parameter on [[JANUS DEFINE]], which defines and sets characteristics of a Janus port. See the [[JANUS DEFINE#parmlist\|List of JANUS DEFINE parameters]].

	This parameter specifies the maximum number of cursors that can be opened for a single ''[[Janus Specialty Data Store]]'' connection. The default for MAXCURS is 5.		This parameter specifies the maximum number of cursors that can be opened for a single ''[[Janus Specialty Data Store]]'' connection. The default for <var>MAXCURS</var> is 5.

	A Sybase Adaptive Server or Omni SQL Server will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a Sybase Adaptive Server attempts to open more cursors than is allowed by MAXCURS, the request will fail.		A Sybase Adaptive Server or Omni SQL Server will open multiple cursors on a connection to an SDS thread. Typically, even for fairly complex requests the number of simultaneously open cursors will not exceed 3 so that the default of 5 should be fine. If a Sybase Adaptive Server attempts to open more cursors than is allowed by <var>MAXCURS</var>, the request will fail.

	The cost of having a high MAXCURS is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with MAXCURS set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.		The cost of having a high <var>MAXCURS</var> is the storage for each possible cursor is allocated either at port start time for each thread or at connection time for <var>[[ALLOCC (JANUS DEFINE parameter)\|ALLOCC]]</var> ports. The storage required for each cursor is about 64 bytes so that on a 40 thread port with <var>MAXCURS</var> set to 5, the virtual storage used for cursor blocks would be 64540 or 12,800 bytes.

	Valid only for SDS (also known as OMNI and OAS) ports.		Valid only for SDS (also known as OMNI and OAS) ports.