• 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

    Pic40 pointsBadges:
  • 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...

    Gypsymorgan5 pointsBadges:
  • 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...

    Ptc636310 pointsBadges:
  • 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

    VisionPlus5 pointsBadges:
  • 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...

    Ldonoho15 pointsBadges:
  • 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 order...

    Jonty Walker105 pointsBadges:
  • 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 would like the...

    Donnaw5 pointsBadges:
  • 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?

    Jonty Walker105 pointsBadges:
  • 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....

    Newcoboluser5 pointsBadges:
  • Question about FTP QUOTE SITE – Tandem to Mainframe

    I read your answer about the following quote site working for unix and winnt sending to a mainframe. Will this same quote site work for a Tandem to Mainframe transfer? quote site file=jes put my.jcl Thanks.

    FTA5 pointsBadges:
  • How to replace edited dataset in QMF through jcl( i.e Batch)

    I have exported one dataset 'IN105.Nord1'through QMF , then I have edited it and now I want to import it in QMF by same name( i.e IN105.Nord1') which I can do it through QMF . But now I would like to achieve same thing by running QMF through jcls( i.e through batch).Can I replace edited dataset...

    Panky5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following