Skip to: Abstract | Comments | Solution | Migration | Download
APAR NUMBER: PJ30609 PRODUCT: z/TPF FUNCTIONAL AREA: CONTINUOUS DATA COLLECTION (CDC) SHIPPED IN PUT: 2 ABSTRACT: CDC CTL-4 with more than one MQ QMGR is defined. CDC DB2 table definition updates. PACKAGE CONTENTS: Source Segments: (C) base/exp/CMQS.exp (C) base/include/tpf/c_icdc.h (C) base/include/tpf/c_mqdc.h (C) base/macro/icdcc.mac (N) base/rt/cdcb.c (C) base/rt/cdco.c (C) base/rt/cdco.mak (C) base/rt/cdcp.c (C) base/rt/cdcp.mak (C) base/rt/cdcq.c (C) base/rt/cdcq.sqc (C) base/rt/cdcr.asm (C) base/rt/cdcs.cpp (C) base/rt/cdcv.c (C) base/rt/cdcv.sqc (C) base/rt/cdcw.c (C) base/rt/cdcw.sqc (C) base/rt/cdcx.c (C) base/rt/cdcx.sqc (C) base/rt/cmqcol.cpp (C) base/rt/cuik.cpp (N) base/samples/ztpf_cdc_tables.sql Object Only Binaries: None. Configuration Independent Binaries: (C) base/lib/libCMQS.so (C) base/load/CDCO.so (C) base/load/CDCP.so (C) base/load/CDCS.so (C) base/load/CMQS.so (C) base/load/CUIK.so (N) base/obj/cdcb.o (C) base/obj/cdco.o (C) base/obj/cdcp.o (C) base/obj/cdcq.o (C) base/obj/cdcr.o (C) base/obj/cdcs.o (C) base/obj/cdcv.o (C) base/obj/cdcw.o (C) base/obj/cdcx.o (C) base/obj/cmqcol.o (C) base/obj/cuik.o Support Files: base/lst/cdcb.lst base/lst/cdco.lst base/lst/cdcp.lst base/lst/cdcq.lst base/lst/cdcr.lst base/lst/cdcs.lst base/lst/cdcv.lst base/lst/cdcw.lst base/lst/cdcx.lst base/lst/cmqcol.lst base/lst/cuik.lst base/lst/CDCO.map base/lst/CDCP.map base/lst/CDCS.map base/lst/CMQS.map base/lst/CUIK.map OTHER BINARIES TO BUILD: None. PREREQUISITE APARS IN APPLICATION ORDER: base/include/tpf/c_icdc.h PJ30403(1) base/rt/cdcp.c PJ30403(1) PJ30419(1) base/rt/cdcs.cpp PJ30403(1) base/lib/libCMQS.so PJ30457(1) PJ30328(1) PJ30508(1) PJ30519(1) PJ30700(2) PJ30309(2) base/load/CDCP.so PJ30403(1) PJ30419(1) base/load/CDCS.so PJ30403(1) base/load/CMQS.so PJ30457(1) PJ30328(1) PJ30508(1) PJ30519(1) PJ30700(2) PJ30309(2) base/obj/cdcp.o PJ30403(1) PJ30419(1) base/obj/cdcs.o PJ30403(1) COMMENTS: If a z/TPF system has multiple subsystems defined and more than one of these subsystems has a z/TPF MQSeries queue manager defined, running continuous data collection (CDC) will cause a CTL-04 dump. A request also was made to change the CDC DB2 tables to use the standard DB2 time-stamp type instead of a character representation for the time and date. SOLUTION: CDC now takes into account that more than one queue manager can be defined on one z/TPF system (one per subsystem). The following changes also 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 z/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. * When writing to tape, the max block size has been changed from 4096 to 4095 bytes. This will resolve a missing byte when writing to tape. This change also requires users to download the latest version (Version 1.4) of the CDC client at http://www.ibm.com/software/htp/tpf/download/tools.htm. The CDC client has new requirements. See the package readme 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: MQSUMMARY_S has been changed to MQQMGRS_D DASD_DEV_DATA_S has been changed to DASD_DEV_DATA_D 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. The CDC client has new requirements. Refer to the download readme file for more details. BUILD COMMANDS AND INSTRUCTIONS: #maketpf commands for linux maketpf -f CUIK cuik.o maketpf -f CMQS cmqcol.o maketpf -f CDCO cdco.o cdcq.o cdcv.o cdcw.o cdcx.o maketpf -f CDCP cdcb.o cdcp.o cdcq.o cdcr.o cdcv.o cdcw.o cdcx.o maketpf -f CDCS cdcs.o TPF_VERIFY_LINK_REFS=NO maketpf CMQS link maketpf CUIK link maketpf CDCO link maketpf CDCP link maketpf CDCS link maketpf CMQS link UPDATED INFORMATION UNITS: z/TPF Messages (Online, SQLCODEs, and errno Values) z/TPF Operations z/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 APAR URL: http://www.ibm.com/software/htp/tpf/ztpfmaint/put2/PJ30609.htm
Click on Link(s) to Download File(s): Login once to access server, leave window open, then click on link(s) below. APAR Package