Server Error Messages 10600 - 10699


 lock hashtable size specifies the number of buckets in the lock hash table.
 the lock spinlock ratio specifies the number of page and row lock buckets in the lock hash table which are protected by each spinlock (buckets per spinlock). 
 row lock promotion HWM sets the maximum number of row locks allowed before SQL server escalates to a table lock. The default value is 200.
 row lock promotion LWM sets the minimum number of row locks allowed before SQL server escalates to a table lock. The default value is 200.
 row lock promotion PCT sets the percentage of row locks allowed before SQL Server escalates to a table lock. The default value is 100.
 dump on conditions indicates whether the SQL Server will create a shared memory dump file if any conditions configured using the sp_dumpconfig stored procedure occurs. Possible values are 0 (not enabled) or 1 (enabled).
 enable SQL Server performance monitoring with Windows NT Perfmon.
 enable unloading of a DLL after each execution of extended stored procedure.
 specify the extended stored procedure execution priority on the XP Server. The values range from 0 to 15. The default value is 8.
 specify the extended stored procedure stack size on the XP Server. The values range and the default value is platform dependent.
 restrict the client execution privileges of the OS command specified with xp_cmdshell. Consult documentation for further details.
 enable start of Sybmail session with Windows NT mail subsystem with SQL Server startup.
 enable SQL Server Error logging with Windows NT Event Viewer.
 enable SQL Server audit (logon success) logging with Windows NT Event Viewer.
 enable SQL Server audit (logon failure) logging with Windows NT Event Viewer.
 specify the computer name for centralized error logging with Windows NT Event Viewer.
 cis rpc handling specifies whether Component Integration Services or a site handler is used to send RPCs. The default is 0 (a site handler is used).
 This parameter is used to change the value of the maximum number of roles that can be enabled by any user in a session.
number of large i/o buffers controls the number of extent size i/o disk buffers which are allocated at server startup. These buffers are used by 'disk mirroring', 'load database' and some dbcc commands.
 number of worker processes is the maximum number of worker processes that can be in use Server-wide at any one time.
 memory per worker process is the additional amount of memory that will be allocated to each worker process.
 max parallel degree is the maximum number of worker processes that can be used by a given query at any one time.
 max scan parallel degree is the maximum number of worker processes that can be used for a parallel scan against a non-partitioned object.
 When set to 1, the Server will allow ONLY those user connections which have already been authenticated by the underlying security mechanism. Default is 0.
 When set to 0, the Server will not initialize the Security Control Layer (support for security services is disabled). Default is 0.
 When this parameter is set to 1, the SQL Server will not allow any user connections which are not using message confidentiality. Default value is 0.
 When this parameter is set to 1, the SQL Server will not allow any user connections which are not using message integrity. Default value is 0.
 When set to 1, the Server will not allow any user connections which are not using message replay detection checks. Default value is 0. When set to 0, the Server will allow connections which use message replay as well as those which don't.
 When set to 1, the Server will not allow any user connections which are not using message origin checks. Default value is 0. When set to 0, the Server will allow connections which use message origin checks as well as those connections which don't.
 When set to 1, the Server will not allow any user connections which are not using message out of sequence detection checks. Default value is 0.
 Each character from this string that appears in the principal name is mapped into the DOLLAR sign. This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the SQL Server name space.
 This login will be used by the SQL Server to let a user enter the SQL Server as a secure default login if the user has already been authenticated by the underlying security mechanism but does not have an entry in the syslogins table.
 Each character from this string that appears in the principal name is mapped into the POUND sign. This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the SQL Server name space.
 Each character from this string that appears in the principal name is mapped into the UNDERSCORE sign. This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the SQL Server name space.
 determines whether users can modify their curread when a cursor is open. The default is 1 (allow users to modify their curread when a cursor is open).
 enables/disables the grouping of stored procedures. The default is 1 (procedure grouping allowed).
 enables/disables granting select to public to the text column of the syscomments table. The default is 1 (grant select on syscomments.text to public).
 enables/disables the ability to send messages to internet addresses. The default is 0 (sendmsg not allowed).
 enables/disables auditing for the whole server. The default is 0 (auditing disabled).
 establishes where SQL Server writes audit records. Values can be 1 to 8, representing sysaudits_01 through sysaudits _08; 0 means to set the current audit table to the next in sequence. The default is 1.
 controls what happens when the audit table becomes full. Values are (1) suspend the audit process and all auditable user processes (default), and (0) truncate the next audit table and start using it as the current table.
 indicates the default port number for sending internet messages.
 enables/disables character conversion before sending to or receiving from the client. The default is 0 (SQL Server will convert characters before sending to or received from the client).
 Maximum dump conditions indicates the maximum number of shared memory dump conditions that can be configured on this server. The value of this field may be from 10 to 100. The default value is 10.
 This configuration option enables/disables the bidirectional index scans
enables/disables asynchronous prefetch server-wide. Sets the percentage of each buffer pool in which prefetched but unused pages can be stored. If needed, this value can be overridden for a pool with local async prefetch limit  
disable disk mirroring is a toggle that allows the user to utilize SQL Server disk mirroring. 
A transaction descriptor is used for each transaction started in a database by a user connection. The number of transaction descriptors per process times the number of user connections is the total number of transaction descriptors available.
enables unicode-based character set conversions. When set to 1, enables conversions for character sets not already in syscharsets. When set to 2, enables Unicode-based conversions for all connections. The default is 0 (off). 
size of unilib cache sets the size of memory (in bytes) to be set aside for additional Unicode-based conversions and collations. 
Configures cache partition server-wide. The global cache partition number must be power of 2, between 1 to 64 and the partitioned buffer pool size must be at least 256P.
The value of ’number of ccbs’ is the number of Configurable Action Point Control Blocks available to aid debugging. 
The value of ’caps per ccb’ is the maximum number of Configurable Action Points that can be configured at any one time within one Configurable Action Point Control Block. 
The value of ’average cap size’ is a guess at how many bytes of memory will be required to store the information associated with a typical Configurable Action Point. 
enable java specifies whether Java Services are loaded when the server is started. The default is 0 (not loaded). 
Size of object heap is the per-process memory used for allocating Java objects. 
Size of class heap is the memory used for Java classes and other such structures that are shared between all processes. 
The 'license information' configuration parameter sets the number of user logins for which Adaptive Server is licensed. When this count is exceeded, an informational message is printed to the error log. Contact Sybase to purchase additional licenses.  
This configuration option ’enable xact coordination’ enables/disables Adaptive Server distributed transaction coordination services. 
The configuration option ’xact coordination interval’ changes the distributed transaction recovery interval. 
The configuration option ’number of dtx participants’ sets the maximum number of local and remote distributed transaction participants that can be active at any instance of time. 
The configuration option ’strict dtm enforcement’ when enabled enforces that only participants that can be managed through Adaptive Server distributed transaction management protocol(s) can participate in a distributed transaction. 
The configuration option ’dtm lock timeout period’ sets the maximum time, in seconds, a distributed transaction participant waits on a lock request after which the lock request is timed out. 
Allow the query optimizer to consider sort-merge join and Join Transitive Closure(JTC). The default is 0. By default, the optimizer does not evaluate sort-merge join and join transitive closure, when generating query execution plans. 
Size of global fixed heap is the size of memory used by the Java subsystem for internal data structures and other needs that are shared by all processes. 
enable monitoring specifies whether the Adaptive Server will collect information for the Monitoring and Diagnostic System.
autostart collector indicates whether the Adaptive Server will start the Q Diagnsotics Engine collector process on server startup. 
collector repository server specifies the name of the Q Diagnostics Engine repository server. 
collector application host specifies the name of the Q Diagnostics Engine Application Server host system. 
collector errorlog file specifies the directory in which the Q Diagnostics Engine Collector process should place its errorlog file. 
collector failover file specifies the directory in which the Q Diagnostics Engine Collector process should place it’s failover file 
collection interval specifies the amount of time the Q Diagnostics Engine Collector process waits between each data collection cycle. 
sql text pipe active indicates whether the Adaptive Server will collect historical sql batch text information. 
sql text pipe max messages specifies the maximum number of messages that can be stored for historical sql text. 
plan text pipe active indicates whether the Adaptive Server will collect historical plan text monitoring information. 
plan text pipe max messages specifies the maximum number of messages that can be stored for historical plan text. 
statement pipe active indicates whether the Adaptive Server will collect historical statement level monitoring information. 
statement pipe max messages specifies the maximum number of messages that can be stored for historical statement text. 
errorlog pipe active indicates whether the Adaptive Server will collect historical errorlog monitoring information. 
errorlog pipe max messages specifies the maximum number of messages that can be stored for historical errorlog text. 
deadlock pipe active indicates whether the Adaptive Server will collect historical deadlock monitoring information. 
deadlock pipe max messages specifies the maximum number of messages that can be stored for historical deadlock data. 
wait event timing specifies whether the Adaptive Server will collect monitoring data for all wait events. 
process event timing specifies whether the Adaptive Server will collect monitoring data on wait events for individual processes. 
object lockwait timing specifies whether the Adaptive Server will collect timing data on lock requests. 
SQL batch capture indicates whether the Adaptive Server will collect sql batch text for each process. 
tatement statistics active indicates whether the SQL Server will collect ad-hoc statement monitoring information 
’text prefetch size’ specifies the number of text pages to prefetch into the text read pipeline. 
The ’default exp_row_size percent’ parameter reserves a specified percentage of page size for expanding updates in data-only-locked tables. The default value is 5. 
’enable housekeeper GC’ is a toggle that enables the housekeeper task to perform space reclamation on data-only-locked tables. The default value is 1 (enabled). 
’enable rep agent threads’ is a toggle that enables RepAgent threads within Adaptive Server. The default value is 0 (disabled). 
’lock scheme’ sets the default locking scheme to be used by the create table and select into commands when a lock scheme is not specified in the command. The default value is allpages. 
’lock wait period’ limits the number of seconds that tasks wait to acquire a lock on a table, data page or data row. The default value is 2,147,483,647. At the default value, all tasks wait indefinitely for locks. 
’max SQL text monitored’ specifies the amount of memory allocated per user connection for saving SQL text to memory shared by Adaptive Server. The default value is 0. 
’read committed with lock’ determines whether an Adaptive Server using transaction isolation level 1 (read committed) holds shared locks on rows or pages of data-only-locked tables during select queries. The default value is 0 (off). 
maximum failed logins is the number of _consecutive_ failed login attempts permitted before the targeted login is locked. It is set to zero after every successful login. 
minimum password length is the minimum number of characters a password must have to be accepted for any new logins. Logins that were set up using the previously set minimum password length can continue having fewer characters for their passwords. 
Setting configuration parameter ’check password for digit’ to 1 checks newly set passwords for the presence of at least one digit. This parameter is off(set to 0) by default. 

Number	Severity	Text and Explanation
10601	10	lock hashtable size specifies the number of buckets in the lock hash table. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10602	10	the lock spinlock ratio specifies the number of page and row lock buckets in the lock hash table which are protected by each spinlock (buckets per spinlock). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10603	10	row lock promotion HWM sets the maximum number of row locks allowed before SQL server escalates to a table lock. The default value is 200. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10604	10	row lock promotion LWM sets the minimum number of row locks allowed before SQL server escalates to a table lock. The default value is 200. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10605	10	row lock promotion PCT sets the percentage of row locks allowed before SQL Server escalates to a table lock. The default value is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10606	10	dump on conditions indicates whether the SQL Server will create a shared memory dump file if any conditions configured using the sp_dumpconfig stored procedure occurs. Possible values are 0 (not enabled) or 1 (enabled). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10607	10	enable SQL Server performance monitoring with Windows NT Perfmon. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10608	10	enable unloading of a DLL after each execution of extended stored procedure. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10609	10	specify the extended stored procedure execution priority on the XP Server. The values range from 0 to 15. The default value is 8. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10610	10	specify the extended stored procedure stack size on the XP Server. The values range and the default value is platform dependent. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10611	10	restrict the client execution privileges of the OS command specified with xp_cmdshell. Consult documentation for further details. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10612	10	enable start of Sybmail session with Windows NT mail subsystem with SQL Server startup. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10613	10	enable SQL Server Error logging with Windows NT Event Viewer. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10614	10	enable SQL Server audit (logon success) logging with Windows NT Event Viewer. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10615	10	enable SQL Server audit (logon failure) logging with Windows NT Event Viewer. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10616	10	specify the computer name for centralized error logging with Windows NT Event Viewer. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10617	16	cis rpc handling specifies whether Component Integration Services or a site handler is used to send RPCs. The default is 0 (a site handler is used). Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
10618	16	This parameter is used to change the value of the maximum number of roles that can be enabled by any user in a session. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
10619	10	number of large i/o buffers controls the number of extent size i/o disk buffers which are allocated at server startup. These buffers are used by 'disk mirroring', 'load database' and some dbcc commands. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10620	10	number of worker processes is the maximum number of worker processes that can be in use Server-wide at any one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10621	10	memory per worker process is the additional amount of memory that will be allocated to each worker process. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10622	10	max parallel degree is the maximum number of worker processes that can be used by a given query at any one time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10623	10	max scan parallel degree is the maximum number of worker processes that can be used for a parallel scan against a non-partitioned object. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10624	10	When set to 1, the Server will allow ONLY those user connections which have already been authenticated by the underlying security mechanism. Default is 0. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10625	10	When set to 0, the Server will not initialize the Security Control Layer (support for security services is disabled). Default is 0. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10626	10	When this parameter is set to 1, the SQL Server will not allow any user connections which are not using message confidentiality. Default value is 0. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10627	10	When this parameter is set to 1, the SQL Server will not allow any user connections which are not using message integrity. Default value is 0. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10628	10	When set to 1, the Server will not allow any user connections which are not using message replay detection checks. Default value is 0. When set to 0, the Server will allow connections which use message replay as well as those which don't. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10629	10	When set to 1, the Server will not allow any user connections which are not using message origin checks. Default value is 0. When set to 0, the Server will allow connections which use message origin checks as well as those connections which don't. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10630	10	When set to 1, the Server will not allow any user connections which are not using message out of sequence detection checks. Default value is 0. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10631	10	Each character from this string that appears in the principal name is mapped into the DOLLAR sign. This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the SQL Server name space. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10632	10	This login will be used by the SQL Server to let a user enter the SQL Server as a secure default login if the user has already been authenticated by the underlying security mechanism but does not have an entry in the syslogins table. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10633	10	Each character from this string that appears in the principal name is mapped into the POUND sign. This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the SQL Server name space. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10634	10	Each character from this string that appears in the principal name is mapped into the UNDERSCORE sign. This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the SQL Server name space. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10635	10	determines whether users can modify their curread when a cursor is open. The default is 1 (allow users to modify their curread when a cursor is open). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10636	10	enables/disables the grouping of stored procedures. The default is 1 (procedure grouping allowed). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10637	10	enables/disables granting select to public to the text column of the syscomments table. The default is 1 (grant select on syscomments.text to public). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10638	10	enables/disables the ability to send messages to internet addresses. The default is 0 (sendmsg not allowed). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10639	10	enables/disables auditing for the whole server. The default is 0 (auditing disabled). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10640	10	establishes where SQL Server writes audit records. Values can be 1 to 8, representing sysaudits_01 through sysaudits _08; 0 means to set the current audit table to the next in sequence. The default is 1. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10641	10	controls what happens when the audit table becomes full. Values are (1) suspend the audit process and all auditable user processes (default), and (0) truncate the next audit table and start using it as the current table. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10642	10	indicates the default port number for sending internet messages. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10643	10	enables/disables character conversion before sending to or receiving from the client. The default is 0 (SQL Server will convert characters before sending to or received from the client). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10645	16	Maximum dump conditions indicates the maximum number of shared memory dump conditions that can be configured on this server. The value of this field may be from 10 to 100. The default value is 10. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
10646	16	This configuration option enables/disables the bidirectional index scans Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
10647	10	enables/disables asynchronous prefetch server-wide. Sets the percentage of each buffer pool in which prefetched but unused pages can be stored. If needed, this value can be overridden for a pool with local async prefetch limit Explanation: This is an informational message. No action is required.
10648	10	disable disk mirroring is a toggle that allows the user to utilize SQL Server disk mirroring. Explanation: This is an informational message. No action is required.
10649	10	A transaction descriptor is used for each transaction started in a database by a user connection. The number of transaction descriptors per process times the number of user connections is the total number of transaction descriptors available. Explanation: This is an informational message. No action is required.
10650	10	enables unicode-based character set conversions. When set to 1, enables conversions for character sets not already in syscharsets. When set to 2, enables Unicode-based conversions for all connections. The default is 0 (off). Explanation: This message is generated from sp_configure when you ask for a description of the 'enable unicode conversions' option.
10651	10	size of unilib cache sets the size of memory (in bytes) to be set aside for additional Unicode-based conversions and collations. Explanation: This is an informational message returned by sp_configure to describe what the 'number of unilib buffers' option does.
10652	16	Configures cache partition server-wide. The global cache partition number must be power of 2, between 1 to 64 and the partitioned buffer pool size must be at least 256P. Explanation: This is an informational message.
10653	10	The value of ’number of ccbs’ is the number of Configurable Action Point Control Blocks available to aid debugging. Explanation: This message documents a feature introduced in Galaxy. However, the config parameters and the message do show up in an 11.9 server. The parameters have no effect on the 11.9 server though.
10654	10	The value of ’caps per ccb’ is the maximum number of Configurable Action Points that can be configured at any one time within one Configurable Action Point Control Block. Explanation: This message documents a feature introduced in Galaxy. However, the config parameters and the message do show up in an 11.9 server. The parameters have no effect on the 11.9 server though.
10655	10	The value of ’average cap size’ is a guess at how many bytes of memory will be required to store the information associated with a typical Configurable Action Point. Explanation: This message documents a feature introduced in Galaxy. However, the config parameters and the message do show up in an 11.9 server. The parameters have no effect on the 11.9 server though.
10656	16	enable java specifies whether Java Services are loaded when the server is started. The default is 0 (not loaded). Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10657	16	Size of object heap is the per-process memory used for allocating Java objects. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10658	16	Size of class heap is the memory used for Java classes and other such structures that are shared between all processes. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10659	10	The 'license information' configuration parameter sets the number of user logins for which Adaptive Server is licensed. When this count is exceeded, an informational message is printed to the error log. Contact Sybase to purchase additional licenses. Explanation: This is an informational message. No action is required.
10660	10	This configuration option ’enable xact coordination’ enables/disables Adaptive Server distributed transaction coordination services. Explanation: This is an informational message. No action is required.
10661	10	The configuration option ’xact coordination interval’ changes the distributed transaction recovery interval. Explanation: his is an informational message. No action is required.
10662	10	The configuration option ’number of dtx participants’ sets the maximum number of local and remote distributed transaction participants that can be active at any instance of time. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10663	10	The configuration option ’strict dtm enforcement’ when enabled enforces that only participants that can be managed through Adaptive Server distributed transaction management protocol(s) can participate in a distributed transaction. Explanation: This is an informational message. No action is required.
10664	10	The configuration option ’dtm lock timeout period’ sets the maximum time, in seconds, a distributed transaction participant waits on a lock request after which the lock request is timed out. Explanation: This is an informational message. No action is required.
10665	10	Allow the query optimizer to consider sort-merge join and Join Transitive Closure(JTC). The default is 0. By default, the optimizer does not evaluate sort-merge join and join transitive closure, when generating query execution plans. Explanation: This is an informational message. No action is required.
10666	16	Size of global fixed heap is the size of memory used by the Java subsystem for internal data structures and other needs that are shared by all processes. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10667	10	enable monitoring specifies whether the Adaptive Server will collect information for the Monitoring and Diagnostic System. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10668	10	autostart collector indicates whether the Adaptive Server will start the Q Diagnsotics Engine collector process on server startup. Explanation: This is an informational message. No action is required.
10669	10	collector repository server specifies the name of the Q Diagnostics Engine repository server. Explanation: This is an informational message. No action is required.
10670	10	collector application host specifies the name of the Q Diagnostics Engine Application Server host system. Explanation: This is an informational message. No action is required.
10671	10	collector errorlog file specifies the directory in which the Q Diagnostics Engine Collector process should place its errorlog file. Explanation: This is an informational message. No action is required.
10672	10	collector failover file specifies the directory in which the Q Diagnostics Engine Collector process should place it’s failover file Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10673	10	collection interval specifies the amount of time the Q Diagnostics Engine Collector process waits between each data collection cycle. Explanation: This is an informational message. No action is required.
10674	10	sql text pipe active indicates whether the Adaptive Server will collect historical sql batch text information. Explanation: This is an informational message. No action is required.
10675	10	sql text pipe max messages specifies the maximum number of messages that can be stored for historical sql text. Explanation: This is an informational message. No action is required.
10676	10	plan text pipe active indicates whether the Adaptive Server will collect historical plan text monitoring information. Explanation: This is an informational message. No action is required.
10677	10	plan text pipe max messages specifies the maximum number of messages that can be stored for historical plan text. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10678	16	statement pipe active indicates whether the Adaptive Server will collect historical statement level monitoring information. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10679	10	statement pipe max messages specifies the maximum number of messages that can be stored for historical statement text. Explanation: This is an informational message. No action is required.
10680	10	errorlog pipe active indicates whether the Adaptive Server will collect historical errorlog monitoring information. Explanation: This is an informational message. No action is required.
10681	10	errorlog pipe max messages specifies the maximum number of messages that can be stored for historical errorlog text. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10682	10	deadlock pipe active indicates whether the Adaptive Server will collect historical deadlock monitoring information. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10683	10	deadlock pipe max messages specifies the maximum number of messages that can be stored for historical deadlock data. Explanation: This is an informational message. No action is required.
10684	10	wait event timing specifies whether the Adaptive Server will collect monitoring data for all wait events. Explanation: This is an informational message. No action is required.
10685	10	process event timing specifies whether the Adaptive Server will collect monitoring data on wait events for individual processes. Explanation: This is an informational message. No action is required.
10686	10	object lockwait timing specifies whether the Adaptive Server will collect timing data on lock requests. Explanation:
10687	10	SQL batch capture indicates whether the Adaptive Server will collect sql batch text for each process. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10688	16	tatement statistics active indicates whether the SQL Server will collect ad-hoc statement monitoring information Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10689	16	’text prefetch size’ specifies the number of text pages to prefetch into the text read pipeline. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
10690	10	The ’default exp_row_size percent’ parameter reserves a specified percentage of page size for expanding updates in data-only-locked tables. The default value is 5. Explanation: This is an informational message. No action is required.
10691	10	’enable housekeeper GC’ is a toggle that enables the housekeeper task to perform space reclamation on data-only-locked tables. The default value is 1 (enabled). Explanation: This is an informational message. No action is required.
10692	10	’enable rep agent threads’ is a toggle that enables RepAgent threads within Adaptive Server. The default value is 0 (disabled). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10693	10	’lock scheme’ sets the default locking scheme to be used by the create table and select into commands when a lock scheme is not specified in the command. The default value is allpages. Explanation: This is an informational message. No action is required.
10694	10	’lock wait period’ limits the number of seconds that tasks wait to acquire a lock on a table, data page or data row. The default value is 2,147,483,647. At the default value, all tasks wait indefinitely for locks. Explanation: This is an informational message. No action is required.
10695	10	’max SQL text monitored’ specifies the amount of memory allocated per user connection for saving SQL text to memory shared by Adaptive Server. The default value is 0. Explanation: This is an informational message. No action is required.
10696	10	’read committed with lock’ determines whether an Adaptive Server using transaction isolation level 1 (read committed) holds shared locks on rows or pages of data-only-locked tables during select queries. The default value is 0 (off). Explanation: This is an informational message. No action is required.
10697	10	maximum failed logins is the number of _consecutive_ failed login attempts permitted before the targeted login is locked. It is set to zero after every successful login. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
10698	10	minimum password length is the minimum number of characters a password must have to be accepted for any new logins. Logins that were set up using the previously set minimum password length can continue having fewer characters for their passwords. Explanation: This is an informational message. No action is required.
10699	10	Setting configuration parameter ’check password for digit’ to 1 checks newly set passwords for the presence of at least one digit. This parameter is off(set to 0) by default. Explanation: This is an informational message. No action is required.