Search Results

Search: Posts Made By: rocking77
2,760
Posted By rocking77
i tried this way ... Tablist.txt has ...
i tried this way ...

Tablist.txt has

SCHEMA1. TABLE1
SCHEMA2. TABLE2
SCHEMA3. TABLE3

TABNAME =$(cat Tablist.txt|awk '{print $2 }')
TABSCHEMA=$(cat Tablist.txt|awk '{print $1}')

later...
2,760
Posted By rocking77
Read line and print output
need help to print the below ..

Content of file looks like below ..

SCHEMA1. TABLE1
SCHEMA2. TABLE2
SCHEMA3. TABLE3

read lines from above file and print o/p as below

print output like...
1,741
Posted By rocking77
echo $PATH ...
echo $PATH
:/opt/ibm/db2/inst1/sqllib/bin:/opt/ibm/db2/inst1/sqllib/adm:/opt/ibm/db2/inst1/sqllib/misc:/opt/ibm/db2/inst1/sqllib/db2tss/bin:/opt/ibm/db2/inst1/.local/bin:/opt/ibm/db2/inst1/bin


...
1,741
Posted By rocking77
Error while using inotifiywait
I Ran below shell script to place some logs from local to Amazon storage S3 .Where the highlighted line giving error ..Can some one suggest why is it failing ?

./filewatcher_maxdb76.sh...
2,530
Posted By rocking77
Error while sudo to instance via bash script
Team ,

I am trying to sudo to instnace using a shell script .In out put i am getting this error for every line ...I am running this script as root ..



sudo su - userid -i db2 "command "

...
1,071
Posted By rocking77
How can i prepare grant staement with 2 files ?
---file1 ( tables
A
B
C
D
E
F
...
...
Z
---file2
Joe
Bob
Mary
Sally
Fred
Elmer
David
933
Posted By rocking77
Add double quotation to Output
tail -n +7 1.txt |head -n -2|awk '{print "sql", $1,"-c groom table " $5 ,"versions"}'

sql DB1 -c groom table T1 versions
sql DB2 -c groom table T2 versions
sql DB3 -c groom table T3 versions
...
774
Posted By rocking77
Rudi , I m trying to fetch the content from...
Rudi ,

I m trying to fetch the content from column (Tablename).

Let me refine my requirement .

below is query result.

# Of Versioned Tables 6
Total # Of Versions 12

...
774
Posted By rocking77
Excluding the unwanted rows
#
Total
Table name
-----------------------+--------+--------------------------------+--------------------------+---------------
GK_AMP
GK_AMP
GK_AMP
GK_AMP
GK_AMP
GK_AMP
(6



how can...
684
Posted By rocking77
Suffic must be a date
00 18 * * 1,2,4 sh /A/B/scripts/daily_inc_diff.sh > /A/B/scripts/output/daily_diff.logTeam ,

how can i add a date to above output file with in crone ?

00 18 * * 1,2,4 sh...
1,399
Posted By rocking77
I updated to INCREMENTAL now error is...
I updated to INCREMENTAL

now error is different .

mv: cannot create regular file `/backup_LOCAL/db_backups/FULL/': Is a directory
mv: cannot create regular file...
1,399
Posted By rocking77
Finally i modified my script like this . #...
Finally i modified my script like this .

# MOVE BACKUPS TO backup_LOCAL/db_backups FROM /backup/db_backups/
cd /backup/db_backups/INCRMENTAL/
#mv /backup/db_backups/INCRMENTAL/*.*...
1,399
Posted By rocking77
oh ok you mean should i need to be there in pwd...
oh ok you mean should i need to be there in pwd before running this command ?
1,399
Posted By rocking77
Unable to copy contents
I am trying to move content of a folder usingls /backup/db_backups/INCREMENTAL/|while read file ; do
mv $file /backup_LOCAL/db_backups/INCREMENTAL/
done...but when I run this command using a bash...
1,523
Posted By rocking77
Output of ls -la 4096 Nov 19 10:30 . 4096...
Output of ls -la

4096 Nov 19 10:30 .
4096 Nov 15 05:45 ..
Nov 19 10:30 X.gz
Nov 19 10:30 y.gz
Nov 19 10:30 yz.txt
Nov 19 10:30 1.txt

so it has both .txt and .gz files, suggest some...
1,523
Posted By rocking77
Error while moving files and deleting
Team i am trying to delete files which are older than 1 day from 1 path (assuming already files are existed ) .

From another path we are trying to move files .like below .While executing this i m...
1,546
Posted By rocking77
Yes I will look at it . But how to delete...
Yes I will look at it .

But how to delete current weeknis umber (201509) - 8 ? My requirement to select the folders which are 8 weeks older only ..
1,546
Posted By rocking77
Remove folder contents
for dir in BKP/*/
do
echo You are in :$dir
done


O/P
--
BKP/201448/
BKP/201449/
BKP/201450/
BKP/201451/
BKP/201452/
BKP/201501/
BKP/201502/
BKP/201503/
BKP/201504/
BKP/201505/...
4,676
Posted By rocking77
for DB in ${DATABASES} do i=0 while [ $i ==...
for DB in ${DATABASES}
do
i=0
while [ $i == 0 ]
do
doing some thing ...

read yn?"Do You Wish To Take Database Backup for $DB?? "
case "$yn" in
[Yy]*) echo " YES"
...
4,676
Posted By rocking77
Just trying to add the case condition to a for...
Just trying to add the case condition to a for loop where for have n number iterations.but after giving choice as N its completly coming out of for loop
not iterating for other DB values in for loop...
4,676
Posted By rocking77
Thanks for your replies this is ksh .Batte I used...
Thanks for your replies this is ksh .Batte I used your sytax .



while true ;do

read yn? "Do You Wish To Take Database Backup for $DB?? "
case $yn in
[Yy]*) echo " YES take...
4,676
Posted By rocking77
Error to Read Input from command line
Team ,
I am trying to write a case condition for database backups.But I am unable to make the script to read input from command line .


while true ;do
read -p "Do You Wish To Take Database...
1,644
Posted By rocking77
You mean "ksh -s" <<EOF THis...
You mean

"ksh -s" <<EOF


THis should work ?
1,644
Posted By rocking77
Syntax error using Awk
Below is hte script which i m trying to for my requirement.If we run the highlighted part individually on database its running file and production accurate o/p
Expected

connect to XXXX...
1,644
Posted By rocking77
Out put of list db directory will come like this...
Out put of list db directory will come like this for n no.of database entries.




Database 1 entry:
Database alias = XXXXX
Database name =...
Showing results 1 to 25 of 74

 
All times are GMT -4. The time now is 07:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy