Fixes are available
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
Implicitly rollback after DDL operation may lead server deleted which may cause DB2 instance crash with below call stack: ================================================================ -------Frame------ ------Function + Offset------ 0x0900000005B46AA8 sqlqg_build_FMP_Request__F22sqlqg_FMP_Request_TypeP24sqlqg_FMP_R untime_ObjectPP17sqlqg_FMP_Request + 0x6F4 0x09000000033ACFF4 sqlqgFedStart__FP14UnfencedServerc + 0x630 0x0900000004F035E0 sqlqgClose__FP12sqlri_rquerys + 0x6FC 0x0900000004F02B20 sqlqgClose__FP12sqlri_rquerys@glue84E + 0x78 0x0900000004444294 sqlricjpInfrequent__FP8sqlrr_cbPP12sqlri_opparml + 0x18C 0x0900000006DB411C sqlricjp__FP8sqlrr_cbP12sqlri_opparmilT4 + 0x428 0x0900000006DA3EF4 sqlricls_complex__FP8sqlrr_cbilN23 + 0x570 0x0900000006DA009C sqlricls_complex__FP8sqlrr_cbilN23@glue858 + 0x78 0x0900000006E6ED44 @88@158562@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_ siblingiN63 + 0xC4 0x0900000006E6F1A0 sqlra_close_sections_on_finalcmt_rollback__FP8sqlrr_cb + 0x60 0x0900000006D836F0 sqlra_close_sections__FP8sqlrr_cbUiT2 + 0x10 0x0900000006D84FD4 sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0x32C 0x0900000006EB447C sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO + 0x36C 0x0900000006EB3DAC sqlrr_rollback__FP14db2UCinterface + 0x19C 0x0900000006F1B268 sqljsRollbackBeforeConnectReset__FP14db2UCconHandle + 0x14C 0x0900000006F1B734 @64@sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x410 0x0900000006F19594 @64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2C0 0x0900000006F18F58 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xEC 0x0900000006C0E314 RunEDU__8sqeAgentFv + 0x238 0x0900000006C0FF10 EDUDriver__9sqzEDUObjFv + 0xDC 0x0900000006C0A3CC sqloEDUEntry + 0x260 OR 0x090000008237D068 lockHash__FPUc + 0xC8 0x090000008237F6DC sqlqgValidateServer__FPUcPvPP11Server_InfoT2 + 0x13C 0x0900000082356C60 sqlqgFindServer__FPUc12Sqlqg_OpTypePP14UnfencedServerUi + 0x420 0x090000008235E578 sqlqgFindUser__FPUc12Sqlqg_OpTypePP19UnfencedRemote_UserPbUib + 0x198 0x090000008229BAB8 find_current_remote_user__14UnfencedServerFPP19UnfencedRemote_Us erPb12Sqlqg_OpType + 0x198 0x0900000082605438 sqlqg_build_FMP_Request__F22sqlqg_FMP_Request_TypeP24sqlqg_FMP_R untime_ObjectPP17sqlqg_FMP_Request + 0xF58 0x0900000082711B18 sqlqgFedStart__FP14UnfencedServerc + 0xA18 0x090000008233C9A8 sqlqgFetch__FP12sqlri_rquery + 0x2C8 0x090000008248EC18 sqlri_djx_rta__FP8sqlrr_cb + 0xCD8 0x0900000080A04BE4 sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm + 0x584 0x0900000080A0575C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x4DC 0x0900000081D97728 sqlrr_process_fetch_request__FP14db2UCinterface + 0xE48 0x0900000081D9E220 sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0xD60 The trap can be recreated with blew steps: There are two connections which operate the same federated server. => db2 get db cfg for feddb | grep -i lock Lock timeout (sec) (LOCKTIMEOUT) = 10 UOW1 | UOW2 db2 +c | db2 +c declare c1 cursor with hold for select * from n1 | open c1 | commit | | select * from n1 | commit | DDL(create another nickname/drop server...) | force application close c1/fetch c1 -- DB2 crash! |
Local fix
Problem summary
User affected: Users of the Federation Server DDL in InfoSphere Federation Server Problem description and summay: See error description
Problem conclusion
Problem was fistly fixed in Version 9.7, FixPak 6. This fix should be applied on the federation Server.
Temporary fix
Comments
APAR Information
APAR number
JR40602
Reported component name
WS FED SVR INST
Reported component ID
5724N9701
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-09-08
Closed date
2012-06-10
Last modified date
2012-06-10
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
WS FED SVR INST
Fixed component ID
5724N9701
Applicable component levels
R970 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCAVQ2","label":"Installation"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 June 2012