[IQUG] DISABLE_RI_Check ='ON" question

Mark Mumy markdmumy at gmail.com
Tue Nov 14 05:09:28 MST 2017


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?

Mark
 
========================

Sent from my mobile device

> On Nov 13, 2017, at 22:16, Louie, David <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?
>  
> Thanks
> David
>  
>  
> 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
> http://iqug.org/mailman/listinfo/iqug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20171114/bf9b2147/attachment.html>


More information about the IQUG mailing list