JR31587: 430N ERROR(FMP PROCESS DOWN) OR DB2 PROCESS DOWN WHEN DOING SOM E DROP OPERATIONS USING SYBASE WRAPPER IN V95FP3

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
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 fixed if next.

Error description

• iN SOME CASES, DROP OPERATION WILL CAUSE DB2 CRASH(TRUSTED
  MODE) OR 430 ERROR(FENCED MODE) WHEN USING SYBASE
  WRAPPER,BELOW IS AN EXAMPLE:
  drop type mapping my_timestamp
  DB20000I  The SQL command completed successfully.
  drop type mapping my_timestamp1  <ShiDa>It succeed here</ShiDa>
  DB20000I  The SQL command completed successfully.
  create type mapping my_timestamp from local type
  SYSIBM.TIMESTAMP(0) to server MY_SERVER remote type
  "dbo"."datetime"
  DB20000I  The SQL command completed successfully.
  create type mapping my_timestamp1 from local type
  SYSIBM.TIMESTAMP(0) to server MY_SERVER remote type
  "dbo"."smalldatetime"
  DB20000I  The SQL command completed successfully.
  create nickname my_nickname2 for
  MY_SERVER."j15user2"."my_nickname_tbl2"
  DB20000I  The SQL command completed successfully.
  drop type mapping my_timestamp
  DB20000I  The SQL command completed successfully.
  drop type mapping my_timestamp1
  DB21034E  The command was processed as an SQL statement because
  it was not a
  valid Command Line Processor command.  During SQL processing it
  returned:
  SQL1476N  The current transaction was rolled back because of
  error "-430".
  SQLSTATE=40506
  

Local fix

• N/A
  

Problem summary

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

Problem conclusion

• Problem was first fixed in Version 9.5, FixPak 4 (s090429). 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

Applicable component levels

• R950 PSN

     UP