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: 20

Reply to This

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


MSSQL linked server attaching to DB2 LUW

Started by Mike Jett in Application Development and DB2. Last reply by Mike Jett 12 hours ago. 2 Replies

I am trying to create a linked server from MSSQL 2014  to DB2 11.1  I am able to create one linked server and get it to work with one DB.  I have not been able to figure out how to add additional catalogs(DB's).  Is it possible to use just one…Continue

Tags: server, linked

Db2 12 Migration Planning & Customer Experiences - Part 1

Started by Sandy Flippen in What's hot ? Sep 12. 0 Replies

Register Now! NEXT CONTENT! Upcoming double webcast Db2 12 Migration Planning and customer experiences. Live Q &A session! PART 1 24th Sept 11:00 AM EST PART 2…Continue [Latest Blogs from the Biggest Names in DB2]

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service