The configuration parameters in sp_configure control resource allocation and performance. The system administrator can reset these configuration parameters to tune performance and redefine storage allocation. In the absence of intervention by the system administrator, the server supplies default values for all the parameters.
A number of configuration parameters are unique to Component Integration Services • enable cis – Use this parameter with sp_configure to enable Component Integration
Services.
Issuing sp_configure "enable cis", 0 disables Component Integration Services after restarting the server.
• enable file access – enables access through proxy tables to eXternal File System. • enable full-text search – enables Enhanced Full-Text Search services. Requires a license
for ASE_EFTS
• max cis remote connections – a non-zero value indicates the number of connection data structures pre-allocated during server initialization. The default is zero.
• cis bulk insert batch size – determines how many rows from the source tables are to be bulk copied into the target table as a single batch using select into, when the target table resides in an SAP ASE or in a DirectConnect server that supports a bulk copy interface. If left at zero (the default), all rows are copied as a single batch. Otherwise, after the count of rows specified by this parameter has been copied to the target table, Component Integration Services issues a bulk commit to the target server, causing the batch to be committed.
If a normal client-generated bulk copy operation (such as that produced by the bcp utility) is received, the client is expected to control the size of the bulk batch, and Component Integration Services ignores the value of this configuration parameter.
• cis bulk insert array size – When performing a bulk transfer of data from one SAP ASE to another, Component Integration Services buffers rows internally, and asks the Open Client bulk library to transfer them as a block. The size of the array is controlled by the configuration parameter cis bulk insert array size. The default is 50 rows, and the property is dynamic, allowing it to be changed without server reboot.
• cis cursor rows – allows users to specify the cursor row count for cursor open and cursor fetch operations. Increasing this value means more rows are fetched in one operation. This increases speed but requires more memory. The default is 50.
• cis packet size – allows you to specify the size of Tabular Data Stream™ (TDS) packets that are exchanged between Component Integration Services and a remote server when connection is initiated.
The default packet size on most systems is 512 bytes, which is adequate for most applications. However, larger packet sizes may result in significantly improved query performance, especially when text and image or bulk data is involved.
If a packet size larger than the default is specified, then the target server must be configured to allow variable-length packet sizes. SAP ASE configuration parameters of interest in this case are:
• additional netmem
• maximum network packet size
See the System Administration Guide: Voume 1 for a complete explanation of these configuration parameters.
• cis rpc handling – determines whether Component Integration Services handles outbound RPC requests by default. When this is enabled using sp_configure “cis rpc handling” 1, all outbound RPCs are handled by Component Integration Services. When you use sp_configure “cis rpc handling” 0, the SAP ASE site handler is used. The thread cannot override it with set cis_rpc_handling on. If the global property is disabled, a thread can enable or disable the capability, as required.
The procedure for resetting configuration parameters is:
1. Execute sp_configure, which updates the values field of the system table master..sysconfigures.
2. Restart the server if you have reset any of the static configuration parameters. The
parameters listed below are dynamic. • cis rpc handling
• cis cursor rows
• cis bulk insert batch size • cis bulk insert array size • cis packet size
See also
• RPC handling and Component Integration Services on page 37 sysconfigures Table
The master..sysconfigures system table stores all configuration options. It contains columns identifying the minimum and maximum values possible for each configuration parameter, as well as the configured value and run value for each parameter. The status column in sysconfigures cannot be updated by the user. Status 1 means dynamic, indicating that new values for these configuration parameters take effect
immediately. The rest of the configuration parameters (those with status 0) take effect only after the reconfigure command has been issued and the server restarted.
You can display the configuration parameters currently in use (run values) by executing sp_configure without giving it any parameters.
Changing the Configuration Parameters
sp_configure displays all the configuration values when it is used without an argument. When used with an option name and a value, the server resets the configuration value of that option in the system tables.
See the System Administration Guide for a complete discussion of sp_configure with syntax options.
• To see the Component Integration Services options, enter:
sp_configure "Component Integration Services"
• To change the current value of a configuration parameter, execute sp_configure as follows:
sp_configure "parameter", value