JCL scripts and sample parameter files

Always test scripts carefully before using them!!!

Oracle JCL Utilities:

• Sample SQL*Plus batch job

• Sample database export job

• Sample database import job

• Sample SQL*Loader job

• Sample RMAN job

• Hot backup an Oracle Database

• Build a CICS Access Manager adaptor

• Sample CICS Access Manager adaptor

General JCL Scripts:

• Download Oracle Install scripts from distribution media

• Rename an Oracle database file

• Move an Oracle database file

• Delete a database file

• Create and format a new Oracle database file

• Copy one controlfile to another

• Alter sharing options for a file

• RMF report on DASD utilization

• Delete a HSM managed file

• Sample RMAN (Recovery Manager) JCL

• Dump Oracle database files to tape

• Restore Oracle database file from tape

• Copy dumps to tape

• Allocate a tape/kast in the catalog

• Run Unix System Services commands from JCL

Oracle Parameter Files:

• Sample MPMTNS parameter file

• Sample MPMPARM parameter file

• [url=/scripts/mvs/ora$fna.txt]Sample ORA$FNA table (File Name and Attributes)[/url]

Console Commands:

• MPM console commands

• TNS console commands

• SLIP trap to prevent OC4 dumps in MPM

• Make a dataset APF authorized

• Define a new MVS Subsystem from the console

• Useful Console Display commands

Rexx command procs

• Rexx exec to start interactive SQL*Plus

• Rexx exec to start interactive Svrmgrl