Given that situation that you are moving from an established db then the quick way will be to issue:
db2 set integrity command with the immediate uncheck parm.
It still has to be done for all tables that will be in check pending.
Do a select for status'C' on the syscat.tables view to find which need to be checked.
Regards, Pierre.

----- Message d'origine -----
De: Gillis Mark <db2udbdba-ezmlmshield-x26269250.[Email address protected]
Date: Jeudi, Novembre 30, 2006 5:38 am
Objet: RE: DB2 Version 8.2, Fixpack 7, for Windows (DB2MOVE)
À: LazyDBA Discussion <[Email address protected]

> Ed
>
> I think if you choose the LOAD option from DB2MOVE, you won't
> adhere to
> any RI and no triggers will fire. All tables with RI will end up in
> CHECK PENDING and need the SET INTEGRITY command running. But if it's
> coming from a Prod system with the same RI and the same
> triggers, that
> shouldn't be a problem should it? Just re-establish the RI after the
> load completes and all future operations in the test database will
> adhere to the established constraints and fire the correct triggers.
>
> Cheers
>
> Mark
>
> -----Original Message-----
> From: Edwards Ed
> [mailto:db2udbdba-ezmlmshield-x61086180.[Email address
> protected]
> Sent: 29 November 2006 20:39
> To: LazyDBA Discussion
> Subject: DB2 Version 8.2, Fixpack 7, for Windows (DB2MOVE)
>
> To All,
> My test database has the same structure as my production
> database. I
> want to copy just the data from the production database to the test
> database. I am going to use the DB2MOVE command. My question
> is: will
> the DB2MOVE command with the LOAD option take care of adhering
> to all
> constraints (primary key, unique key, foreign key, and check)?
> And, do
> I have to worry about triggers? Also, I know I will have to
> reset all
> sequences.
>
>
> Please take a few minutes to provide feedback on the quality of
> serviceyou received. The Department of Education values your
> feedback as a
> customer. Commissioner John L. Winn is committed to continuously
> assessing and improving the level and quality of services
> provided to
> you by Department staff. Simply use the link below. Thank you in
> advance for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address
> protected]
>
> -----------------------------------------------------------------
> ----
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
> post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> This e-mail (and any attachments) may contain privileged and/or
> confidential information. If you are not the intended recipient
> please do not disclose, copy, distribute, disseminate or take
> any action in reliance on it. If you have received this message
> in error please reply and tell us and then delete it. Should you
> wish to communicate with us by e-mail we cannot guarantee the
> security of any data outside our own computer systems. For the
> protection of Legal & General's systems and staff, incoming
> emails will be automatically scanned.
>
> Any information contained in this message may be subject to
> applicable terms and conditions and must not be construed as
> giving investment advice within or outside the United Kingdom.
>
> The following companies are subsidiary companies of the Legal &
> General Group Plc which are authorised and regulated by the
> Financial Services Authority for advising and arranging the
> products shown: Legal & General Partnership Services Limited
> (insurance and mortgages), Legal & General Insurance Limited
> (insurance), Legal & General Assurance Society Limited
> (life assurance, pensions and investments), Legal & General Unit
> Trust Managers Limited and Legal & General Portfolio Management
> Services Limited (investments).
>
> They are registered in England under numbers shown.
> The registered office is Temple Court, 11 Queen Victoria Street,
> London EC4N 4TP.
>
> Legal & General Partnership Services Limited: 5045000 Legal &
> General Assurance Society Limited: 166055 Legal & General (Unit
> Trust Managers) Limited: 1009418 Legal & General (Portfolio
> Management Services) Limited: 2457525 Legal & General Insurance
> Limited: 423930
>
> They are registered with the Financial Services Authority under
> numbers shown. You can check this at www.fsa.gov.uk/register
>
> Legal & General Partnership Services Limited: 300792 Legal &
> General Assurance Society Limited: 117659 Legal & General (Unit
> Trust Managers) Limited: 119273 Legal & General (Portfolio
> Management Services) Limited: 146786 Legal & General Insurance
> Limited: 202050
>
>
>
> -----------------------------------------------------------------
> ----
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>

Pierre Saint-Jacques

DB2 & UDB email list listserv db2-l LazyDBA home page