Unanswered: CREATE NICKNAME failing on Redhat 7.3/DB2 Fixpak 10
I am using the CREATE NICKNAME sql command to an iSeries AS400 and it fails with SQL0902C error, as below
create nickname as400nick for machineid.lib.pfname
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0902C A system error (reason code = "255") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005
I am running DB2 version 7.2 (fixpack level 10a) on Redhat 7.3 however it was working before under fixpak7 (we recently upgraded to fixpak 10a). Is this a known fixpak10 problem ? The as400 ('serverh') appears in my db2 list node directory output.
Just to add extra confusion, we can connect directly to the iSeries and run sql commands e.g. db2 "connect to machineid user fred using bill" works !