This file contains additions/changes made to the Global Knowledge database for September 2011. 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-LV110930. 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. **** Change 'SI7' to the Schema you are using for your Repository **** UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'Sword Apak' WHERE TVENDOR.FVENDORNAME LIKE 'LM Software%'; UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'Experian QAS' WHERE TVENDOR.FVENDORNAME LIKE 'QAS%'; UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'Oracle Corporation' WHERE TVENDOR.FVENDORNAME LIKE 'StorageTek%'; UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'Pitney Bowes Inc.' WHERE TVENDOR.FVENDORNAME LIKE 'Group 1 Software%'; UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'CA Technologies' WHERE TVENDOR.FVENDORNAME LIKE 'CA, Inc.%'; UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'Oracle Corporation' WHERE TVENDOR.FVENDORNAME LIKE 'StorageTek%'; UPDATE SI7.TVENDOR TVENDOR SET FVENDORNAME = 'FIS' WHERE TVENDOR.FVENDORNAME LIKE 'Metavante Corporation%'; UPDATE SI7.PRODUCT SET VENDOR_GUID = (SELECT FVENDORGUID FROM SI7.TVENDOR WHERE FVENDORNAME = 'Experian QAS' ) , VENDOR_NAME = 'Experian QAS' WHERE VENDOR_NAME = 'QAS' ; UPDATE SI7.PRODUCT SET VENDOR_GUID = (SELECT FVENDORGUID FROM SI7.TVENDOR WHERE FVENDORNAME = 'Oracle Corporation' ) , VENDOR_NAME = 'Oracle Corporation' WHERE VENDOR_NAME = 'StorageTek'; UPDATE SI7.PRODUCT SET VENDOR_GUID = (SELECT FVENDORGUID FROM SI7.TVENDOR WHERE FVENDORNAME = 'Pitney Bowes Inc.' ) , VENDOR_NAME = 'Pitney Bowes Inc.' WHERE VENDOR_NAME = 'Group 1 Software'; --------------------------------------------------------------------------------------- Move 67 modules to GKB - 8/09/2011 1:04:47 PM INSERT : CA Technologies,CA Spool Print Management,BASE,r11.6, Move 8801 modules to GKB - 20/09/2011 2:11:55 PM INSERT : Compuware Corporation,Abend-Aid,BASE,12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,BASE (SKFXAUTH),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,BASE (SKFXCLIB),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,BASE (SKFXLOAD),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 2.3 (SKFXCLIB),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 2.3 (SKFXLOAD),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 3.1 (SKFXCLIB),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 3.1 (SKFXLOAD),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 3.2 (SKFXCLIB),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 3.2 (SKFXLOAD),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 4.1 (SKFXCLIB),12.01.00, INSERT : Compuware Corporation,Abend-AID for CICS,CICS TS 4.1 (SKFXLOAD),12.01.00, INSERT : InfoTel Corp.,InfoPak for VSAM,BASE,7.0, INSERT : SysperTec Communications,VIRTEL,BASE,4.45, Move 11026 modules to GKB - 21/09/2011 7:40:34 AM INSERT : BMC Software,B&B Common Modules,COMMON,AD41 (1101), INSERT : BMC Software,B&B Common Modules,COMMON,BQ11 (1101), INSERT : BMC Software,B&B Common Modules,COMMON,CB23, INSERT : BMC Software,B&B Common Modules,COMMON,DZ30, INSERT : BMC Software,B&B Common Modules,COMMON,I072, INSERT : BMC Software,B&B Common Modules,COMMON,IM72, INSERT : BMC Software,B&B Common Modules,COMMON,PC12, INSERT : BMC Software,B&B Common Modules,COMMON,V45E, INSERT : BMC Software,B&B Common Modules,COMMON,V45W, INSERT : BMC Software,B&B Common Modules,COMMON,ZIB11 (1101), REPLACE : BMC Software,B&B Common Modules,COMMON,ZX33, REPLACE : BMC Software,B&B Common Modules,COMMON,ZZ60, INSERT UNKNOWN : BMC Software,B&B Common Modules,COMMON (COPY),ZX33, INSERT : BMC Software,B&B Common Modules,COMMON (COPY),ZX33, INSERT : BMC Software,B&B Common Modules,COMMON (COPY),ZZ60, INSERT : BMC Software,B&B Common Modules,General,A220, INSERT : BMC Software,CMF MONITOR,BASE,5.8.00, INSERT : BMC Software,Common Infrastructure Component,BASE,10.1.00, INSERT : BMC Software,DB2 Assist Component,BASE,10.1.0, INSERT : BMC Software,Energizer for CICS,BASE,4.5.04, INSERT : BMC Software,MAINVIEW AutoOPERATOR,BASE,7.2.00, INSERT : BMC Software,MAINVIEW Data Store,BASE,3.1.00, INSERT : BMC Software,MAINVIEW for CICS,BASE,6.3.00, INSERT : BMC Software,MAINVIEW for DB2,BASE,10.1.00, INSERT : BMC Software,MAINVIEW for IMS,Offline Products,4.5.00, INSERT : BMC Software,MAINVIEW for IMS,Online Products,4.5.00, INSERT : BMC Software,MAINVIEW for IP,BASE,3.1.00, INSERT : BMC Software,MAINVIEW for Linux,BASE,1.4.00, INSERT : BMC Software,MAINVIEW for UNIX System Services,BASE,1.6.00, INSERT : BMC Software,MAINVIEW for WebSphere,Application Server,3.1.00, INSERT : BMC Software,MAINVIEW for Websphere MQ,BASE,4.4.00, INSERT : BMC Software,MAINVIEW for z/OS,BASE,3.0.00, INSERT : BMC Software,MAINVIEW SRM,BASE,7.6.00, INSERT : BMC Software,MAINVIEW SYSPROG Services,BASE,3.6.00, INSERT : BMC Software,MAINVIEW Transaction Analyzer,BASE,3.1.00, INSERT : BMC Software,SQL Explorer for DB2,Common Explain,4.5.04, Move 2471 modules to GKB - 21/09/2011 7:48:35 AM INSERT : CA Technologies,CA Endevor Software Change Manager,BASE,r15, INSERT UNKNOWN : CA Technologies,CA Endevor Software Change Manager,Web Services,r15, INSERT : CA Technologies,CA Endevor Software Change Manager,Web Services,r15, INSERT : Compuware Corporation,File-AID for DB2,BASE,6.2.0, INSERT : Compuware Corporation,File-AID for DB2,Object Administration,6.2.0, INSERT : Compuware Corporation,XPEDITER/TSO,BASE,9.1.0, INSERT : Compuware Corporation,XPEDITER/TSO,DB2 Stored Procedures,9.1.0, INSERT UNKNOWN : Software AG,webMethods EntireX,Adabas Libraries,8.2.3, INSERT : Software AG,webMethods EntireX,Adabas Libraries,8.2.3, INSERT UNKNOWN : Software AG,webMethods EntireX,BASE,8.1.3, INSERT : Software AG,webMethods EntireX,BASE,8.1.3, INSERT UNKNOWN : Software AG,webMethods EntireX,Broker,8.1.3, INSERT : Software AG,webMethods EntireX,Broker,8.1.3, INSERT UNKNOWN : Software AG,webMethods EntireX,Broker Services,8.1.3, INSERT : Software AG,webMethods EntireX,Broker Services,8.1.3, INSERT UNKNOWN : Software AG,webMethods EntireX,Integrated Authentication,2.3.1, INSERT : Software AG,webMethods EntireX,Integrated Authentication,2.3.1, INSERT UNKNOWN : Software AG,webMethods EntireX,Remote Procedure Call,8.1.3, INSERT : Software AG,webMethods EntireX,Remote Procedure Call,8.1.3, INSERT UNKNOWN : Software AG,webMethods EntireX,Security Extensions,2.3.1, INSERT : Software AG,webMethods EntireX,Security Extensions,2.3.1, Move 5296 modules to GKB - 22/09/2011 9:56:33 AM INSERT : ACA,ALEX,LE,1.7.0, INSERT : CA Technologies,CA File Master Plus,BASE,8.5.0, INSERT UNKNOWN : CA Technologies,CA File Master Plus for IMS,BASE,8.5.0, INSERT : CA Technologies,CA File Master Plus for IMS,BASE,8.5.0, INSERT UNKNOWN : CA Technologies,CA SymDump for CICS,BASE,r8.5, INSERT : CA Technologies,CA SymDump for CICS,BASE,r8.5, INSERT : IBM,CICS Transaction Server for z/OS,BASE,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,BASE,3.2(1106),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,CICS Auth,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,CICS Auth,3.2(1103),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,CICS Link,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,CICS Link,3.2(1103),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,CICS LPA,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,CICS LPA,3.2(1003),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,CICS Message Editing,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,CICS Message Editing,3.2(1103),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,CICS SOAP,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,CICS Web Support,3.2(1103),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,CICSPLEX SM,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,CICSPLEX SM,3.2(1108),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,External CICS Interface,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,External CICS Interface,3.2(1103),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,JAVA FEATURE,2.2(0612),5697-E93 INSERT : IBM,CICS Transaction Server for z/OS,JAVA FEATURE,3.2(1106),5655-M15 INSERT : IBM,CICS Transaction Server for z/OS,WS SECURITY,3.2 (1103),5655-M15 INSERT : IBM,Tivoli Asset Discovery for z/OS,BASE,7.5.0, Move 28 modules to GKB - 22/09/2011 10:13:45 AM INSERT : MacKinney Systems Inc.,VTAM/Switch,BASE,5.0, Move 339 modules to GKB - 23/09/2011 8:29:08 AM INSERT : CA Technologies,CA 1 Tape Management,BASE,r12.6,