Db2 Tools for z/OS

 View Only

Elevating a QMF Fixpack to a fully licensed and configured version for roll out to new machines

By shawn sullivan posted Thu September 17, 2020 03:37 PM

  

Elevating a QMF  Fix pack to a fully licensed and configured version for roll out to new machines

 

If my organization has one hundred laptops with QMF for Workstation installed and configured, then when a QMF Fix pack comes out, I download it from IBM Fix Central and give it to my roll out team to apply it.

But what if we have merged with another organization and there are one hundred additional machines that need QMF? Do I have to do TWO installs on each machine: One with the old release and one with the new fix pack?

No, the following onetime process will elevate a fixp ack to  a fully licensed version and allow the installer software to configure the new system.

Step 1)

Download the latest fix pack from IBM Fix Central and unzip  it into a directory:

figure 1

Step 2)

 Choose one machine that has QMF for Workstation already installed and configured.  Go to the directory into which QMF for Workstation was installed and copy the license key:

figure 2

Put that license key in the directory with the setupwinXX.exe

figure 3

If you stop here, then the setupwin64.exe (in this case) will pick up the license key and allow you to do a single install on the new machines. However, these new installs will NOT be configured to connect to  any repositories or databases.

 

Step 3) On the pre-configured machine, go to the user home directory , typically in

C:\Users\<userid>\AppData\Roaming\IBM\QMF for Workstation

And collect the following three files:

Figure 4

The repoistories.xml has the connection strings to the Repository Storage.

The .storage is OPTIONAL, it has all the user interface config settings like GLOBAL Variables, buttons, menus etc. ONLY include this if you have a standard setup that you wish to rollout.

.bi.jdbc.drivers has the locations of all the JDBC drivers on the master machine. NOTE that these drivers need to be in the SAME location for the target clean machines. That is, if they are in a directory called C:\QMF\Drivers on the master machine then that folder, populated with the same drivers must be on the target machine. The rollout team can most likely make the process create an populate such a folder.

If the drivers are on a shared driver like \\serverx\QMF\Drivers or Z:\QMF\Drivers then there is no need to have the roll out team deliver drivers.

With these files in place, this folder can be delivered to the roll out team to deploy to the new machines.

Figure 5

Step 4) Optionally, you may set up a silent install for the roll out.

To do this you, run the install one more time on the Master machine, but you run it from a Windows Command line with the parameter -r followed by the file name installer.properties

figure 6

This will walk you through the normal install wizard, but it will record your choices in a file called installer.properties.
Put installer.properties in the same folder as the setupwinXX.exe and the other files.

figure 8

Now, on a target machine, if the command

Setupwin64.exe -i silent  is given from a command line in the folder with all the files above,

figure 7

The product will install silently and take the choices recorded in the installer.properties file.

This is a good way to limit which components end-users get on their machines. There may be no point in rolling out the QMF for Workstation Administrator functionality or the QMF Data Service Data Studio to everyone.

There is a Help topic in QMF for Workstation that gives further details on the silent install.

 




#Db2Toolsforz/OS
#Db2QMF
#QMF
5 comments
31 views

Permalink

Comments

Thu August 05, 2021 10:37 AM

Johan can you look in the directory you installed QMF into and see if there is a file called Workstation-zSeries.lic present? I just downloaded QMF 12.2.0.5 and used my even older license key from 12.1 and it works fine.
Perhaps we can do a webex meeting and I can look at your system.
If so contact me at sullivan@rocketsoftware.com

Thu August 05, 2021 10:35 AM

Shawn, the original QMF 12.2 came with a Workstation-MP.lic file.

Removing Workstation-MP.lic from the folder where 12.2 was installed and just leaving the Workstation-zSeries.lic cleared the QMF license error. 

Thanks for your help.

Thu August 05, 2021 10:14 AM

Hi Shawn, thanks for the FixCentral instructions.

I followed the instructions to upgrade QMF 12.2 to 12.2.0.5
However connections to DB2 z/OS continue to result in error: 
REP01004. The following error has occurred while accessing database: DAL01044. Connection is blocked due to the following: No license to access this type of database server is available

Does setupwin64.exe need to be run from the command line?

Wed August 04, 2021 05:11 PM

John
1) In Fix Central, enter QMF in the "Product Selector" field. Choose your edtition of QMF
2)  Under the Installed Version drop down list pick 12.2. DO NOT pick 12.2.0.1, or 12.2.0.2 or 12.2.0.3 etc. You MUST pick 12.2 or the list of fixpacks will be empty.
For Platform select All
3) Click the Continue Button underneath the Platform dropdown
4) Click the Continue Button on the next page.

Wed August 04, 2021 04:51 PM

Hi Shawn, I cannot find any fixpak for QMF 12.2 in FixCentral.

Please advice on how to search it in FixCentral.