Fixes are available
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 number
JR31587
Reported component name
SYBASE WRAPPER
Reported component ID
5724N9711
Reported release
950
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-01-05
Closed date
2009-06-16
Last modified date
2009-06-16
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
24 May 2022