DB2 V9.1 Adapter Limitations

Sales and support for DB2 V9.1 adapter has ended.

Supported Types
Read Table Limitations
Execute Select SQL Limitations
Write Table Limitations
Execute Update SQL Limitations
Write by Loader Limitations
Main exception messages
Notes

Supported Types

This adapter supports types as follows.

name	Support	Remarks
SMALLINT	Yes
INTEGER	Yes
BIGINT	Yes
REAL	Yes
DOUBLE	Yes
DECIMAL	Yes
DATE	Yes
TIME	Yes
TIMESTAMP	Yes
CHAR	Yes
CHAR FOR BIT DATA	Limited
VARCHAR	Yes
VARCHAR FOR BIT DATA	Limited
LONG VARCHAR FOR BIT DATA	Limited
CLOB	Yes
BLOB	Limited
GRAPHIC	Yes
VARGRAPHIC	Yes
LONGVARGRAPHIC	Limited
DBCLOB	Limited

Yes: Support.
Limited: Support with limitations.
No: Not supported.

Read Table Limitations

If the table name is enclosed by quotation marks, the table names are case-sensitive.

Execute Select SQL Limitations

None.

Write Table Limitations

If the table name is enclosed by quotation marks, the table names are case-sensitive.

Does not support batch update.

Execute Update SQL Limitations

Does not support batch update.

Restriction on writing by loader

The following types are not supported.
- LONG VARGRAPHIC
- DBCLOB
- BLOB
- CHAR FOR BIT DATA
- VARCHAR FOR BIT DATA
- LONG VARCHAR FOR BIT DATA

About Client Tools

DB2 client is required in the host where DataSpiderServer is installed.

Supported Client Version

V9.1 (Windows)

Notes

Refer to [TCP/IP service name (SVCENAME)] by executing "DB2 GET DBM CONFIG" command to check TCP service name of database instance.
Execute "DB2 CATALOG TCPIP NODE" command to add to node directory of the client. Refer to CATALOG TCPIP NODE command For more information about the command.

Main exception messages

Exception Name	Message	Cause / Solution
java.sql.SQLException	IO Exception opening socket to server <hostname> on port <port>. The DB2 Server may be down.	Cannot connect to the database.Please check the host name and port number.
	The application server rejected establishment of the connection. An attempt was made to access a database, dstes, which was not found.	Make sure the specified table exists.
	Connection authorization failure occurred. Reason: password invalid.	Please check the specified user name or password.
	DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: XXX; SELECT * FROM <table name>; <space>	Spaces may have been inserted into the specified table name. In that case, enclose table name with quotation marks.
	DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: <table name>	Make sure the specified table exists.