Unable to copy a flat file to VSAM KSDS file



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

Re: Unable to copy a flat file to VSAM KSDS file

Postby Robert Sample » Sat Dec 13, 2014 10:15 pm

Talk to your site support group!

Most sites these days have support for extended VSAM data sets (that is, a VSAM data set that has more than 4 GB) -- but whether or not YOUR site does is not something anyone on this forum can say.

If your site does not yet support extended VSAM, then what you want to do cannot be done -- period. The 4 GB limit is an absolute limit unless extended support is available.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Unable to copy a flat file to VSAM KSDS file

Postby Shikha » Sat Dec 13, 2014 10:21 pm

Thanks for your reply Robert. I read about half track blocking. How can we achieve this in the current VSAM definition? FRom what I undertand, that would help me avoid hitting 4GB limit.
Shikha
 
Posts: 5
Joined: Sat Dec 13, 2014 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to copy a flat file to VSAM KSDS file

Postby Shikha » Sat Dec 13, 2014 10:24 pm

WE are stuck in a situation where the storage team is not available over weekend and it is critical we resolve this issue now.

I am trying to understand what can be done to avoid hitting the limit.

//COPYVSAM EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DELETE (ABCDE.FGHHIJK.LMN.CLUSTER.Q42014) CLUSTER
DEFINE -
CLUSTER -
(NAME(ABCDE.FGHHIJK.LMN.CLUSTER.Q42014) -
OWNER(CA7CSF) -
KEY(29 0) -
RECSZ(126 5344) -
FREESPACE(0 0) -
RECOVERY -
NOERASE -
INDEXED -
NOWRITECHECK -
NOIMBED -
NOREPLICATE -
UNORDERED -
REUSE -
CYL(1500 1500) -
NONSPANNED -
SHR(2 3) -
VOLUME(****))
Shikha
 
Posts: 5
Joined: Sat Dec 13, 2014 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to copy a flat file to VSAM KSDS file

Postby Shikha » Sat Dec 13, 2014 10:45 pm

Number of records, I forgot to mention earlier is 7644848.

7285967 record got copied and the job is abending post that.
Shikha
 
Posts: 5
Joined: Sat Dec 13, 2014 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to copy a flat file to VSAM KSDS file

Postby enrico-sorichetti » Sat Dec 13, 2014 10:58 pm

WE are stuck in a situation where the storage team is not available over weekend and it is critical we resolve this issue now.


remember ...
replying on a forum is on voluntary base
on our own time
free of charge

there is no obligation on our side to reply/help
there should be no expectation on your side to receive any

unfortunately Your urgency is Yours and only Yours ...
a help forum is not the best place to seek help for time critical problems
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3003
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Unable to copy a flat file to VSAM KSDS file

Postby Shikha » Sat Dec 13, 2014 11:12 pm

I completely agree with you. I am sorry if you felt like I was trying to impose any urgency. I was just trying to tell, why I posted in the forum instead of going to the storage team.
Shikha
 
Posts: 5
Joined: Sat Dec 13, 2014 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to copy a flat file to VSAM KSDS file

Postby enrico-sorichetti » Sun Dec 14, 2014 12:51 am

it is not a problem of imposing or wording ...
it is just that claiming urgency, or venting about (mis)organization issues, is against any good habits in posting ,
and You might get -on some forum/mailing list- much worse answers and bashing ;)

IMHO even worse when You ask questions that should be answered by people getting paid for that inside Your organization :mrgreen:

furthermore we know nothing about the way Your system is set up,
so any reply good for the environments we know about might not agree with Your organization standards
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3003
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Unable to copy a flat file to VSAM KSDS file

Postby Robert Sample » Sun Dec 14, 2014 12:58 am

Half-track blocking will not help you. Half-track blocking is NOT for VSAM data sets -- VSAM data sets use controlintervals and controlareas instead of blocks.

And your basic problem will not change, no matter the number of records or anything else you say or attempt -- a VSAM data set has a limit of 4 GB UNLESS EXTENDED ADDRESSABILITY IS USED AND AVAILABLE AT YOUR SITE. You cannot get around this limit by any technique you use -- it is an absolute limit. You need to work with your site storage group -- either via callout this weekend or next week after they get back -- to use extended addressability for your VSAM data set.

As far as your question goes, the ONLY thing you can do to not hit the limit is to not load so many records into the data set -- or convert it to extended addressability so the limit no longer applies (and the technique to do so will be specific to your site).
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Unable to copy a flat file to VSAM KSDS file

Postby BillyBoyo » Sun Dec 14, 2014 4:00 am

Post a LISTCAT. In the Code tags.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Previous

Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post