Script to get the weekly tablespace growth
Clash 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
edited Apr 18 at 11:35
simlev
47019
asked Apr 18 at 10:28
Ramesh J
1
add a comment |Â
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
edited Apr 18 at 11:35
simlev
47019
asked Apr 18 at 10:28
Ramesh J
1
What approach have you tried already? Have you thought aboutdiff?
– 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 certainawkfeature, 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
add a comment |Â
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
edited Apr 18 at 11:35
simlev
47019
asked Apr 18 at 10:28
Ramesh J
1
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
edited Apr 18 at 11:35
simlev
47019
asked Apr 18 at 10:28
Ramesh J
1
edited Apr 18 at 11:35
simlev
47019
edited Apr 18 at 11:35
simlev
47019
edited Apr 18 at 11:35
simlev
47019
47019
asked Apr 18 at 10:28
Ramesh J
1
asked Apr 18 at 10:28
Ramesh J
1
asked Apr 18 at 10:28
Ramesh J
1
1
What approach have you tried already? Have you thought aboutdiff?
– 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 certainawkfeature, 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
add a comment |Â
What approach have you tried already? Have you thought aboutdiff?
– 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 certainawkfeature, 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
add a comment |Â
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.
answered Apr 18 at 13:37
simlev
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
add a comment |Â
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.
answered Apr 18 at 13:37
simlev
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
add a comment |Â
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.
answered Apr 18 at 13:37
simlev
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
add a comment |Â
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.
answered Apr 18 at 13:37
simlev
47019
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.
answered Apr 18 at 13:37
simlev
47019
answered Apr 18 at 13:37
simlev
47019
answered Apr 18 at 13:37
simlev
47019
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
add a comment |Â
@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
add a comment |Â
Â
draft saved
draft discarded
Â
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
awkfeature, 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