IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Having a JCL error: CONFLICTING DCB PARAMETERS


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Mon Oct 08, 2007 5:20 pm
Reply with quote

swapnadeep.ganguly wrote:
I got the successful execution of the job.

swapnadeep.ganguly wrote:
I have having one more issue regarding the above problem...
Some junk value are getting written into the backup file.
If you post the sysout of the successful execution, we might be able to help find the junk.......
Back to top
View user's profile Send private message
swapnadeep.ganguly

Active User


Joined: 21 Mar 2007
Posts: 203
Location: India

PostPosted: Mon Oct 08, 2007 5:24 pm
Reply with quote

The SYSOUT of the successful execution is as under:
Code:

SYSIN :                                                                       
  SORT FIELDS=COPY                                                             
  OUTFIL FNAMES=SORTOUT1,VTOF,OUTREC=(1,108)                                   
WER276B  SYSDIAG= 652870, 3242611, 3242611, 4252489                           
WER164B  8,944K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,             
WER164B     0 BYTES RESERVE REQUESTED, 3,122,272 BYTES USED                   
WER146B  20K BYTES OF EMERGENCY SPACE ALLOCATED                               
WER108I  SORTIN   : RECFM=VB   ; LRECL=   113; BLKSIZE= 27998                 
WER110I  SORTOUT1 : RECFM=FB   ; LRECL=   108; BLKSIZE= 27972                 
WER405I  SORTOUT1 :  DATA RECORDS OUT        151; TOTAL RECORDS OUT        151
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                                 
WER416B  SORTIN   : EXCP'S=1,UNIT=3390,DEV=19C6,CHP=(92959798999A9B9D,1),VOL=SMS1B0
WER416B  OUTFIL WAS USED FOR SORTOUT                                           
WER054I  RCD IN        151, OUT        151                                     
WER169I  RELEASE 1.2 BATCH 0427 TPF LEVEL 1.1                                 
WER052I  END SYNCSORT - N48FF9AA,STEP01,,DIAG=AA00,7144,822C,00CE,E2C2,4CEA,8268,A6E0
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Mon Oct 08, 2007 6:55 pm
Reply with quote

Swapnadeep,

Quote:
SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT1,VTOF,OUTREC=(1,108)

Why are you copying first 4 bytes into the OP file? Try again by replacing '1' with '5' in the above outrec statement.
'108' is the record length thats gets copied from IP to OP. So you may to have adjust this when you change 1 to 5.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Oct 08, 2007 10:02 pm
Reply with quote

DFSORT is NOT shipped as a valid name for invoking the DFSORT product. You should use PGM=ICEMAN or PGM=SORT. (Some sites assign DFSORT as an alias but your site obviously hasn't). The correct DFSORT job would be something like this:

Code:

//STEP01   EXEC PGM=ICEMAN,COND=(0,LT)                   
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...   input file
//OUT DD DSN=...  output file
//SYSIN    DD *                                           
  SORT FIELDS=(1,4,CH,A)                                   
  OUTFIL FNAMES=OUT,VTOF,OUTREC=(1,108)
/*


Note that 1,108 would include the RDW from the VB records. You probably don't want that in your FB records.
Back to top
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Mon Oct 08, 2007 10:54 pm
Reply with quote

I think you want OUTREC=(1:5,108).
If you do not need to sort the file SORT FIELDS=COPY will work fine in place of SORT FIELDS=COPY.
Note that with length 108 you are still cutting off byte 109. Check to see if this contains needed data.
Back to top
View user's profile Send private message
annujp

New User


Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN

PostPosted: Tue Oct 09, 2007 1:18 am
Reply with quote

Your sort card is correct. Your shop would not have DFSORT. That is the reason for the abend.
Try using EXEC PGM = SYNCSORT with the same sort card. That worked for me.
If you are sure you have DFSORT in your shop, you can try giving a steplib with the appropriate system load library.

Let me know if this helps.

Thanks
Anitha
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Oct 09, 2007 1:36 am
Reply with quote

Quote:
Your shop would not have DFSORT. That is the reason for the abend.


No, the reason for the ABEND is the use of PGM=DFSORT. This is NOT a valid way to invoke DFSORT or Syncsort. PGM=SORT or PGM=ICEMAN is the correct way and will invoke the sort product at the site, which in this case happens to be Syncsort. PGM=SYNCSORT will work for Syncsort, but not DFSORT unless SYNCSORT is set up as an alias for DFSORT by the site. It's best to use PGM=SORT or PGM=ICEMAN neither of which requires that the site set up an alias.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Tue Oct 09, 2007 1:46 am
Reply with quote

I am always amazed how people offer advice before reading enough of the thread to determine if the advice is correct or even needed.... icon_rolleyes.gif
Back to top
View user's profile Send private message
annujp

New User


Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN

PostPosted: Tue Oct 09, 2007 2:04 am
Reply with quote

There is no way to delete the messages after posting them. And its not immediately clear how many pages are there in the post.
It would be great if senior members do not ridicule people who are trying to help others. Also i dont see how a statement like this could help with the question asked in the forum.
Thanks
Anitha
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Oct 09, 2007 2:52 am
Reply with quote

Quote:
... Also i dont see how a statement like this could help with the question asked in the forum.


It does not help with the current question,
but it might help to have in the future a better quality of answers,

dont' t You agree that 33 follow-on to convert a vb to a fb are really too much
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Tue Oct 09, 2007 5:15 am
Reply with quote

annujp wrote:
There is no way to delete the messages after posting them. And its not immediately clear how many pages are there in the post.
It would be great if senior members do not ridicule people who are trying to help others. Also i dont see how a statement like this could help with the question asked in the forum.
Anitha,
If you would follow the thread to its current status, you would know if you are making a "stupid" statement or actually advising good help....
The choice is yours, either deal with it or not.....
My advice is to:
Read the entire thread before you post;
Think before you post;
Preview before you post;
And post when you have questions or potential solutions.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Oct 09, 2007 8:12 am
Reply with quote

Helo Anitha,

If you post something you are later not satisfied with, you can contact the moderator of that part of the forum or one of us "senior moderators" via PM and request a correction or removal of the post.

We "seniors" get ahead of ourselves sometimes also icon_smile.gif
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Oct 09, 2007 6:16 pm
Reply with quote

If you are getting junk values, are they really junk or are they packed? DB2 store numbers in some COMP format and most utilities unload them as such so they can be efficiently loaded into a different table, unless you specify otherwise.
Back to top
View user's profile Send private message
swapnadeep.ganguly

Active User


Joined: 21 Mar 2007
Posts: 203
Location: India

PostPosted: Tue Oct 09, 2007 7:19 pm
Reply with quote

Actually we are not having these datas in the tables. But they are appearing in the flat files.
E.g.: The table's first column is a date (say, 01-01-1999) but when we download this table into the file we are getting as " X01-01-1999" ie the first column in the file is space while the second column is X which is not present in the table.

Moreover, can you please let me know how I can remove this?
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Tue Oct 09, 2007 7:32 pm
Reply with quote

Swapnadeep,

Quote:
The table's first column is a date (say, 01-01-1999) but when we download this table into the file we are getting as " X01-01-1999" ie the first column in the file is space while the second column is X which is not present in the table.

Use OUTREC for truncating the data as per your wish.
Back to top
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Tue Oct 09, 2007 8:12 pm
Reply with quote

I will repost my previous post because I believe it has your answer. The first 4 bytes are the length of the variable length record. To remove them use the following.

I think you want OUTREC=(1:5,108).
If you do not need to sort the file SORT FIELDS=COPY will work fine in place of SORT FIELDS=COPY.
Note that with length 108 you are still cutting off byte 109. Check to see if this contains needed data.
Back to top
View user's profile Send private message
swapnadeep.ganguly

Active User


Joined: 21 Mar 2007
Posts: 203
Location: India

PostPosted: Wed Oct 10, 2007 9:19 am
Reply with quote

I think I cannot make myself clear to you Guru's.

My question is while we use the IBM Utility DSNUTILB, do we get a junk value in the first two columns of the generated dataset?

After following the method you all suggested, I was able to generate the file without the junk characters.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 10, 2007 11:27 am
Reply with quote

Quote:
My question is while we use the IBM Utility DSNUTILB, do we get a junk value in the first two columns of the generated dataset?


Why do You ask a question which You already replied by Yourself,

the original program, AS YOU SAID, creates a VB ( variable blocked ) dataset

what You consider JUNK ( garbage/useless things) is the most important component of VB organization...
THE LENGHT OF THE RECORD
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top