This section describes requirements for the System z servers running z/OS. If you are using Data Express for Distributed Systems, which means that your Knowledge Base will reside on a Windows machine, you can skip this section.
Any mainframe system that supports the minimum software requirements listed in the Software Requirements section can be used. Data Express requires the following amount of disk space:
The following software is supported for z/OS:
Data Express for z/OS uses a DB2 database that contains about 150 tables and views. The database must be at least DB2 V7R1 with proper DDF configuration.
The tablespace definition for one table and the DDL statements used to create the database and are shown below.
CREATE TABLESPACE      ANURDCLA                                   
       IN              &URDBASE                                   
       USING STOGROUP  &URSGROUP                                  
       PRIQTY              $PQTY                                      
       SECQTY              $SQTY                                      
       FREEPAGE         $FPAGE                                     
       PCTFREE            $PFREE                                     
       BUFFERPOOL    &URBPTS                                    
       SEGSIZE 64                                                 
       COMPRESS         $COMPRESS;                                 
CREATE TABLE  &UROWNER..ANURDCLA                                  
(MCRECID                SMALLINT             NOT NULL WITH DEFAULT,
 FILRECID                  INTEGER               NOT NULL WITH DEFAULT,
 FLDRECID                 INTEGER              NOT NULL WITH DEFAULT,
 CLATYPE                  SMALLINT            NOT NULL WITH DEFAULT,
 PRG                            SMALLINT            NOT NULL WITH DEFAULT,
 CDRULECLA            INTEGER               NOT NULL WITH DEFAULT,
 CONFID                     INTEGER               NOT NULL WITH DEFAULT, 
 FLAGDEL                  CHAR      (001)      NOT NULL WITH DEFAULT, 
 BESTCLA                   CHAR      (001)      NOT NULL WITH DEFAULT) 
 IN  &URDBASE..ANURDCLA;            
 
               	 Data Express for z/OS uses 45 partitioned data sets (PDS) and 4 sequential data sets (SEQ). PDS and SEQ data sets are identified by the combination of a prefix and a suffix. However, the user can only choose the prefix.
The current prefixes are MFDATA.VxRx for the VR release library, MFDATA.VxRxPTF for the PTF library, and MFDATA.VxRxPER for the Personalized library. These prefixes can be modified. Suffixes (for example, BIND, CLIST, and DDL) cannot be modified.
Data Express for z/OS uses the following 45 partitioned data sets:
MFDATA.V2R0.BIND MFDATA.V2R0.CBL MFDATA.V2R0.CLIST MFDATA.V2R0.COPY MFDATA.V2R0.DBRMLIB MFDATA.V2R0.DDL MFDATA.V2R0.DDLALTER MFDATA.V2R0.FTOUTPUT MFDATA.V2R0.JCL MFDATA.V2R0.LOAD MFDATA.V2R0.OBJ MFDATA.V2R0.PACKAGE MFDATA.V2R0.PANEL MFDATA.V2R0.SKEL MFDATA.V2R0.SYSPUNCH MFDATA.V2R0PTF.BIND MFDATA.V2R0PTF.CBL MFDATA.V2R0PTF.CLIST MFDATA.V2R0PTF.COPY MFDATA.V2R0PTF.DBRMLIB MFDATA.V2R0PTF.DDL MFDATA.V2R0PTF.DDLALTER MFDATA.V2R0PTF.FTOUTPUT MFDATA.V2R0PTF.JCL MFDATA.V2R0PTF.LOAD MFDATA.V2R0PTF.OBJ MFDATA.V2R0PTF.PACKAGE MFDATA.V2R0PTF.PANEL MFDATA.V2R0PTF.SKEL MFDATA.V2R0PTF.SYSPUNCH MFDATA.V2R0PER.BIND MFDATA.V2R0PER.CBL MFDATA.V2R0PER.CLIST MFDATA.V2R0PER.COPY MFDATA.V2R0PER.DBRMLIB MFDATA.V2R0PER.DDL MFDATA.V2R0PER.DDLALTER MFDATA.V2R0PER.FTOUTPUT MFDATA.V2R0PER.JCL MFDATA.V2R0PER.LOAD MFDATA.V2R0PER.OBJ MFDATA.V2R0PER.PACKAGE MFDATA.V2R0PER.PANEL MFDATA.V2R0PER.SKEL MFDATA.V2R0PER.SYSPUNCH
Data Express uses the following four sequential data sets:
MFDATA.V2R0.IMPSRC MFDATA.KBPARAM MFDATA.V2R0.ALLDDL MFDATA.V2R0.ALLBNDPK
The installer can modify the names of the first and second qualifier of a data set (for example: MFDATA.V2R0, MFDATA.V2R0PTF, and MFDATA.V2R0PER) according to your requirements.
Data Express for z/OS users must be suitably configured both at the TSO and DB2 level. For a proper configuration, the following authorizations are required:
Most activities in Data Express for z/OS consist of batch jobs executed through JCLs, which are normally created by specific submission functions by updating predefined skeletons (parameters, environment, and database specifications).
The following actions may be performed in order to customize the product to meet organizational standards:
CREATE STOGROUP &URSGROUP VOLUMES (xxxxxxxx) VCAT xxx; CREATE DATABASE &URDBASE STOGROUP &URSGROUP;