Operations › Performing the EXTRACT and LOAD Steps--USVEXEC

Performing the EXTRACT and LOAD Steps--USVEXEC

The sample JCL for the batch Database Extract and Database Load Components of CA IDMS Extractor are contained in:

• z/OS-Target or Distribution source library member USVEXEC
• z/VSE- SAMPJCL library member USVEXEC.S
• z/VM- USVEXEC EXEC

This JCL is used after you create and save a Selection Criteria Specification using the online Selection Criteria Specification Component.

After supplying values for the variables, you can use this JCL as is, or it can be used as a model when you create and save a JCL member of the CA IDMS Extractor database using the Edit JCL option on the Main Menu screen. You can then use the Submit option to submit the JCL for execution.

Be sure to review Allocating Space for DASD Files.

Also review the CA IDMS Extractor Data Flow Information exhibit shown below.

Notes:

• If you create this member using the Edit JCL Option, do not include the PROCESS parameter statement in the member. The appropriate PROCESS parameter statement is created and placed into the JCL for you prior to submitting the job by the Submit Option. Thus, a single JCL member can be used by more than one Selection Criteria Specification.
• If the database name DBNAME of the target database differs from that of the source database, then a SYSIDMS DBNAME parameter should be added to the JCL used in the Load step as follows:

  //SYSIDMS DBNAME=target-dbname
  

Also all areas included in the specified target subschema must be included in this DBNAME table.

CA IDMS Extractor Data Flow Information