Search Results

Hi all,
We are receiving huge number of "Receive Errors" on our database server on AIX. Any pointers to troubleshoot would be really appreciated.

oslevel:
AIX 5.3.0.0

ifconfig -a
en6:...

Thanks.
I am trying to run the script the other way so that I can insert the values in the table. I need to change the value in the text file to a time stamp in db2.
So, basically I need the...

Thanks for the reply.
The database is db2 and does not support to_char function.

Hi,
I am having difficulty to compare a string in a file against a date from a a table and print the latest date. Below are the values.

String in File : 2009-12-02 00:37:51
Value Table : ...

Hi all,
I am using ftp command to transfer a file from one AIX5.3 box to different box with the same OS level. Is there a way I could change the permissions on the file once its transferred, as I am...

Hi all,
I am required to automate a ftp process for a file around 2 GB on a daily basis from AIX to Windows.Is there a utility or a software that could compress the file on AIX and can be...

Great..
Thanks.

Hi,
I have the following script to move the files from active directory to archive directory if the file system is 75% full. Everything works fine except the while loop does not get out when the...

Yep...works great.
Thanks.

Hi all,
How do I extract a value without special characters? I need to extract the value of %Used from below and if its greater than 80, need to send a notification.
I am doing this right now..Its...

Great..
Thanks again..

Hi,
I am using the following command to extract any log files that are older than 3 days using the following command.

find DIR/LOGDIR -type f -mtime +3 |grep LOG > log_list.out
The results are...

Thanks..
Works great.

Hi All,

I have a file in DirA/ABC.out a need to move to DirB.I am using the following steps now:

mv DirA/ABC.out DirB
compress -f DirB/ABC.out

Is there a way to just do this one step as I...

Hi all,
I have a data file and need to load the data into tables in a database. The problem is I cannot use a while loop with each line as the data is free text and has all kinds of weird characters...

Hi all,
Thanks for all the answers..based on the above answers I modified the below script ..

Here is the input file...
XYZ-2066779% xyz~%
XYZ-000036480% chxyz36r~%
XYZ-2056453%...

Hi all,
I have to extract only the second part of a database column (VARCHAR) and the value is seperated by a "~"

xyz~
chxyz36r~
abder~000082685
mnops~000083554
fulfil302~00026

Above are...

Below is the output from a db2 reorg command.

DB20000I The REORG command completed successfully.

I am trying to grab the return code(DB20000I) to check for succees or failure.
I need to use...

Hi all,
I have the following script.Can somone explain to me what it does.Thanks in advance.

if test $# -lt 1
then
echo "Message"
exit 1
fi

Hi all,
I have the following script.Can somone explain what it does.Thanks in advance.

if test $# -lt 1
then
echo "Message"
exit 1
fi