I'm not familiar with 'teradata' but it sort of sounds like a GIS database? If so, the actual process of extracting and comparing the data will be something you'll have to derive but I can help with the method of obtaining this data from two different servers.
Hello all, I know that is a question which has made too many times, and I have been looking into the threads but all posted was not sucessfully for me so...
I need a shell script which connect two unix servers, but NOT using ssh... Is there another way to do it?
I've tried ssh but it didn't... (1 Reply)
How do i connect from C program to teradata Database?
The C program is being executed from a Unix script, AIX.
I am calling a C program from a Unix shell script and the C Program executes some SQLs on Teradata Database. (3 Replies)
Hi Guru's,
Pardon me for the breach of rules.....
I have very little knowledge about Shell Programming and Scripting hope you guys help me out of this troble
I have very little time hence could not find the right way to direct my queries.
coming to the problem
I need to call a... (2 Replies)
Hi ,
I am trying to write a script which does the wincvs login and does some checkout operations.
When i do it from command prompt with command
wincvs -d :pserver:username@server:/cvs/repository
it pops up a cvs window and i can do some operations there. I wanted to automate this through... (1 Reply)
Hello,
I have access to several linux servers (mostly centos based) located in a DC in another country.
from day to day I need to login to each of them to do some work (they dont have gui/window manager installed, I work only from console), or even to just do a check like df -h for disc usage.... (3 Replies)
I need a shell script using expect to login to couple of remote servers and read "crontab -l -u <username>" & "cat /etc/rc.local" & "df -h" and able to create output into a file saved locally with hostname.crontab & hostname.rc.local & disk.status. I can supply a file as list of hostname or IP... (4 Replies)
Hi All,
As we are using SQLPLUS command to connect Oracle Database in unix:
Like below syntax:
sqlplus username/password@dbname << EOI
SET HEADING OFF
SPOOL MAX_DATE_VAL.txt
select max(LAST_UPDT_DATE) from source_defect;
SPOOL OFF
here the result is stored in... (0 Replies)
Hi Master,
I need to create dan run script in linux to get data from teradata
I did this
---------- Post updated at 02:28 AM ---------- Previous update was at 02:25 AM ----------
LOG_DIR="/home/";
OUTDIR="/home/";
SCRIPT_NAME=“test";
DUMPFILE="${OUTDIR}${SCRIPT_NAME}"_"$(date... (2 Replies)
Hi Experts,
I am querying backup status results for multiple databases and getting each and every database result in one csv file. so i need to combine all csv files in one excel file with separate tabs. I am not familiar with perl script so i am using shell script.
Could anyone please... (4 Replies)
Discussion started by: ramakrk2
4 Replies
LEARN ABOUT OSF1
ac
ac(8) System Manager's Manual ac(8)NAME
ac - Outputs connect-session records
SYNOPSIS
ac [-dp] [-w filename] [user(s) ...]
FLAGS
Outputs the total connect time for each midnight-to-midnight period for which a wtmp file exists. When user(s) is specified, this flag lim-
its the output to the login names specified by any user(s) parameter(s). Outputs the connect time total by individual login name of the
user specified with the -p flag and the user(s) parameter. Omission of this flag permits a total only for the midnight-to-midnight time
period for all logged in users to be produced. Specifies a wtmp file other than the /var/adm/wtmp file. The wtmp file you access for data
may have been created automatically by some shell script administration command (for example, runacct) or manually by the system adminis-
trator when the original /var/adm/wtmp file becomes too large.
DESCRIPTION
The ac command prints to the default output device the total connect time in hours to the nearest hundredth for all users, or the connect
time for any user(s) specified with the -p flag. It also prints the names of users specified by the user(s) parameter who have logged in
during the life of the current /var/adm/wtmp file.
Connect-time records are written by the init and the login programs and are collected in the /var/adm/wtmp file, when such a file exists.
When a /var/adm/wtmp file does not exist, no connect-time accounting records are written; consequently, when connect-time records are
wanted, the system administrator should create a /var/adm/wtmp file that has an initial record length of 0 (zero). Records in wtmp files
(there may be more than one such file) should be processed periodically to keep the files from becoming too large.
When you use the runacct command in a shell script, additional wtmp files can be automatically created whenever the current wtmp file
becomes too large. You can output the contents of any of these other files when you specify the -w flag and the desired wtmp filename.
The ac command is run independently with respect to any accounting shell procedure created or run by any of the acct/* shell procedures or
runacct commands.
EXAMPLES
To obtain an output of the total connect time for all users who have logged in during the life of the current wtmp data file, enter:
/usr/sbin/ac To obtain an output of the total connect time for grossman and mcwhinney as recorded in the default wtmp data file,
enter:
/usr/sbin/ac grossman mcwhinney To obtain an output of the connect time subtotals for grossman and mcwhinney as recorded in the
default wtmp data file, enter:
/usr/sbin/ac -p grossman mcwhinney
FILES
Specifies the command path. Is the active data file for the collection of connect-time records.
RELATED INFORMATION
Commands: login(1), init(8) delim off
ac(8)