Fix Readme
Abstract
This is a copy of the HOLD ACTION instructions for PTF UJ99264.
Content
Customers who are planning a migration to V9.1 must apply the PTF before running the HSISCUST job for V9.1. No further action is required in this case. If the HSISCUST job has been run before applying the PTF, these HOLD ACTION instructions may be applicable.
The HOLD ACTION contains instructions for multiple migration scenarios so all the instructions applicable for the local set up need to be completed. For Db2 databases, there are instructions for updates to the REST API JCL/PARM as well.
***************************************************************
* TIMING : POST-APPLY *
***************************************************************
Apply the PTF before implementing the ++HOLD ACTION.
NOTE: This PTF DOES NOT require any ++HOLD ACTION to
be implemented for any existing IBM Z SW Asset Mgmnt
Db2 V8.2/V8.3/V8.3.1 repositories that have not
migrated to IBM Z SW Asset Mgmnt V9.1.
For customers using SQLite databases, apply this PTF
for the target libraries to be up to date.
For newly migrated IBM Z SW Asset Mgmnt Db2 V9.1
repositories from V8.2, V8.3, V8.3.1 or new
IBM Z SW Asset Mgmnt V8.3 repositories that have just
been defined after GA, the ++HOLD ACTION must be
implemented after the PTF is applied.
A DBA will usually implement these changes.
NOTES
The following instructions (1 and 2) apply only to existing Db2
repositories, where you do not need to run the customization
job, HSISCUST.
1. JCLLIB member HSISGRNT
In the comment section add the following line,
after line 46:
//* GRANT DBADM ON DATABASE &DBNOT TO authid ;
Add the same line after line 61, after section:
//UPDATE EXEC HSIJSQLE
//SYSIN DD *
[...]
//* GRANT DBADM ON DATABASE &DBNOT TO authid ;
NOTE: Replace the following variable names according to
site requirements:
&DBNOT - Notifications Database schema name
authid - same as DBADMIN in job HSISCUST
2. JCLLIB member HSISMS31
Expected result for SQL(1) - V9.1 (after migration)
should be like the one below:
//* DBNAME TBCREATOR #TSCOUNT #TBCOUNT #COL
//* __________ _____________ ________ ________ ________
//* &DB &REPZSCHM 55 55 613
//* &DB &REPZSCHM_LKB7 5 5 29
//* &DB &REPZSCHM_LKU7 5 5 28
//* --Totals --------------------- 65 65 670
Expected result for SQL(2) - V9.1 (after migration)
DBNAME TBCREATOR #INDEXES
__________ _____________ ________
&DB &REPZSCHM 98
&DB &REPZSCHM_LKB7 3
--Totals -------------------- 101
NOTE: Replace the following variable names according to
site requirements:
&DB - Repository database name
&REPZSCHM - Repository schema name
The following instructions (3, 4 and 5) apply ONLY to existing SQLite
repositories and databases, migrating from V8.2
where you do not need to run the customization job, HSISCUST.
3. JCLLIB member HSISMS31
Expected result for SQL(1) - V8.3/V8.3.1
should be like the one below:
CREATOR #TBCOUNT
_________________ ________
&REPZSCHM 54
&REPZSCHM_LKB7 5
&REPZSCHM_LKU7 5
NOTE: Replace the following variable names according to
site requirements:
&REPZSCHM - Repository schema name
4. JCLLIB member HSISMS33
NOTE: Replace the following variables:
&REPZSCHM - Repository schema name
This step can be executed only if HSISMS33 has never
been run.
In member HSISMS33, of JCLLIB, add the following
statements towards the end:
DROP INDEX &REPZSCHM.PKPDUCT ;
COMMIT ;
ALTER TABLE &REPZSCHM.PRODUCT RENAME
TO PRODUCT_OLD ;
COMMIT ;
CREATE TABLE &REPZSCHM.PRODUCT (
SW_KEY CHAR(32) NOT NULL ,
SW_TYPE CHAR(8) ,
VENDOR_NAME CHAR(50) ,
PRODUCT_NAME CHAR(80) ,
VERSION INTEGER ,
VERSION_NAME CHAR(80) ,
FEATURE_NAME CHAR(80) ,
PID CHAR(16) ,
EID CHAR(8) ,
SSPID CHAR(8) ,
SSEID CHAR(8) ,
PRICETYPE CHAR(10) ,
SUBCAPACITY CHAR(20) ,
ICA CHAR(1) ,
IPLA CHAR(1) ,
VUE CHAR(8) ,
VENDOR_GUID CHAR(32) ,
PRODUCT_GUID CHAR(32) ,
VERSION_GUID CHAR(32) ,
FEATURE_GUID CHAR(32) ,
LAST_UPDATE_TIME TIMESTAMP ,
ALT_PRODUCT_NAME CHAR(80) ,
FOBSERVEDELETED TIMESTAMP ,
BUNDLE_NAME CHAR(50) ,
FTYPE CHAR(1) ,
FSUITE_ID SMALLINT ,
ALT_VENDOR_NAME CHAR(50) NOT NULL DEFAULT ' ' ,
OPSYS CHAR (1) NOT NULL WITH DEFAULT ' ',
LMPCODE CHAR (4),
PRIMARY KEY (SW_KEY, OPSYS))
IN &REPZSCHM.VPRODUCT
VOLATILE ;
COMMIT;
CREATE TYPE 2 UNIQUE INDEX &REPZSCHM.PKPDUCT
ON &REPZSCHM.PRODUCT(SW_KEY, OPSYS)
USING STOGROUP
PRIQTY 48
SECQTY -1
ERASE NO
CLOSE NO;
COMMIT;
INSERT INTO &REPZSCHM.PRODUCT
SELECT * FROM &REPZSCHM.PRODUCT_OLD ;
COMMIT;
5. JCLLIB member HSISMS34
NOTE: Replace the following variables:
&REPZSCHM - Repository schema name
This step can be executed only if HSISMS34 has never
been run.
In member HSISMS34, of JCLLIB, add the following
statements before the "COMMIT;":
DROP TABLE &REPZSCHM.PRODUCT_OLD ;
The following instructions (6 and 7) apply ONLY to existing SQLite
repositories and databases, migrating from V8.3, V8.3.1,
where you do not need to run the customization job, HSISCUST.
6. JCLLIB member HSISMS38
NOTE: Replace the following variables:
&REPZSCHM - Repository schema name
This step can be executed only if HSISMS38 has never
been run.
In member HSISMS38, of JCLLIB, add the following
statements towards the end:
DROP INDEX &REPZSCHM.PKPDUCT ;
COMMIT ;
ALTER TABLE &REPZSCHM.PRODUCT RENAME
TO PRODUCT_OLD ;
COMMIT ;
CREATE TABLE &REPZSCHM.PRODUCT (
SW_KEY CHAR(32) NOT NULL ,
SW_TYPE CHAR(8) ,
VENDOR_NAME CHAR(50) ,
PRODUCT_NAME CHAR(80) ,
VERSION INTEGER ,
VERSION_NAME CHAR(80) ,
FEATURE_NAME CHAR(80) ,
PID CHAR(16) ,
EID CHAR(8) ,
SSPID CHAR(8) ,
SSEID CHAR(8) ,
PRICETYPE CHAR(10) ,
SUBCAPACITY CHAR(20) ,
ICA CHAR(1) ,
IPLA CHAR(1) ,
VUE CHAR(8) ,
VENDOR_GUID CHAR(32) ,
PRODUCT_GUID CHAR(32) ,
VERSION_GUID CHAR(32) ,
FEATURE_GUID CHAR(32) ,
LAST_UPDATE_TIME TIMESTAMP ,
ALT_PRODUCT_NAME CHAR(80) ,
FOBSERVEDELETED TIMESTAMP ,
BUNDLE_NAME CHAR(50) ,
FTYPE CHAR(1) ,
FSUITE_ID SMALLINT ,
ALT_VENDOR_NAME CHAR(50) NOT NULL DEFAULT ' ' ,
OPSYS CHAR (1) NOT NULL WITH DEFAULT ' ',
LMPCODE CHAR (4),
PRIMARY KEY (SW_KEY, OPSYS))
IN &REPZSCHM.VPRODUCT
VOLATILE ;
COMMIT;
CREATE TYPE 2 UNIQUE INDEX &REPZSCHM.PKPDUCT
ON &REPZSCHM.PRODUCT(SW_KEY, OPSYS)
USING STOGROUP
PRIQTY 48
SECQTY -1
ERASE NO
CLOSE NO;
COMMIT;
INSERT INTO &REPZSCHM.PRODUCT
SELECT * FROM &REPZSCHM.PRODUCT_OLD ;
COMMIT;
DROP TABLE &REPZSCHM.PRODUCT_OLD ;
COMMIT;
7. JCLLIB member HSISMS31
Expected result for SQL(1) - V8.3/V8.3.1
should be like the one below:
CREATOR #TBCOUNT
_________________ ________
&REPZSCHM 54
&REPZSCHM_LKB7 5
&REPZSCHM_LKU7 5
8. JCLLIB member HSISTPRM
NOTE: Replace the following variables:
&REPZSCHM - Repository schema name
If the migration to V9.1 has already taken place
and jobs HSISMS33, HSISMS34 (migration from V8.2),
have previously been run, then in the job HSISTPRM,
after:
//UPDATE EXEC HSIJSQLE
//SYSIN DD *
add the following statements:
DROP INDEX &REPZSCHM.PKPDUCT ;
COMMIT ;
ALTER TABLE &REPZSCHM.PRODUCT RENAME
TO PRODUCT_OLD ;
COMMIT ;
CREATE TABLE &REPZSCHM.PRODUCT (
SW_KEY CHAR(32) NOT NULL ,
SW_TYPE CHAR(8) ,
VENDOR_NAME CHAR(50) ,
PRODUCT_NAME CHAR(80) ,
VERSION INTEGER ,
VERSION_NAME CHAR(80) ,
FEATURE_NAME CHAR(80) ,
PID CHAR(16) ,
EID CHAR(8) ,
SSPID CHAR(8) ,
SSEID CHAR(8) ,
PRICETYPE CHAR(10) ,
SUBCAPACITY CHAR(20) ,
ICA CHAR(1) ,
IPLA CHAR(1) ,
VUE CHAR(8) ,
VENDOR_GUID CHAR(32) ,
PRODUCT_GUID CHAR(32) ,
VERSION_GUID CHAR(32) ,
FEATURE_GUID CHAR(32) ,
LAST_UPDATE_TIME TIMESTAMP ,
ALT_PRODUCT_NAME CHAR(80) ,
FOBSERVEDELETED TIMESTAMP ,
BUNDLE_NAME CHAR(50) ,
FTYPE CHAR(1) ,
FSUITE_ID SMALLINT ,
ALT_VENDOR_NAME CHAR(50) NOT NULL DEFAULT ' ' ,
OPSYS CHAR (1) NOT NULL WITH DEFAULT ' ',
LMPCODE CHAR (4),
PRIMARY KEY (SW_KEY, OPSYS))
IN &REPZSCHM.VPRODUCT
VOLATILE ;
COMMIT;
CREATE TYPE 2 UNIQUE INDEX &REPZSCHM.PKPDUCT
ON &REPZSCHM.PRODUCT(SW_KEY, OPSYS)
USING STOGROUP
PRIQTY 48
SECQTY -1
ERASE NO
CLOSE NO;
COMMIT;
INSERT INTO &REPZSCHM.PRODUCT
SELECT * FROM &REPZSCHM.PRODUCT_OLD ;
COMMIT;
DROP TABLE &REPZSCHM.PRODUCT_OLD ;
COMMIT;
If the migration to V9.1 has already taken place
and job HSISMS38 (migration from V8.3/V8.3.1)
has previously been run, then in the job HSISTPRM,
after:
//UPDATE EXEC HSIJSQLE
//SYSIN DD *
add the following statements:
DROP INDEX &REPZSCHM.PKPDUCT ;
COMMIT ;
ALTER TABLE &REPZSCHM.PRODUCT RENAME
TO PRODUCT_OLD ;
COMMIT ;
CREATE TABLE &REPZSCHM.PRODUCT (
SW_KEY CHAR(32) NOT NULL ,
SW_TYPE CHAR(8) ,
VENDOR_NAME CHAR(50) ,
PRODUCT_NAME CHAR(80) ,
VERSION INTEGER ,
VERSION_NAME CHAR(80) ,
FEATURE_NAME CHAR(80) ,
PID CHAR(16) ,
EID CHAR(8) ,
SSPID CHAR(8) ,
SSEID CHAR(8) ,
PRICETYPE CHAR(10) ,
SUBCAPACITY CHAR(20) ,
ICA CHAR(1) ,
IPLA CHAR(1) ,
VUE CHAR(8) ,
VENDOR_GUID CHAR(32) ,
PRODUCT_GUID CHAR(32) ,
VERSION_GUID CHAR(32) ,
FEATURE_GUID CHAR(32) ,
LAST_UPDATE_TIME TIMESTAMP ,
ALT_PRODUCT_NAME CHAR(80) ,
FOBSERVEDELETED TIMESTAMP ,
BUNDLE_NAME CHAR(50) ,
FTYPE CHAR(1) ,
FSUITE_ID SMALLINT ,
ALT_VENDOR_NAME CHAR(50) NOT NULL DEFAULT ' ' ,
OPSYS CHAR (1) NOT NULL WITH DEFAULT ' ',
LMPCODE CHAR (4),
PRIMARY KEY (SW_KEY, OPSYS))
IN &REPZSCHM.VPRODUCT
VOLATILE ;
COMMIT;
CREATE TYPE 2 UNIQUE INDEX &REPZSCHM.PKPDUCT
ON &REPZSCHM.PRODUCT(SW_KEY, OPSYS)
USING STOGROUP
PRIQTY 48
SECQTY -1
ERASE NO
CLOSE NO;
COMMIT;
INSERT INTO &REPZSCHM.PRODUCT
SELECT * FROM &REPZSCHM.PRODUCT_OLD ;
COMMIT;
DROP TABLE &REPZSCHM.PRODUCT_OLD ;
COMMIT;
NOTES
The following instructions (9 and 10) apply to all existing Db2
repositories, where you do not need to run the customization
job, HSISCUST.
9. PARM library member HSISAPIE
Replace in the comment section related to parameter
DSNAOINI the existing comment with the following:
//* "DSNAOINI=" is the 'odbc.ini' file containing the
//* specifications for the DB2 connection.
//* This can be configured according to
//* preferences, provided that the following
//* constraints are met:
//* - In the [COMMON] section
//* * MULTICONTEXT=2
//* * CURRENTAPPENSCH=ASCII
//* * FLOAT=IEEE
//* - In the [SUBSYSTEM] section
//* * MVSATTACHTYPE=RRSAF
//* IMPORTANT: The .ini file should be tagged
//* as either binary or IBM-1047 with the text
//* tag off (T=off).
//*
10. JCLLIB member HSISAPIP
After
//STDPARM DD *
replace the old command:
SH cd $UNX_API_PATH; ./ --prod
with the new command:
SH cd $UNX_API_PATH; ./bin/name of go-rest-server executable
Was this topic helpful?
Document Information
Modified date:
01 April 2026
UID
ibm17268143