his file contains additions/changes made to the Global Knowledge database for August 2012. The Global Knowledge Database is a complete replacement of your current copy. You will need to run the following jobs in order to replace your copy: GKB Updates are now available via Fix Central http://www.ibm.com/support/fixcentral . In order to use Fix Central you have to have a valid IBM Userid and password. Complete the screen prompts: 1. Product Family - Select Tivoli 2. Product - Select IBM Tivoli Asset Discovery for z/OS If not found, try scrolling down and look for "Tivoli Asset Discovery for z/OS". 3. Installed Version - Select 7.2.0 4. Platform - Select z/OS Select all fixes to display. The format of the fix is 7.2.0-Tiv-TADZ-zOS-LV120831. The last six digits signify the fix level and is in YYMMDD format. The name of the file that contains the updates is TADZKB.XMI. Download this file as binary. You then need to upload this file to the mainframe to a pre-allocated file with the attributes FB 80. Once uploaded, you need to receive the file, RECEIVE INDATASET(tadzkb.xmi). When prompted for additional information enter, DA(name of file) The name of the file is important as it is used as input to the KB load jobs. This restores the KB file, making it ready to be used to update the Knowledge bases. Once you have restored the KB, you need to run the KB load jobs. 1. Before you submit any job, ensure that the input file is changed to the name of the file you have received it from. 2. For HSISDB03 in the JCLLIB: Uncomment STEP3. This step drops the Global Knowledge Base tables. Submit HSISDB03. 3. For HSISDB05 in the JCLLIB: Uncomment STEP3. This step drops the Global Knowledge Base for z/OS UNIX tables. Submit HSISDB05. 4. For HSISDB11 in the JCLLIB (optional): Comment STEP1. This prevents creation of table space Uncomment STEP3. This drops the IQ Filter tables. Submit HSISDB11 5. Re-run the Grant job HSISGRNT to restore the DB2 authorities. HSISGRNT restores the DB2 authorities which are lost when the tables are dropped in HSISDB03, HSISDB05, HSISDB11. ***** This step first appeared on the LV110729 KB (July 29, 2011); if you skipped that KB update, the procedure described below might still be applicable when updating to the new KB. ----- In this (July 29, 2011) v7.2 GKB, the products CA PAN/SQL BASE and CA PAN/SQL CICS are renamed to CA Easytrieve Plus for DB2 BASE and CA Easytrieve Plus for DB2 CICS respectively. Once you load the updated GKB you will have to rematch your IQ data for the system where these products are installed. You will need to change the option in the IQIMPORT job from FULLREMATCH=N to FULLREMATCH=Y only for the affected systems. This option will force a complete rematch of the IQ data and the new names will be used for product identification. ***** ***** The following step first appeared on the LV100630 KB (June 30, 2010) and was meant to be a one-off procedure for all customers. It is being repeated here for the benefit of those who may not have applied this change but have since been updating their KB. If you are currently experiencing the specific problem of having the same product associated to 2 different vendors (such as those shown in the SQL below), then run this procedure. ***** 6. Over time many Software Companies change their names or acquire other Software companies. In order to support these name changes, as of level 100630 the names of these Vendors have been changed. Prior to using this level, it is important to ask your DBA to run the following SQL against your Repository to change the names. Some of these Vendors may not exist in your Repository and hence an SQL error may be issued, e.g. 'ROW NOT FOUND FOR FETCH, UPDATE, OR DELETE'. You may ignore this error. If you do not run this SQL prior to using the new GKB then you will end up with the same products associated to 2 different Vendors. Move 41 modules from LKB to GKB - 1/08/2012 5:01:06 PM INSERT : Thales e-Security Ltd,Security Resource Manager for IBM MVS,BASE,2.5.0, Move 673 modules from LKB to GKB - 1/08/2012 5:07:29 PM INSERT : Allen Systems Group,ASG-TMON for CICS/ESA,BASE,3.3.0, Move 103 modules from LKB to GKB - 1/08/2012 5:09:52 PM INSERT : World Programming,World Programming System,BASE,3.0.0, Move 242 modules from LKB to GKB - 7/08/2012 8:28:20 PM INSERT : PKWARE, Inc.,PKZIP for z/OS,BASE,14.0B, Move 477 modules from LKB to GKB - 22/08/2012 4:03:06 PM INSERT : Information Builders,FOCUS Database Interfaces,ADABAS,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,DATACOM,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,IDMS,7.6.12, INSERT UNKNOWN : Information Builders,FOCUS Database Interfaces,Java,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,Java,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,MODEL204,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,SQL,7.6.12, INSERT UNKNOWN : Information Builders,FOCUS Database Interfaces,Teradata,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,Teradata,7.6.12, INSERT : Information Builders,FOCUS Database Interfaces,TOTAL,7.6.12, INSERT : Information Builders,FOCUS for IBM Mainframes,BASE,7.6.12, INSERT : Information Builders,FOCUS for IBM Mainframes,IMS,7.6.12, INSERT : Information Builders,FOCUS for IBM Mainframes,Multi Session Option,7.6.12, Move 19 modules from LKB to GKB - 22/08/2012 4:40:28 PM INSERT UNKNOWN : IBM,Tivoli Storage Manager for z/OS USS Client and API,API (BIN),6.1.0,5698-B22 INSERT : IBM,Tivoli Storage Manager for z/OS USS Client and API,API (BIN),6.1.0,5698-B22 INSERT UNKNOWN : IBM,Tivoli Storage Manager for z/OS USS Client and API,API (IBM),6.1.0,5698-B22 INSERT : IBM,Tivoli Storage Manager for z/OS USS Client and API,API (IBM),6.1.0,5698-B22 INSERT UNKNOWN : IBM,Tivoli Storage Manager for z/OS USS Client and API,Backup-Archive Client (BIN),6.1.0,5698-B22 INSERT : IBM,Tivoli Storage Manager for z/OS USS Client and API,Backup-Archive Client (BIN),6.1.0,5698-B22 INSERT UNKNOWN : IBM,Tivoli Storage Manager for z/OS USS Client and API,Backup-Archive Client (IBM),6.1.0,5698-B22 INSERT : IBM,Tivoli Storage Manager for z/OS USS Client and API,Backup-Archive Client (IBM),6.1.0,5698-B22 Move 4239 modules from LKB to GKB - 22/08/2012 9:01:49 PM REPLACE : BMC Software,B&B Common Modules,COMMON (copy),ZX33, REPLACE : BMC Software,B&B Common Modules,COMMON (copy),ZZ60, INSERT : BMC Software,B&B Common Modules,COMMON Link,ZX33, INSERT : BMC Software,B&B Common Modules,COMMON Link,ZZ60, INSERT : BMC Software,MAINVIEW SRM,BASE,7.7.0, Move 9 modules from LKB to GKB - 23/08/2012 7:35:56 AM INSERT : IBM,DB2,BASE (SDSNLOD2),9.1.0 (1108),5635-DB2 INSERT : IBM,DB2,JDBC/SQLJ,9.1.0 (1108),5635-DB2 Move 14 modules from LKB to GKB - 23/08/2012 7:38:28 AM INSERT : IBM,DB2,BASE (SDSNLOD2),9.1.0 (0808),5635-DB2 REPLACE : IBM,DB2,BASE (SDSNLOD2),9.1.0 (1108),5635-DB2 REPLACE : IBM,DB2,JDBC/SQLJ,9.1.0 (1108),5635-DB2 Move 60 modules from LKB to GKB - 23/08/2012 7:54:28 AM INSERT : Compuware Corporation,XPEDITER/CICS,BASE (SMXDAAFX),9.0.0, INSERT : Compuware Corporation,XPEDITER/CICS,BASE (SMXDAUTH),9.0.0, INSERT : Compuware Corporation,XPEDITER/CICS,BASE (SMXDPDSE),9.0.0, Move 629 modules from LKB to GKB - 23/08/2012 8:09:43 AM INSERT : Mainstar Software Corporation,Backup & Recovery Manager Suite,BASE,6.2.0, Move 6 modules from LKB to GKB - 23/08/2012 8:14:27 AM INSERT : HP,HP Exstream,BASE,8.3.11, Move 794 modules from LKB to GKB - 24/08/2012 9:08:20 AM INSERT : IBM,DB2,BASE,9.1.0 (1203),5635-DB2 INSERT : IBM,DB2,BASE (SDSNLOD2),9.1.0 (1203),5635-DB2 INSERT : IBM,DB2,JDBC/SQLJ,9.1.0 (1203),5635-DB2 INSERT : IBM,DB2,ODBC (SDSNLOD2),9.1.0 (1203),5635-DB2 INSERT : IBM,DB2,Subsystem Initialization,9.1.0 (1203),5635-DB2 INSERT : IBM,DB2 SQL Performance Analyzer for z/OS,BASE (SANLLOAD),3.2.0 (1203),5697-I04 INSERT : IBM,DB2 SQL Performance Analyzer for z/OS,BASE (SANLLODS),3.2.0 (1203),5697-I04 Move 1366 modules from LKB to GKB - 24/08/2012 10:11:40 AM INSERT UNKNOWN : Action Software International,Event Action,BASE,7.11.02, INSERT : Action Software International,Event Action,BASE,7.11.02, Move 1340 modules from LKB to GKB - 24/08/2012 12:19:16 PM INSERT : IBM,IBM Configuration Assistantance Tool,BASE,3.1.0 (1201), INSERT : IBM,IBM Tivoli Omegamon,Mgmt Svr for z/OS (TKANMOD),6.2.3,5698-A79 INSERT : IBM,IBM Tivoli Omegamon,Mgmt Svr for z/OS (TKANMODL),6.2.3,5698-A79 INSERT : IBM,IBM Tivoli Omegamon,Mgmt Svr for z/OS (TKANMODS),6.2.3,5698-A79 INSERT : IBM,IBM Tivoli Omegamon Common Modules,CT/Engine (TKANMODL),6.2.3,5698-A79 INSERT : IBM,IBM Tivoli Omegamon Common Modules,CT/Engine (TKANMODS),6.2.3,5698-A79 INSERT : IBM,Tivoli Advanced Catalog Management,BASE,2.4.0,5698-A50 INSERT : IBM,Tivoli Advanced Catalog Management,Monitoring Agent (TKANMOD),2.4.0,5698-A50 INSERT : IBM,Tivoli Advanced Catalog Management,Monitoring Agent (TKANMODL),2.4.0,5698-A50 Move 209 modules from LKB to GKB - 26/08/2012 10:06:59 PM INSERT : CA Technologies,CA PMO Runtime Performance Optimizer,BASE,4.4.0, INSERT : CA Technologies,CA-Crews Catalog Recovery,BASE,4.5.0,CREWS.00200 INSERT : CA Technologies,Endevor for DB2 Interface,BASE,r11, INSERT : IBM,DB2 DataPropagator for z/OS,BASE,8.1.0 (0408),5655-I60 INSERT : Macro 4,Trace Master,BASE,3.1.1, INSERT : Mainstar Software Corporation,VSAM Manager,BASE,4.3.01, INSERT : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.4.5, INSERT : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.4.6, INSERT : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.5.0, INSERT : William Data Systems,Exigence,BASE,4.70, Move 999 modules from LKB to GKB - 28/08/2012 3:10:41 PM INSERT UNKNOWN : BSP Incorporated,A-Auto,BASE,6.0.0, INSERT : BSP Incorporated,A-Auto,BASE,6.0.0, INSERT UNKNOWN : BSP Incorporated,A-Log,BASE,3.8.0, INSERT : BSP Incorporated,A-Log,BASE,3.8.0, INSERT UNKNOWN : BSP Incorporated,A-Spool,BASE,3.8.0, INSERT : BSP Incorporated,A-Spool,BASE,3.8.0, INSERT UNKNOWN : Canon Software Information,DEX-II,BASE,1.0, INSERT : Canon Software Information,DEX-II,BASE,1.0, INSERT UNKNOWN : FujiXerox,FXHFDL,BASE,1.0, INSERT : FujiXerox,FXHFDL,BASE,1.0, INSERT UNKNOWN : FujiXerox,FXLIEP,BASE,1.0, INSERT : FujiXerox,FXLIEP,BASE,1.0, INSERT UNKNOWN : Saison Information Systems,HULUFT for Maninframe MVS,BASE,4.0, INSERT : Saison Information Systems,HULUFT for Maninframe MVS,BASE,4.0,