CA SSO DB2 Server Wire Protocol

Document ID : KB000032795
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary

 When configuring an ODBC Data Source on a UNIX OS to connect to an IBM DB2 Data Source, the 'db2wire.ini' data source template is used to configure the  'system_odbc.ini' file.  The template files are located in  <Siteminder_home>/db. 

The 'db2wire.ini' data source template is a basic template.  

Example:

[ODBC Data Sources]
SiteMinder Data Source=DataDirect 7.1 DB2 Driver

[SiteMinder Data Source]
Driver
=/opt/CA/siteminder/odbc/lib/NSdb227.so
Description=DataDirect 7.1 DB2 Driver
Database=nete_database
IpAddress=nete_server
TcpPort=50000
Package=nete_package
PackageOwner=
GrantAuthid=PUBLIC
GrantExecute=0
IsolationLevel=CURSOR_STABILITY
DynamicSections=100
DMCleanup=2

 

 

The sample Data Source information includes the basic attributes necessary to establish a connection to the database.  Any additional features or settings supported by the ODBC server would require that the appropriate attribute be manually added to the Data Source.

Solution:

This is a list of all of the available Data Source attributes on the SQL Wire Protocol driver for DB2.

Driver=/opt/CA/siteminder/odbc/lib/NSdb227.so
Description=
IpAddress=localhost
TcpPort=50000
Location=
Collection=
Database=SMDB2TEST1
LogonID=
WithHold=1
FetchTSWTZasTimestamp=0
AddStringToCreateTable=
AlternateID=
DefaultIsolationLevel=1
ConcurrentAccessResolution=0
CatalogSchema=
UseCurrentSchema=0
CharsetFor65535=
CharsetFor65535Mode=1
ReportCodePageConversionErrors=0
XMLDescribeType=-10
LoginTimeout=15
QueryTimeout=0
EnableLiteralReplacement=0
GrantExecute=1
GrantAuthid=PUBLIC
PackageCollection=NULLID
PackageOwner=
DynamicSections=1000
ApplicationUsingThreads=1
AuthenticationMethod=0
GSSClient=native
EncryptionMethod=0
CryptoProtocolVersion=
TrustStore=
TrustStorePassword=
KeyStore=
KeyStorePassword=
KeyPassword=
HostNameInCertificate=
ValidateServerCertificate=1
LoadBalancing=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
AlternateServers=
FailoverMode=0
FailoverGranularity=0
FailoverPreconnect=0
EnableBulkLoad=0
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
ApplicationName=
ClientUser=
ClientHostName=
AccountingInfo=
ProgramID=
CurrentFuncPath=
PackageNamePrefix=DD
Pooling=0
ConnectionReset=0
MaxPoolSize=100
MinPoolSize=0
LoadBalanceTimeout=0
ExtendedOptions=
KeepAlive=0

 

NOTE: The attributes in the example (above) reflect the hardcoded, default values.  Adding the attribute and modifying the value will override the default value with the user-designated value.