> # Summary of Service Attribute Use

> The following tables list the service attributes and identify the SequeLink Servers to which they apply:

> - Table D-1 "Attributes Used by All SequeLink Servers"
> - Table D-2 "Attributes Used by All SequeLink Servers for Databases Without ROWID Support"
> - Table D-3 "Attributes Used by SequeLink Server for DB2 UDB on Linux, UNIX, and Windows"
> - Table D-4 "Attributes Used by SequeLink Server for DB2 UDB on z/OS"
> - Table D-5 "Attributes Used by SequeLink Server for Informix"
> - Table D-6 "Attributes Used by SequeLink Server for JDBC Socket"
> - Table D-7 "Attributes Used by SequeLink Server for Microsoft SQL Server"
> - Table D-8 "Attributes Used by SequeLink Server for ODBC Socket"
> - Table D-9 "Attributes Used by SequeLink Server for Oracle"
> - Table D-10 "Attributes Used by SequeLink Server for Sybase"

> Table D-1 lists the service attributes that are used by all SequeLink Servers. The attribute name provides a link to the description of the attribute.

> Table D-1. Attributes Used by All SequeLink Servers
> "DataSourceAllowBatchStatements"
> "DataSourceAllowPrefetch"
> "DataSourceApplID"
> "DataSourceArrayFetchMaxBytes"
> "DataSourceAutoApplId"
> "DataSourceBatchProcessing"
> "DataSourceBlockFetchForUpdate"
> "DataSourceCurrentCatalog"
> "DataSourceCursorHold"
> "DataSourceDescribeParam"
> "DataSourceDescription"
> "DataSourceDisableWarnings"
> "DataSourceEnableAccess"
> "DataSourceEnableDescribeParam"
> "DataSourceFetchNextOnly"
> "DataSourceFetchTimeStampAsString"
> "DataSourceFixCharTrim"
> "DataSourceGetOutputParams"
> "DataSourceLimitCursorColumnSize"
> "DataSourceLimitParamBindSize"
> "DataSourceLogoffBehaviour"
> "DataSourceLogonMethod"
> "DataSourceName"
> "DataSourceReadOnly"
> "DataSourceReportLobsAsLongvar"
> "DataSourceSchemaFilterList"
> "DataSourceSessionToken"
> "DataSourceSLKStcCrsrLngCLBuff"
> "DataSourceTableTypeFilterList"
> "DataSourceThreadMaxRpc"
> "DataSourceThreadRpcTimeOut"
> "DataSourceTransactionIsolation"
> "DataSourceWorkArounds"
> "DataSourceWorkarounds2"
> "DataSourceWorkaroundsXliteration"
> "ServiceAdminAuthMethods"
> "ServiceAdministrator"
> "ServiceAdministratorGroup"
> "ServiceAdminKerberosPrincipalName"
> "ServiceCancelEnabled"
> "ServiceCatchExceptions"
> "ServiceCodePage"
> "ServiceCodePageMap"
> "ServiceConnectInfo"
> "ServiceConnectionModel"
> "ServiceDeadClntDetInt"
> "ServiceDebugLogLevel"
> "ServiceDebugLogPath"
> "ServiceDescription"
> "ServiceDetailedOSLogonErrors"
> "ServiceEncryptionAlgorithm"
> "ServiceEnvironmentVariable"
> "ServiceEventTraceLocation"
> "ServiceEventTraceSize"
> "ServiceEvQGetNrEventsMax"
> "ServiceEvQPingTimeout"
> "ServiceEvQShmMonitorSize"
> "ServiceEvQShmQMaxResend"
> "ServiceEvQShmQSize"
> "ServiceEvQShmQWaitResend"
> "ServiceExecPath"
> "ServiceExecPath2"
> "ServiceHost"
> "ServiceIdleTimeInt"
> "ServiceIIOPObjectKey"
> "ServiceIIOPOperationTarget"
> "ServiceInternalTimeout"
> "ServiceKerberosPrincipalName"
> "ServiceLanguage"
> "ServiceMaxSessions"
> "ServiceMaxThreads"
> "ServiceMessageFile"
> "ServiceMinThreads"
> "ServiceName"
> "ServiceRegisterTCPPort"
> "ServiceResolveHostNames"
> "ServiceTCP1stRecvTimeLimit"
> "ServiceThreadLockThreshold"
> "ServiceEvQShmMonitorSize"
> "ServiceEvQShmQMaxResend"
> "ServiceUnixSyslogFacility"
> "ServiceUser"

> Table D-2 lists the service attributes that are used by SequeLink Servers for databases that do not have native ROWID support. The attribute name provides a link to the description of the attribute. ROWID is not used for Oracle and Informix.

> Table D-2. Attributes Used by All SequeLink Servers for Databases Without ROWID Support
> "DataSourceKeySetName"
> "DataSourceKeySetDataType"
> "DataSourceKeySetOptions"
> "DataSourceKeySetSize"

> In addition to the service attributes listed in Table D-1, SequeLink Server for DB2 UDB on Linux, UNIX, and Windows uses the service attributes listed in Table D-3.

> Table D-3. Attributes Used by SequeLink Server for DB2 UDB on Linux, UNIX, and Windows
> "DataSourceDB2ConnectOptions"
> "DataSourceDB2LogPath"

> In addition to the service attributes listed in Table D-1, SequeLink Server for DB2 UDB on z/OS uses the service attributes listed in Table D-4.

> Table D-4. Attributes Used by SequeLink Server for DB2 UDB on z/OS
> "DataSourceDB2DBFilterList"
> "DataSourceDB2CatalogOwner"
> "DataSourceDB2CollectionPrefix"
> "DataSourceDB2DecimalPoint"
> "DataSourceDB2MaxLobSize"
> "DataSourceDB2ReportLobsFirst"
> "DataSourceDB2TranslateCount"
> "MVSDataSourceDB2Plan"
> "MVSDataSourceUIDMap"
> "MVSDB2ExitLibrary"
> "MVSDB2LoadLibrary"
> "MVSDB2RootDescription"
> "MVSDB2SubsystemName"
> "MVSDB2Version"
> "MVSGlobalClustername"
> "MVSGlobalCompTrace"
> "MVSGlobalDB2Attachment"
> "MVSGlobalDescCode"
> "MVSGlobalID"
> "MVSGlobalRouteCode"
> "MVSGlobalSMFRecordType"
> "MVSGlobalSosLimit"
> "MVSGlobalSubSysID"
> "MVSGlobalWLMEnclaves"
> "MVSServiceAdminAuthorizationEnable"
> "MVSServiceAdminSecurity"
> "MVSServiceAuthorizationClass"
> "MVSServiceAuthorizationEnable"
> "MVSServiceAuthorizationResource"
> "MVSServiceDataSourceAuthorization"
> "MVSServiceDB2InterfaceID"
> "MVSServiceLoadModule"
> "MVSServiceSecurity"
> "MVSServiceUIDMap"
> "MVSUID"
> "MVSUIDDefaultAccess"
> "MVSUIDMapDescription"

> In addition to the service attributes listed in Table D-1, SequeLink Server for Informix uses the service attributes listed in Table D-5.

> Table D-5. Attributes Used by SequeLink Server for Informix
> "DataSourceINFClientLocale"
> "DataSourceINFDbAnsiWarn"
> "DataSourceINFDbLang"
> "DataSourceINFDbLocale"
> "DataSourceINFDbNls"
> "DataSourceINFDelimldent"
> "DataSourceINFHost"
> "DataSourceINFInformixDir"
> "DataSourceINFInformixServer"
> "DataSourceINFLang"
> "DataSourceINFService"
> "ServiceINFMaxNrActStat"

> In addition to the service attributes listed in Table D-1, SequeLink Server for JDBC Socket uses the service attributes listed in Table D-6.

> Table D-6. Attributes Used by SequeLink Server for JDBC Socket
> "DataSourceProviderTypesFile"
> "DataSourceProviderTypesSection"
> "DataSourceSOCEmptyRowSyntax"
> "DataSourceSOCJDBCDbProperties Name"
> "DataSourceSOCJDBCDriverClassName"
> "DataSourceSOCJDBCLogPath"
> "DataSourceSOCJDBCReadLongDataLength"
> "ServiceDBConnectionPooling"

> In addition to the service attributes listed in Table D-1, SequeLink Server for Microsoft SQL Server uses the service attributes listed in Table D-7.

> Table D-7. Attributes Used by SequeLink Server for Microsoft SQL Server
> "DataSourceMSSBindAllLOBs"
> "DataSourceMSSConnectOptions"
> "DataSourceMSSCursorType"
> "DataSourceMSSCursorWarnings"
> "ServiceMSSMergeXaBranches"

> In addition to the service attributes listed in Table D-1, SequeLink Server for ODBC Socket uses the service attributes listed in Table D-8.

> Table D-8. Attributes Used by SequeLink Server for ODBC Socket
> "DataSourceProviderTypesFile"
> "DataSourceProviderTypesSection"
> "DataSourceSOCEmptyRowSyntax"
> "DataSourceSOCODBCLogPath"
> "ServiceDBConnectionPooling"

> In addition to the service attributes listed in Table D-1, SequeLink Server for Oracle uses the service attributes listed in Table D-9.

> Table D-9. Attributes Used by SequeLink Server for Oracle
> "DataSourceORAMapTSWTZ"
> "DataSourceORANumber0IsNumeric"
> "DataSourceORAPublicSchemaSupp"
> "DataSourceORARecyclebinSupp"
> "DataSourceORAReportDBLinkAsCatalog"
> "DataSourceORAServiceName"
> "DataSourceORASynDBLinkObjSupp"
> "ServiceORASerializeLogon"

> In addition to the service attributes listed in Table D-1, SequeLink Server for Sybase uses the service attributes listed in Table D-10.

> Table D-10. Attributes Used by SequeLink Server for Sybase
> "DataSourceSybConnectOptions"
> "DataSourceSYBLogPath"
> "DataSourceSybNetworkAddress"