06-27-2006
How to refine results of grep -p
I need help to further reduce the output shown below. I want to be able to only return the paragraph where the 'Database alias' is exactly equal to DBIHP. I do not want the other paragraphs being shown below.
[diimps1@aixudbtest1 /home/dbadvlp]$ echo $dbalias
DBIHP
[diimps1@aixudbtest1 /home/dbadvlp]$ db2 list db directory|grep -p 'Database alias = '$dbalias
Database alias = DBIHPP1
Database name = DBIHPP1
Local database directory = /db2udb/diimps1/dbihpp1/dbpath
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database alias = DBIHPS1
Database name = DBIHPS1
Local database directory = /db2udb/diimps1/dbihps1/dbpath
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database alias = DBIHP
Database name = DBIHP
Local database directory = /db2udb/diimps1/dbihp/dbpath
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database alias = DBIHPC1
Database name = DBIHPC1
Local database directory = /db2udb/diimps1/dbihpc1/dbpath
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
ls -ltr | grep string
How can I use regular expressions to filter the results provided even more. I am using the above command as a reference. (1 Reply)
Discussion started by: ckandreou
1 Replies
2. UNIX for Dummies Questions & Answers
Hi
I need to search for matching strings in a database and I want to print out all files that matches in "detail", which means that I want the output to contain datum of last saving. I only get the grep function tp print the actual file names which is not enough since the database is to large... (14 Replies)
Discussion started by: slire
14 Replies
3. UNIX for Dummies Questions & Answers
On our one HP-UX 11i box, we have some very long paths defined. When I want to check on our user processes running, the resulting paths are chopped off. /xyz/abc/123/......./server/b is really a process running in the ..../server/bin directory. Is this a terminal problem or buffer length... (1 Reply)
Discussion started by: bsp18974
1 Replies
4. Shell Programming and Scripting
Hi
The commnad shows the following o/p
df -kh /abc/bds/ |awk {'print$5'}
capacity
87%
I want the o/p as 87 only
Can we achieve this using a oneliner of sorts
NB : Code tags not working with my google chrome , So wasn't able to place code in tags . Pls dont penalise :-)
Thanks (6 Replies)
Discussion started by: ultimatix
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am currently reading a tar file and searching for a particular word using grep e.g. Plane. At the moment, if a sentence is found with the word "Plane" the sentence itself is piped to another file.
Here is the code i am using;
for jar in 'cat jar_file.tar'; do
tar -tvf... (3 Replies)
Discussion started by: crunchie
3 Replies
6. Shell Programming and Scripting
Hello guys,
I have been looking around but can't find the answer to my problem:
If the grep command displays no results, print "no results have been found" and increment x. But if the grep command find something, do nothing.
if
echo "no results have been found $x"
x=`expr $x + 1 `... (3 Replies)
Discussion started by: Benou
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
Am running the command below to search for files that contains a certain string.
grep -il "shutdown" `find . -type f -mtime -1 -print` | grep "^./scripts/active"
How do I get it to do a ls -l on the list of files? I tried doing ls -l `grep -il "shutdown" `find . -type f -mtime -1... (5 Replies)
Discussion started by: newbie_01
5 Replies
8. Shell Programming and Scripting
Hi all,
I'm working with a peice of software that runs on Linux that allows planning trips in cars through maps. This software has different variations depending on the type of car, e.g. BMW, Audi, Hyundai, etc... Each variation has a dependency on common external components that are not... (1 Reply)
Discussion started by: emoshaya
1 Replies
9. Shell Programming and Scripting
hi,
let's say we have input in files test1.txt, test2.txt, text3.txt ... ... ... ('...' means more files & lines not just 'dots')
test1.txt has:
A
B
C
D
...
...
...
test2.txt has
A
B
C
D
...
...
... (4 Replies)
Discussion started by: msonoth
4 Replies
10. Shell Programming and Scripting
Hi,
i have a file hello.log which as several line that look like the below
2015-12-07 09:46:56 0:339 120.111.12.12 POST /helloWorld
2015-12-07 09:46:57 0:439 122.111.12.12 POST /helloWorld
....
when i grep expecting to see results like the below.
... (6 Replies)
Discussion started by: mohtashims
6 Replies
LEARN ABOUT CENTOS
basic_db_auth
BASIC_DB_AUTH(1) User Contributed Perl Documentation BASIC_DB_AUTH(1)
NAME
basic_db_auth - Database auth helper for Squid
SYNOPSIS
basic_db_auth [options]
DESCRIPTOIN
This program verifies username & password to a database
--dsn Database DSN. Default "DBI:mysql:database=squid"
--user Database User
--password
Database password
--table Database table. Default "passwd".
--usercol
Username column. Default "user".
--passwdcol
Password column. Default "password".
--cond Condition, defaults to enabled=1. Specify 1 or "" for no condition If you use --joomla flag, this condition will be changed to
block=0
--plaintext
Database contains plain-text passwords
--md5 Database contains unsalted md5 passwords
--salt Selects the correct salt to evaluate passwords
--persist
Keep a persistent database connection open between queries.
--joomla
Tells helper that user database is Joomla DB. So their unusual salt hashing is understood.
COPYRIGHT
Copyright (C) 2007 Henrik Nordstrom <henrik@henriknordstrom.net> Copyright (C) 2010 Luis Daniel Lucio Quiroz <dlucio@okay.com.mx> (Joomla
support) This program is free software. You may redistribute copies of it under the terms of the GNU General Public License version 2, or
(at youropinion) any later version.
perl v5.16.3 2014-06-09 BASIC_DB_AUTH(1)