Script to get the weekly tablespace growth

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












We would get every week db tablespace report, I just want to know how to
generate report after comparing last week and this week .



Please find the below sample files.



Last week report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36419005 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5632000 1980928 73.96
 4 TSI03 DMS 4096 0x0000 5 5999664 5607680 389888 93.46
 5 TSD02 DMS 4096 0x0000 3 2266080 2155264 109568 95.10
 6 TSI02 DMS 4096 0x0000 3 2555904 2396928 158592 93.78
 7 TS08 DMS 4096 0x0000 6 44703680 37979328 6724160 84.95
 8 TS10 DMS 4096 0x0000 1 3248576 1375872 1872672 42.35
 9 TSD04 DMS 4096 0x0000 4 163840 151738 12094 92.61
 10 TSI04 DMS 4096 0x0000 2 67584 28960 38620 42.85
 11 TSD05 DMS 4096 0x0000 3 1572864 1448960 123136 92.12
 12 TSI05 DMS 4096 0x0000 3 1310720 963328 346624 73.49


This week's report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47


Desired report (headings only):



Tab Page Num Total Used Free Last_weekPercent New_week Percent Difference (or) Growth
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used Used



shell awk scripting




share|improve this question





















  • What approach have you tried already? Have you thought about diff?
    – simlev
    Apr 18 at 10:58










  • It looks like you want to generate a report, not just check the two for differences. I recommend you add proof of your efforts so far and pinpoint exactly where you got stuck. You'll find many forum users willing to help you grasp the usage of a certain awk feature, but you shoudn't be asking for someone else to do your job entirely. Also, I suggest you complete the desired output, so others have something to check against (and you don't send the wrong message, like "I'm so lazy to do my own report, I won't even calculate it once".
    – simlev
    Apr 18 at 13:35











  • I am very new to LInux, This is almost my first task to work in linux, Thanks for your reply,
    – Ramesh J
    Apr 19 at 12:53














up vote
0
down vote

favorite












We would get every week db tablespace report, I just want to know how to
generate report after comparing last week and this week .



Please find the below sample files.



Last week report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36419005 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5632000 1980928 73.96
 4 TSI03 DMS 4096 0x0000 5 5999664 5607680 389888 93.46
 5 TSD02 DMS 4096 0x0000 3 2266080 2155264 109568 95.10
 6 TSI02 DMS 4096 0x0000 3 2555904 2396928 158592 93.78
 7 TS08 DMS 4096 0x0000 6 44703680 37979328 6724160 84.95
 8 TS10 DMS 4096 0x0000 1 3248576 1375872 1872672 42.35
 9 TSD04 DMS 4096 0x0000 4 163840 151738 12094 92.61
 10 TSI04 DMS 4096 0x0000 2 67584 28960 38620 42.85
 11 TSD05 DMS 4096 0x0000 3 1572864 1448960 123136 92.12
 12 TSI05 DMS 4096 0x0000 3 1310720 963328 346624 73.49


This week's report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47


Desired report (headings only):



Tab Page Num Total Used Free Last_weekPercent New_week Percent Difference (or) Growth
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used Used



shell awk scripting




share|improve this question





















  • What approach have you tried already? Have you thought about diff?
    – simlev
    Apr 18 at 10:58










  • It looks like you want to generate a report, not just check the two for differences. I recommend you add proof of your efforts so far and pinpoint exactly where you got stuck. You'll find many forum users willing to help you grasp the usage of a certain awk feature, but you shoudn't be asking for someone else to do your job entirely. Also, I suggest you complete the desired output, so others have something to check against (and you don't send the wrong message, like "I'm so lazy to do my own report, I won't even calculate it once".
    – simlev
    Apr 18 at 13:35











  • I am very new to LInux, This is almost my first task to work in linux, Thanks for your reply,
    – Ramesh J
    Apr 19 at 12:53












up vote
0
down vote

favorite









up vote
0
down vote

favorite











We would get every week db tablespace report, I just want to know how to
generate report after comparing last week and this week .



Please find the below sample files.



Last week report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36419005 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5632000 1980928 73.96
 4 TSI03 DMS 4096 0x0000 5 5999664 5607680 389888 93.46
 5 TSD02 DMS 4096 0x0000 3 2266080 2155264 109568 95.10
 6 TSI02 DMS 4096 0x0000 3 2555904 2396928 158592 93.78
 7 TS08 DMS 4096 0x0000 6 44703680 37979328 6724160 84.95
 8 TS10 DMS 4096 0x0000 1 3248576 1375872 1872672 42.35
 9 TSD04 DMS 4096 0x0000 4 163840 151738 12094 92.61
 10 TSI04 DMS 4096 0x0000 2 67584 28960 38620 42.85
 11 TSD05 DMS 4096 0x0000 3 1572864 1448960 123136 92.12
 12 TSI05 DMS 4096 0x0000 3 1310720 963328 346624 73.49


This week's report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47


Desired report (headings only):



Tab Page Num Total Used Free Last_weekPercent New_week Percent Difference (or) Growth
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used Used



shell awk scripting




share|improve this question













We would get every week db tablespace report, I just want to know how to
generate report after comparing last week and this week .



Please find the below sample files.



Last week report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36419005 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5632000 1980928 73.96
 4 TSI03 DMS 4096 0x0000 5 5999664 5607680 389888 93.46
 5 TSD02 DMS 4096 0x0000 3 2266080 2155264 109568 95.10
 6 TSI02 DMS 4096 0x0000 3 2555904 2396928 158592 93.78
 7 TS08 DMS 4096 0x0000 6 44703680 37979328 6724160 84.95
 8 TS10 DMS 4096 0x0000 1 3248576 1375872 1872672 42.35
 9 TSD04 DMS 4096 0x0000 4 163840 151738 12094 92.61
 10 TSI04 DMS 4096 0x0000 2 67584 28960 38620 42.85
 11 TSD05 DMS 4096 0x0000 3 1572864 1448960 123136 92.12
 12 TSI05 DMS 4096 0x0000 3 1310720 963328 346624 73.49


This week's report:



Tab Page Num Total Used Free Percent
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used
--- --------------- ---- ----- -------- ---- ------- --------- --------- -------
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - -
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - -
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - -
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47


Desired report (headings only):



Tab Page Num Total Used Free Last_weekPercent New_week Percent Difference (or) Growth
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used Used




shell awk scripting





share|improve this question












share|improve this question




share|improve this question








edited Apr 18 at 11:35









simlev

47019




47019









asked Apr 18 at 10:28









Ramesh J

1




1











  • What approach have you tried already? Have you thought about diff?
    – simlev
    Apr 18 at 10:58










  • It looks like you want to generate a report, not just check the two for differences. I recommend you add proof of your efforts so far and pinpoint exactly where you got stuck. You'll find many forum users willing to help you grasp the usage of a certain awk feature, but you shoudn't be asking for someone else to do your job entirely. Also, I suggest you complete the desired output, so others have something to check against (and you don't send the wrong message, like "I'm so lazy to do my own report, I won't even calculate it once".
    – simlev
    Apr 18 at 13:35











  • I am very new to LInux, This is almost my first task to work in linux, Thanks for your reply,
    – Ramesh J
    Apr 19 at 12:53
















  • What approach have you tried already? Have you thought about diff?
    – simlev
    Apr 18 at 10:58










  • It looks like you want to generate a report, not just check the two for differences. I recommend you add proof of your efforts so far and pinpoint exactly where you got stuck. You'll find many forum users willing to help you grasp the usage of a certain awk feature, but you shoudn't be asking for someone else to do your job entirely. Also, I suggest you complete the desired output, so others have something to check against (and you don't send the wrong message, like "I'm so lazy to do my own report, I won't even calculate it once".
    – simlev
    Apr 18 at 13:35











  • I am very new to LInux, This is almost my first task to work in linux, Thanks for your reply,
    – Ramesh J
    Apr 19 at 12:53















What approach have you tried already? Have you thought about diff?
– simlev
Apr 18 at 10:58




What approach have you tried already? Have you thought about diff?
– simlev
Apr 18 at 10:58












It looks like you want to generate a report, not just check the two for differences. I recommend you add proof of your efforts so far and pinpoint exactly where you got stuck. You'll find many forum users willing to help you grasp the usage of a certain awk feature, but you shoudn't be asking for someone else to do your job entirely. Also, I suggest you complete the desired output, so others have something to check against (and you don't send the wrong message, like "I'm so lazy to do my own report, I won't even calculate it once".
– simlev
Apr 18 at 13:35





It looks like you want to generate a report, not just check the two for differences. I recommend you add proof of your efforts so far and pinpoint exactly where you got stuck. You'll find many forum users willing to help you grasp the usage of a certain awk feature, but you shoudn't be asking for someone else to do your job entirely. Also, I suggest you complete the desired output, so others have something to check against (and you don't send the wrong message, like "I'm so lazy to do my own report, I won't even calculate it once".
– simlev
Apr 18 at 13:35













I am very new to LInux, This is almost my first task to work in linux, Thanks for your reply,
– Ramesh J
Apr 19 at 12:53




I am very new to LInux, This is almost my first task to work in linux, Thanks for your reply,
– Ramesh J
Apr 19 at 12:53










1 Answer
1






active

oldest

votes

















up vote
0
down vote













Quick solution:



perl -lane '1..eof?$p[$F[0]]=$F[9]:print$_,sprintf("%8s%8.2f",$p[$F[0]],$F[9]-$p[$F[0]])' this_weeks_report last_weeks_report


Output:



Tab Page Num Total Used Free Percent - 0.00
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used - 0.00
--- --------------- ---- ----- -------- ---- ------- --------- --------- ------- - 0.00
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - - - 0.00
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - - - 0.00
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - - - 0.00
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80 73.96 -0.16
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21 93.46 -0.25
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91 95.10 -0.19
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64 93.78 -0.14
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73 84.95 -0.22
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08 42.35 -0.27
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38 92.61 -0.23
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74 42.85 -0.11
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10 92.12 -0.02
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47 73.49 -0.02


Comments:



This does not handle the headings. To do that, you'd better expand the one-liner into a full fledged script, where you can more easily fine-tune the output and add further functionality to suit your needs.






share|improve this answer





















  • @RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
    – simlev
    Apr 19 at 13:08











Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);








 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f438472%2fscript-to-get-the-weekly-tablespace-growth%23new-answer', 'question_page');

);

Post as a guest

















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
0
down vote













Quick solution:



perl -lane '1..eof?$p[$F[0]]=$F[9]:print$_,sprintf("%8s%8.2f",$p[$F[0]],$F[9]-$p[$F[0]])' this_weeks_report last_weeks_report


Output:



Tab Page Num Total Used Free Percent - 0.00
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used - 0.00
--- --------------- ---- ----- -------- ---- ------- --------- --------- ------- - 0.00
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - - - 0.00
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - - - 0.00
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - - - 0.00
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80 73.96 -0.16
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21 93.46 -0.25
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91 95.10 -0.19
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64 93.78 -0.14
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73 84.95 -0.22
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08 42.35 -0.27
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38 92.61 -0.23
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74 42.85 -0.11
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10 92.12 -0.02
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47 73.49 -0.02


Comments:



This does not handle the headings. To do that, you'd better expand the one-liner into a full fledged script, where you can more easily fine-tune the output and add further functionality to suit your needs.






share|improve this answer





















  • @RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
    – simlev
    Apr 19 at 13:08















up vote
0
down vote













Quick solution:



perl -lane '1..eof?$p[$F[0]]=$F[9]:print$_,sprintf("%8s%8.2f",$p[$F[0]],$F[9]-$p[$F[0]])' this_weeks_report last_weeks_report


Output:



Tab Page Num Total Used Free Percent - 0.00
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used - 0.00
--- --------------- ---- ----- -------- ---- ------- --------- --------- ------- - 0.00
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - - - 0.00
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - - - 0.00
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - - - 0.00
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80 73.96 -0.16
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21 93.46 -0.25
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91 95.10 -0.19
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64 93.78 -0.14
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73 84.95 -0.22
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08 42.35 -0.27
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38 92.61 -0.23
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74 42.85 -0.11
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10 92.12 -0.02
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47 73.49 -0.02


Comments:



This does not handle the headings. To do that, you'd better expand the one-liner into a full fledged script, where you can more easily fine-tune the output and add further functionality to suit your needs.






share|improve this answer





















  • @RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
    – simlev
    Apr 19 at 13:08













up vote
0
down vote










up vote
0
down vote









Quick solution:



perl -lane '1..eof?$p[$F[0]]=$F[9]:print$_,sprintf("%8s%8.2f",$p[$F[0]],$F[9]-$p[$F[0]])' this_weeks_report last_weeks_report


Output:



Tab Page Num Total Used Free Percent - 0.00
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used - 0.00
--- --------------- ---- ----- -------- ---- ------- --------- --------- ------- - 0.00
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - - - 0.00
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - - - 0.00
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - - - 0.00
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80 73.96 -0.16
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21 93.46 -0.25
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91 95.10 -0.19
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64 93.78 -0.14
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73 84.95 -0.22
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08 42.35 -0.27
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38 92.61 -0.23
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74 42.85 -0.11
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10 92.12 -0.02
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47 73.49 -0.02


Comments:



This does not handle the headings. To do that, you'd better expand the one-liner into a full fledged script, where you can more easily fine-tune the output and add further functionality to suit your needs.






share|improve this answer













Quick solution:



perl -lane '1..eof?$p[$F[0]]=$F[9]:print$_,sprintf("%8s%8.2f",$p[$F[0]],$F[9]-$p[$F[0]])' this_weeks_report last_weeks_report


Output:



Tab Page Num Total Used Free Percent - 0.00
 Id TableSpace Name Type Size State Cont Pages Pages Pages Used - 0.00
--- --------------- ---- ----- -------- ---- ------- --------- --------- ------- - 0.00
 0 SYSCATSPACE SMS 4096 0x0000 1 96511 - - - - 0.00
 1 SYSTOOLSPACE SMS 4096 0x0000 1 257 - - - - 0.00
 2 USERSPACE1 SMS 4096 0x0000 8 36342895 - - - - 0.00
 3 TSD03 DMS 4096 0x0000 6 7614640 5620224 1992704 73.80 73.96 -0.16
 4 TSI03 DMS 4096 0x0000 5 5999664 5592320 405248 93.21 93.46 -0.25
 5 TSD02 DMS 4096 0x0000 3 2266080 2150912 113920 94.91 95.10 -0.19
 6 TSI02 DMS 4096 0x0000 3 2555904 2393472 162048 93.64 93.78 -0.14
 7 TS08 DMS 4096 0x0000 6 44703680 37881632 6821856 84.73 84.95 -0.22
 8 TS10 DMS 4096 0x0000 1 3248576 1367008 1881536 42.08 42.35 -0.27
 9 TSD04 DMS 4096 0x0000 4 163840 151362 12470 92.38 92.61 -0.23
 10 TSI04 DMS 4096 0x0000 2 67584 28886 38694 42.74 42.85 -0.11
 11 TSD05 DMS 4096 0x0000 3 1572864 1448704 123392 92.10 92.12 -0.02
 12 TSI05 DMS 4096 0x0000 3 1310720 963072 346880 73.47 73.49 -0.02


Comments:



This does not handle the headings. To do that, you'd better expand the one-liner into a full fledged script, where you can more easily fine-tune the output and add further functionality to suit your needs.







share|improve this answer













share|improve this answer



share|improve this answer











answered Apr 18 at 13:37









simlev

47019




47019











  • @RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
    – simlev
    Apr 19 at 13:08

















  • @RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
    – simlev
    Apr 19 at 13:08
















@RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
– simlev
Apr 19 at 13:08





@RameshJ Please remember to accept the answer if it satisfies you. You do that by clicking on the check mark next to it.
– simlev
Apr 19 at 13:08













 

draft saved


draft discarded


























 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f438472%2fscript-to-get-the-weekly-tablespace-growth%23new-answer', 'question_page');

);

Post as a guest
































































-

Popular posts from this blog

How to check contact read email or not when send email to Individual?

Image
Clash Royale CLAN TAG #URR8PPP up vote 1 down vote favorite I'm using WordPress 4.9.8, CiviCRM to 5.5.1, I usually send email to contact by Search> Find contacts View contact details Action> Send email Send email ok, Contact received mail ok like picture But status only Email sent though contact read email or not. So, can CiviCRM can change status to Email read when contact read email? wordpress email share | improve this question asked Sep 26 at 0:12 ToanLuong 49 9 add a comment  |  up vote 1 down vote favorite I'm using WordPress 4.9.8, CiviCRM to 5.5.1, I usually send email to contact by Search> Find contacts View contact details Action> Send email Send email ok, Contact received mail ok like picture But status only Email sent though contact read email or not. So, can CiviCRM can change status to Email read when contact read email? wordpress email share | improve this question asked Se
Read more

Bahrain

Image
For other uses, see Bahrain (disambiguation). Sovereign island state in the Persian Gulf Kingdom of Bahrain مملكة البحرين   (Arabic) Mamlakat al-Baḥrayn Flag Coat of arms Anthem:  نشيد البحرين الوطني Bahrainona Our Bahrain Location of   Bahrain    (circled in red) Capital and largest city Manama 26°13′N 50°35′E  /  26.217°N 50.583°E  / 26.217; 50.583 Official languages Arabic Ethnic groups (2010 [1] ) 50.7% Arab (46% Bahrani, 4.7% other Arabs) 45.5% Asian 1% European 1.2% Others Religion Islam Demonym(s) Bahraini Government Unitary constitutional monarchy • King Hamad bin Isa Al Khalifa • Crown Prince Salman bin Hamad bin Isa Al Khalifa • Prime Minister Khalifa bin Salman Al Khalifa Legislature National Assembly • Upper house Consultative Council • Lower house Council of Representatives Independence • Declared Independence [2] 14 August 1971 • from United Kingdom [1] 15 August 1971 • Admitted to the United Nations 21 September 1971 • Kingdom of Bahrain 14 February 2002
Read more

Postfix configuration issue with fips on centos 7; mailgun relay

Image
Clash Royale CLAN TAG #URR8PPP up vote 0 down vote favorite I am trying to setup postfix to relay all mail generated on the local machine via SMTP to a mailgun relay. I have used the mailgun relay before with success on an ubuntu server, but I am migrating to a Centos 7 server which I will be running in FIPS mode. There error log is below, slightly sanitized. I have a small enough network that I choose to have each machine reach out to mailgun individually (this the loopback-only, 127.0.0.0/8 restrictions) and no firewall open port allowing smtp in to the machine. I assume the FIPS mode (and with it disabling of MD5) is causing problems, but I don't know how to overcome it or if it is even possible for tls_fprint to use some supported hash such as sha256 or sha512. However, the relay=none is slightly concerning since I have relayhost set, but perhaps that is because the smtp process is failing? Any help would be appreciated! postconf -n: alias_database = hash:/etc/alia
Read more