I am currently running the following Korn shell script which works fine:
#!/usr/bin/ksh
count=`db2 -x "select count(*) from schema.tablename"`
echo "count"
I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
I have seen references in the forum about getting yesterday's date but it is either by changing something in the system (date, time zone, ...) or with more then one line of script cmds.
How can I get yesterday's date without changing anything in the system and in one single command line ? (4 Replies)
Hello,
I am trying to show today's date and time in a better format than ‘date' (Using positional parameters). I found a command mktime and am wondering if this is the best command to use or will this also show me the time elapse since 1/30/70? Any help would be greatly appreciated, Thanks... (3 Replies)
Hi,
I want to compare today's date(DDMMYYYY) with yesterday(DDMMYYYY) from system date,if (today month = yesterday month) then execute alter query else do nothing.
The above requirement i want in Shell script(KSH)...
Can any one please help me?
Double post, continued here. (0 Replies)
Hi Guys,
I have a file with following content
From 20121014 : To 20121014
Number of days : 1
1234
1245
1246
1111
Everyday i run my script i want to modify "To" date on the first line with current date. I have set the current date in script as
RUN_DATE=`date -u +%Y%m%d`
So i want... (9 Replies)
Hi
I want to get tomorrow and yesterday date from date command. My shell is KSH and server is AIX. I tried several options, but unable to do. Please help on this.
Regards
Rajesh (5 Replies)
Hi,
One of my Unix scripts needs to look for files coming in on Fridays. This script runs on Mondays. $date +"%y%m%d" will give me today's date. How can I get previous Friday's date.. can I do "today's date minus 3 days" to get Friday's date? If not, then any other way?? Name of the files is... (4 Replies)
Hello,
I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead.
Here's what I... (5 Replies)
hi all,
How to compare two files whether they are same are not...? like i had my input files as 20141201_file.txt and 20141130_file2.txt
how to compare the above files based on date .. like todays file and yesterdays file...? (4 Replies)
Hi Community!
Following on from this code in another thread:
#!/bin/bash
file_string=`/bin/cat date.txt | /usr/bin/awk '{print $5,$4,$7,$6,$8}'`
file_date=`/bin/date -d "$file_string"`
file_epoch=`/bin/date -d "$file_string" +%s`
now_epoch=`/bin/date +%s`
if
then
#let... (2 Replies)
Discussion started by: Greenage
2 Replies
LEARN ABOUT DEBIAN
backup-manager-upload
BACKUP-MANAGER-UPLOAD(8) backup-manager-upload BACKUP-MANAGER-UPLOAD(8)NAME
backup-manager-upload - Multiprotocol uploader for backup-manager.
SYNOPSIS
backup-manager-upload [options] date
DESCRIPTION
backup-manager-upload will upload all the archives generated on the given date to the specified host with either ftp or scp. It's also
possible to use this program for uploading data to an Amazon S3 account. Some metadates are available like "today" or "yesterday".
REQUIRED ARGS --mode=transfer-mode
Select the transfer mode to use : ftp, scp, or s3.
--host=hostname1,hostname2,...,hostnameN
Select a list of remote hosts to connect to.
--user=username
Select the user to use for connection.
OPTIONAL ARGS --password=password
Select the ftp user's password (only needed for ftp transfers).
--key=path_to_private_key
Select the ssh private key file to use when opening the ssh session for scp transfer. Obviously, this is only needed for scp transfer
mode. If you don't specify a key file, the user's default private key will be used.
--directory=directory
Select the location on the remote host where files will be uploaded. Default is /backup/uploads.
--bucket=bucket
Sets the bucket name for the Amazon S3 service backup into.
--root=directory
Select the local directory where files are. Default is /var/archives
--gpg-recipient=gpg-recipient
Select the gpg public key for encryptiong the archives when uploading with the method ssh-gpg. This can be a short or long key id or a
descriptive name. The precise syntax is described in the gpg man page.
--list
Just list the files to upload.
--ftp-purge
Purge the remote directory before uploading files in FTP mode.
--s3-purge
Purge the remote directory before uploading files in FTP mode.
--ssh-purge
Purge the remote directory before uploading files in SSH mode.
--verbose
Flag to enable verbose mode.
date
Date pattern to select some files to upload, can be a valid date (YYYYMMDD) or 'today' or 'yesterday'.
ERROR CODES
If something goes wrong during an upload, backup-manager-upload will exit with a non null value. In such a case every error messages are
sent to STDERR.
Here are the possible error codes:
bad command line (wrong arguments) : 10
FTP transfer failure : 20
SCP transfer failure : 21
S3 transfer failure : 22
Unknown upload method: 23
SEE ALSO backup-manager(3)AUTHORS
Alexis Sukrieh - main code and design
Brad Dixon - Amazon S3 upload method
Jan Metzger - ssh-gpg upload method
perl v5.14.2 2012-05-09 BACKUP-MANAGER-UPLOAD(8)