Re: VSAM question/problem

2014-05-22 Thread Pommier, Rex
Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Clark Morris Sent: Tuesday, May 20, 2014 8:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem On 20 May 2014 14:25:42 -0700, in bit.listserv.ibm-main you wrote: (3,3) While I don't have the VSAM manuals handy, I

Re: VSAM question/problem

2014-05-21 Thread John McKown
Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of John Clifford Sent: Tuesday, May 20, 2014 3:55 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem Rex, Have you tried using REPRO (IDCAMS) to unload it to a flat file (vb/9160

Re: VSAM question/problem

2014-05-21 Thread Dazzo, Matt
: Tuesday, May 20, 2014 4:55 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem Rex, Have you tried using REPRO (IDCAMS) to unload it to a flat file (vb/9160/27998) and see if it goes clean or issues an error message which may be more informational. If no error, try to repro 'reuse

Re: VSAM question/problem

2014-05-21 Thread Pommier, Rex
7:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem I have a question pertaining to DCB info when doing 'REPRO (IDCAMS) to unload it to a flat file'. John specified '(vb/9160/27998)' how is this determined? tks Matt -Original Message- From: IBM Mainframe Discussion

Re: VSAM question/problem

2014-05-21 Thread John McKown
On Wed, May 21, 2014 at 7:56 AM, Dazzo, Matt mda...@pch.com wrote: I have a question pertaining to DCB info when doing 'REPRO (IDCAMS) to unload it to a flat file'. John specified '(vb/9160/27998)' how is this determined? tks Matt Your LISTCAT showed a MAXLRECL or 9156. With RECFM=VB, there

VSAM question/problem

2014-05-20 Thread Pommier, Rex
Hi List, We have a VSAM KSDS with 1 record in it that is causing us some heartburn. I was able to create a new dataset and REPRO this one into the new one successfully, and the new dataset works fine, but I'd like to know what may be causing the original to be having problems - and possibly

Re: VSAM question/problem

2014-05-20 Thread Staller, Allan
AVERAGE KEY LENGTH: 0.0 This looks suspicious, but is not supported by any of the other doc you have supplied. The listcat shows a KEYLEN of 30, not zero. You might try a print of the INDEX component and see if it shows anything, otherwise, I am at a loss. If it really gives you that

Re: VSAM question/problem

2014-05-20 Thread John McKown
I don't know VSAMUTIL, but it likely looks at the catalog statistics. With VSAM, the catalog statistics are _NOT_ guaranteed to be correct. In fact, your LISTC has this warning it the listing: STATISTICS (* - VALUE MAY BE INCORRECT) The only way to fix this is to delete/define/reload the data

Re: VSAM question/problem

2014-05-20 Thread Pommier, Rex
something like this before. Thanks, Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Staller, Allan Sent: Tuesday, May 20, 2014 2:27 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem AVERAGE KEY LENGTH: 0.0

Re: VSAM question/problem

2014-05-20 Thread John Clifford
Rex, Have you tried using REPRO (IDCAMS) to unload it to a flat file (vb/9160/27998) and see if it goes clean or issues an error message which may be more informational. If no error, try to repro 'reuse' back over the file with the unloaded record. Being there are some counts in the splits

Re: VSAM question/problem

2014-05-20 Thread Pommier, Rex
Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of John McKown Sent: Tuesday, May 20, 2014 3:26 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem I don't know VSAMUTIL, but it likely looks at the catalog statistics. With VSAM, the catalog

Re: VSAM question/problem

2014-05-20 Thread Pommier, Rex
To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem Rex, Have you tried using REPRO (IDCAMS) to unload it to a flat file (vb/9160/27998) and see if it goes clean or issues an error message which may be more informational. If no error, try to repro 'reuse' back over the file

Re: VSAM question/problem

2014-05-20 Thread Pommier, Rex
: Re: VSAM question/problem Rex, Have you tried using REPRO (IDCAMS) to unload it to a flat file (vb/9160/27998) and see if it goes clean or issues an error message which may be more informational. If no error, try to repro 'reuse' back over the file with the unloaded record. Being there are some

Re: VSAM question/problem

2014-05-20 Thread Ed Finnell
What are SHR options? In a message dated 5/20/2014 4:21:17 P.M. Central Daylight Time, rpomm...@sfgmembers.com writes: I can't say for sure, but my guess is there's something 'not-quite-right' in the enqueueing logic that is supposed to be protecting the dataset from being updated by

Re: VSAM question/problem

2014-05-20 Thread Pommier, Rex
(3,3) -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ed Finnell Sent: Tuesday, May 20, 2014 4:24 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem What are SHR options? In a message dated 5/20/2014 4:21:17 P.M

Re: VSAM question/problem

2014-05-20 Thread Gene Hudders
Hi: I can't say for sure, but my guess is there's something 'not-quite-right' in the enqueueing logic that is supposed to be protecting the dataset from being updated by CICS and batch simultaneously. ATTRIBUTES KEYLEN30 AVGLRECL2965

Re: VSAM question/problem

2014-05-20 Thread Bob Rutledge
Pommier, Rex wrote: REPRO'ing with the REUSE reset the statistics and did the mini reorg. This leads me to further believe there was an application hiccup that caused the problem in the first place. I can't say for sure, but my guess is there's something 'not-quite-right' in the enqueueing

Re: VSAM question/problem

2014-05-20 Thread Pommier, Rex
, May 20, 2014 4:36 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem Hi: I can't say for sure, but my guess is there's something 'not-quite-right' in the enqueueing logic that is supposed to be protecting the dataset from being updated by CICS and batch simultaneously

Re: VSAM question/problem

2014-05-20 Thread John Clifford
:26 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem I don't know VSAMUTIL, but it likely looks at the catalog statistics. With VSAM, the catalog statistics are _NOT_ guaranteed to be correct. In fact, your LISTC has this warning it the listing: STATISTICS (* - VALUE MAY

Re: VSAM question/problem

2014-05-20 Thread Clark Morris
@LISTSERV.UA.EDU] On Behalf Of Ed Finnell Sent: Tuesday, May 20, 2014 4:24 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question/problem What are SHR options? In a message dated 5/20/2014 4:21:17 P.M. Central Daylight Time, rpomm...@sfgmembers.com writes: I can't say for sure, but my guess