Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 7 Operational Requirements for CA Datacom Access : Extracting CA Datacom Table Information

Extracting CA Datacom Table Information
Use the TIBCO Object Service Broker tool DATACOM to extract metadata from CA Datacom Data Dictionary and generate TIBCO Object Service Broker DAT definitions. Note that the extractor only handles one-element CA Datacom tables and cannot generate multiple-element DAT table definitions.
Use TIBCO Object Service Broker tools to create and manipulate the TIBCO Object Service Broker DAT table definition, as follows:
The screen-based definer, available as part of the 3270 Workbench, enables you to generate TIBCO Object Service Broker table definitions of type DAT on the basis of the metadata extracted from CA Datacom Data Dictionary. You can inspect and modify definitions, including multiple-element ones, through the screen-based definer.
The UI DAT table editor, available as part of the TIBCO Object Service Broker UI, enables the creation and manipulation of DAT table definitions, including multiple-element ones, on the basis of a COBOL copybook available as a text file at definition time. For details, refer to TIBCO Object Service Broker UI Online Help.
You can use the Workbench table definer and the UI table editor against a definition any number of times in any order.
Before defining TIBCO Object Service Broker DAT tables through the screen-based definer, you must extract the CA Datacom metadata to make it available for the definition process.
The extracted CA Datacom table definition information is stored in a TIBCO Object Service Broker TDS table. Because the data is static, you must re-extract the table information whenever changes are made to new or existing CA Datacom table definitions.
Prerequisites
Before you can extract CA Datacom information, the CA Datacom Multi-User Facility must be running, but the server does not need to be.
To run the extractor as a job in a separate address space, first do the following:
1.
Customize the contents of the @SCHEDULEMODEL(MVS,DCOMDEXT) table instance (the JOB name and the names of the libraries in the STEPLIB concatenation).
2.
At install time, the @SCHEDULEMODEL(MVS,DCOMDEXT) and @SCHEDULESAMPLE(MVS,@DCOMDEXT) table instances contain identical data. After modifying the former, you can use the latter for reference. If maintenance needs to be applied in the future, TIBCO Object Service Broker will deliver the changes to @SCHEDULESAMPLE(MVS,@DCOMDEXT) only.
To run the extractor in-process, ensure that the STEPLIB library used by the Execution Environment includes the CA Datacom LOAD library (CAAXLOAD or CABDLOAD) and the CA Datacom URT library (CUSLIB) in its concatenation.
Extraction of Table Information
To extract the table information:
1.
A Table Management Facility screen appears similar to the following:

 
 
                 TIBCO OSB Facility for DAT-type Table Definition Management
 
                 _ Manage TIBCO OSB DAT-type table definitions
_ Extract CA-Datacom metadata
 
 
PFKEYS: 2=LOGS 3=EXIT 12=EXIT

 
2.
An Extract screen appears similar to the example shown:

 
 
           ----------------------------------------------------------
           | Extract CA‑Datacom table metadata. Enter:             |
           | - name for a single table, or                         |
           | - partial* where partial represents 0 to 31 first     |
           |     characters of the table name (e.g. ACC*, *), or    |
           |   - ALL (or *) for all tables.                         |
----------------------------------------------------------
CA‑Datacom table name : ________________________________
    CA‑Datacom DD Userid  : ________________________________
  CA‑Datacom DD Password:  ____________
 
 
 
PFKEYS: 12=EXIT 3=EXIT ENTER=PROCESS

 
3.
partial* for all the tables whose name starts with partialname, where partial is 0 to 31 characters long
4.
5.
6.
In the CA-Datacom DD Password field, type the CA-Datacom Data Dictionary password that corresponds to the user ID entered in the previous field.
If you do not specify a password, the default password specified during installation of CA Datacom applies.
7.
The extractor is invoked and produces an extract report similar to the one below.

 
2006-10-02 GENERATED DATACOM TABLES FROM DATADICTIONARY USERA
 
______ACTION TABLE_________________________ _ID'S__ ELEMENT EXCEPTIONS__________________________________
SELECTED SYSAUTHOBJ 00015 AOB AOBRW DUPLICATE MASTER KEY - OPTIMIZED GENERATED
SELECTED SYSCOLAUTH 00015 ACL ACLRW DUPLICATE MASTER KEY - OPTIMIZED GENERATED
SELECTED SYSCONSTRDEP 00015 CND CNDEL DUPLICATE MASTER KEY - OPTIMIZED GENERATED
NOT SELECTED SYSCONSTROBJ 00015 CNO NO ELEMENT SPANNING ENTIRE RECORD
SELECTED SYSCONSTRSRC 00015 CNS CNSEL DUPLICATE MASTER KEY - OPTIMIZED GENERATED
SELECTED SYSDBAUTH 00015 ADB ADBRW DUPLICATE MASTER KEY - OPTIMIZED GENERATED
SELECTED SYSPLANAUTH 00015 SPA SQLEL DUPLICATE MASTER KEY - OPTIMIZED GENERATED
SELECTED SYSPRIVDEP 00015 SPD SQLEL DUPLICATE MASTER KEY - OPTIMIZED GENERATED
SELECTED SYSTABAUTH 00015 ATB ATBRW DUPLICATE MASTER KEY - OPTIMIZED GENERATED
NOT SELECTED SYSTEM 00002 SYS NO ELEMENT SPANNING ENTIRE RECORD
SELECTED SYSVIEWDEP 00015 VWD VWDEL DUPLICATE MASTER KEY - OPTIMIZED GENERATED
NOT SELECTED TEXT 00002 TXT NO ELEMENT SPANNING ENTIRE RECORD
NOT SELECTED TRIGGER 00002 TRG NO ELEMENT SPANNING ENTIRE RECORD
NOT SELECTED TTM-TABLE 00017 TTM NO ELEMENT SPANNING ENTIRE RECORD

 
If you are running the extraction in a TSO session, the @SCHEDULEMODEL(MVS,DCOMDEXT) table instance, which you must customize for your site, spawns a separate job and thus determines where the extract report is sent. Otherwise, a child transaction is executed and the resulting log is available to you via PF2 upon termination.
Extract Report
The extract report shows the following information on the CA Datacom tables whose metadata has been extracted:
The names of the tables not selected and why they were not selected (for example, the CA Datacom table does not have an element name spanning the entire row)

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved