IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to move DB2 Installation HLQ


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
SkydiveFreak007

New User


Joined: 23 Feb 2022
Posts: 5
Location: Germany

PostPosted: Wed Feb 23, 2022 7:37 pm
Reply with quote

Hi,

I need to move an existing Db2 Installation to a new HLQ. (DSN1110.** -> DSN1210.**)
Since there are many VSAM datasets, active (in-use) Linklist Datasets, APF authorized datasets and many internal references to the old HLQ, I wonder whats the easiest procedure to get it done.

I could make a full copy of every dataset to the new HLQ and rerun nearly every installation job, so like a full installation.
I could also run the Db2-Generation in mode MIGRATE with the very same code base just another HLQ and just run the migration jobs (But I never did such before).

Since I don't want to do any experiment, which way would you recommend me?

Best regards,
SkydiveFreak007
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 541
Location: London

PostPosted: Mon Feb 28, 2022 12:27 pm
Reply with quote

Is this a time constrained process, i.e. does it have to be completed within a fixed time period? Why do you need to do this in the first place, it seem quite extreme?
Back to top
View user's profile Send private message
SkydiveFreak007

New User


Joined: 23 Feb 2022
Posts: 5
Location: Germany

PostPosted: Mon Feb 28, 2022 3:41 pm
Reply with quote

It is not a time constrained process.
It is also not a really important system - but is in use.

As part of my training I installed a Db2 V11.1 and then migrated to version V12.1.
Here I made the mistake not to pay attention to the correct HLQ, while it was correctly selected for version 11 it is wrong for version 12.

Now there would be the possibility to inform the customer, to delete everything and to set up everything correctly again, or to correct the error somehow.

I also know that I could have installed version 12 directly, but the goal was to do this with a migration
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 541
Location: London

PostPosted: Mon Feb 28, 2022 4:11 pm
Reply with quote

Quick google leads to this rabbit hole at the below link. Depending on the number of datasets affected it could be a very lengthy process.

www.ibm.com/docs/en/db2-for-zos/11?topic=design-changing-high-level-qualifier-db2-data-sets

If you have something like Rocket software's VCR for DB2 or some equivalent it makes it easier.
Back to top
View user's profile Send private message
SkydiveFreak007

New User


Joined: 23 Feb 2022
Posts: 5
Location: Germany

PostPosted: Mon Feb 28, 2022 7:04 pm
Reply with quote

Thank you for this. So I will make just a second installation, that will do it ;-)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts z/vm installation problem All Other Mainframe Topics 0
No new posts zOS COD installation under zVM All Other Mainframe Topics 0
No new posts How to move values from single dimens... COBOL Programming 1
No new posts Reading the CSV data in COBOL and mov... COBOL Programming 4
No new posts Move a particular line from a PS file... CLIST & REXX 7
Search our Forums:

Back to Top