Hey Mark Gillis,
Thanks for the info! Have a great Day!
-----Original Message-----
From: Gillis Mark
[mailto:db2udbdba-ezmlmshield-x26269250.[Email address protected]
Sent: Thursday, November 30, 2006 5:38 AM
To: LazyDBA Discussion
Subject: RE: DB2 Version 8.2, Fixpack 7, for Windows (DB2MOVE)
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 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]
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page