MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 9 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: JCL to see discarded duplicate records during load
AD7

Replies: 4
Views: 3074

PostForum: Job Control Language(JCL)   Posted: Fri Dec 15, 2006 4:00 am   Subject: JCL to see discarded duplicate records during load
I tried using ICETOOL to sort the input file and look for the duplicates - but our shop doesn't seem to have it installed, also since the number of records is HUGE, it would really be difficult to loo ...
  Topic: JCL to see discarded duplicate records during load
AD7

Replies: 4
Views: 3074

PostForum: Job Control Language(JCL)   Posted: Fri Dec 15, 2006 12:14 am   Subject: JCL to see discarded duplicate records during load
Hi Kolusu,

Thanks for the quick reply.

I am using the following job for my load, the job loads two tables subsequently -

000017 //************************************************************ ...
  Topic: JCL to see discarded duplicate records during load
AD7

Replies: 4
Views: 3074

PostForum: Job Control Language(JCL)   Posted: Thu Dec 14, 2006 6:38 am   Subject: JCL to see discarded duplicate records during load
Hi All,

I am trying to execute a load onto a table using DSNUTILB, however,
I am getting unique index violation errors for the load for a few records.

I need to find the records for which th ...
  Topic: Abend SB37, S04E
AD7

Replies: 2
Views: 4914

PostForum: Database   Posted: Tue Oct 31, 2006 2:55 am   Subject: Abend SB37, S04E
@BAUER

Thank you so much!

The first load abended because the space allocated for the temporary data sets was insufficient, I had increased the parameters and re-ran the JCL.

The second abend ...
  Topic: Abend SB37, S04E
AD7

Replies: 2
Views: 4914

PostForum: Database   Posted: Mon Oct 30, 2006 2:26 am   Subject: Abend SB37, S04E
Hi all,

I am running a load JCL for a few tables using the DSNUPROC utility.

The JCL started running properly and even loaded 2 of the tables, however when the load step for the third table came ...
  Topic: Funny Storage Group - Vanished ? What Happened?
AD7

Replies: 0
Views: 896

PostForum: Database   Posted: Thu Oct 26, 2006 1:59 am   Subject: Funny Storage Group - Vanished ? What Happened?
Hi all,

I am trying to create a tablespace T in database D using a storagegroup G.

When I ran the DDL I got an SQL error saying that the Storage Group object did not exist.

When I chkd on t ...
  Topic: Delete a Tape Data Set ( HOW? )
AD7

Replies: 5
Views: 9844

PostForum: Utilities   Posted: Thu Oct 26, 2006 12:23 am   Subject: Delete a Tape Data Set ( HOW? )
Also, can we use HDELETE for deletion of data from a tape and subsequent rewriting data onto the same tape ( I'm not sure if I am using the right terms).
Let me rephrase my question - Smile
What does H ...
  Topic: Delete a Tape Data Set ( HOW? )
AD7

Replies: 5
Views: 9844

PostForum: Utilities   Posted: Wed Oct 25, 2006 11:47 pm   Subject: Delete a Tape Data Set ( HOW? )
@Mervyn @Bill Dennis

Hey guys!

Thanks a Lot! Smile

I wrote a jcl with the IDCAMS utility (from one of the ibm.pulib manuals).
With instream as - delete tape.data.set

so does this mean - tha ...
  Topic: Delete a Tape Data Set ( HOW? )
AD7

Replies: 5
Views: 9844

PostForum: Utilities   Posted: Wed Oct 25, 2006 3:23 am   Subject: Delete a Tape Data Set ( HOW? )
Hi all,

I need to delete my tape datasets.

1. The online manuals say that I should'nt use IEFBR14 ( says it can only be used for DASD based data sets). Why?

2. It also goes onto suggest tha ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group