Search Results

I am trying to call sproc from shell script. Please check if the below code works.


if [ ${lv_stepstartnum} -le 4 ] && [ ${lv_stependnum} -ge 4 ]
then
# Setup local step variables...

The script to get the db user password from LDAP does not work on AIX 5.3. It's using bash. Our current shell is /usr/bin/shell.


How can i make changes to this script so that it can run on aix...

How to call a stored procedure from shell program

Jim,

My question is below ---

We have a below script and based on which we have create a script which starts sqlldr loading.


#!/bin/ksh
# mon_large_files.sh
# Monitors for large files...

asdfasdfasdfasdf???

Hi,

We have 2 scripts below for reporting sar output which are pretty same.
In first script i want to add to the program whatever is given in the comments.
In second script I want to use while...

Thanks Zaxxon!

Could you incorporate in the below script
sar -f sa15 | grep -v Average | grep -v "^$" | grep -vi restart | grep -v System | grep -v AIX | tail -48 > sa15.$$
mailx -s "Last 48...

I am running below script to display last 48 hour data but the output is not displaying heading -

AIX eqrdb26u1 1 6 00CFD5E34C00 01/21/10
System configuration: lcpu=8 ent=2.00 mode=Uncapped ...

Hi,

How can we run/schedule a shell script. Since there is no access to cron at this point of time we have to think other way out to run a script every hour.
How can we achieve this. Need...

Methyl,

Data get appended to the sa15 file automatically.....we have filter and send only last 48 hours data. every row is hourly data ie., tail -48.

How can i schedule it to run every hour...

Hi CfaJOHNSON,

I have this below script from TonyFuller,

sar -f sa15 | grep -v Average | grep -v "^$" | grep -vi restart | grep -v System | grep -v AIX | tail -144 > sa15.$$
mailx -s "Last 48...

Tony Fuller,

This is not homework? Officials means my Seniors...They want this report..i am a DBA witn minimum
o/s knowledge. So i need ur help in this

Hi TonyFuller,

I got this reply from my official when i ran ur 1st sar shell prog -

---- Reply is----
The assumption and calculation are not correct. You must look at the top line where you...

Need script....We get sar file sa15 with 7 days data which gets appended.. we want filter and parse the outptu such that we should filter only last 48 hours data and then email it to out team.

we...

In my home directory in server , you will find a file called sa15 that contains sar data

To read this file, run:
sar -f sa15


We will need to parse the output, send last 48 hrs of data and...

We have a program which create sar output files which has a weeks data...
To read file we use sar -f sa15 command which has multiple days data( a weeks data)....we need to only get last 48 hours...

I have 8 set of files.

eg:
File 1 -- sybase row count
emp 45
dept 55
outln 78
xxx 91

File 2 -- oracle row count
emp 71
dept 10
outln 78
xxx 91
rtyurtuyrtuyrt 123...