mass copying of apps from one Valence instance to another

[rdeardorff@spi-ind.com]

I am setting up a sepearate testing environment and am curious if there is a way to mass copy all the apps from one instance (produciton) to another? I really don't want to do this on a one by one move using NAB.

I know there are the VV* phyiscal files that contain all the information, but I am not clear which ones I should copy. Suggestions?

[robert.swanson]

You could try using VVMIGRATE -- go to a 5250 command line, add your production instance to your library list, then CALL VVMIGRATE, filling in the "from" and "to" libraries as appropriate. Then hit F24 and switch all the Y/N fields to "N" except for Apps, so you don't include users, settings, environments, etc. If it's a fresh instance you might want to include Groups and Categories as well.

This was really meant for moving from Valence 5.* to Valence 6.*, but in theory it should serve your purpose.

[rdeardorff@spi-ind.com]

will this clear the existing files if I need to run it over and over?

[robert.swanson]

Yes, and it will warn you before you proceed that records are going to be replaced.

[rdeardorff@spi-ind.com]

image.png?

but I have no jobs running in that instance.

image.png?

is there a file I need to clear that Valence thinks there is a user logged in but there is not?

[robert.swanson]

The instance was likely terminated while a session was running.

This should clear it:

• ADDLIBLE SPACEREG
• CALL VVSYSINFO
• F8
• place an "X" beside any sessions listed and hit ENTER

[rdeardorff@spi-ind.com]

ohhh...this works great!!! Exactly what I was looking for....THANK YOU!!

[rdeardorff@spi-ind.com]

spoke too soon. the vast majority of my apps did not come over....I ran this under the QSECOFR profile.

VVMIGRATE

image.png



?The source Valence instance I am copying from (btw, that installed version on this screen shot comes out of the Valence6 instance, not the SPACE6D10 instance)

SPACE6D10 has 301 apps/70 categories

image.png?

but after VVMIGRATE, SPACEREG only has 37 and shows 64 categories, but I am only seeing 6 categories at the dashboard.

image.png?

[robert.swanson]

Appears we'll need to revisit this then. As I mentioned, VVMIGRATE was originally intended to move records from 5.* to 6.3. While it should in theory function for 6.3 to 6.3 data transfers, I suspect there's something causing an SQL exception on the inserts in your case.

I'll reach out to you directly to arrange a web meeting. Hopefully it's something simple we can adjust in the source.