06-10-2011
VGersh,
Thanks for replying. The whole story is that we'll be executing each of the four scripts at different points during the day. We'll include each quarterly script as an entry in the cron.
The reason we're doing this is because our replication environment is spewing a boatload of alerts due to the volume of updates, not to mention, the load backing up.
Any additional help with the GMT-4 issue would be great.
Thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
3. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
4. Shell Programming and Scripting
does somebody know GMT mapping? please reply (2 Replies)
Discussion started by: SANGUINE
2 Replies
5. AIX
Hello,
On Aix 5.2, we changed the parameters tcp_keepinit, tcp_keepintvl and tcp_keepidle with the no command.
tunrestore -R is present in inittab
in the directory /etc/tunables we can clearly see the inclusion of parameters during reboot, including the file lastboot.log
... (0 Replies)
Discussion started by: dantares
0 Replies
6. Shell Programming and Scripting
I have a file which is tab delimited, it contains the GMT date.
Please tell me how to convert from GMT to PST time and if the date and time is of 2 days ago from the current date store the lines in a file or else remove the line.
10.1.10.178 - - -
10.1.10.178 - - ... (2 Replies)
Discussion started by: sandy1028
2 Replies
7. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
8. Shell Programming and Scripting
Hi All,
I am trying to dowmload the zip file "zkManageCustomers.zip " but i dont have access. Can anyone help me to download this file
See the below link-
http://www.ibm.com/developerworks/opensource/library/wa-aj-open/index.html?ca=drs-
Please help me as early as... (1 Reply)
Discussion started by: aish11
1 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
LEARN ABOUT OPENSOLARIS
rtc
rtc(1M) System Administration Commands rtc(1M)
NAME
rtc - provide all real-time clock and GMT-lag management
SYNOPSIS
/usr/sbin/rtc [-c] [-z zone-name]
DESCRIPTION
On x86 systems, the rtc command reconciles the difference in the way that time is established between UNIX and MS-DOS systems. UNIX systems
utilize Greenwich Mean Time (GMT), while MS-DOS systems utilize local time.
Without arguments, rtc displays the currently configured time zone string. The currently configured time zone string is based on what was
last recorded by rtc-z zone-name.
The rtc command is not normally run from a shell prompt; it is generally invoked by the system. Commands such as date(1) and rdate(1M),
which are used to set the time on a system, invoke /usr/sbin/rtc -c to ensure that daylight savings time (DST) is corrected for properly.
OPTIONS
-c This option checks for DST and makes corrections if necessary. It is normally run once a day by a cron job.
If there is no RTC time zone or /etc/rtc_config file, this option will do nothing.
-z zone-name This option, which is normally run by the system at software installation time, is used to specify the time zone in which
the RTC is to be maintained. It updates the configuration file /etc/rtc_config with the name of the specified zone and the
current GMT lag for that zone. If there is an existing rtc_config file, this command will update it. If not, this command
will create it.
FILES
/etc/rtc_config The data file used to record the time zone and GMT lag. This file is completely managed by /usr/sbin/rtc, and it is read
by the kernel.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Architecture |x86 |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
date(1), rdate(1M), attributes(5)
SunOS 5.11 3 Oct 2003 rtc(1M)