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

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


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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: 3156
Location: Tucson AZ

PostPosted: Wed Feb 28, 2007 9:22 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Allocated cylinders of a dataset DB2 12
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts Reading dataset in Python - New Line ... All Other Mainframe Topics 22
Search our Forums:

Back to Top