Skip to: Abstract | Comments | Solution | Migration | Download
APAR NUMBER: PJ30701 PRODUCT: TPF4 FUNCTIONAL AREA: CONTINUOUS DATA COLLECTION (CDC) SHIPPED IN PUT: 20 ABSTRACT: Queries of a large CDC-TPFDF database may take too long and the build scripts for CDCO/CDCP requires updates. APAR CONTENTS: FEATURE TYPE STATUS NAME Base CHeader Changed include/c$icdc.h Base CHeader Changed include/c$irc1df.h Base CHeader Changed include/c$irc2df.h Base CHeader New include/tpf/c_irc0df.h Base Macro New macro/irc0df.mac Base Macro Changed macro/irc1df.mac Base Macro Changed macro/irc2df.mac Base BldScript Changed source/rt/base/cdcobs.bsc Base C Changed source/rt/base/cdcp.c Base BldScript Changed source/rt/base/cdcpbs.bsc Base SQLC Changed source/rt/base/cdcq.sqlc Base Assembler Changed source/rt/base/cdcr.asm Base CPP Changed source/rt/base/cdcs.cpp Base SQLC Changed source/rt/base/cdcx.sqlc Base Assembler Changed source/rt/base/uf1t.asm PREREQUISITE APARS: To be applied in order listed. Base CHeader Changed include/c$icdc.h PJ27095(12) PJ28097(15) PJ29925(19) PJ30137(19) PJ30215(20) PJ30233(20) PJ30465(20) PJ30503(20) Base CHeader Changed include/c$irc1df.h PJ29925(19) Base CHeader Changed include/c$irc2df.h PJ29925(19) PJ30137(19) Base Macro Changed macro/irc1df.mac PJ29925(19) Base Macro Changed macro/irc2df.mac PJ29925(19) PJ30137(19) Base BldScript Changed source/rt/base/cdcobs.bsc PJ27095(12) PJ28097(15) PJ29925(19) Base C Changed source/rt/base/cdcp.c PJ27095(12) PJ27775(15) PJ28097(15) PJ29925(19) PJ30137(19) PJ30215(20) PJ30233(20) PJ30253(20) PJ30251(20) PJ30465(20) PJ30503(20) Base BldScript Changed source/rt/base/cdcpbs.bsc PJ27095(12) PJ28097(15) PJ29925(19) PJ30216(20) Base SQLC Changed source/rt/base/cdcq.sqlc PJ27095(12) PJ28097(15) PJ29811(19) PJ29925(19) PJ30465(20) PJ30503(20) Base Assembler Changed source/rt/base/cdcr.asm PJ27095(12) PJ27343(13) PJ28097(15) PJ29811(19) PJ29925(19) PJ30503(20) Base CPP Changed source/rt/base/cdcs.cpp PJ29925(19) PJ30233(20) PJ30465(20) Base SQLC Changed source/rt/base/cdcx.sqlc PJ29925(19) PJ30465(20) PJ30503(20) Base Assembler Changed source/rt/base/uf1t.asm PJ29925(19) PJ30137(19) COMMENTS: When using TPFDF as the storage medium for CDC and running CDC at its fastest collection frequency (every 5 seconds) for a full day, CDC will generate a sizeable TPFDF database. It can take too long for TPFDF to respond to the CDC clients query request of such a large database. Currently, the MACHINE_TYPE field does not concatenate the machines model number. Additionally, the CDCO/CDCP build scripts do not reference segment CDCB. SOLUTION: B+Tree indexing has been added to the CDC TPFDF detail file. This allows for improved response time when querying data. Also, the MACHINE_TYPE field now contains the machine type and model number. The CDCO and CDCP build scripts now include a reference to the CDCB segment. DEPENDENCIES SEGMENTS TO BE ASSEMBLED OR COMPILED: None. SEGMENTS TO BE LINK EDITED: cdco40.exe (Shipped in Tar File) cdcp40.exe (Shipped in Tar File) cdcs40.exe (Shipped in Tar File) COREQS: None. MIGRATION CONSIDERATIONS: Existing CDC TPFDF databases cannot be migrated to using the updated DBDEF. It will require the initialization (ZUDFM INIT FCA0) of the FCA0 file. This affects all TPF LPAR's within a loosely coupled complex. UPDATED INFORMATION UNITS: None. See your IBM representative if you need additional information. DOWNLOAD INSTRUCTIONS: http://www.ibm.com/software/htp/tpf/pages/maint.htm -- END APAR PJ30701
Download file(s): Login once to access server, leave window open, then click on link(s) below.Source Listing Binary