View previous topic :: View next topic
|
Author |
Message |
monga
New User
Joined: 18 Apr 2006 Posts: 13
|
|
|
|
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 |
|
|
prav_06 Warnings : 1 Active User
Joined: 13 Dec 2005 Posts: 154 Location: The Netherlands
|
|
|
|
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 |
|
|
monga
New User
Joined: 18 Apr 2006 Posts: 13
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
What does the internal file definition look like? |
|
Back to top |
|
|
monga
New User
Joined: 18 Apr 2006 Posts: 13
|
|
|
|
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 |
|
|
|