DSNTEJCS
USE THIS JCL TO CREATE AND POPULATE THE Db2 UDB COMMON SAMPLE TABLES WITHIN A USER-SPECIFIED SCHEMA.
//********************************************************************* 00010000
//* NAME = DSNTEJCS 00020000
//* 00030000
//* DESCRIPTIVE NAME = DB2 SAMPLE APPLICATION - COMMON SAMPLE TABLES 00040000
//* 00050000
//* Licensed Materials - Property of IBM 00060000
//* 5635-DB2 00070000
//* (C) Copyright 2003, 2006 IBM CORP. 00080000
//* Status = Version 9 00090000
//* 00110000
//* FUNCTION = USE THIS JCL TO CREATE AND POPULATE THE DB2 UDB COMMON 00120000
//* SAMPLE TABLES WITHIN A USER-SPECIFIED SCHEMA. 00130000
//* 00140000
//* NOTES = IF THE TABLES ALREADY EXIST WITHIN THE SCHEMA, THEY 00150000
//* WILL BE DROPPED AND RECREATED 00160000
//* 00170000
//* DEPENDENCIES = 00180000
//* (1) YOUR PRIMARY AUTHORIZATION ID MUST BE AUTHORIZED TO USE THE 00190000
//* SPECIFIED SCHEMA 00200000
//* (2) THE SPECIFIED SCHEMA REQUIRES THE FOLLOWING AUTHORITIES: 00210000
//* - CREATETAB, CREATETS ON DATABASE DSNDB04 00220000
//* - USE OF BUFFERPOOL BP0 00230000
//* - USE OF STOGROUP SYSDEFLT 00240000
//* - USE OF TABLESPACE DSNDB04.SYSDEFLT 00250000
//* - CREATEALIAS 00260000
//* - DROP ON DATABASE DSNDB04 00270000
//* (3) PRIOR TO RUNNING THIS JOB, CUSTOMIZE IT FOR YOUR SYSTEM: 00280000
//* (A) ADD A VALID JOB CARD 00290000
//* (B) LOCATE AND CHANGE ALL OCCURRENCES OF THE FOLLOWING STRINGS 00300000
//* AS INDICATED: 00310000
//* - '!CEE!' TO THE PREFIX OF YOUR TARGET LIBRARY FOR 00320000
//* IBM LANGUAGE ENVIRONMENT 00330000
//* - 'DSN!!0' TO THE PREFIX OF YOUR TARGET LIBRARY FOR DB2 00340000
//* - THE SUBSYSTEM NAME '!DSN!' TO THE NAME OF YOUR DB2 00350000
//* - !SCHEMA! TO THE SCHEMA WITHIN WHICH YOU WISH TO CREATE 00360000
//* A COPY OF THE DB2 COMMON SAMPLE TABLES 00370000
//* 00380000
//* CHANGE ACTIVITY = 00390000
//********************************************************************* 00400000
//* 00410000
//JOBLIB DD DSN=!CEE!.SCEERUN,DISP=SHR 00420000
// DD DSN=DSN!!0.SDSNLOAD,DISP=SHR 00430000
//* 00440000
//* STEP 1 : CREATE AND POPULATE THE COMMON SAMPLE TABLES 00450000
//* 00460000
//PH0CSS01 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT) 00470000
//SYSTSPRT DD SYSOUT=* 00480000
//SYSPRINT DD SYSOUT=* 00490000
//SYSUDUMP DD SYSOUT=* 00500000
//SYSTSIN DD * 00510000
DSN SYSTEM(!DSN!) 00520000
RUN PROGRAM(DSN8CST) PLAN(DSN8CST) PARMS('/!SCHEMA!') 00530000
END 00540000
//* 00550000