Hi colleagues, thank you for you fast response,
I have run this commands
Code:
db2 -x "select substr(TBSPACE,1,20) TABLESPACE from syscat.tables where tabschema = 'MIATLAS' and tabname like '%TH' group by TBSPACE order by 1" | while read tablespace
do
db2 "list tablespaces show detail" |grep -p -w $tablespace | egrep "Name|Total pages|Free pages|Page size" | while read label equals value rest
do
echo "$label $equals $value $rest\t\c"
done ; echo
done ; echo
the output is as follows
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
I need to do a multiplication for the output to be like this.
Code:
Name = TSADOR Total pages = 14991360 Free pages = 5345152 Page size (bytes) = 32768 Mb=Free pages*Page size (bytes)
Name = TSHISTNEW Total pages = 4186112 Free pages = 1276544 Page size (bytes) = 32768 Mb=Free pages*Page size (bytes)
Name = TSHISTTI Total pages = 6279168 Free pages = 1991168 Page size (bytes) = 32768 Mb=Free pages*Page size (bytes)
thanks for your valuable help.
Moderator's Comments:
Code tags for code, please.
Last edited by Corona688; 06-25-2012 at 03:11 PM..
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... (5 Replies)
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 Replies)
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... (5 Replies)
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 =... (2 Replies)
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... (10 Replies)
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... (4 Replies)
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... (5 Replies)
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"... (4 Replies)
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... (3 Replies)
Discussion started by: cmccabe
3 Replies
LEARN ABOUT OSX
mincore
MINCORE(2) BSD System Calls Manual MINCORE(2)NAME
mincore -- determine residency of memory pages
SYNOPSIS
#include <sys/types.h>
#include <sys/mman.h>
int
mincore(caddr_t addr, size_t len, char *vec);
DESCRIPTION
The mincore() system call allows a process to obtain information about whether pages are core resident. The current core residency of the
pages is returned in the character array vec. For each entry in the character array vec, the following bit values may be set depending upon
the state of the page:
MINCORE_INCORE 0x1 /* Page is incore */
MINCORE_REFERENCED 0x2 /* Page has been referenced by us */
MINCORE_MODIFIED 0x4 /* Page has been modified by us */
MINCORE_REFERENCED_OTHER 0x8 /* Page has been referenced */
MINCORE_MODIFIED_OTHER 0x10 /* Page has been modified */
RETURN VALUES
Upon successful completion, a value of 0 is returned. Otherwise, a value of -1 is returned and errno is set to indicate the error.
ERRORS
[EINVAL] addr is not a valid address for user mode.
[EFAULT] an error occurred trying to copy to the output character array vec.
SEE ALSO madvise(2), minherit(2), mlock(2), mprotect(2), msync(2), munmap(2)HISTORY
The mincore() function first appeared in 4.4BSD.
BSD June 9, 1993 BSD
06-25-2012
