Fixes are available
Closed as program error.
You will encountered -901 error when creating a nickname pointing to a table or a view that has a column with data type char(0): SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Invalid nickname column length".) SQLSTATE=58004 The problem is easy to be reproduced: ========================================================== db2 connect to <source dbname> db2 "create view test_view as select char('') as col1 from sysibm.sysdummy1" db2 connect to <fed dbname> db2 "create nickname nk_test for drdaserver.schema.test_view" ==========================================================
Cast the CHAR(0) column to a not null column as: cast('' as char(1)) as col1
User affected: Users who use DRDA wrapper of in InfoSphere Federation Server Problem description and summay: See error description
Problem was fistly fixed in Version 10, FixPak 2. This fix should be applied on the federation Server.
Reported component name
DB2 FOR LUW
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
DB2 FOR LUW
Fixed component ID
Applicable component levels