View previous topic :: View next topic |
Author |
Message |
binduvnair Beginner
Joined: 07 Jan 2003 Posts: 16 Topics: 8
|
Posted: Tue Aug 05, 2003 5:38 am Post subject: DBDGEN - VSAM generation |
|
|
Hello All,
Can anyone please tell me whether the VSAM file will be created when we run the DBDGEN or should we run a separate DEFINE CLUSTER statement for it?
Regards,
Bindu |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
Posted: Tue Aug 05, 2003 2:39 pm Post subject: |
|
|
Bindu,
You need to define clusters seperately. There is an assembler language listing of the DBD macro expansion created by DBD generation execution.Usually the Print option ON DBDGEN is set to PRINT NOGEN, so that you will not get a huge listing.
If the DBD generation is for a database that uses VSAM as the operating system access method, a page in the assembler listing will provide recommended values for some of the parameters necessary to define the data sets of the database to VSAM.
CONTROLINTERVALSIZE and RECORDSIZE values other than those recommended might be desired for special reasons, such as performance improvement.
So you can take those recommended values and define the clusters as a seperate step.
check this link for a detailed explanation on
Database Description (DBD) Generation.
Check this link for a example of the recommended VSAM define cluster parameters
Assembler Listing
Hope this helps...
cheers
kolusu |
|
Back to top |
|
|
binduvnair Beginner
Joined: 07 Jan 2003 Posts: 16 Topics: 8
|
Posted: Tue Aug 05, 2003 10:54 pm Post subject: |
|
|
Thanks Kolusu. We were really confused about the define cluster statement in the listing of the DBDGEN. We thought the VSAM would be automatically created when we run the assembler code for dbdgen generation. Thanks for clarifying our doubt |
|
Back to top |
|
|
|
|