RE: How many members in a file?

It's already at *nomax members, sitting at 31000 currently. I'll be testing
my monitor/emailer tomorrow.

TomH

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Monday, April 02, 2012 5:27 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: How many members in a file?

Just curious, why not set it to *nomax, and send an email alert if > 29000.

At least it won't explode in production.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Hightower
Sent: Monday, April 02, 2012 4:43 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: How many members in a file?


I can probably use the imbedded sql way. I'm thinking I can set it as
once-a-day program, run after nightly IPL. If a certain threshold is
reached (say 29000 members), send an email alert. That should give us a few
days lead time to do some cleanup.

Tom


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, April 02, 2012 3:28 PM
To: Midrange Systems Technical Discussion
Subject: RE: How many members in a file?

Yes, partitions is a database way of saying members.
Looking at the view that is in that view perhaps I can see why it takes so
long. It summarizes a count of all the partitions within that table. I'm
sorry, members within that file.

The API earlier suggested to retrieve the file description may be a better
performer. But a lot longer development time.


Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Tom Hightower" <tomh@xxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>,
Date: 04/02/2012 04:10 PM
Subject: RE: How many members in a file?
Sent by: midrange-l-bounces@xxxxxxxxxxxx



I can write it any way that I need to. I'm doing some testing using that
in
interactive SQL - what is number_partitions? Is that the number of
members?

... and it takes quite a while to run for a large number of members in the
file.

Tom


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, April 02, 2012 2:29 PM
To: Midrange Systems Technical Discussion
Subject: RE: How many members in a file?

Are you allowed to use SQL imbedded into rpg? For example

select NUMBER_PARTITIONS into :NbrMbrs
FROM SYSTSTAT
WHERE SYSTEM_TABLE_SCHEMA='ROB'
and SYSTEM_TABLE_NAME='MYFILE'


Rob Berendt