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
swapnadeep.ganguly

Active User


Joined: 21 Mar 2007
Posts: 203
Location: India

PostPosted: Mon Oct 08, 2007 1:59 pm
Reply with quote

Hi,

I want to download from a db2 based table. For the same I am providing the file name with the following parameters.
Code:

//UTIL     EXEC DSNUTDH1,SYSTEM=TDH1,UID='PV5240A',UTPROC=''
//DSNUTDH1.SYSREC DD DSN=PV5240A.DB2.CARR.MKT.DTL,           
//    DISP=(NEW,CATLG,DELETE),                             
//    DCB=(RECFM=FB,LRECL=108),                             
//    SPACE=(CYL,(20,20),,,ROUND)                           
//*                                                         
//*                                                         
//DSNUTDH1.SYSLISTD DD DSN=PV5240A.DB2.CARR.DEFENIT,         
//    DCB=(RECFM=FB,LRECL=108,BLKSIZE=0,DSORG=PS),         
//    DISP=(NEW,CATLG,DELETE),UNIT=DISK,                   
//    SPACE=(CYL,(10,10),RLSE)                             
//*                                                         


After the downloading is complete, I am trying to copy the data file into the GDG base whose definition is as follow:
Code:

//STEP02   EXEC PGM=IEBGENER,COND=(0,LT)                         
//SYSPRINT DD SYSOUT=*                                           
//SYSOUT   DD SYSOUT=*                                           
//SYSIN    DD DUMMY                                               
//SYSUT1   DD DSN=PV5240A.DB2.CARR.MKT.DTL,DISP=(SHR,CATLG,DELETE)
//SYSUT2   DD DSN=PV5240A.DB2.CARR.MKT.BKUP(+1),                   
//            DISP=(NEW,CATLG,DELETE),                           
//            SPACE=(CYL,(20,20),,,ROUND),                       
//            DCB=(RECFM=FB,LRECL=108)                           
/*                                         
                       

But when I try to execute the above job, the job abends with a MAXCC=12. In the spool I am getting the following error display:

Code:

DATA SET UTILITY - GENERATE       
IEB311I CONFLICTING DCB PARAMETERS


When i checked out the data file's parameters, I found that to be of VB instead of FB and its LRECL is 113 instead of 108.
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 2:24 pm
Reply with quote

Swapnadeep,

One of the possibel reasons for your error-

Quote:
The output logical record length is different from the input logic
record length or the input record format is variable and the output
record format is fixed when editing is not specified. Refer to z/OS
DFSMSdfp Utilities, SC26-7414, section ''Changing Logical Record
Length'' under IEBGENER


Verify your IP and OP file attributes.
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 2:29 pm
Reply with quote

Hi Murali,

Can you please be a bit more ellaborative?

I have already specified that the type of data file(PV5240A.DB2.CARR.MKT.DTL) that I am creating is of the VB type with LRECL of 113.
But I mentioned it in my JCL to be of FB type with a LRECL of 108.
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 2:32 pm
Reply with quote

Swapnadeep,

You cannot SIMPLY convert FB to VB or vice-versa.

If you need to do this, search DFSORT forum.... you will get info on conversion.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon Oct 08, 2007 2:35 pm
Reply with quote

DSNUTDH1 will generate its own dcb parms, regardless of what you put in your jcl..............
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 2:39 pm
Reply with quote

Then the best method is to change the file into FB format with my required LRECL using the DFSORT.

Then shall i proceed to copy this changed file into my GDG?
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 2:42 pm
Reply with quote

Swapnadeep,
Quote:
Then shall i proceed to copy this changed file into my GDG?


Why do you need one more step? You can directly copy the data into GDG GENERATION using the SORT (during conversion itself).
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 2:49 pm
Reply with quote

Please correct me if I am going wrong any where in the following piece of code:
Code:

//STEP01   EXEC PGM=DFSORT,COND=(0,LT)                   
//SYSIN    DD *                                           
SORT FIELDS=(1,4,CH,A)                                   
OUTFIL FNAMES=PV5240A.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)
//
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 2:51 pm
Reply with quote

Swapnadeep,

Quote:
OUTFIL FNAMES=PV5240A.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)


Wrong. Go thru the outfil syntax.
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 2:55 pm
Reply with quote

The synatx is:

SORT FIELDS=(7,8,CH,A)
OUTFIL FNAMES=FB1,VTOF,OUTREC=(5,76)

Now as per my understanding, FB1 stands for the output file name. Outrec specifies the LRECL.

Please correct me if i am wrong in my understanding.
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 2:57 pm
Reply with quote

Ok.
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 3:01 pm
Reply with quote

So I have done the above piece of code correctly

i.e OUTFIL FNAMES=PV5240A.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108) part is correct in syntax???
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 3:04 pm
Reply with quote

I belive so.
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 3:05 pm
Reply with quote

I am getting a system abend of 806. The details as obtained from spool is:
Code:

CSV003I REQUESTED MODULE DFSORT   NOT FOUND           
CSV028I ABEND806-04  JOBNAME=Pv5240AA  STEPNAME=STEP01
IEA995I SYMPTOM DUMP OUTPUT                           
SYSTEM COMPLETION CODE=806  REASON CODE=00000004
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 3:10 pm
Reply with quote

Swapnadeep,

Quote:
CSV003I REQUESTED MODULE DFSORT NOT FOUND

Probably this might give some idea about the error.
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 3:13 pm
Reply with quote

I am getting the idea that the module DFSORT is not available. So how can I proceed next?

Is this a system utility defined by IBM?
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 3:19 pm
Reply with quote

Quote:
So how can I proceed next?


Check this link -
ibmmainframes.com/post-13099.html&highlight=
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: Mon Oct 08, 2007 3:21 pm
Reply with quote

swapnadeep.ganguly wrote:
I am getting the idea that the module DFSORT is not available. So how can I proceed next?

Is this a system utility defined by IBM?
Your shop may not have IBM's DFSORT, use the standard name of SORT and it should point to the availible version.....
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 3:55 pm
Reply with quote

Hi,

I am using the following piece of code as per the forum
Code:

//STEP01   EXEC PGM=SORT,COND=(0,LT)                         
//SORTIN   DD DSN=N48FF9.DB2.CARR.MKT.DTL,DISP=SHR           
//SORTOUT1 DD DSN=N48FF9.DB2.CARR.MKT.BKUP(+1),               
//            DISP=(NEW,CATLG,DELETE),                       
//            RECFM=FB,LRECL=108,                             
//            SPACE=(CYL,(20,20),,,ROUND)                     
//SYSIN    DD *                                               
SORT FIELDS=COPY                                             
OUTFIL FNAMES=N48FF9.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)
/*                                                           
//SYSOUT   DD SYSOUT=*                                       
//SYSDUMP  DD SYSOUT=*                                       


But I am getting an abend. The error as described in the spool is:

Code:

SYSIN :                                                       
SORT FIELDS=COPY                                             
     *                                                       
OUTFIL FNAMES=N48FF9.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)
       *                                                     
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT               
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT               
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000
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 3:58 pm
Reply with quote

Swapnadeep,

Dont you think you are repeating the OUTFIL syntax error again and again?
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: Mon Oct 08, 2007 4:05 pm
Reply with quote

Swapnadeep,
You need at least one space in front of the control statement.

murmohk1 wrote:
Dont you think you are repeating the OUTFIL syntax error again and again?
Real helpful.... icon_rolleyes.gif
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 4:14 pm
Reply with quote

Murali,

Previously you had told that my understanding for the syntax of OUTFIL statement was correct. Can you please let me know exactly where i am going wrong?
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 4:20 pm
Reply with quote

Swapnadeep,

Quote:
Previously you had told that my understanding for the syntax of OUTFIL statement was correct.

In your prev example, FB1 is a ddname and not the actual OP file name.
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 4:25 pm
Reply with quote

Thank you all.

I got the successful execution of the job.
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:15 pm
Reply with quote

I have having one more issue regarding the above problem...

Some junk value are getting written into the backup file.

E.g. the following is the extract from the data file(Variable block file)

Code:


***************************** Top of Data ******************************
 ³1920-01-012005-08-03  2005-08-03 9999-12-31National Accounts - SAM/CAD
 ³1920-01-012005-08-03  2005-08-03 9999-12-31NAG - Special Program     
 ³1920-01-012005-08-03  2005-08-03 9999-12-31Specialty - GULF           
 ³1920-01-012005-08-03  2005-08-03 9999-12-31National - Canada         


However the extract from the GDG based Fixed block file is as under:
Code:

***************************** Top of Data ******************************
 É  ³1920-01-012005-08-03  2005-08-03 9999-12-31National Accounts - SAM
 É  ³1920-01-012005-08-03  2005-08-03 9999-12-31NAG - Special Program 
 É  ³1920-01-012005-08-03  2005-08-03 9999-12-31Specialty - GULF       
 É  ³1920-01-012005-08-03  2005-08-03 9999-12-31National - Canada     


Can you please let me know how can i remove these junk value from my file?
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 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts dsnrexx fails without error message CLIST & REXX 9
No new posts writing into VSAM indexed tabl in PL1... PL/I & Assembler 8
No new posts Injecting HTTPHEADER parameters in th... PL/I & Assembler 0
No new posts SORT ERROR PARAMETER VALUE EXCEEDS M... DFSORT/ICETOOL 12
No new posts How to prevent two schid’s from con... CA Products 1
Search our Forums:

Back to Top