DB2 V8 cm going to ENFM and NFM

Jeff Frazier

DB2 V8 cm going to ENFM and NFM
Hello,
We are going to ENFM then NFM this Saturday. Before we run DSNTIJNE I know
we have to take an I/C of CM catalog plus before that we will be taking a
full volume backup of DB2 subsystem. If for whatever reason we need to go
back to CM is the I/C of catalog we took before DSNTIJNE usable to go back
to or would it be better just to restore back to full volume backup? This
is our test subsystems by the way. Any experiences anyone would care to
share?
Thanks In advance,

Jeff

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Gareth Jones

Re: DB2 V8 cm going to ENFM and NFM
(in response to Jeff Frazier)
My advice would be that, as fall back from ENFM or NFM to CM is not
supported in V8, you should use the full volume backup, including catalog,
directory, logs, BSDS, user table spaces etc. Once you have started updating
objects, and then start recovering the catalog/directory to a prior point in
time, you make things very complicated for yourself. You need to identify
what would cause you to want to fall back to CM, and how long after entering
ENFM/NFM this could be. In test this may not be so important, but in
production it is as you probably can't afford to recover the subsystem to a
prior point in time, with all the potential data loss this would involve.

Alternatively, contact IBM support and ask if they can provide assistance in
a fallback to CM, if you think you really need it.

Gareth

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms