Hey Pierre,
Thanks for the info! Have a great Day!
Please take a few minutes to provide feedback on the quality of service you 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]
-----Original Message-----
From: p [mailto:db2udbdba-ezmlmshield-x87041595.[Email address protected]
Sent: Thursday, November 30, 2006 11:49 AM
To: LazyDBA Discussion
Subject: Re : RE: DB2 Version 8.2, Fixpack 7, for Windows (DB2MOVE)
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
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page