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

Reply to This

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


Automatic storage add path

Started by Fernando Monjes in What's hot ? Feb 12. 0 Replies

Hi I have db2 version 10 and tablespace (dms) with automatic storage, how can I add a container or path, I don't use STOGROUP, is there any option? Thank youContinue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Gagan Kakkar Feb 12. 3 Replies

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service