QA testing mainframe code
I have 3500 members in my loadlib and a set of scripts to test this code. However i do not know what sort of code coverage i am achieving with these scripts. Is there a way to monitor which members from the loadlib are being executed by my test scripts? Note my JCL always executes [...]
Answer Question
| October 2, 2009 12:33 PM
JCL, QA testing, Quality assurance, Quality assurance testing, SMF, SYSIN
I have 3500 members in my loadlib and a set of scripts to test this code. However i do not know what sort of code coverage i am achieving with these scripts. Is there a way to monitor which members from the loadlib are being executed by my test scripts? Note my JCL always executes [...]
Answer Question
| October 2, 2009 12:33 PM
JCL, QA testing, Quality assurance, Quality assurance testing, SMF, SYSIN
How to add the date in the file name in JCL
need to create a JCL which runs every month end and create a file with name which has the current date in it
Answer Question
| January 27, 2010 9:35 AM
JCL
need to create a JCL which runs every month end and create a file with name which has the current date in it
Answer Question
| January 27, 2010 9:35 AM
JCL
IKJEFT01 job giving SYSTEM COMPLETION CODE=0C4 REASON CODE=00000011
One of my job is trying to search the reagions which are holding a file and run this step //PSTY0020 EXEC PGM=IKJEFT01,DYNAMNBR=8, // PARM=(‘%ISFSCAN,&INS..PO.STDATM.JOURNAL’, // ‘DD(2&DD),NONCICSABORT’) //SYSPROC DD DSN=CSG.CTLCARD,DISP=SHR //SYSTSIN DD DUMMY //SYSTSPRT DD SYSOUT=* //SYSOUT DD SYSOUT=* //ISFSINFO DD DSN=&FSINFO,DISP=SHR //ISFDADS DD DSN=&SEQ..PB.STDATM.ISFDADS, // DISP=(MOD,CATLG,DELETE), // DATACLAS=SMALL //ISFDADR DD DSN=&SEQ..PB.STDATM.ISFDADR, // DISP=(MOD,CATLG,DELETE), // DATACLAS=SMALL [...]
Answer Question
| April 14, 2009 5:22 PM
ABEND, IKJEFT01, JCL, Job Control Language, RC=000011
One of my job is trying to search the reagions which are holding a file and run this step //PSTY0020 EXEC PGM=IKJEFT01,DYNAMNBR=8, // PARM=(‘%ISFSCAN,&INS..PO.STDATM.JOURNAL’, // ‘DD(2&DD),NONCICSABORT’) //SYSPROC DD DSN=CSG.CTLCARD,DISP=SHR //SYSTSIN DD DUMMY //SYSTSPRT DD SYSOUT=* //SYSOUT DD SYSOUT=* //ISFSINFO DD DSN=&FSINFO,DISP=SHR //ISFDADS DD DSN=&SEQ..PB.STDATM.ISFDADS, // DISP=(MOD,CATLG,DELETE), // DATACLAS=SMALL //ISFDADR DD DSN=&SEQ..PB.STDATM.ISFDADR, // DISP=(MOD,CATLG,DELETE), // DATACLAS=SMALL [...]
Answer Question
| April 14, 2009 5:22 PM
ABEND, IKJEFT01, JCL, Job Control Language, RC=000011
Mainframe batch DB2 table I-O monitoring
Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo
Answer Question
| March 23, 2009 2:17 PM
DB2, DB2 Table, I/O Monitoring, JCL
Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo
Answer Question
| March 23, 2009 2:17 PM
DB2, DB2 Table, I/O Monitoring, JCL
CAVIEW mainframe-JCL convert to PROC-issues
We have CAVIEW on the mainframe, sequential files containing report data are sent to CAVIEW via the mainframe utility IEBGENER at the ends of jobs that produce reports. This system DID have straight JCL – we converted to JCL-and-cataloged PROCEDURE (PROC). The filename into CAVIEW, the CAVIEW reference for SYSUT2 remained the same (e.g. //SYSUT2 [...]
Answer Question
| November 25, 2008 7:15 PM
CA, CA View, IEBGENER, JCL, PROCSTEPNAME
We have CAVIEW on the mainframe, sequential files containing report data are sent to CAVIEW via the mainframe utility IEBGENER at the ends of jobs that produce reports. This system DID have straight JCL – we converted to JCL-and-cataloged PROCEDURE (PROC). The filename into CAVIEW, the CAVIEW reference for SYSUT2 remained the same (e.g. //SYSUT2 [...]
Answer Question
| November 25, 2008 7:15 PM
CA, CA View, IEBGENER, JCL, PROCSTEPNAME
use of ftp for multiple files
I need to process a JOB in mainframe FROM CONTROL_M with FTP sending multiple files from HOST to a user server. The problem is that I need a name different that the original coming from host, even without ‘ . The execution ( IT’S ONLY A PROOF JCL ): +++++++++++++++ //PTCFTPES JOB (D,ING,4788),MSGCLASS=X,CLASS=A,PRTY=9, // REGION=0M [...]
Answer Question
| November 7, 2008 8:22 PM
File transfers, FTP, JCL, Mainframe OS
I need to process a JOB in mainframe FROM CONTROL_M with FTP sending multiple files from HOST to a user server. The problem is that I need a name different that the original coming from host, even without ‘ . The execution ( IT’S ONLY A PROOF JCL ): +++++++++++++++ //PTCFTPES JOB (D,ING,4788),MSGCLASS=X,CLASS=A,PRTY=9, // REGION=0M [...]
Answer Question
| November 7, 2008 8:22 PM
File transfers, FTP, JCL, Mainframe OS
Making OMIT command inactive after a some count
I have to write a JCL step in which I have to copy a file in to another file after omitting ONLY 5 records in which starting 4 position are having character 1644. Can you please help? Thanks in advance, Sushant Sharma
Answer Question
| October 3, 2008 7:24 AM
JCL, Job Control Language, OMIT statement, SORT statement
I have to write a JCL step in which I have to copy a file in to another file after omitting ONLY 5 records in which starting 4 position are having character 1644. Can you please help? Thanks in advance, Sushant Sharma
Answer Question
| October 3, 2008 7:24 AM
JCL, Job Control Language, OMIT statement, SORT statement
DB2 Select on a large number of rows/
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the [...]
Answer Question
| September 22, 2009 3:52 PM
DB2, JCL, SQL
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the [...]
Answer Question
| September 22, 2009 3:52 PM
DB2, JCL, SQL
Sending email with SMTP thru JCL
I’m trying to use SMTP to send emails using IBM JCL (IEBGENER). This is the JCL I’m using.I’m getting INVALID COMMAND errors on the SYSIN commands. Help. //VS90033Y JOB (1,6893215,FPN-800),’CMMS’,MSGCLASS=V,USER=VS90033 //**************************************************************** /**MAIN CLASS=DSN7BTCH,FAILURE=CANCEL,LINES=(9999,W) /**FORMAT PR,DDNAME=,DEST=RM685 //***** //ST0101 EXEC PGM=IEBGENER,REGION=4M //SYSPRINT DD SYSOUT=* //SYSUT1 DD DSN=VS90033.SPF.CNTL(TESTDATA),DISP=SHR //SYSUT2 DD SYSOUT=A,DEST=SMTP //SYSIN DD * HELO BEC MAIL FROM:<LDONOHO1@VISTEON.COM> [...]
Answer Question
| August 14, 2008 12:14 PM
IEBGENER, JCL, SMTP
I’m trying to use SMTP to send emails using IBM JCL (IEBGENER). This is the JCL I’m using.I’m getting INVALID COMMAND errors on the SYSIN commands. Help. //VS90033Y JOB (1,6893215,FPN-800),’CMMS’,MSGCLASS=V,USER=VS90033 //**************************************************************** /**MAIN CLASS=DSN7BTCH,FAILURE=CANCEL,LINES=(9999,W) /**FORMAT PR,DDNAME=,DEST=RM685 //***** //ST0101 EXEC PGM=IEBGENER,REGION=4M //SYSPRINT DD SYSOUT=* //SYSUT1 DD DSN=VS90033.SPF.CNTL(TESTDATA),DISP=SHR //SYSUT2 DD SYSOUT=A,DEST=SMTP //SYSIN DD * HELO BEC MAIL FROM:<LDONOHO1@VISTEON.COM> [...]
Answer Question
| August 14, 2008 12:14 PM
IEBGENER, JCL, SMTP
Printing Documents
I am printing documents that I have designed in DOC1. The data comes from COBOL programs that I have written that gather information from DB2. The pages are not printing in the center of the page, so it is cutting off some information at the bottom and the right. I got a lead that this [...]
Answer Question
| August 13, 2009 5:00 PM
COBOL, DOC1, JCL
I am printing documents that I have designed in DOC1. The data comes from COBOL programs that I have written that gather information from DB2. The pages are not printing in the center of the page, so it is cutting off some information at the bottom and the right. I got a lead that this [...]
Answer Question
| August 13, 2009 5:00 PM
COBOL, DOC1, JCL
How to submit a JCL through VB Script?
i have a jcl to submit into mainframe without logging into mainframe. I have write a script but unable to submit the jcl into mainframe from that script. Can anyone please help me out? I really appricate your write.
Answer Question
| July 23, 2008 5:31 PM
FTP, JCL, VBScript
i have a jcl to submit into mainframe without logging into mainframe. I have write a script but unable to submit the jcl into mainframe from that script. Can anyone please help me out? I really appricate your write.
Answer Question
| July 23, 2008 5:31 PM
FTP, JCL, VBScript
Need help with FILEAID in BATCH
I’m new to FILEAID, so I’d be grateful for some sage guidance on FILEAID command syntax’s and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I’m trying (desperately) to create a work-around in [...]
Answer Question
| July 9, 2008 6:31 PM
DB2, File-AID, JCL, VB, Visual Basic
I’m new to FILEAID, so I’d be grateful for some sage guidance on FILEAID command syntax’s and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I’m trying (desperately) to create a work-around in [...]
Answer Question
| July 9, 2008 6:31 PM
DB2, File-AID, JCL, VB, Visual Basic
DSNTEP2 output problem
DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don’t have ANY experience with REXX, so an example would be appreciated. Jon
Answer Question
| December 5, 2011 4:49 PM
DB2, DSNTEP2, JCL, REXX, SQL
DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don’t have ANY experience with REXX, so an example would be appreciated. Jon
Answer Question
| December 5, 2011 4:49 PM
DB2, DSNTEP2, JCL, REXX, SQL
Rookie using DSNTEP2 and IBM JCL – Need Help with JCL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
Answer Question
| June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
I’d appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I’m having problems creating a JCL – my brain can’t remember command syntax’s from that long ago. I need to create a JCL that will accept an input [...]
Answer Question
| June 11, 2008 1:08 PM
DB2, DSNTEP2, EXEC, JCL, SQL
jcl spool command
which spool command is used to release a job with hold option
Answer Question
| August 12, 2009 5:43 AM
JCL, Spool files
which spool command is used to release a job with hold option
Answer Question
| August 12, 2009 5:43 AM
JCL, Spool files
Need help executing MULTIPLE SQL extracts from a JCL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]
Answer Question
| January 27, 2010 6:57 PM
DB2, JCL, SELECT statement, SQL
GREYBEARD52: Thanks again for the info, BUT I’m not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won’t help – it doesn’t support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command [...]
Answer Question
| January 27, 2010 6:57 PM
DB2, JCL, SELECT statement, SQL
Creating JCL to execute a large merged file of SQL for DB2
I need to create a JCL that will execute – individually – SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?
Answer Question
| June 3, 2008 4:55 PM
DB2, JCL, SQL
I need to create a JCL that will execute – individually – SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?
Answer Question
| June 3, 2008 4:55 PM
DB2, JCL, SQL
Problem with highlighting a program or JCL
I am a COBOL developer, and I’ve got a new terminal (Lenovo) yesterday. I have a problem: I cannot highlight a COBOL program or JCL in the TSO. I type command “HI” in the command line, but instead of getting the next screen with highlight options, I am getting the error message “Invalid terminal” in [...]
Answer Question
| January 27, 2010 8:24 PM
COBOL, JCL, Lenovo terminal
I am a COBOL developer, and I’ve got a new terminal (Lenovo) yesterday. I have a problem: I cannot highlight a COBOL program or JCL in the TSO. I type command “HI” in the command line, but instead of getting the next screen with highlight options, I am getting the error message “Invalid terminal” in [...]
Answer Question
| January 27, 2010 8:24 PM
COBOL, JCL, Lenovo terminal
How to change name of file to include date in the name of the file
I want to FTP from mainframe to PC. We run the JCL to do that and this JOB should run every day. Is it possible to change the name of the file that I want to send to the PC everytime? For instance, I’d like to put the month/date/year in the file name. //********************************************************************** //* [...]
Answer Question
| May 29, 2008 4:30 AM
FTP, JCL, Job Control Language, Mainframe
I want to FTP from mainframe to PC. We run the JCL to do that and this JOB should run every day. Is it possible to change the name of the file that I want to send to the PC everytime? For instance, I’d like to put the month/date/year in the file name. //********************************************************************** //* [...]
Answer Question
| May 29, 2008 4:30 AM
FTP, JCL, Job Control Language, Mainframe
Unloading specific records in a foreign key, cascade format.
Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I [...]
Answer Question
| June 25, 2008 6:33 PM
DB2, DB2 administration, JCL, OS/390, QMF, Query Management Facility
Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I [...]
Answer Question
| June 25, 2008 6:33 PM
DB2, DB2 administration, JCL, OS/390, QMF, Query Management Facility
