Eddy_G

Tech Tip: How can I create a job to install the sample databases and their applications?

Discussion created by Eddy_G Employee on May 24, 2016

Question:

After doing an upgrade install of IDMS the two demonstration databases, EMPDEMO and SQLDEMO are not installed.

How can I create a job to install these sample databases and their applications?

 

Answer:

If you already have them installed from a previous release they can still be used. To install or re-install the demo databases you will need to rerun CAISAG to generate the JCL required to install them. The following parameters are needed in the VARBLIST to install the demo databases:

GJUPGRAD = NO 
SQLDEMO = YES
EMPDEMO = YES

The files are allocated in JOB05
The files are added to the global DMCL in JOB07
EMPDEMO is build in JOB14
SQLDEMO is build in JOB15

You will need to edit the JOB05  and JOB07 JCL and only run the appropriate sections that deal with the demo databases then run JOB14 and JOB15.

Outcomes