Version 14.0 › CA Datacom Tools Products › Enhancements to the Previous Release › PDCs for CA Datacom/DB

PDCs for CA Datacom/DB

APAR RI13085 Solution 35

DBPNGPR is a program that you can use to evaluate XCF and CCI communication protocols. It is similar to the other techniques used in CA Datacom/DB. You can use it to ping XCF to find information about XCF groups and XCF members in existence at the time on your system. This utility is beneficial for those sites using XCF when certain XCF-related problems occur and can identify connection problems at detailed level.

Information has been added to the CA Datacom/DB Database and System Administration Guide.

APAR RI21102 Solution 48

With the application of APAR RO13308, a greater requirement for jobs to be run APF authorized is recognized. Several places in the CA Datacom/DB documentation are updated:

• CA Datacom/DB Message Reference Guide, two new messages and one removed message
• CA Datacom/DB DBUTLTY Reference Guide for z/OS
  • Overview section
  • REORG (Parallel BACKUP/LOAD)
  • REPORT MEMORY=CF function
• CA Datacom/DB Database and System Administration Guide
  • DBMSTLST Macro Parameters section, under the SMFRTY= parameter

APAR RI23671 Solution 154 (z/OS and z/VSE)

In CA Datacom Version 12.0, the default for all databases was set as OPTIMIZE for the MUF startup option ACCESS. CA Datacom SQL requires the database to have this turned on in order to use SQL Data Definition Language (DDL) statements such as CREATE TABLE, ALTER TABLE (for example to add, modify or drop an INDEX or a CONSTRAINT) or DROP TABLE. If SQL DDL is attempted on a database not set as OPTIMIZE, return code 94(170) is given.

SQL Data Definition Language (DDL) statements are not allowed when running in a MUFplex configuration with two or more Multi-User Facilities (MUFs) enabled.

This Product Documentation Change (PDC) provided changes in the following:

• CA Datacom/DB Database and System Administration Guide
  • Using the Multi-User Facility
  • Parallel Sysplex, Datacom Sharing (MUFplex)
• CA Datacom/DB SQL User Guide
  • Before You Start, Creating SQL Tables
  • SQL DDL Statements in a MUFplex
  • Creating SQL Objects
  • SQL Statements
• CA Datacom/DB Message Reference Guide
  • Return Code 90 (170)

APAR RI29501 Solution 237 (z/OS)

This PDC introduceD the CA Datacom/DB Data Reorganization Update for Version 12.0. This update included significant new functionality for the 12.0 users combined with a new documentation delivery. This update included:

• This informational solution
• The CA Technologies Green Book CA Datacom/DB Data Reorganization
• A set of confirmed PTFs that deliveedr several key enhancements for the Version 12.0 environment
• A PDF document provided documentation on the new options and reports involved
• An informational solution that provided documentation for the use of the new Version 12.0 enhancements

APAR RI29664 Solution 243 (z/OS)

The CA Datacom/DB Data Reorganization Green Book was delivered in 2011. The Green Book discusses many techniques for managing and performing data row reorganizations.

The Green Book describes the following five pairs of Accounting tables:

• High Level Accounting tables (A90 and A91)
• High Level Accounting tables with Key Information (A92 and A93)
• High Level Access with Key Information for Non-CICS (A94 and A95)
• High Level Access with Key Information for Selected DBIDs (A96 and A97)
• High Level Access with Key Information for Selected Time Periods (A98 and A99)

Steps are also provided on how to download the DDUPDATE transactions for sample Accounting tables A90-A99.

APAR RI29752 Solution 244 (z/OS and z/VSE)

This PDC clarified the meaning of CBSIO and MAXSTIO.