DB2 UDB API stage sends out strange warning messages
Posted: Fri Apr 18, 2008 3:09 pm
I have a job which is using the DB2 UDB API (non-parallel) stage in a Parallel job. The job works just fine but the following warning messages come out (all three, just once per run) and they sure make no sense to me.
join_STG_REBATE_CLAIM_REJECT_to_PHARMACY_DATA_FACT,0: Invalid character(s) ([xFC]) found converting string (code point(s): PR_DBE[xFC]PR_DBE) from codepage UTF-8 to Unicode, substituting.
join_STG_REBATE_CLAIM_REJECT_to_PHARMACY_DATA_FACT,0: Invalid character(s) ([xFC]) found converting string (code point(s): DBO[xFC]DBO) from codepage UTF-8 to Unicode, substituting.
join_STG_REBATE_CLAIM_REJECT_to_PHARMACY_DATA_FACT,0: Invalid character(s) ([xFC]) found converting string (code point(s): PHARMACY_DATA_FACT pdf[xFC]STG_REBATE_CLAIM_REJECT stg) from codepage UTF-8 to Unicode, substituting.
I am using mostly defaults. I chose "Generate SELECT clause from column list; enter other clauses" in the Query Type and put "DBO.PHARMACY_DATA_FACT pdf, DBO.STG_REBATE_CLAIM_REJECT stg" in the TableName and " pdf.CLAIM_IDENTIFIER = stg.CLAIM_IDENTIFIER and pdf.CLAIM_STATUS = stg.CLAIM_STATUS and pdf.CLIENT_ID = stg.CLIENT_ID" in the where clause.
Here is the generated SQL:
I also changed Transaction Isolation to "Uncommitted Read" and Prefetch rows to "500". That's it.
Any clues would be greatly appreciated.
join_STG_REBATE_CLAIM_REJECT_to_PHARMACY_DATA_FACT,0: Invalid character(s) ([xFC]) found converting string (code point(s): PR_DBE[xFC]PR_DBE) from codepage UTF-8 to Unicode, substituting.
join_STG_REBATE_CLAIM_REJECT_to_PHARMACY_DATA_FACT,0: Invalid character(s) ([xFC]) found converting string (code point(s): DBO[xFC]DBO) from codepage UTF-8 to Unicode, substituting.
join_STG_REBATE_CLAIM_REJECT_to_PHARMACY_DATA_FACT,0: Invalid character(s) ([xFC]) found converting string (code point(s): PHARMACY_DATA_FACT pdf[xFC]STG_REBATE_CLAIM_REJECT stg) from codepage UTF-8 to Unicode, substituting.
I am using mostly defaults. I chose "Generate SELECT clause from column list; enter other clauses" in the Query Type and put "DBO.PHARMACY_DATA_FACT pdf, DBO.STG_REBATE_CLAIM_REJECT stg" in the TableName and " pdf.CLAIM_IDENTIFIER = stg.CLAIM_IDENTIFIER and pdf.CLAIM_STATUS = stg.CLAIM_STATUS and pdf.CLIENT_ID = stg.CLIENT_ID" in the where clause.
Here is the generated SQL:
Code: Select all
SELECT PHARMACY_DIMENSION_KEY,PRESCRIBER_DIMENSION_KEY,
DRUG_DIMENSION_KEY,pdf.CLAIM_IDENTIFIER,
<snip>
WHERE pdf.CLAIM_IDENTIFIER = stg.CLAIM_IDENTIFIER
and pdf.CLAIM_STATUS = stg.CLAIM_STATUS
and pdf.CLIENT_ID = stg.CLIENT_ID;
Any clues would be greatly appreciated.