This file contains additions/changes made to the Global Knowledge database for September 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-LV120928. 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 39 modules to GKB - 8/09/2012 3:51:12 PM INSERT : IBM,R3S,BASE,2.5.0, Move 681 modules to GKB - 12/09/2012 5:37:17 PM REPLACE : CA Technologies,CA PMO Runtime Performance Optimizer,BASE,4.4.0, REPLACE : CA Technologies,CA-Crews Catalog Recovery,BASE,4.5.0,CREWS.00200 REPLACE : CA Technologies,Endevor for DB2 Interface,BASE,r11, INSERT : IBM,CICS Transaction Server for z/OS,PL/1 FEATURE,3.2.0 (0806),5655-M15 INSERT : IBM,DB2,JDBC/SQLJ,9.1.0 (1102),5635-DB2 INSERT : IBM,DB2,ODBC (SDSNLOD2),9.1.0 (1102),5635-DB2 REPLACE : IBM,DB2 DataPropagator for z/OS,BASE,8.1.0 (0408),5655-I60 INSERT : IBM,IBM Tivoli zSecure Alert,BASE,1.9.0 (02),5655-T11 INSERT : IBM,IBM Tivoli zSecure Audit for RACF,BASE,1.9.0 (02),5655-T02 INSERT : IBM,TSO COBOL Prompter,BASE,1.1 (8103), REPLACE : Macro 4,Trace Master,BASE,3.1.1, REPLACE : Mainstar Software Corporation,VSAM Manager,BASE,4.3.01, INSERT : Marble Computer Inc.,DCD,BASE,2.4, INSERT : NCR Corporation,Teradata,BASE (APPLOAD),14.0, REPLACE : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.4.5, REPLACE : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.4.6, INSERT : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.4.8, REPLACE : Oracle Corporation,Hyperion SQR Production Reporting,BASE,8.5.0, INSERT : Quest Software, Inc.,NCI/XF,BASE,2.1, INSERT : Quest Software, Inc.,PassGo Multsess,BASE,2.7.0, INSERT : Sterling Commerce,GENTRAN:Plus,CICS,6.3, REPLACE : William Data Systems,Exigence,BASE,4.70, Move 665 modules to GKB - 12/09/2012 5:41:42 PM REPLACE : Applied Software,SSR Server for CICS,BASE,4.0, Move 2126 modules to GKB - 17/09/2012 5:39:51 PM INSERT : GT Software,Ivory Server,BASE,3.6.0, INSERT : Hitachi ID Systems, Inc.,Hitachi ID Password Manager,BASE,2.1.2, INSERT : Infogix, Inc.,ACR/PLUS,TSO,4.1, INSERT : Macro 4,DumpMaster,BASE,7.1, INSERT : Marble Computer Inc.,DCD,BASE,3.8, INSERT : MAX Software,MAX/REXX,BASE,3.4.0, INSERT : NETEC International Inc.,CICS Applications Control Facility,BASE (LOADLIB),4.7.00, INSERT : Pitney Bowes Inc.,Streamweaver,BASE,6.4.9, INSERT : Software Diversified Services,VitalSigns for VTAM,BASE,5.1.4, INSERT : Systemware, Inc.,Job History System,BASE,3.8, INSERT UNKNOWN : UNICOM Systems, Inc.,CARTS,BASE (APFLIB),3.6.0, INSERT : UNICOM Systems, Inc.,CARTS,BASE (APFLIB),3.6.0, INSERT : UNICOM Systems, Inc.,CARTS,BASE (APFLIB),4.2.0, INSERT UNKNOWN : UNICOM Systems, Inc.,CARTS,BASE (LOADLIB),4.2.0, INSERT : UNICOM Systems, Inc.,CARTS,BASE (LOADLIB),4.2.0, Move 500 modules to GKB - 18/09/2012 5:14:38 PM INSERT UNKNOWN : CA Technologies,CA Mainframe Applicstion Tuner,BASE (3LOAD),8.5.0,MATUNE00020 INSERT : CA Technologies,CA Mainframe Applicstion Tuner,BASE (3LOAD),8.5.0,MATUNE00020 INSERT UNKNOWN : CA Technologies,CA Mainframe Applicstion Tuner,BASE (AUTH),8.5.0,MATUNE00020 INSERT : CA Technologies,CA Mainframe Applicstion Tuner,BASE (AUTH),8.5.0,MATUNE00020 INSERT UNKNOWN : CA Technologies,CA Mainframe Applicstion Tuner,BASE (LOAD),8.5.0,MATUNE00020 INSERT : CA Technologies,CA Mainframe Applicstion Tuner,BASE (LOAD),8.5.0,MATUNE00020 INSERT UNKNOWN : CA Technologies,CA Mainframe Applicstion Tuner,BASE (PLD),8.5.0,MATUNE00020 INSERT : CA Technologies,CA Mainframe Applicstion Tuner,BASE (PLD),8.5.0,MATUNE00020 Move 1 modules to GKB - 19/09/2012 8:14:39 AM INSERT UNKNOWN : Merrill Consultants,MXG Tape Mount Montoring,BASE,12.26, INSERT : Merrill Consultants,MXG Tape Mount Montoring,BASE,12.26, Move 47 modules to GKB - 25/09/2012 8:33:22 AM INSERT : IBM,DB2,BASE (SDSNLOD2),9.1.0 (1204),5635-DB2 INSERT : IBM,DB2,ODBC (SDSNLOD2),9.1.0 (1204),5635-DB2 INSERT UNKNOWN : MacKinney Systems Inc.,Easy Help,BASE,2.8, INSERT : MacKinney Systems Inc.,Easy Help,BASE,2.8, Move 444 modules to GKB - 25/09/2012 12:27:19 PM INSERT : CA Technologies,CA-OPS/MVS,BASE,r12,PVLSOF00200 INSERT UNKNOWN : CA Technologies,CA-OPS/MVS,BASE (PLD),r12,PVLSOF00200 INSERT : CA Technologies,CA-OPS/MVS,BASE (PLD),r12,PVLSOF00200 INSERT UNKNOWN : CA Technologies,CA-OPS/MVS,CICS Operations Facility,r12, INSERT : CA Technologies,CA-OPS/MVS,CICS Operations Facility,r12, INSERT UNKNOWN : CA Technologies,CA-OPS/MVS,NSM/SSM,r12, INSERT : CA Technologies,CA-OPS/MVS,NSM/SSM,r12, INSERT UNKNOWN : CA Technologies,CA-OPS/MVS,OPSHMC REXX,r12, INSERT : CA Technologies,CA-OPS/MVS,OPSHMC REXX,r12, INSERT UNKNOWN : CA Technologies,CA-OPS/MVS,OPSLOG WebView,r12, INSERT : CA Technologies,CA-OPS/MVS,OPSLOG WebView,r12, Move 30 modules to GKB - 28/09/2012 8:20:40 AM REPLACE : IBM,File Manager for z/OS,CICS (SFMNMOD1),12.1.0,5655-W68 REPLACE : IBM,File Manager for z/OS,CICS (SFMNMOD1),9.1.0,5655-U29 REPLACE : IBM,File Manager for z/OS,CICS (SFMNMOD2),12.1.0,5655-W68 REPLACE : IBM,File Manager for z/OS,CICS (SFMNMOD2),9.1.0,5655-U29 Move 242 modules to GKB - 28/09/2012 9:43:54 AM INSERT : DocuCorp International Inc,DocuMerge,BASE,3.2.2, INSERT UNKNOWN : Pitney Bowes Inc.,List Conversion Plus,BASE,2.7.0, INSERT : Pitney Bowes Inc.,List Conversion Plus,BASE,2.7.0, INSERT UNKNOWN : Pitney Bowes Inc.,Merge/Purge Plus,BASE,2.7.0, INSERT : Pitney Bowes Inc.,Merge/Purge Plus,BASE,2.7.0, REPLACE : ASPG Inc,MegaCryption,BASE,5.4.1, REPLACE : ASPG Inc,MegaCryption,BASE,6.1.3, INSERT : Compuware Corporation,XPEDITER/DevEnterprise,BASE,4.2.0, INSERT : EMC Corporation,InfoMover,BASE,2.1.8, INSERT : EMC Corporation,InfoMover,BASE,2.3.8, INSERT : Innovation Data Processing,FATAR,BASE,4.3.0, INSERT : Innovation Data Processing,FATS,BASE,4.3.0, INSERT : MacKinney Systems Inc.,Listcat Plus,BASE,7.0,