PK04941: SQLCODE206 USING OPTION IP FROM PANEL ADB2Z55 TO LIST IP NAMES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool, an sqlcode206 (-206) can occur when
  using line command IP to list ip names in panel adb2z55 . Error
  messages may appear similar to the following:
  .
  DSNT408I SQLCODE = -206, ERROR:  LINKNAME IS NOT A COLUMN OF AN
  INSERTED TABLE,
           UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM
  CLAUSE, OR IS NOT A
           COLUMN OF THE TRIGGERING TABLE OF A TRIGGER
  

Local fix

• Option IP works, after correcting a SELECT statement in panel
  ADB2Z55 :
  from  IP,'SELECT * FROM &DB2ALOCP.&sysibm..LUNAMES +
  to    IP,'SELECT * FROM &DB2ALOCP.&sysibm..IPNAMES +
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool,            *
  *                 who use the IP line command on panel         *
  *                 ADB2Z55, are affected.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE206 (-206) can occur when using  *
  *                      line command IP to list ip names in     *
  *                      panel ADB2Z55 .                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The line command IP caused SQLCODE -206.
  

Problem conclusion

• The wrong DB2 Communication Database table was used in the SQL
  query. The problem has been fixed.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADB2Z55
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK03358

     UP05/05/19 P F505

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.