Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Dataset Creation RECFM FB - changed to VBS.....

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
monga

New User


Joined: 18 Apr 2006
Posts: 13

PostPosted: Wed Feb 28, 2007 4:39 pm    Post subject: Dataset Creation RECFM FB - changed to VBS.....
Reply with quote

Hi,

I am creating a batch spufi jcl. The job runs fine (RC 0) but there is an issue with the dataset created in the job.
I am trying to create a FB sequential dataset. But the problem is when the job runs the dataset is created with the same
parameters but is VBS Record format. And adding to this I am not able to view the contents of this dataset - I get a message
'Invalid Record Format'. Any idea why this is happening? Am I missing something here? Can I route the O/P records to SYSOUT?

Listing down the Proc here:

Code:

//PS0010 EXEC PGM=IKJEFT1B,DYNAMNBR=20                   
//STEPLIB DD DISP=SHR,DSN=?N1..DSNLOAD                 
//         DD DSN=?N1..DSNLOAD,DISP=SHR               
//DBRMLIB  DD DISP=SHR,DSN=?N1..DBRMLIB.DATA           
//SYSPRINT DD SYSOUT=*                                   
//SYSTSPRT DD SYSOUT=*                                   
//SYSDUMP  DD DUMMY                                       
//DB2OUT   DD DSN=MYDSET.TEST.OP1,DISP=(NEW,CATLG,DELETE),
//         DCB=(LRECL=80,BLKSIZE=800,DSORG=PS,RECFM=FB),
//         UNIT=DISK,SPACE=(CYL,(20,5),RLSE)             
//SYSTSIN  DD DSN=&DSN1..DB2.CTLLIB(&SYS1),DISP=SHR       
//SYSIN    DD DSN=&DSN2..CTLLIB(SQLMBR),DISP=SHR


Thanks.
Back to top
View user's profile Send private message

prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Wed Feb 28, 2007 5:04 pm    Post subject:
Reply with quote

Monga,
u can route your output to the spool just give

//DB2OUT DD SYSOUT=*

But the dd st. what u have given is absolutely fine, the error message what u got would be thrown if there is an issue with the BLKSIZE of the d/s, or please increase the lrecl of your output data set and try.


Thamilzan.
Back to top
View user's profile Send private message
monga

New User


Joined: 18 Apr 2006
Posts: 13

PostPosted: Wed Feb 28, 2007 6:42 pm    Post subject:
Reply with quote

Well these are the things that I have tried:

1) Increasing the block size and the corresponding LRECL

2) DB2OUT DD SYSOUT=* Trying to route the query o/p to sysout (Maxcc 2000 - Message DB2OUT - BLKSIZE missing)

3) Creating a dataset in FB RECFM and then using it in query with DISP=SHR. However here also the RECFM is changed from FB to VBS.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Feb 28, 2007 9:22 pm    Post subject:
Reply with quote

What does the internal file definition look like?
Back to top
View user's profile Send private message
monga

New User


Joined: 18 Apr 2006
Posts: 13

PostPosted: Thu Mar 01, 2007 9:45 am    Post subject:
Reply with quote

If I run the job as listed above, the dataset created is like this:

Management class . . : **None**
Storage class . . . : **None**
Volume serial . . . : WORK67
Device type . . . . : 3390
Data class . . . . . : **None**
Organization . . . : PS
Record format . . . : VBS
Record length . . . : 800
Block size . . . . : 27998
1st extent tracks . : 1
Secondary tracks . : 75
Data set name type :
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us