Page 1 of 1
Report on sizes of RT_LOG files/tables
Posted: Tue Sep 05, 2006 1:18 pm
by gsherry1
Hello Forum,
Is there a way a quick query to produce a report containing the size of all the RT_CONFIG tables/files?
I understand that auto purge options only take affect during import, unless manually set on job or with script.
Thanks in advance.
- Greg
Posted: Tue Sep 05, 2006 3:15 pm
by kcbland
Not really. There's row counts and then there's file sizes. I think you're probably more interested in filesize. The easiest way is to peep the project folder and use a shell script to get the file size listings. The issue is the correlation to the job name via the job number. There's no supported method for doing this, so probably a listing of DS_JOBS will help. Maybe a Batch job to do a TCL SELECT of the DS_JOBS file, then a looping call to DSExecute with a ls -l on each RT_LOGnnn file? If you're adventurous, you can just get all the sizes with one command and then correlate in reverse from the RT_LOGnnn number to the jobname in an array built from looking at DS_JOBS.
Warning: Obscure and Arcane Knowledge!
Posted: Tue Sep 05, 2006 4:36 pm
by ray.wurlod
Two steps.
Code: Select all
ACCOUNT.FILE.STATS ALL LOCAL
SELECT FILENAME.LONG, FILESIZE FROM STAT.FILE WHERE FILENAME.LONG LIKE 'RT_CONFIG%';
Substitute RT_LOG for RT_CONFIG depending on which answer you want.
to get a listing of other information (column names from the STAT.FILE table) that is available.