Skip to: Abstract | Comments | Solution | Migration | Download
APAR NUMBER: PJ30503 PRODUCT: TPF4 FUNCTIONAL AREA: CONTINUOUS DATA COLLECTION (CDC) SHIPPED IN PUT: 20 ABSTRACT: CDC DB2 table definition update APAR CONTENTS: FEATURE TYPE STATUS NAME Base CHeader Changed include/c$icdc.h Base SQL New sample/cdc_tables.sql Base C Changed source/rt/base/cdcb.c Base C Changed source/rt/base/cdco.c Base C Changed source/rt/base/cdcp.c Base SQLC Changed source/rt/base/cdcq.sqlc Base Assembler Changed source/rt/base/cdcr.asm Base SQLC Changed source/rt/base/cdcv.sqlc Base SQLC Changed source/rt/base/cdcw.sqlc Base SQLC Changed source/rt/base/cdcx.sqlc Base CPP Changed source/rt/base/cmqcol.cpp 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) Base C Changed source/rt/base/cdcb.c PJ27095(12) PJ28557(19) Base C Changed source/rt/base/cdco.c PJ29925(19) PJ30215(20) 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) Base SQLC Changed source/rt/base/cdcq.sqlc PJ27095(12) PJ28097(15) PJ29811(19) PJ29925(19) PJ30465(20) Base Assembler Changed source/rt/base/cdcr.asm PJ27095(12) PJ27343(13) PJ28097(15) PJ29811(19) PJ29925(19) Base SQLC Changed source/rt/base/cdcv.sqlc PJ29925(19) Base SQLC Changed source/rt/base/cdcw.sqlc PJ29925(19) Base SQLC Changed source/rt/base/cdcx.sqlc PJ29925(19) PJ30465(20) Base CPP Changed source/rt/base/cmqcol.cpp PJ25780(09) PJ26156(10) PJ27023(12) PJ27332(13) PJ28435(16) PJ29789(19) PJ29833(19) PJ29925(19) PJ30465(20) COMMENTS: A request was made to change the continuous data collection (CDC) DB2 tables to use the standard DB2 time-stamp type instead of a character representation for the time and date. SOLUTION: The following changes have been made: * All DB2 tables now contain a DB2 time stamp to replace the old character-based time. * All tables now contain a SMALLINT column indicating the partition number, allowing users to partition their table if they choose to do so. * Several tables have small column/name changes (see the Migration section). * The ZCDCO command will no longer drop/delete table information from DB2 or the TPF file system (this was never the case with tape of TPFDF). * Table create statements are provided in a separate file (sample/cdc_tables.sql). * The ZCDCO command will still create the tables if they are not present. * User exit CDCB will be called before each DB2 insert statement to determine the partition number to use (default is 1). * Machine type/model number field is correctly populated This change also requires users to download the latest version (Version 1.3) of the CDC client at http://www.ibm.com/software/htp/tpf/download/tools. The CDC client has new requirements. See the package readme file. DEPENDENCIES SEGMENTS TO BE ASSEMBLED OR COMPILED: None. SEGMENTS TO BE LINK EDITED: cdcb40.exe (Shipped in Tar File) cdco40.exe (Shipped in Tar File) cdcp40.exe (Shipped in Tar File) cmqs40.exe (Shipped in Tar File) COREQS: None. MIGRATION CONSIDERATIONS: All DB2 tables have been updated with the following two new columns: TPF_TIME TIMESTAMP NOT NULL DB2_PTN_NO SMALLINT NOT NULL All time/date character representations have been removed from all of the tables. The following tables have changed names: MQ_SUMMARY_S has been changed to MQQMGRS_D DASD_DEV_DATA_S has been changed to DASD_DEV_DATA_S The TIME_OF_DAY column has been removed from the STATIC_INFO_S table. No data migration script is being provided for this APAR. The following procedure is recommended for existing DB2 databases: 1) Archive the existing tables 2) Drop tables 3) Create new tables. Any SQL programs that used to query the CDC tables will need to be updated. UPDATED INFORMATION UNITS: TPF Messages (Online) TPF Migration Guide: Program Update Tapes TPF Operations TPF System Performance and Measurement Reference See your IBM representative if you need additional information. DOWNLOAD INSTRUCTIONS: http://www.ibm.com/software/htp/tpf/pages/maint.htm -- END APAR PJ30503
Download file(s): Login once to access server, leave window open, then click on link(s) below.Source Listing Binary