how to take the back up the log files for n days
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
how to take the back up the log files for n days
Hi,
how to take the back up the log files for n days
thanks,
sudhakar
how to take the back up the log files for n days
thanks,
sudhakar
i need to know datastage
This query may help you
Where nn is the jobnumber.
Code: Select all
SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can, by invoking TCL from the command line.
But, as Arnd suggests, this is not future proof. In the next release ("Hawk"), job logs are not stored in this fashion.
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';"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.