Re: Simple VSAM question on sizing INDEX component

2020-08-31 Thread CM Poncelet
t; Sent: Monday, August 31, 2020 5:17 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Simple VSAM question on sizing INDEX component > > Is the data set (and dfsms) set up for CA_RECLAIM? > > -Original Message- > From: IBM Mainframe Discussion List On Behalf Of &g

Re: Simple VSAM question on sizing INDEX component

2020-08-31 Thread Jousma, David
  |  1830 East Paris Ave, SE  |  MD RSCB2H  |  Grand Rapids, MI 49546 616.653.8429  |  fax: 616.653.2717 -Original Message- From: IBM Mainframe Discussion List On Behalf Of Lizette Koehler Sent: Monday, August 31, 2020 8:48 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Simple VSAM question

Re: Simple VSAM question on sizing INDEX component

2020-08-31 Thread Lizette Koehler
According to the LISTC it has CA-RECLAIM(YES) -Original Message- From: IBM Mainframe Discussion List On Behalf Of Allan Staller Sent: Monday, August 31, 2020 5:17 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Simple VSAM question on sizing INDEX component Is the data set (and dfsms

Re: Simple VSAM question on sizing INDEX component

2020-08-31 Thread Allan Staller
Is the data set (and dfsms) set up for CA_RECLAIM? -Original Message- From: IBM Mainframe Discussion List On Behalf Of Lizette Koehler Sent: Sunday, August 30, 2020 5:12 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Simple VSAM question on sizing INDEX component [CAUTION: This Email is from

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread CM Poncelet
EVELs to its smallest possible number, >> no? >> >> -Original Message- >> From: IBM Mainframe Discussion List On Behalf Of >> Mike Schwab >> Sent: Sunday, August 30, 2020 7:48 PM >> To: IBM-MAIN@LISTSERV.UA.EDU >> Subject: Re: Simple VSAM que

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Mike Schwab
SD. A > REORG should reduce the number of LEVELs to its smallest possible number, no? > > -Original Message- > From: IBM Mainframe Discussion List On Behalf Of > Mike Schwab > Sent: Sunday, August 30, 2020 7:48 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: S

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Clark Morris
[Default] On 30 Aug 2020 15:12:07 -0700, in bit.listserv.ibm-main stars...@mindspring.com (Lizette Koehler) wrote: >List - > > > >I have a VSAM Dataset that has grown over the years. When it was set up - >the INDEX space was left to default > One other thing to check for in addition to the

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Tony Thigpen
On Behalf Of Mike Schwab Sent: Sunday, August 30, 2020 7:48 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Simple VSAM question on sizing INDEX component CAUTION: This email originated from outside of the Texas Comptroller's email system. DO NOT click links or open attachments unless you expect

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Michael Watkins
component on DASD. A REORG should reduce the number of LEVELs to its smallest possible number, no? -Original Message- From: IBM Mainframe Discussion List On Behalf Of Mike Schwab Sent: Sunday, August 30, 2020 7:48 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Simple VSAM question on sizing INDEX

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Mike Schwab
CYL(4 1) should leave one cylinder empty. Cylinder CA will result is a more efficient index. On Sun, Aug 30, 2020 at 5:12 PM Lizette Koehler wrote: > > List - > > > > I have a VSAM Dataset that has grown over the years. When it was set up - > the INDEX space was left to default > > > > I am

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Tony Thigpen
How many index levels do you have? Tony Thigpen Lizette Koehler wrote on 8/30/20 6:11 PM: List - I have a VSAM Dataset that has grown over the years. When it was set up - the INDEX space was left to default I am wondering if it makes sense to override the Track Allocation and put

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Michael Watkins
. -Original Message- From: Michael Watkins Sent: Sunday, August 30, 2020 6:00 PM To: IBM Mainframe Discussion List Cc: Michael Watkins Subject: RE: Simple VSAM question on sizing INDEX component The index component alone is 2.4 MB? 2,400,000/56664 = 43 tracks? Sure, Allocate the index

Re: Simple VSAM question on sizing INDEX component

2020-08-30 Thread Michael Watkins
you have already activated 'CA reclaim' for all pertinent DATACLASes in ISMF. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Lizette Koehler Sent: Sunday, August 30, 2020 5:12 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Simple VSAM question on sizing INDEX component

Simple VSAM question on sizing INDEX component

2020-08-30 Thread Lizette Koehler
List - I have a VSAM Dataset that has grown over the years. When it was set up - the INDEX space was left to default I am wondering if it makes sense to override the Track Allocation and put it in Cylinders. We are noticing a little bit of an increase in run time during reorg. I was

Re: RES: VSAM question

2015-07-22 Thread Crabtree, Anne D
] On Behalf Of william janulin Sent: Wednesday, July 22, 2015 8:34 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: RES: VSAM question OK there has been an email trail on this but I believe I was not clear in my explanations. It is my understanding that I can define VSAM clusters using a DATACLASS

Re: RES: VSAM question

2015-07-22 Thread william janulin
: Wednesday, July 22, 2015 7:34 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: RES: VSAM question OK there has been an email trail on this but I believe I was not clear in my explanations. It is my understanding that I can define VSAM clusters using a DATACLASS parameter that specifies extended

Re: RES: VSAM question

2015-07-22 Thread william janulin
Bradesco. Patrocinador oficial dos Jogos Olímpicos e Paralímpicos Rio 2016. -Mensagem original- De: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] Em nome de william janulin Enviada em: segunda-feira, 20 de julho de 2015 15:57 Para: IBM-MAIN@LISTSERV.UA.EDU Assunto: VSAM

Re: VSAM question

2015-07-21 Thread retired mainframer
] On Behalf Of william janulin Sent: Tuesday, July 21, 2015 6:24 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question To list; OK. I modified a dataclass to specify extended addressability but I still get the 110 error: DEFINE - CLUSTER - ( - NAME

Re: VSAM question

2015-07-21 Thread william janulin
@LISTSERV.UA.EDU] On Behalf Of william janulin Sent: Tuesday, July 21, 2015 6:36 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question Would not modifying an existing DATACLASS to specify Extended Addressability do the same thing?         On Tuesday, July 21, 2015 9:32 AM, Blake, Daniel J

Re: VSAM question

2015-07-21 Thread Lizette Koehler
Subject: Re: VSAM question You might need to show us the code for your dataclass routine but before that can you confirm that you used ISMF to: translate the routine without error into a working SCDS dataset after updating the source; validate the routine test the routine

Re: VSAM question

2015-07-21 Thread Blake, Daniel J [CTR]
You got it. Dan Blake 2967 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of william janulin Sent: Tuesday, July 21, 2015 9:36 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question Would not modifying an existing DATACLASS

Re: VSAM question

2015-07-21 Thread Lizette Koehler
Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of william janulin Sent: Tuesday, July 21, 2015 6:36 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question Would not modifying an existing DATACLASS to specify Extended Addressability do the same thing? On Tuesday, July 21

Re: VSAM question

2015-07-21 Thread william janulin
Of william janulin Sent: Monday, July 20, 2015 2:57 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: VSAM question To list;   Is there a way around the 4 gig limitation when defining a LINEAR cluster on volumes not managed my SMS? I have to download Websphere v8.5 and am attempting to define a ZFS dataset

Re: VSAM question

2015-07-21 Thread Blake, Daniel J [CTR]
, July 21, 2015 9:24 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question To list;  OK. I modified a dataclass to specify extended addressability but I still get the 110 error:   DEFINE -    CLUSTER - ( - NAME(WAS850.ZFS) - LINEAR - CYL(8000

Re: VSAM question

2015-07-21 Thread william janulin
the total size is greater than 4 GB). Dan -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of william janulin Sent: Tuesday, July 21, 2015 9:24 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: VSAM question To list;  OK. I modified

VSAM question

2015-07-20 Thread william janulin
To list;   Is there a way around the 4 gig limitation when defining a LINEAR cluster on volumes not managed my SMS? I have to download Websphere v8.5 and am attempting to define a ZFS dataset large enough to hold the product plus its myriad of ptfs. Thank you in advance, Bill J.

Re: VSAM question

2015-07-20 Thread Leonardo Vaz
Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of william janulin Sent: Monday, July 20, 2015 2:57 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: VSAM question To list;   Is there a way around the 4 gig limitation when defining a LINEAR cluster on volumes not managed my SMS? I have

RES: VSAM question

2015-07-20 Thread ITURIEL DO NASCIMENTO NETO
15:57 Para: IBM-MAIN@LISTSERV.UA.EDU Assunto: VSAM question To list; Is there a way around the 4 gig limitation when defining a LINEAR cluster on volumes not managed my SMS? I have to download Websphere v8.5 and am attempting to define a ZFS dataset large enough to hold the product plus its

Re: VSAM question

2015-07-20 Thread Lizette Koehler
Of william janulin Sent: Monday, July 20, 2015 11:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: VSAM question To list; Is there a way around the 4 gig limitation when defining a LINEAR cluster on volumes not managed my SMS? I have to download Websphere v8.5 and am attempting to define a ZFS

Re: VSAM question

2015-07-20 Thread william janulin
Format DEF CL (name) DATACLAS(efformat name) Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of william janulin Sent: Monday, July 20, 2015 11:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: VSAM question To list

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