how to take the back up the log files for n days

[sudhakar_viswa]

Hi,

how to take the back up the log files for n days

thanks,
sudhakar

[loveojha2]

This query may help you

Code: Select all

SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

Where nn is the jobnumber.

[chulett]

Better to take the 'dsjob' approach as it is more 'future proof'. IMHO.

[sudhakar_viswa]

hi loveojha2 ,

how can i execute this Code in unix

SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

thanks,sudhakar

[ArndW]

You cannot, this is a command that needs to be executed in TCL or from the ADMINistrator command.

[ray.wurlod]

You can, by invoking TCL from the command line.

Code: Select all

cd project_dir && . $DSHOME/dsenv && $DSHOME/bin/dssh "SELECT * FROM RT_LOGnn WHERE TIMESTAMP BETWEEN '2006-04-01' AND '2006-04-05';"

But, as Arnd suggests, this is not future proof. In the next release ("Hawk"), job logs are not stored in this fashion.

[sudhakar_viswa]

Hi ray.wurlod and ArndW ,

Thanku.I want to store the result in unix file.how can i do that.


thanks,
sudhakar

[ArndW]

how about a command like dsjob -logsum MyProjectName MyJobName > MyUnixTextFileName.txt from UNIX.

[sudhakar_viswa]

hi ArndW ,

i want to execute this query in unix
SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

and i should store this result into one text file in unix.

how to do that?

thanks,
sudhakar

[ray.wurlod]

Simply redirect output into your file using the ">" redirection operator.

Note, however, that SQL can not be executed from UNIX, no matter how much you may want to do so, because UNIX is not a database environment. You need some kind of wrapper, such as exemplified in earlier posts.