[IQUG] DISABLE_RI_Check ='ON" question

Louie, David David.Louie at blackrock.com
Tue Nov 14 07:58:09 MST 2017

Thanks Mark.  We found the issue and wanted to double check.    (bad files)

We are running load table from flat files.   I know ignore constraint on load table will kick out bad data but we don’t have this on.


From: Mark Mumy [mailto:markdmumy at gmail.com]
Sent: Tuesday, November 14, 2017 7:09 AM
To: Louie, David <David.Louie at blackrock.com>
Cc: IQ Users Group <iqug at iqug.org>; Gandhi, Jitendra <jitendra.gandhi at blackrock.com>
Subject: Re: [IQUG] DISABLE_RI_Check ='ON" question

With disable on, all rows load.  If rows were kicked out for ri violations you would see these in the IQmsg file.  But you’d have to have the ri check on.

How are you moving data?


Sent from my mobile device

On Nov 13, 2017, at 22:16, Louie, David <David.Louie at blackrock.com<mailto:David.Louie at blackrock.com>> wrote:
We are doing a conversion from solaris to linux and before we run our load table we disable_RK_check=’on’ so we don’t run into constraint violations. ( we decided to create all constaints prior to our data loads)

From what we were told this will ‘disable RI checking and all the data will load.

We have an instance where we have data count diffs between two tables.   Only 2.4 billion rows of 4 billion were loaded.

Is the disable RI check discarding rows which violate FK constraints and not loading all rows as we were lead to believe?

IF so then would dropping all constraints, loading data, setting disable RI ‘on’ then recreating the constraints be the way to get around this?


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

© 2017 BlackRock, Inc. All rights reserved.
IQUG mailing list
IQUG at iqug.org<mailto:IQUG at iqug.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20171114/7bc95c7e/attachment-0001.html>

More information about the IQUG mailing list