Error Selecting from logfile RT_LOGxxx DataStage

DataStage Director Error Message When try to view the log.

Error selecting from log file RT_LOGnn
Command was: SSELECT RT_LOGnn WITH @ID LIKE '1NON' COUNT.SU
Error was: Internal data error. File /RT_LOGnn/':
Computed blink of 0xnnnn does not match expected blink of 0xnnnn! Detected within group starting at address 0xnnnnnn!

Cause:

The error message received indicates that the log file for the job is corrupted.

Solution:

The Log file must be recreated.

We can try 3 things here.

1) Create a Copy of the Job and delete the old job and compile the new job

0r

2) Manully delete and re-create the RT_LOGxx , for this follow below steps.

1. Log on to DS Administrator and go to the Projects tab. Select the project in question and click on the "Command" button.
2. Delete the existing damaged log file with the following command, where xxx is the description number as seen in the error:
   Ex : DELETE.FILE DATA RT_LOG52
3. Create a new log file with the following command, where xxx is the description number as seen in the error:
   CREATE.FILE DATA RT_LOG52 30

Or 

# This will Clear the logfile of the Job

3)   CLEAR.FILE RT_LOG52 ( This will do the trick )

How to Save DataStage Job log from Director to a File

1. 
   
   When DataStage Director is opened it will open in the default view and displays the status of all jobs in the folder currently selected in the repository tree.
   
   
   You must change to the Job Log View.
   Job Log View - Displays the log file for a job chosen from the Job Status view or the Job Schedule view. To switch to this view, choose View > Log, or click the Log button on the toolbar.
   
   
   Remove any filter.
   Select View > Filter Entries
   Under the Limit Window - Select All entries
   Make sure all Types of Messages are selected
   Print out the Job Log to a flat file. The content of the printout depends on the view you are using and the options you choose in the Print dialog box. Print the current view:
   Do one of the following to display the Print dialog box:
   Choose Project > Print... .
   Click the Print button on the toolbar.
   Choose the range of items to print in the Range area: select
   All entries prints all entries in the current view.
   Choose what to print by selecting in the Print what area:
   Full details prints detailed information for each item.
   Select the Print to file check box.
   Click OK. The Print to file dialog box appears. Enter the name of a text file to use. The default is DSDirect.txt in the client directory.
   
   
   Source : http://www-01.ibm.com/support/docview.wss?uid=swg21574038

Replace a String on a First Line in Unix

sed -e '1s/FromString/ToString/' 20160804.txt > 20160804_new.txt

How to convert fixed width file to delimeted file in UNIX

Ex: awk -v OFS=, '{ print substr($0, 1, 1), substr($0, 2, 10), substr($0, 12, 4), substr($0, 16, 2), substr($0, 18, 2) }' FIX_COMMA.txt > CSV.txt