Get Locked DataStage Jobs via Shell Script
Atul Singh
December 17, 2021
== Like the below page to get the update Facebook Page Facebook Group Twitter Feed Telegram Group
Showing posts with label Job. Show all posts
Showing posts with label Job. Show all posts
Friday, 17 December 2021
Thursday, 16 December 2021
Get File Size in Transformer Stage - DataStage
Atul Singh
December 16, 2021
I have seen lot of cases where I have to get the file size or no of lines in file or any Linux command output in between job flow. The easy ...
Wednesday, 15 December 2021
Know your DataStage Jobs Status without Director
Atul Singh
December 15, 2021
Like the below page to get the update Facebook Page Facebook Group Twitter Feed Telegram Group
Wednesday, 23 December 2020
Trigger Jenkins Job Remotely
Atul Singh
December 23, 2020
In some cases, You want to trigger Jenkins Job Build from CLI or programmatic way rather than usual GUI operation where you have to login on...
Tuesday, 19 December 2017
How to export the datastage job in individual dsx
Atul Singh
December 19, 2017
This script will export the datastage jobs into individual dsx files as sometimes, we need individual dsx to maintain the code version or s...
Monday, 11 September 2017
Datastage Calling script in Remote Server
Atul Singh
September 11, 2017
Step 1: Setting up UNIX server to automatically login without prompt-ing a password. 1. SSH must be installed in both servers. (primary...
Thursday, 13 July 2017
Utility to Get Last Run Log of DataStage Job
Atul Singh
July 13, 2017
Love the new feature of IBM DataStage to fetch the last run log of any jobs with the help of "dsjob" command. In older version o...
Wednesday, 5 April 2017
NULL Handling in Sequential File Stage
Atul Singh
April 05, 2017
DataStage has a mechanism for denoting NULL field values. It is slightly different in server and parallel jobs. In the sequential file sta...
Tuesday, 6 December 2016
Import the jobs from DS windows client #iLoveScripting
Atul Singh
December 06, 2016
As we have discussed a script which can export the datastage jobs from your client system ( http://bit.ly/2frNPKj ) likewise we can write a...
Saturday, 5 November 2016
Export the jobs from DS windows client
Atul Singh
November 05, 2016
Datastage jobs Export/Import are occasional activity (Deployment time :-)) for a developer But it becomes very tedious if the job list are...
Tuesday, 11 October 2016
5 Tips For Better DataStage Design #16
Atul Singh
October 11, 2016
1. Use 4-node configuration file for unit testing/system testing the job. 2. If there are multiple jobs to be run for the same module. Arc...
Tuesday, 23 February 2016
DataStage Scenario #15 - Get First & Last Date of Last Month
Unknown
February 23, 2016
Design a job which can generate the First and Last date of Last Month and pass this into an SQL which executes inside a parallel job? ...
Monday, 1 February 2016
5 Tips For Better DataStage Design #8
Atul Singh
February 01, 2016
#1. Templates have to be created to enhance reusability and enforce coding standard. Jobs should be created using templates. #2. The temp...
Wednesday, 27 January 2016
How to get table list used in DataStage jobs ?
Atul Singh
January 27, 2016
While developing jobs in DataStage, sometimes we face this requirement to get all the table list which was used by our DataStage jobs, but ...
Sunday, 17 January 2016
Count of Jobs - A Quick DataStage Recipe
Atul Singh
January 17, 2016
What to Cook: How to count number of jobs in DS project Ingredients: Use dsjobs "-ljobs" command How to Cook: Go to D...
Wednesday, 23 December 2015
5 Tips For Better DataStage Design #6
Atul Singh
December 23, 2015
#1. If you are using a copy or a filter stage either immediately after or immediately before a transformer stage, you are reducing the eff...
Monday, 16 November 2015
List DataStage jobs which used this Parameter
Atul Singh
November 16, 2015
Open the DataStage Administrator Client Click on the Projects tab and select the project you would like to generate a list for. ...
Tuesday, 10 November 2015
Check Memory Utilization by Datastage processes
Atul Singh
November 10, 2015
While we are running lots of DataStage job on a Linux DataStage server or different environment are sharing the same server which cause th...
Friday, 30 October 2015
UpCase and DownCase String Function : DataStage Transformation
Atul Singh
October 30, 2015
Downcase(column): This function converts all the input character to LOWER case where input can be in any case. input =...
Wednesday, 28 October 2015
Left and Right String Function - DataStage Transformation
Atul Singh
October 28, 2015
Today, we will discuss two more datastage transformer functions - Left & Right. These two functions use to get or cut the string fro...
