Fixes are available
APAR status
Closed as program error.
Error description
Env: Federation server: v10.1fp2 (non-Oracle mode) data source: v10.1fp2 DPF (Oracle mode) Problem summary: The following query failed with: WITH OCENA41(CUSTOMERID1, ACCOUNTID1, AMOUNT41, RATING41) AS ( SELECT A.CUSTOMER_ID, A.ACCOUNT_ID, B.COVERAGE_AMOUNT, '100 ' FROM IFRS.HGAA4_MNTH_NBS_ACCOUNT_RATING A INNER JOIN IFRS.T_D_CUSTOMER_ACCOUNT_N CA ON A.ACCOUNT_ID = CA.ORIGINAL_SOURCE_ID LEFT OUTER JOIN IFRS.T_AG_NBS_COLLATERAL_ALGORITHM_SUMMARY B ON CA.CUSTOMER_ACCOUNT_SID = B.CUSTOMER_ACCOUNT_SID INNER JOIN IFRS.T_D_SECURITY_ADEQUACY_SEGMENT C ON B.SECURITY_ADEQUACY_SEGMENT_SID = C.SECURITY_ADEQUACY_SEGMENT_SID AND C.SECURITY_ADEQUACY_SEGMENT_CD = '1' WHERE A.YEAR = '2013' AND A.MONTH = '04' AND B.COVERAGE_AMOUNT > 0 ), OCENA42(CUSTOMERID2, ACCOUNTID2, AMOUNT42, RATING42) AS ( SELECT A.CUSTOMER_ID, A.ACCOUNT_ID, B.COVERAGE_AMOUNT, CASE WHEN (RATING3 = '100 ' OR RATING3 = '202 ') THEN '100 ' WHEN RATING3 = '315 ' THEN '202 ' WHEN RATING3 = '430 ' THEN '315 ' WHEN RATING3 = '5100' THEN '430 ' ELSE ' ' END FROM IFRS.HGAA4_MNTH_NBS_ACCOUNT_RATING A INNER JOIN IFRS.T_D_CUSTOMER_ACCOUNT_N CA ON A.ACCOUNT_ID = CA.ORIGINAL_SOURCE_ID LEFT OUTER JOIN IFRS.T_AG_NBS_COLLATERAL_ALGORITHM_SUMMARY B ON CA.CUSTOMER_ACCOUNT_SID = B.CUSTOMER_ACCOUNT_SID INNER JOIN IFRS.T_D_SECURITY_ADEQUACY_SEGMENT C ON B.SECURITY_ADEQUACY_SEGMENT_SID = C.SECURITY_ADEQUACY_SEGMENT_SID AND C.SECURITY_ADEQUACY_SEGMENT_CD = '2' WHERE YEAR = '2013' AND MONTH = '04' AND B.COVERAGE_AMOUNT > 0 ), OCENA43(CUSTOMERID3, ACCOUNTID3, AMOUNT43, RATING43) AS ( SELECT A.CUSTOMER_ID, A.ACCOUNT_ID, B.COVERAGE_AMOUNT, A.RATING3 FROM IFRS.HGAA4_MNTH_NBS_ACCOUNT_RATING A INNER JOIN IFRS.T_D_CUSTOMER_ACCOUNT_N CA ON A.ACCOUNT_ID = CA.ORIGINAL_SOURCE_ID LEFT OUTER JOIN IFRS.T_AG_NBS_COLLATERAL_ALGORITHM_SUMMARY B ON CA.CUSTOMER_ACCOUNT_SID = B.CUSTOMER_ACCOUNT_SID INNER JOIN IFRS.T_D_SECURITY_ADEQUACY_SEGMENT C ON B.SECURITY_ADEQUACY_SEGMENT_SID = C.SECURITY_ADEQUACY_SEGMENT_SID AND C.SECURITY_ADEQUACY_SEGMENT_CD = '3' WHERE YEAR = '2013' AND MONTH = '04' AND B.COVERAGE_AMOUNT > 0 ), SVE(CUSTOMERIDS, ACCOUNTIDS, AMOUNT41S, RATING41S, AMOUNT42S, RATING42S ) AS ( SELECT X.CUSTOMERID1, X.ACCOUNTID1, X.AMOUNT41, X.RATING41, Y.AMOUNT42, Y.RATING42 FROM OCENA41 X INNER JOIN OCENA42 Y ON X.ACCOUNTID1 = Y.ACCOUNTID2 ) select * from SVE; DB2 Database Error: ERROR [58004] [IBM][DB2/LINUXX8664] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Bad Opcode -9, ref_arity 3, sqlnq_pid ID 941 (SYSIBM.DJ_RPAD)".) Note: query joins 1 local table an 3 federated tables (over nicknames): - IFRS.HGAA4_MNTH_NBS_ACCOUNT_RATING - local table - IFRS.T_D_CUSTOMER_ACCOUNT_N - nickname - IFRS.T_AG_NBS_COLLATERAL_ALGORITHM_SUMMARY - nickname - IFRS.T_D_SECURITY_ADEQUACY_SEGMENT - nickname
Local fix
Change function mapping from SYSIBM.DJ_RPAD/RPAD to SYSIBM.RPAD/RPAD for udb
Problem summary
User affected: Users who use InfoSphere Federation Server Problem description and summay: See error description
Problem conclusion
Problem was fistly fixed in Version 10.1, FixPak 3. This fix should be applied on the federation Server.
Temporary fix
Comments
APAR Information
APAR number
JR47218
Reported component name
FEDERATED RUNTI
Reported component ID
5724N9703
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-10
Closed date
2013-10-21
Last modified date
2013-10-21
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
FEDERATED RUNTI
Fixed component ID
5724N9703
Applicable component levels
RA10 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 October 2013