DB2 V10.5 Adapter Limitations

Supported Types

This adapter supports types as follows.

Type name SupportRemarks
SMALLINTYes 
INTEGERYes 
BIGINTYes 
REALYes 
DOUBLEYes 
DECIMALYes 
DATEYes 
TIMEYes 
TIMESTAMPYes 
CHARYes 
CHAR FOR BIT DATALimited 
VARCHARYes 
VARCHAR FOR BIT DATALimited 
LONG VARCHAR FOR BIT DATALimited 
CLOBYes 
BLOBLimited 
GRAPHICYes 
VARGRAPHICYes 
LONGVARGRAPHICLimited 
DBCLOBLimited 
XMLLimitedTreated as String data.

Read Table

Specification Limits

Execute Select SQL

Specification Limits

None

Write table

Specification Limits

Execute Update SQL

Specification Limits

Write by Loader

Specification Limits

Notes

Main exceptions

Exception name Cause Actions
com.ibm.db2.jcc.am.SqlNonTransientConnectionException Required property "<Host name>" is unclear. ERRORCODE=-4222, SQLSTATE=08001 Cannot connect to the database. Check the [Host name] in global resource.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException Exception java.net.ConnectException: Error occurred upon opening sockets to Server /<Host name>. Port: <Port number> Message: Connection refused: connect ERRORCODE=-4499, SQLSTATE=08001 Check the [Port number] in global resource
com.ibm.db2.jcc.am.DisconnectNonTransientException For the disperse protocol error causing release of allocating conversation, the execution failed.
DRDA Data stream syntactic error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009
Check the environment of the destination.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException The application server rejected establishment of the connection. An attempt was made to access a database, <Database name>, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004 You may be specifying database that does not exist. Specify the existing database in [Database name] from the global resource.
com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException Connection authorization failure occurred. Reason: password invalid. ERRORCODE=-4214, SQLSTATE=28000 User name or password is wrong. Check [User name] or [Password]. in global resource.
com.ibm.db2.jcc.am.SqlSyntaxErrorException DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=<Table name>, DRIVER=4.16.53 Spaces may have been inserted into the specified table name. Spaces may have been inserted into the [Table name]. In that case, enclose table name with quotation marks.
Table does not exist. DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<Table name>, DRIVER=4.16.53 Specify an existing table from [Table name].