Catalog level question while migrating in V12...and getting back in V11

Hi group,

We recently moved our first datasharing DB2 from V11 to V12 in a test environment.

In order to build up a comprehensive backup procedure, we did the following:

- While still in V11, we saved (physical save with FDR) all the DSNDB06, DSNDB01, logcopy and BSDS files relative to the DB2 V11.

- Moved up DB2 from V11 to V12 (code + catalog), and reach that level V12R1M504.

Then the restore procedure :

First restoring DSNDB06, DSNDB01, logcopy and BSDS (with PGM=FDRDSF => so physically replacing all the V12 catalog TS with its V11 counterparts and deleting those created in V12) and plugging the code toward V11 files again, at this point we should have everything back in V11...code is back in V11, but the catalog remains libelled as V12 !!!


Same thing after reinitializing SCA and lock structures dedicated to DB2.

The others DB2 part of the datasharing remained in V11 all along.

So does anyone know why DB2 keeps this catalog level while all the traces of V12 were obviously erased ?

Views: 22

Reply to This

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


NEW Announcement! Db2 Analytics Accelerator Version 7.5

Started by Patricia Zakhar in What's hot ? Oct 15. 0 Replies

Today, IBM announced the Db2 Analytics Accelerator for z/OS Version 7.5, which delivers enterprise-grade transactional and analytic processing. It introduces Integrated Synchronization, a transformative capability that provides an integrated,…Continue

Export Data from DB2 5.0 Database from a Laptop

Started by Rakesh in Application Development and DB2 Oct 8. 0 Replies

Dear All,   I've to Export Data out from DB2 5.0 Database from a Laptop. I've installed Toad for DB2 on that Laptop. Now going to Install DB2OLEDBV5_x64 on that Laptop. After this how to proceed?ThanksRakeshContinue

Tags: Export, 5, DB2

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service