asdf13
asked on
files with deleted records - flag ?
Exists there a flag (or somthing else) to identify files with deleted records ?
DSPRFD with (*MBR) is little bit too expensive . . .
DSPRFD with (*MBR) is little bit too expensive . . .
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
asdf13:
Ouch.
So many members... some ERP or similar app creating them?
Unusual elements get involved when member counts start to grow. One example is that authorities get stored with _each_ member. This is because members are actually objects themselves although we don't program for that -- we program as if the *FILE is the object. You can see this in action when you do something like CHGOBJAUT for a *FILE with many members; it can take a long time for the command to complete as each member gets touched behind the scenes.
That kind of overhead can drain a system (as you probably experience at times). Elimination of excess members can really pay off.
Good luck.
Tom
Ouch.
So many members... some ERP or similar app creating them?
Unusual elements get involved when member counts start to grow. One example is that authorities get stored with _each_ member. This is because members are actually objects themselves although we don't program for that -- we program as if the *FILE is the object. You can see this in action when you do something like CHGOBJAUT for a *FILE with many members; it can take a long time for the command to complete as each member gets touched behind the scenes.
That kind of overhead can drain a system (as you probably experience at times). Elimination of excess members can really pay off.
Good luck.
Tom
ASKER
thanks for recommendation.
My intention was, to save systemresources (performance).
Big libraries, with many files and up to 32.000 members, takes a lot of processing time with DSPFD or RTVMBRD. ("too expensive . . . ")
Now i got the information, that in former releases (<V5), a "inofficial" API delivered the flag "contains deleted records". But this API doesn't exits yet.