|
Create Application Directory Structure |
Scroll |
While the Connect CDC SQData Variable Directory <SQDATA_VAR_DIR> location works fine for Capture Agents and the sqdaemon Controller daemon, Apply Engine Script development typically requires a different structure to accommodate the organization of development into areas of responsibility, e.g: Test and Production as well as "Applications". We recommend the following base directory for Engine script development to accommodate specific application, organizational and operational requirements:
<SQDATA_VAR_DIR>/<your_hierarchy_here>/
The nature of the Apply Engine scripts a structure accommodating similar items from dissimilar platforms such as DDL from DB2 and Oracle. For that reason the following directory nodes are recommended at the next level for script development and parts management:
./<directory_name> |
Description |
|---|---|
ENGINE |
Main Engine scripts |
CDCPROC |
CDC Engine Called Procedures referenced by #INCLUDE |
LOADPROC |
Load (UnLoad) Engine Called Procedures referenced by #INCLUDE |
DSDEF |
Datastore Definition referenced by #INCLUDE |
<TYPE>DDL |
RDBMS specific DDL, eg DB2DDL, ORADDL, MSSQLDDL, etc |
IMSSEG |
IMS Segment Copybooks |
IMSDBD |
IMS DBD |
<TYPE>COB |
System specific COBOL copybooks, eg: VSAMCOB, SEQCOB (sequential files) |
XMLDTD |
XML Document Type Definitions that will be used in a DESCRIPTION command |
<TYPE>CSR |
RDBMS specific Cursors, eg DB2CSR, ORACSR,etc |
<TYPE>LOAD |
RDBMS specific Load Control, eg DB2LOAD, ORALOAD ,etc |
Notes:
1.While it may be more convenient to user lower case directory names, if your environment includes the z/OS Platform, consideration should be given to reusability as some z/OS references must be in Upper Case.
2.Engine scripts are typically Platform specific in that they cannot be used on another type of Platform, eg z/OS and UNIX without at least minor modification.
3.Called Procedures can frequently be used with little or no changes on another platform, even when they contain platform specific Functions, unless they require direct access to a datastore on another platform, an atypical requirement.
4.Throughout the remainder of this document, part locations will usually refer only to the last node of standard z/OS Partitioned Datasets and UNIX or Windows directory hierarchy.
Commands similar to the following may be used to create the recommended directory structures. Alternatively unzip the $sqdata_Apply_Engine_Parts.zip file to create the full structure along with sample parts and shell scripts:
$ mkdir -p <SQDATA_VAR_DIR>/DB2DDL --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/ORADDL --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/IMSDBD --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/IMSSEG --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/ENGINE --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/CDCPROC --mode=775
