| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle on MVS able to submit JCL ??
You could FTP to 127.0.0.1....
127.0.0.1 is the universal IP address of the system you are on. That is you would FTP to yourself and then send the FTP file, the JCL, to the JES reader. Give it a try it seems to work on our installation.
Greg
-----Original Message-----
Sent: Wednesday, November 20, 2002 6:49 PM
To: Multiple recipients of list ORACLE-L
Thanks but EVERYTHING is on the mainframe (including Oracle). As far as I know there is no such thing as PIPEs and daemon processes on the mainframe.
I can place skeleton JCL in a proclib. The problem is getting Oracle on the mainframe to somehome invoke the internal reader to submit the JCL.
-----Original Message-----
Greg
Sent: Monday, November 18, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
Babette,
If you are on a UNIX platfrom you can ftp the JCL directly to the JES reader to submit a job on the mainframe. You need to set the parameter "site filetype=JES". On my web site (http://www.oracle-developer.us/code.htm) I have code posted to allow Oracle 8i or greater to FTP directly from Oracle.
Here is an example using just UNIX:
HOW TO SUBMIT A MAINFRAME BATCH JOB FROM UNIX STEP ONE: Create your jcl in a unix file. remember to use all upper case!
EXAMPLE: iefbr14.jcl
//M33TEST1 JOB (HRP,TEST),M33,CLASS=V,MSGCLASS=X,NOTIFY=M33
//STEP01 EXEC PGM=IEFBR14
//DD1 DD DSN=M33.TEST.FILE2,
// UNIT=HRSDA,
// SPACE=(CYL,(1,1),RLSE),
// DCB=(RECFM=FB,LRECL=080,BLKSIZE=27920,DSORG=PS),
// DISP=(NEW,CATLG,DELETE)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//*
STEP TWO: Create a job script to FTP your JCL to the mainframe.
192.6.1.79 is the address of the mainframe for this example.
'uid' should be replaced with your user id.
'password' should be replaced with your password.
'iefbr14.jcl' is the file that we created in step one.
Remember to grant execute rights to the job script using chmod.
########################################################################
### ftp a job to be submitted on the mainframe
########################################################################ftp -vn 192.6.1.79 <<END_OF_FTP_INPUT
STEP THREE: Run your job (as illustrated by the output).
$ ftpjesjob.job
Connected to 192.6.1.79.
220-FTPSRVR IBM MVS V3R2 at IBMMVS01, 12:07:39 on 2000/08/03
220 Connection will close if idle for more than 2 minutes.
Remote system type is MVS.
331 Send password please.
230 M33 is logged on. Working directory is "M33.".
200 Site command was accepted
200 Port request OK.
125 Sending Job to JES Internal Reader FIXrecfm 80
250-It is known to JES as JOB00676
250 Transfer completed successfully.
349 bytes sent in 0.00 seconds (1002.41 Kbytes/s)
221 Quit command received. Goodbye.
$
Hope that helps you out
Greg
-- [snipped] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: babette_at_rogers.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mirsky, Greg INET: gmirsky_at_Estee.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Nov 21 2002 - 08:03:29 CST
 |
 |