Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm
No new posts Profile changed to NUMBER ON STD (fro... Martylin TSO/ISPF 1 Thu Aug 03, 2017 9:14 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us