Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Grep string

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Grep string
# 1  
Old 04-09-2017
Grep string
Hi,

Need help to grep string, actually out of string in not complete while grep using -w its not able to capture



Code:
db2pd -db VATPROD -reorg 

Table Reorg Stats:
Address            TableName          Start               End                 PhaseStart          MaxPhase   Phase      CurCount   MaxCount   Status  Completion
0x00007F61A25C0B80 ALERT              04/08/2017 13:14:53 04/08/2017 13:14:53 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A25C5F80 ALERT_PROPERTIES   04/08/2017 13:15:15 04/08/2017 13:15:15 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A2E2F580 HMON_ATM_INFO      04/09/2017 22:32:31 04/09/2017 22:32:31 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A2480B80 APPCONNECTIONS     04/08/2017 12:41:15 04/08/2017 12:41:15 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A2481880 TBSPACE_UTILIZATIO 04/09/2017 22:32:31 04/09/2017 22:32:31 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A2483280 TBSPACE_CONT_UTILI 04/09/2017 22:32:32 04/09/2017 22:32:32 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A267BD80 RECLAIM_STORAGE_IN 04/09/2017 22:32:31 04/09/2017 22:32:31 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A25DA280 SQL_DIM            04/09/2017 22:32:31 04/09/2017 22:32:32 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A46A1A80 LOCK_IDLETIME_STAT 04/08/2017 12:41:15 04/08/2017 12:41:15 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A2EB0D00 DB2LUW_MONINDEX    04/08/2017 12:41:15 04/08/2017 12:41:15 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A2EA0080 DB2LUW_MONTABLESPA 04/08/2017 12:41:15 04/08/2017 12:41:15 n/a                 n/a        n/a        0          0          Done    0
0x00007F61A25B4000 SQL_FACT           04/08/2017 12:41:15 04/08/2017 12:41:46 n/a                 n/a        n/a        0          0          Done    0


Full name of table is TBSPACE_CONT_UTILIZATION


Code:
db2pd -db VATPROD -reorg | grep -w TBSPACE_CONT_UTILIZATION

shows no results

I can only pass variable as full, how to get below row using above grep command

Code:
0x00007F61A2481880 TBSPACE_UTILIZATIO 04/09/2017 22:32:31 04/09/2017 22:32:31 n/a                 n/a        n/a        0          0          Done    0

Last edited by Scrutinizer; 04-10-2017 at 12:36 AM.. Reason: Code tags and spelling
# 2  
Old 04-10-2017
How about this:

Code:
db2pd -db VATPROD -reorg | grep -w "TBSPACE_CONT_UTIL.*"

or if you are trying to match both lines above how about:

Code:
db2pd -db VATPROD -reorg | grep -w "TBSPACE_.*UTIL.*" infile

# 3  
Old 04-10-2017
hi chubler,

thanks for reply

Actually i m passing the table name as variable in script

but the output of
Code:
db2pd -db VATPROD -reorg

only show part of table name

igiving full table name
Code:
grep -w TBSPACE_CONT_UTILIZATION

i want to grep only this row

Code:
0x00007F61A2481880 TBSPACE_UTILIZATIO 04/09/2017 22:32:31 04/09/2017 22:32:31 n/a                 n/a        n/a        0          0          Done    0

Last edited by Scrutinizer; 04-10-2017 at 12:50 AM..
# 4  
Old 04-10-2017
Alternatively with awk, try:
Code:
db2pd -db VATPROD -reorg | awk -v table=TBSPACE_CONT_UTILIZATION 'table~"^" $2'

--
To get TBSPACE_UTILIZATION, use table=TBSPACE_UTILIZATION instead..

--
On Solaris use /usr/xpg4/bin/awk



--
@Chubler_XL : I don't think -w serves a purpose here
Last edited by Scrutinizer; 04-10-2017 at 12:54 AM..
# 5  
Old 04-10-2017
I removed it.
Last edited by Aia; 04-10-2017 at 12:13 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grep a sub-string from a string stored in a variable.

For example: I am grepping "Hello" from a file and there are 10 matches. So all ten lines with match will get stored into a variable($match). Now I want to ignore those lines which have "Hi" present in that. Currently I tried this: match = grep "Hello" file | grep -v "Hi" file But that's not... (2 Replies)
Discussion started by: pavan
2 Replies

2. Shell Programming and Scripting

Grep a string and count following lines starting with another string

I have a large dataset with following structure; C 0001 Carbon D SAR001 methane D SAR002 ethane D SAR003 propane D SAR004 butane D SAR005 pentane C 0002 Hydrogen C 0003 Nitrogen C 0004 Oxygen D SAR011 ozone D SAR012 super oxide C 0005 Sulphur D SAR013... (3 Replies)
Discussion started by: Syeda Sumayya
3 Replies

3. Shell Programming and Scripting

Grep exact string from main string

Hi , am getting output file, it sontains the below values. ./hawk_DOM1_FIRST_ENV ./hawk_DOM2_SECOND_ENV ./hawk_DOM3_THIRD_ENV Now I need to grep the word "DOM1_FIRST_ENV","DOM2_SECOND_ENV" like that. I tired with cut -d "_". Its not working with any deleimiter. Can you please help to... (3 Replies)
Discussion started by: ckchelladurai
3 Replies

4. Shell Programming and Scripting

Grep string in files and list file names that contain the string

Hi, I have a list of zipped files. I want to grep for a string in all files and get a list of file names that contain the string. But without unzipping them before that, more like using something like gzcat. My OS is: SunOS test 5.10 Generic_142900-13 sun4u sparc SUNW,SPARC-Enterprise (8 Replies)
Discussion started by: apenkov
8 Replies

5. Shell Programming and Scripting

grep exact string from files and write to filename when string present in file

I am attempting to grep an exact string from a series of files within a directory and append that output to the filename when it is present in the file. I've been after this all day with no luck. Thanks for your help in advance :wall:. (4 Replies)
Discussion started by: JC_1
4 Replies

6. Shell Programming and Scripting

Grep a string from input file and delete next three lines including the line contains string in xml

Hi, 1_strings file contains $ cat 1_strings /home/$USER/Src /home/Valid /home/Review$ cat myxml <projected value="some string" path="/home/$USER/Src"> <input 1/> <estimate value/> <somestring/> </projected> <few more lines > <projected value="some string" path="/home/$USER/check">... (4 Replies)
Discussion started by: greet_sed
4 Replies

7. Shell Programming and Scripting

Grep a string and write a value to next line of found string

Hi, I have two variables x and y. i need to find a particular string in a file, a workflow name and then insert the values of x and y into the next lines of the workflow name. basically it is like as below wf_xxxxxx $$a= $$b= $$c= figo $$d=bentley i need to grep the 'wf_xxxx' and then... (6 Replies)
Discussion started by: angel12345
6 Replies

8. Shell Programming and Scripting

grep on string and printing line after until another string has been found

Hello Everyone, I just started scripting this week. I have no background in programming or scripting. I'm working on a script to grep for a variable in a log file Heres what the log file looks like. The x's are all random clutter xxxxxxxxxxxxxxxxxxxxx START: xxxxxxxxxxxx... (7 Replies)
Discussion started by: rxc23816
7 Replies

9. Shell Programming and Scripting

Grep for a string and then grep using a string from that result

Hello, Thanks in advance for the query. There is a log file abcd.log which has multible line like this. "hello1" , "hello2", "hello3" , "hello4" , "hello5" I want to grep for the lines which has "hello4" & "hello5" and use "hello2" to grep the same log file again. All these should... (8 Replies)
Discussion started by: kzenthil
8 Replies

10. UNIX for Dummies Questions & Answers

| help | unix | grep - Can I use grep to return a string with exactly n matches?

Hello, I looking to use grep to return a string with exactly n matches. I'm building off this: ls -aLl /bin | grep '^.\{9\}x' | tr -s ' ' -rwxr-xr-x 1 root root 632816 Nov 25 2008 vi -rwxr-xr-x 1 root root 632816 Nov 25 2008 view -rwxr-xr-x 1 root root 16008 May 25 2008... (7 Replies)
Discussion started by: MykC
7 Replies
Login or Register to Ask a Question