[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Missing functionality

From: Crissy, Frank
Subject: Missing functionality
Date: Mon, 29 Mar 2010 16:05:28 -0500

In AIX when I want to ignore case and search for a word AND I want the 
paragraph that the word is in I can issue the following command

Db2 list tablespace show detail | grep -ip dat4k001

And I get

cpaidi6h: /opt/hd/db/db2/instance/pprdi100/prdi26
> db2 list tablespaces show detail | grep -ip dat4k001
 Tablespace ID                        = 151
 Name                                 = DAT4K001
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
 Total pages                          = 5000
 Useable pages                        = 4960
 Used pages                           = 160
 Free pages                           = 4800
 High water mark (pages)              = 160
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 32
 Number of containers                 = 1
 Minimum recovery time                = 2009-09-10-

If it try the same idea in Linux

address@hidden : /opt/hd/db/db2/instance/addc92/apply
> db2 list tablespaces | grep -ip idx8k003
grep: invalid option -- p
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
address@hidden : /opt/hd/db/db2/instance/addc92/apply

How about an equivalent function in Linux like AIX.



Nick Crissy
(Frank N. Crissy)
Lead DBA


The information in this Internet Email is confidential and may be legally 
privileged. It is intended solely for the addressee. Access to this Email by 
anyone else is unauthorized. If you are not the intended recipient, any 
disclosure, copying, distribution or any action taken or omitted to be taken in 
reliance on it, is prohibited and may be unlawful. When addressed to our 
clients any opinions or advice contained in this Email are subject to the terms 
and conditions expressed in any applicable governing The Home Depot terms of 
business or client engagement letter. The Home Depot disclaims all 
responsibility and liability for the accuracy and content of this attachment 
and for any damages or losses arising from any inaccuracies, errors, viruses, 
e.g., worms, trojan horses, etc., or other items of a destructive nature, which 
may be contained in this attachment and shall not be liable for direct, 
indirect, consequential or special damages in connection with this e-mail 
message or its attachment.

The information contained in this e-mail and any attached documents
may contain information that is confidential or otherwise protected
from disclosure. If you are not the intended recipient of this
message, or if this message has been sent to you in error, please
immediately alert the sender by reply e-mail and then delete this
message, including any attachments. Any dissemination, distribution
or other use of the contents of this message by anyone other than
the intended recipient is strictly prohibited.

JPEG image

reply via email to

[Prev in Thread] Current Thread [Next in Thread]