Hi Folks,
I am using db2 command -> db2 list tablespace show detail
Code:
Tablespace ID = 10
Name = TSCDDHLMSUM
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 320
Useable pages = 288
Used pages = 224
Free pages = 64
High water mark (pages) = 224
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 11
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 1024
Useable pages = 1020
Used pages = 92
Free pages = 928
High water mark (pages) = 92
Page size (bytes) = 32768
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
As you can see, there are 2 tablespaces information shown in row format, I would like to have show it into column format
Code:
Tablespace ID Name Type Contents ....
------------- ----- ---- -------
10 TSCDDHLMSUM Database managed space ....
11 SYSTOOLSPACE Database managed space ....
A file content have
1 1:-0.289433 2:0.833778 3:0.314471 4:-0.289433 5:-0.81876 6:-0.456693 7:-0.17511 8:-0.644555 9:-0.00666341 10:-1.13603
I will like to have that column into row with numbers to be printed (red color) only after colon
output shud be like that
-0.289433... (1 Reply)
hi,
I have a requirement where in I read the values from a file using awk. The resulting data should be converted into row format from column format.
For ex: My log file login.lst contains the following
SERVER1 DB1
SERVER2 DB2
SERVER3 DB3
SERVER4 DB4
I use awk to grep only the server... (6 Replies)
Getting tired of cut-and-paste...so I thought I would post a question.
how do I change this column output to a single row?
from this:
# vgdisplay -v /dev/vgeva05 | grep dsk | awk '{print $3}'
/dev/dsk/c6t0d5
/dev/dsk/c11t0d5
/dev/dsk/c15t0d5
/dev/dsk/c18t0d5
/dev/dsk/c7t0d5... (8 Replies)
Hi,
I have a file like this
50 1 2 1374438
50 1 2 1682957
50 5 2 1453574
50 10 2 1985890
100 1 2 737307
100 5 2 1660204
100 10 2 2148483
and I want to convert this by... (1 Reply)
Dear Perl users,
Could you help me how to convert from row to column if I've a case below:
Linux 2014_01_24 CPU 10
Linux 2014_01_24 MEM 20
UNIX 2014_01_24 CPU 30
UNIX 2014_01_24 MEM ... (6 Replies)
Hi Unix Forum,
I have a relatively easy question i suppose for which, however, until now i could not find a solution.
I am working with a program that will give me an output file similar to the following:
A
1
2
3
4
B
1
2
3
4
C
1 (9 Replies)
Hi
FileA.txt
E_TIM 16,
ETE 15,
EOND 26,
EEC 81,
E_1 un,
E_2 un,
E_3 un,
E_4 284,
E_TIM 17,
ETE 15,
EOND 29,
EEC 82,
E_1 un,
E_2 un,
E_3 un,
E_4 249, (6 Replies)
Discussion started by: asavaliya
6 Replies
LEARN ABOUT OPENSOLARIS
btop
btop(9F) Kernel Functions for Drivers btop(9F)NAME
btop - convert size in bytes to size in pages (round down)
SYNOPSIS
#include <sys/ddi.h>
unsigned long btop(unsigned long numbytes);
INTERFACE LEVEL
Architecture independent level 1 (DDI/DKI).
PARAMETERS
numbytes Number of bytes.
DESCRIPTION
The btop() function returns the number of memory pages that are contained in the specified number of bytes, with downward rounding in the
case that the byte count is not a page multiple. For example, if the page size is 2048, then btop(4096) returns 2, and btop(4097) returns 2
as well. btop(0) returns 0.
RETURN VALUES
The return value is always the number of pages. There are no invalid input values, and therefore no error return values.
CONTEXT
The btop() function can be called from user, interrupt, or kernel context.
SEE ALSO btopr(9F), ddi_btop(9F), ptob(9F)
Writing Device Drivers
SunOS 5.11 16 Jan 2006 btop(9F)