|
| 6 members and 17 guests have been online with in the last 10 minutes. |
|
|
| No posts have caught fire as of yet. |
|
|
|
bigfoot53
member
Reged: 06/24/08
Last on: 03/08/10
Posts: 61
|
|
what is the command to show me a list of files marked for deletion ?
thanks
B 
--------------------
World A7.3, Cume13 - V5R4
|
lfirmat
member
Reged: 06/15/06
Last on: 06/04/10
Posts: 53
Loc: Buenos Aires, Argentina
|
|
DSPFD command. the best is to send this information to a file, make a littl e clp program that only reorganize files (RGZPFM command) when the number o f delete records greater than zero.=0AMore better is putting this little pr ocess in the as400 schedule and run it every month (or two)=0Abye and good luck=0ALuis=0AA73 cum 15=0A =0Ahttp://clalumadi.blogspot.com/=0A=0A=0A=0A =0A
|
jdickeymcc
member
Reged: 12/16/09
Last on: 07/23/10
Posts: 63
|
|
Are you talking about files, or are you talking about records? There is no way that I know of on the AS/400 to mark a file for deletion. So I am puzzled by your question. You may have to explain what you are trying t o do in more detail.
If you are trying to get rid of deleted records, to free up disk space, t hat would involve the RGZPFM command, which would tie in with your subjec t line of "Reorganization". There is no direct command available that wo uld show you files with deleted records in them. The way I would attack this is to do a DSPFD command to an output file. I would do DSPFD FILE l ibrary value/*ALL TYPE *MBRLIST OUTPUT *OUTFILE FILEATR *PF OUTFILE libra ry/file name OUTMBR (I leave this at the defaults). That generates a fil e with a record for each physical file member. Each record will have a r ecord count and a deleted record count. You would process this file, add ing logic to say skip if less than x deleted records or less than x% of t otal records. Or you could sort this file in descending order by deleted record count and see what files you want to reorganize and just manually reorganize those files (when not in use).
Hope this helps a bit.
John Dickey
McCarthy Building Companies
St. Louis, MO 63124
314-919-2264
JDickey@McCarthy.com
From: jdeworld-bounces@jdelist.com [mailto:jdeworld-bounces@jdelist.com] On Behalf Of bigfoot53
Sent: Sunday, February 07, 2010 4:09 PM
To: jdelistsubscribers@jdelist.com
Subject: Reorganization
what is the command to show me a list of files marked for deletion ?
thanks
B [cid:~WRD000.jpg]
World A7.3, Cume13 - V5R4
|
bigfoot53
member
Reged: 06/24/08
Last on: 03/08/10
Posts: 61
|
|
Thanks for the info, and Yes its records not files sorry for the confusion.
Thanks
Bruce
--------------------
World A7.3, Cume13 - V5R4
|
Jim_rubino
member
Reged: 09/09/01
Last on: 08/19/10
Posts: 367
Loc: Missouri
|
|
I wrote a simple CL program that will run a Taatool command (cvtmbrd -
convert member description) to an outfile. I run this over *USRLIBL for
all *DATA files that are *PF files. I then run a query over the file
producing a report showing the files, number records and number of
deleted records.
The CL will always submit the job to run in batch, running this on an
810 iSeries with 16G of memory running on V5R4M0 - it took 20 minutes to
complete.
It sorts by number of deleted records in descending order.
Below is a what the report looks like. I would be willing to share the
CL source with anyone who has the Taatool product, contact me off line -
jim.rubino@fike.com
02/09/10 13:30:14
PAGE 1
Current Number Of File Library TEXT
Number Of Deleted Text
Records Records 'Description'
1,292,389 13,188,833 F98002 ESECURITY Cross -
Reference File Information
21,090,261 4,024,590 F5631 ETESTDATA Sales
Order/Purchasing Segment Values
2,277,242 3,861,974 F98003 ESECURITY Cross - Program
Field Information
7,200,310 2,859,262 F3102 ETESTDATA Work Order
Variance
497,522 1,369,593 F98001 ESECURITY Cross -
Reference Relationships
851,297 1,086,682 F98HELP ESECURITY Help
Instructions Master File
117,879 262,183 F32921 ECFGTEST Cross Segment
Editing Rules - Values
494,355 250,426 VSURCHRG SHP4VAR25F Surcharge By
Zip Code Range
181,710 168,514 F9620 EDEVCMN Cursor
Sensitive Control Master
102,007 97,914 F56321 ECFGTEST Segment Print
Control File
359 87,199 F6001_MARN ECFGTEST Configuration
Pricing File
1,366 85,618 F6001 ECFGTEST Configuration
Pricing File
18,798 83,799 FCF16 ECFGTEST Generic Text
File
512,448 73,961 F0011 ETESTDATA Batch Control
Records
22,758 69,059 BNKPRO SHP4VAR25F Bank of Pro
Numbers
More...
Jim
|
|
0 registered and 0 anonymous users are browsing this forum.
Moderator: ekempter, Christian Audet, jdecnc, Sef
Print Thread
|
Forum Permissions
You cannot start new topics
You cannot reply to topics
HTML is disabled
UBBCode is enabled
|
Rating:
Thread views: 374
|
|
|
|
|
|
|
Previous
Index
Next
Threaded
Reorganization
Edit
Reply
Quote
[Re: 