07-11-2006
sh script that reads/writes based upon contents of a file
Hi everyone,
Ive got a quick question about the feasibility and any suggestions for a shell script. I can use sh or ksh, doesnt matter. Basically, Ive got an output file from a db2 command that looks like so:
SCHEMA NAME CARD LEAF ELEAF LVLS ISIZE NDEL KEYS F4 F5 F6 F7 F8 REORG
-------------------------------------------------------------------------------------------------
Table: DB2INST2.ADVISE_INDEX
DB2INST2 IDX_I1 4 1 0 1 10 0 2 100 - - 0 0 -----
DB2INST2 IDX_I2 4 1 0 1 24 0 4 100 - - 0 0 -----
Table: DB2INST2.ADVISE_INSTANCE
SYSIBM SQL060710185042710 2 1 0 1 10 0 2 100 - - 0 0 -----
Table: DB2INST2.ADVISE_MQT
DB2INST2 MQT_I1 - - - - - - - - - - - - -----
DB2INST2 MQT_I2 - - - - - - - - - - - - -----
Table: DB2INST2.ADVISE_PARTITION
DB2INST2 PRT_I1 - - - - - - - - - - - - -----
Table: DB2INST2.Active_Server_Pages
DB2INST2 ACTSRVPG_IDX - - - - - - - - - - - - -----
Table: DB2INST2.Active_Server_Pages_D
DB2INST2 ACTSRVPG_DX 8622 127 0 3 97 0 8622 65 89 52 0 0 *----
DB2INST2 ACTSRVPG_DX2 8622 41 0 2 82 0 2889 76 90 2 0 0 *----
Table: DB2INST2.Active_Server_Pages_H
DB2INST2 ACTSRVPG_HX 20492 302 0 3 97 0 20492 7 89 22 0 0 *----
If any of you are db2 dba's, youll recognize its the output for reorgchk. Basically what im trying to do is to move the string after "Table: " to a differnt file if any of the output between it and the next occurance of "Table: " contains a star(*). Im thinking I would need to use SED to somehow extract that block of text, put it in another file, place the schema.tablename (in the last case it is DB2INST2.Active_Server_Pages_H) in a variable, grep that file for the star, and if it exists (no matter how many occurances), then write that variable that has the schema.tablename to another file enclosed in a command that I already have (will be reorg table). Any takers on the feasibility of this? Please request clarification if nessesary.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi intelligent beings,
I am trying to write a script that
1. Accepts the following arguments:
store_number
div_number
user_id
div_code
2. Will read from a configuration file to get the Database
3. Use the div_code to determine which value to retrieve from the configuration file
... (1 Reply)
Discussion started by: dolo21taf
1 Replies
2. Shell Programming and Scripting
I would like to write shell/perl script which identifies the top unix processes that are performing high disk I/O's or/and writes
If any one knows the solution please help me?
-Swamy (0 Replies)
Discussion started by: avsswamy
0 Replies
3. UNIX for Advanced & Expert Users
Guys,
Is there any UNIX command that captures the 'Unix process which is performing high disk I/O reads and writes'.
can you help me in this?
-Swamy (6 Replies)
Discussion started by: avsswamy
6 Replies
4. Shell Programming and Scripting
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (4 Replies)
Discussion started by: mmiller99
4 Replies
5. Filesystems, Disks and Memory
Hi,
I am trying to find the reliability of 'vmstat -d' for showing the actual physical writes on sectors on hard disk.
Can anyone please tell me if the numbers in the "sectors" field under "read" or "write" headers show a count of the actual write commands sent to disk from the low level... (2 Replies)
Discussion started by: jake24
2 Replies
6. Filesystems, Disks and Memory
Hi All
I was wondering how the copying of vast amounts of data affected the overall lifespan of an HDD.
In my example, I'm copying approx 120GB (250,000) of files, once per hour from disk to another.
Is this likely to have a detrimental effect on the disk in terms of reads/writes etc?
... (2 Replies)
Discussion started by: huskie69
2 Replies
7. UNIX for Dummies Questions & Answers
I was analyzing the Disk read using hdparm utility.
This is what i got as a result.
# hdparm -t /dev/sda
/dev/sda:
Timing buffered disk reads: 108 MB in 3.04 seconds = 35.51 MB/sec
# hdparm -T /dev/sda
/dev/sda:
Timing cached reads: 3496 MB in 1.99 seconds = 1756.56 MB/sec... (1 Reply)
Discussion started by: pinga123
1 Replies
8. Shell Programming and Scripting
Hi
I am looking for an easy way to lock game mode (0) for everyone included op on a Minecraft server. It can be a script that every time a player changes game to 1 the script changes back to 0. What the player writes is visible in the java console. I am not good at script programming and my... (0 Replies)
Discussion started by: MyMorris
0 Replies
9. Shell Programming and Scripting
Hi
I have 2 files
1.del
----
1,2,3,4,5
1,2,3,4,4
1,1,1,1,2
2.del
----
1,2,3,4,5
1,
1,2,3,4,4
1,1,1,1,2
I need to compare the above two files in unix, as in the output should only tell the difference in contents as I should get only the line
1 ( from 2.del) , rest all lines are... (4 Replies)
Discussion started by: Ethen561
4 Replies
10. Shell Programming and Scripting
I have below script to read a file line by line. How can I ensure that the loop will stop after last line.
#!/bin/bash
while read -r mod ver tarball; do
echo $mod
done < taskfile.txt (4 Replies)
Discussion started by: aderamos12
4 Replies
LEARN ABOUT FREEBSD
return
exit(1) User Commands exit(1)
NAME
exit, return, goto - shell built-in functions to enable the execution of the shell to advance beyond its sequence of steps
SYNOPSIS
sh
exit [n]
return [n]
csh
exit [ ( expr )]
goto label
ksh
*exit [n]
*return [n]
DESCRIPTION
sh
exit will cause the calling shell or shell script to exit with the exit status specified by n. If n is omitted the exit status is that of
the last command executed (an EOF will also cause the shell to exit.)
return causes a function to exit with the return value specified by n. If n is omitted, the return status is that of the last command exe-
cuted.
csh
exit will cause the calling shell or shell script to exit, either with the value of the status variable or with the value specified by the
expression expr.
The goto built-in uses a specified label as a search string amongst commands. The shell rewinds its input as much as possible and searches
for a line of the form label: possibly preceded by space or tab characters. Execution continues after the indicated line. It is an error to
jump to a label that occurs between a while or for built-in command and its corresponding end.
ksh
exit will cause the calling shell or shell script to exit with the exit status specified by n. The value will be the least significant 8
bits of the specified status. If n is omitted then the exit status is that of the last command executed. When exit occurs when executing
a trap, the last command refers to the command that executed before the trap was invoked. An end-of-file will also cause the shell to exit
except for a shell which has the ignoreeof option (See set below) turned on.
return causes a shell function or '.' script to return to the invoking script with the return status specified by n. The value will be the
least significant 8 bits of the specified status. If n is omitted then the return status is that of the last command executed. If return
is invoked while not in a function or a '.' script, then it is the same as an exit.
On this man page, ksh(1) commands that are preceded by one or two * (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words, following a command preceded by ** that are in the format of a variable assignment, are expanded with the same rules as a vari-
able assignment. This means that tilde substitution is performed after the = sign and word splitting and file name generation are not
performed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
break(1), csh(1), ksh(1), sh(1), attributes(5)
SunOS 5.10 15 Apr 1994 exit(1)