JR32106: CREATE NICKNAME FAILED WHEN REMOTE TABLE WITH ANY INDEX ON LINUX AMD64(ARITHMETIC OVERFLOW )

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When you have an index on remote table and try to create
  nickname on it, you will receive this error as below:
  create nickname nickctlib for
  DATASTORE_SYBASE."j15user1"."tt"
  DB21034E The command was processed as an SQL statement because
  it was not a
  valid Command Line Processor command. During SQL processing it
  returned:
  SQL0802N Arithmetic overflow or other arithmetic exception
  occurred.
  SQLSTATE=22003
  

Local fix

• N/A
  

Problem summary

• Users affected:
     Users of the Sybase wrapper in InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 9.5 FixPak 5 (s091123 ). This
  fix should be applied on the federation server.
  

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:

Fix information

• Fixed component name

  SYBASE WRAPPER

• Fixed component ID

  5724N9711

Applicable component levels

• R950 PSN

     UP