need to recycle DB2 after each mode when migrating to v11

william giannelli

need to recycle DB2 after each mode when migrating to v11

We are preparing to migrate from v10 to v11.

After each mode conversion: CM ENFM NFM

Is it necessary to recycle DB2 after each mode conversion before proceeding?

Also, when converting the BSDS to extended format is it necessary to recycle after the catalog and directory to extended LRSN format?

Thank you

Bill

James Campbell

need to recycle DB2 after each mode when migrating to v11
(in response to william giannelli)
1) Usually several months elapse between CM and ENFM/NFM. ENFM and NFM are
usually run in sequence in the same change window.

Most people like to run the conversion jobs in ACCESS(MAINT). So Db2 gets cycled after
CM and NFM, but not after ENFM (because NFM is coming up).

2) It is usually convenient to run the catalog extended LRSN format in ACCESS(MAINT).
So a recycle afterwards is necessary.

Of course you can try to run these jobs in normal mode. I don't - so I cannot comment of the
consequences. I suppose it depends on what locks application programs put on the catalog
- YMMV.

During a V8 to V10 migration one Db2 subsystem was brought up in normal mode - Db2
objected and switched itself into MAINT mode for the running of DSNTIJTC. I don't know if
V11 would do the same.

James Campbell

On 9 Sep 2017 at 13:34, william giannelli wrote:

>
> We are preparing to migrate from v10 to v11.
> After each mode conversion: CM ENFM NFM
> Is it necessary to recycle DB2 after each mode conversion before proceeding?
> Also, when converting the BSDS to extended format is it necessary to recycle after the catalog
> and directory to extended LRSN format?
> Thank you
> Bill
>


---
This email has been checked for viruses by AVG.
http://www.avg.com

Jim Tonchick

need to recycle DB2 after each mode when migrating to v11
(in response to James Campbell)

The BSDS conversion should also be run with the subsystem down. The conversion job does a rename that requires exclusive access to the files.

-----Original Message-----
From: James Campbell <[login to unmask email]>
To: db2-l <[login to unmask email]>
Sent: Sun, Sep 10, 2017 02:41 AM
Subject: [DB2-L] - RE: need to recycle DB2 after each mode when migrating to v11


1) Usually several months elapse between CM and ENFM/NFM. ENFM and NFM are
usually run in sequence in the same change window.

Most people like to run the conversion jobs in ACCESS(MAINT). So Db2 gets cycled after
CM and NFM, but not after ENFM (because NFM is coming up).

2) It is usually convenient to run the catalog extended LRSN format in ACCESS(MAINT).
So a recycle afterwards is necessary.

Of course you can try to run these jobs in normal mode. I don't - so I cannot comment of the
consequences. I suppose it depends on what locks application programs put on the catalog
- YMMV.

During a V8 to V10 migration one Db2 subsystem was brought up in normal mode - Db2
objected and switched itself into MAINT mode for the running of DSNTIJTC. I don't know if
V11 would do the same.

James Campbell

On 9 Sep 2017 at 13:34, william giannelli wrote:

>
> We are preparing to migrate from v10 to v11.
> After each mode conversion: CM ENFM NFM
> Is it necessary to recycle DB2 after each mode conversion before proceeding?
> Also, when converting the BSDS to extended format is it necessary to recycle after the catalog
> and directory to extended LRSN format?
> Thank you
> Bill
>


---
This email has been checked for viruses by AVG.
<a href="http://www.avg.com" target="_blank">http://www.avg.com</a>

-----End Original Message-----

Steven Lamb

RE: need to recycle DB2 after each mode when migrating to v11
(in response to James Campbell)

As a SAP site, we went straight from v10 to v11 NFM in one go (following the procedure of course), with an "online migration". This was helped by the fact that we use data sharing, so we were able to take down members of the DSG independently as and when required by re-routing application transactions to other members. This is in a system with dynamic SQL.

We used the same principle for the Catalog LRSN conversion.

 

Regards,

Steve

Edited By:
Steven Lamb[Organization Members] @ Sep 11, 2017 - 08:17 AM (Europe/London)