IBM Support

DRDA wrapper returns SQL0901N "Index column name not
found - search 1" while create nickname for DB2 for IBM i

Troubleshooting


Problem

Attempts to create nickname for a remote table from DB2 on IBM iSeries (IBM i) resulted in SQL0901N error with Reason "Index column name not found - search 1"

Symptom


db2 => CREATE NICKNAME MYNICKNAME FOR <SERVER NAME>.<SCHEMA>.<REMOTE TABLE NAME>
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "Index column name not
found - search 1".) SQLSTATE=58004


db2diag.log output:

2011-12-20-15.50.48.413805-360 I1647585E793 LEVEL: Error
PID : 9505 TID : 46945187916096PROC : db2sysc
INSTANCE: DB2INST1 NODE : 000 DB : FDB3
APPHDL : 0-7 APPID: *LOCAL.DB2INST1.111220214313
AUTHID : DB2INST1
EDUID : 18 EDUNAME: db2agent (TESTDB)
FUNCTION: DB2 UDB, catalog services, sqlrl_create_nickname_index, probe:181
MESSAGE : Index column name not found - search 1
DATA #1 : String, 9 bytes
Nickname:
DATA #2 : String, 4 bytes
MYNICKNAME
DATA #3 : String, 22 bytes
Current column number:
DATA #4 : signed integer, 8 bytes
0
DATA #5 : String, 24 bytes
Number of index columns:
DATA #6 : signed integer, 8 bytes
1
DATA #7 : String, 26 bytes
Current index column name:
DATA #8 : String, 10 bytes
IXCOL00001

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Sources and Wrappers - DRDA","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;9.5;9.7","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
25 April 2025

UID

swg21576022