|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to convert this script so that it runs the dbv at most 5x at a time instead of serially?
Post 303027997 by newbie_01 on Saturday 29th of December 2018 06:28:55 AM
12-29-2018
How to convert this script so that it runs the dbv at most 5x at a time instead of serially?
Hi,
Attached is a generated script of the database files if/when we want to run dbv = dbverify.
The script runs fine by itself but it does take awhile to finish. In a worse case scenario, it can take up to 7 hours to finish as the dbv runs serially.
I need help and guidance to somehow have some parallelism in terms of running the dbv. For instance, I want to at least have 5xdbv running at some point in time. So for a start, run 5 of these dbv's, and then 'monitor' in the background if some has finished, then start more dbv until there's 5xdbv running again and so on and so forth.
As there are several databases on the same server, I cannot simply ps -ef | grep dbv to check for the number of dbv commands running. That is, I may have two of these scripts that I want to run for two different databases. So the 5xdbv run is for each database. If there is two of these scripts then there should be 10xdbv running at one time, 5 for each database.
Not sure where or how to start
Any advice will be much appreciated. Thanks in advance. BTW, prefers something that I can use on both Solaris and Linux
P.S.:
Belated Merry Christmas, Happy New Year to All.
Attached is a generated script of the database files if/when we want to run dbv = dbverify.
The script runs fine by itself but it does take awhile to finish. In a worse case scenario, it can take up to 7 hours to finish as the dbv runs serially.
I need help and guidance to somehow have some parallelism in terms of running the dbv. For instance, I want to at least have 5xdbv running at some point in time. So for a start, run 5 of these dbv's, and then 'monitor' in the background if some has finished, then start more dbv until there's 5xdbv running again and so on and so forth.
As there are several databases on the same server, I cannot simply ps -ef | grep dbv to check for the number of dbv commands running. That is, I may have two of these scripts that I want to run for two different databases. So the 5xdbv run is for each database. If there is two of these scripts then there should be 10xdbv running at one time, 5 for each database.
Not sure where or how to start
Any advice will be much appreciated. Thanks in advance. BTW, prefers something that I can use on both Solaris and LinuxP.S.:
Belated Merry Christmas, Happy New Year to All.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is there an easy method to do an on the fly conversion of a standard epoch time (seconds from 1970) to more readable date format?
Does Unix have anything built in to do this? (4 Replies)
Discussion started by: LordJezo
4 Replies
2. Shell Programming and Scripting
hi friends,
this is my first time with this type of script so please pardon my ignorance. i have this script in which a piece of code needs to be added which can have the Asia/Hong kong time as well. system date and format is GMT so no problem with GMT and even EST is covered..i have ato add new... (5 Replies)
Discussion started by: xejatt
5 Replies
3. Shell Programming and Scripting
Hi guys,
I know that this topic has been discuss numerous times, and I have search the net and this forum for it.
However, non able to address the problem I faced so far.
I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies
4. Shell Programming and Scripting
Hi,
Is there any easy way to convert date time(stored in shell variable ) to epoch time in solaris box? As +%s is working on linux but not on solaris, also -d option is not working.
Any suggestion please? (6 Replies)
Discussion started by: anshuman0507
6 Replies
5. Shell Programming and Scripting
Hello,
We have an oracle database running on a Linux host (RHEL5)...I'm trying to run Oracle dbv (database verify utility) and capture its output to a file using the following syntax but the standart output does NOT get redirected to the file...
dbv blocksize=32768 ... (2 Replies)
Discussion started by: luft
2 Replies
6. Shell Programming and Scripting
Hi,
What i am looking for and i am new to this too, is a bash script that will add time in the format hh:mm:ss and produce the answer in minutes or seconds. It needs to be a loop since there are hundreds of times in my file. This is data is from a CDR that calculates duration of time used. ... (2 Replies)
Discussion started by: trotella
2 Replies
7. Shell Programming and Scripting
Hello All -
I have a script that grabs data from the net and outputs the following data
46029 46.144 -124.510 2010 07 26 22 50 320 4.0 6.0 2.2 9 6.8 311 1012.1 -0.9 13.3 13.5 13.3 - -
46041 47.353 -124.731 2010 07 26 22 50 250 2.0 3.0 1.6 8 6.4 - 1011.6 - ... (0 Replies)
Discussion started by: drexnefex
0 Replies
8. Shell Programming and Scripting
Dear experts,
I have an epoch time input file such as : -
1302451209564
1302483698948
1302485231072
1302490805383
1302519244700
1302492787481
1302505299145
1302506557022
1302532112140
1302501033105
1302511536485
1302512669550
I need the epoch time above to be converted into real... (4 Replies)
Discussion started by: aismann
4 Replies
9. Shell Programming and Scripting
Hi guys thanks for the help for my previous posts.Now i have a requirement that i download a XMl file which has UTC time stamp.I need to convert UTC time into Unix server timezone.
For ex if the time zone of unix server is CDT then i need to convert into CDT.whatever may be the system time... (5 Replies)
Discussion started by: mohanalakshmi
5 Replies
10. UNIX for Advanced & Expert Users
Hello,
I am trying to run a script through crontab and it runs the first time and then it does not run.
I tried to run a simple script (as shown below) and I see the same issue.
#!/bin/ksh
clear
echo "Good Morning, World." > /tmp/test123
Crontab Entry:
30 09 * * *... (9 Replies)
Discussion started by: hasn318
9 Replies
LEARN ABOUT DEBIAN
trbdf
trbdf(1) User Manuals trbdf(1) NAME
trbdf - convert BDF-font from one encoding to other SYNOPSIS
trbdf -C | -l | -h trbdf [-s] [-f input-codeset ] [-t output-codeset ] [--foundry[=] new-foundry ] BDF-font DESCRIPTION
trbdf is a program for translation of BDF fonts from one encoding to other. One exciting feature of trbdf is that it tries to approximate the symbols that miss from the font or from the encoding of the font with existing symbols when possible. If the option -s or --gen-script is given trbdf will generate an awk(1) script for translation of BDF-fonts for fixed combination of input- codeset and output-codeset This is useful for faster convertion of many files. This script is used as filter. If none of -C, -s, -l, -h and their equivalents is given the BDF-font will be read assuming it is coded with codeset input-codeset On stan- dard output it will be recoded so to use codeset output-codeset Both input-codeset and output-codeset are case insensitive and default to `cp1251'. OPTIONS
-C, --copyright Display copying conditions and warranty information. -s, --gen-script Generates conversion script for given input and output encodings instead to convert BDF-font. This option is usefull if you have to convert many fonts. The generated script expects the input font from its standard input and outputs the converted font. -l, --list List all known codesets. -h, --help Display this help and exit. -f input-codeset, --from[=]input-codeset Codeset of the source font. -f output-codeset, --to[=]output-codeset Codeset of the generated font. --foundry[=]new-foundry Use this option if you want to change the foundry of the generated fonts. AUTHOR
Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg> SEE ALSO
bdftopcf(1x) trscripts NOV 2002 trbdf(1)