Script to reformat output Post: 302660217

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Script to reformat output Post 302660217 by systemoper on Friday 22nd of June 2012 08:33:42 AM

06-22-2012

Registered User

Script to reformat output

Hi colleagues,

I have the followind script.

Code:

db2 -x "select substr(TBSPACE,1,20) TABLESPACE from syscat.tables where tabschema = 'SCHEMA' and tabname like '%XXXX' group by TBSPACE order by TBSPACE" | awk '{print $1}' | while read tablespace
do
  db2 "list tablespaces show detail" |grep -p -w $tablespace |egrep "Name|Total pages|Free pages|Page size" |awk '{print $1 " " $2 "  " $3 "  " $4 "  " $5}' | while read a b c d e
  do
  done
done

The output of this script is this.

Code:

 Name                                 = TSADOR
 Total pages                          = 14991360
 Free pages                           = 5345152
 Page size (bytes)                    = 32768
 Name                                 = TSHISTNEW
 Total pages                          = 4186112
 Free pages                           = 1276544
 Page size (bytes)                    = 32768
  Name                                 = TSHISTTI
 Total pages                          = 6279168
 Free pages                           = 1991168
 Page size (bytes)                    = 32768

The desired output is this, please:

Code:

Tableaspace             Total Pages      Free Pages    Page Zise
TSADOR               14991360       5345152       32768
TSHISTNEW         4186112         1276544       32768
TSHISTTI              6279168          1991168       32768
     T O T A L      -------------       ------------ 
                             25456640          8612864

Thank you very match for you help.

Last edited by joeyg; 06-22-2012 at 09:59 AM.. Reason: Please wrap data and sripts with CodeTags

systemoper

View Public Profile for systemoper

Find all posts by systemoper

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

reformat the output from "diff" command

Hi all, I use the diff command and got the output: $> diff -e file1.txt file2.txt 15a 000675695 Yi Chen Chen 200520 EASY 50 2/28/05 0:00 SCAD Debit Card Charge . 12a 000731176 Sarah Anderson 200520 EASY 25 2/28/05 0:00 SCAD Debit Card Charge . 11a...

2. UNIX for Advanced & Expert Users

reformat ps output

I often use "ps -ef" command to list all running processes. Now i want to customize the output to show only 2 parts: CMD and UID as below: /bin/bash /usr/bin/run-parts /etc/cron.weekly root /usr/sbin/httpd apache /usr/sbin/httpd apache /usr/sbin/httpd apache I use ps -ef | awk '{print $8"...

3. Shell Programming and Scripting

reformat data with a shell script

Can anyone help me with a shell script that can do the following: I have a data in fasta format (first line is the header, followed by a sequence of characters). >ALLLY GGCCCCTCGAGCCTCGAACCGGAACCTCCAAATCCGAGACGCTCTGCTTATGAGGACCTC GAAATATGCCGGCCAGTGAAAAAATCTTGTGGCTTTGAGGGCTTTTGGTTGGCCAGGGGC...

4. Shell Programming and Scripting

Shell Script to Reformat a flat file

Hi , I have a text file noname.txt containing 1000+ records like this. One of the record I have given below. Input will b e like this BOT: 2010/06/01 00:25:59 21 = "private" Access-Method = 31 NCC = GBR 01 = "340806@osiris.fr.ft" 04 =...

5. Shell Programming and Scripting

need awk or sed help to reformat output

We have the following output: server1_J00_data_20120711122243 server1_J00_igs_20120711122243 server1_J00_j2ee_20120711122243 server1_J00_sec_20120711122243 server1_J00_data_20120711131819 server1_J00_igs_20120711131819 server1_J00_j2ee_20120711131819 server2_J00_data_20120711122245...

6. Shell Programming and Scripting

Use search pattern to reformat the output

I have below file listing ] ls -1 *.txt MISTradesReport_141105_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt MISTradesReport_141106_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt MISTradesReport_141107_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-24.txt...

7. Shell Programming and Scripting

Using awk to reformat file output

Hi there. I need to reformat a large file. Here is a sample of the file. NETIK0102_UCS_Boot_a,NETIK0102_UCS_Boot_b 5200 2438 70G 5200 2439 70G NETIK0102_UCS_HBA0_a,NETIK0102_UCS_HBA1_b,NETIK0102_UCS_HBA2_a,NETIK0102_UCS_HBA3_b 2673 19D7 55G 2673 19C0 30G 2673 19F5 120G...

8. Shell Programming and Scripting

Alter awk script to reformat output

Data: 0,mfrh_green_screen,1455432969,37540,/prod/test/system/sys/unikixmain.log,3.0M,mfrh_green_screen,3120660,0,36964--37540 0,mfrh_green_screen,1455433269,38100,/prod/test/system/sys/unikixmain.log,3.1M,mfrh_green_screen,3164223,0,37540--38100...

9. Shell Programming and Scripting

Reformat awk output

I need to rearrange the output but i am unable to arrange it to match the format. In the output i need NAME=\"To in the column . Bash: #!/bin/bash cd /cygdrive/c/output/a cat *.txt > output.txt i=/cygdrive/c/output/a/output.csv #echo "NE_Name, Source, Destination, OSPF_AREA_ID"...

10. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14...

LEARN ABOUT LINUX

drop_tablespace

DROP 
TABLESPACE(7)						   SQL Commands 						DROP TABLESPACE(7)

NAME

       DROP TABLESPACE - remove a tablespace

SYNOPSIS

       DROP TABLESPACE [ IF EXISTS ] tablespacename

DESCRIPTION

       DROP TABLESPACE removes a tablespace from the system.

       A  tablespace  can  only  be  dropped  by  its owner or a superuser.  The tablespace must be empty of all database objects before it can be
       dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are
       using  the  tablespace. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to
       temporary files residing in the tablespace.

PARAMETERS

       IF EXISTS
	      Do not throw an error if the tablespace does not exist. A notice is issued in this case.

       tablespacename
	      The name of a tablespace.

NOTES

       DROP TABLESPACE cannot be executed inside a transaction block.

EXAMPLES

       To remove tablespace mystuff from the system:

       DROP TABLESPACE mystuff;

COMPATIBILITY

       DROP TABLESPACE is a PostgreSQL extension.

SEE ALSO

       CREATE TABLESPACE [create_tablespace(7)], ALTER TABLESPACE [alter_tablespace(7)]

SQL - Language Statements					    2010-05-14							DROP TABLESPACE(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

reformat the output from "diff" command

Discussion started by: CamTu

2. UNIX for Advanced & Expert Users

reformat ps output

Discussion started by: fongthai

3. Shell Programming and Scripting

reformat data with a shell script

Discussion started by: manishabh

4. Shell Programming and Scripting

Shell Script to Reformat a flat file

Discussion started by: smalya

5. Shell Programming and Scripting

need awk or sed help to reformat output

Discussion started by: ux4me

6. Shell Programming and Scripting

Use search pattern to reformat the output

Discussion started by: krg.sati

7. Shell Programming and Scripting

Using awk to reformat file output

Discussion started by: kieranfoley

8. Shell Programming and Scripting

Alter awk script to reformat output

Discussion started by: SkySmart

9. Shell Programming and Scripting

Reformat awk output

Discussion started by: adgjmpt

10. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

Discussion started by: cmccabe

LEARN ABOUT LINUX

drop_tablespace