Quick way round this that I sometimes use is
Export to temp1.sql of del modified by nochardel
SELECT 'set integrity for ' || tabname || ' immediate checked'
FROM syscat.tables
where tabschema not in ('SYSIBM','SYSCAT','SYSSTAT','SYSTOOLS')
and tabschema = 'your_schema_here'
AND STATUS = 'C'
;
which will build all the statements for you in the temp1.sql file. Give it a quick eyeball and the
db2 -f temp1.sql
to reset all the tables (you may need to be run several times if the tables don't appear in dependency order, but you can always run it, regen it and run it again, until the regen of temp1.sql doesn't produce anything)
Cheers
Mark
-----Original Message-----
From: p [mailto:db2udbdba-ezmlmshield-x87041595.[Email address protected]
Sent: 30 November 2006 16:49
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