DB2 FOR LUW / DB2FORLUW / A10 - DB2

db2 => create wrapper mssql_wrap library 'libdb2mssql3.so' 
db2 => create server mssql2008_serv type mssqlserver version 
2008 wrapper mssql_wrap options(node '*', dbname '*') 
db2 => create user mapping for user server mssql2008_serv 
options(remote_authid '*', remote_password '*') 
db2 => set passthru mssql2008_serv 
db2 => create table test3 (c1 date, c2 char) 
db2 => insert into test3 values ('2012-01-01','a') 
db2 => insert into test3 values ('2012-01-02','b') 
db2 => insert into test3 values ('2012-01-03','c') 
db2 => insert into test3 values ('2012-01-04','d') 
db2 => set passthru reset 
 
From SQL Server Management Studio, run 
EXEC sp_createstats 
 
After that, create nickname will fail: 
db2 => create nickname mssql_test3 for mssql2008_serv.*.test3 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0180N  The syntax of the string representation of a datetime 
value is 
incorrect.  SQLSTATE=22007

User affected: 
  Users who of  in InfoSphere Federation Server 
Problem description and summay: 
  See error description

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was fistly fixed in Version 10, FixPak 2. This 
fix should be applied on the federation Server.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.11.2012
04.01.2013
04.01.2013