Designer Implementation in Data Stage
Designer
(a) Import/ Export
(b)Node configuration
(c)Advanced find
(a) Import/ Export
We can import and export entre project or individual components of repository
To more jobs from 1 project to other
job backups
Export :- (Project – India /DWS)
C :/ Document and setting / admin/ desktop/Backup. new àJob components to export
[Export job designs with executables read only items]
Type of export DSX (platform dependent) XML (independent) àExportàExport complete
To add a new file to already existing one
- Append to existing file
We are Storing the back up file in the Desktop
Desktop click on Backup. New openyou can view an basic Script
We can also view through command line prompt
DS export
DS import
Open a Designer client – with new project :-
Import :- (project – India/ Analyzer project)
Data stage components import from file (Browse the file that we saves in export)
- Import Selected
- performance analysis ok
| Data Stage Import | |
| Type 1 | Name Status |
| Table definition …………………. | |
| Job definition ……………… | |
| Job definition ……………….. |
Multiple Job Compiler
To compile n no. of Jobs Tools Multiple Job Compile parallel Next Remove all And select required Jobs Next Next Start Compile show compile report when finished
Opens a Note pad
- Data stage Compilation Report
Server : India
Project :dws
Started at :
Finished at :
Time Taken :
3items processed
2 items compiled Successfully
1 items failed compilation
Compile information list compiled ok
Can Multiple users run the same job at some time ?
Sol:- when 2 or more people run the same job at same time with different parameters, use an option / enable the job option
Allow Multiple instances
Open any job job properties parameters
Can 2 persons open the job at same time ?
Sol :- yes
1st person will have Read, write options
2nd person will have only Read option
Note:-
w can’t run the Multiple jobs at same time in Designer
we can run Multiple jobs at same time in director
To run Multiple Jobs at same time in director
It asks for Invocation Id
Invocation Id
A user defined identification to run a job for that instance
It is creating an instance
In the output, different users should give different output extensions
Example:- abc (1.txt) abc (2.txt)
Tool Run Director click on the jobàIn vocation id1000Any number
Scheduling
Click on any Job Right click Add to schedule Set the time
(b) Node Configuration
Its not our Role, DSA will do it
For Sometimes we need to run a job on particular node Configuration, then we use Node configuration.
Example
A Data set is created on 4 nodes abut we created a job on 2 nodes
àwhile we run, it aborts à SO, we need to make Sure that it run on 4 nodes using Node Configuration.
Questions based on Node Configuration
What is a Node ?
Sol :- logical CPU
What is Node Configuration ?
Sol :- Technique of creating logical CPU’s
How to See Nodes ?
Sol :- 3 ways to see Nodes :-
- check at logs
- configuration file
- Job Score
Learn DataStage by Tekslate - Fastest growing sector in the industry.Explore Online DataStage Training and course is aligned with industry needs & developed by industry veterans.
Tekslate will turn you into DataStage Expert.
(a) check at logs
Tools run director click on log Select Main program : APT configure file Node details are displayed
(b) configuration file
(Real time it is disabled)
Tools configuration default node details are displayed
(c) Job Score
Job properties parameters Add environment variables ReportingReport Score Report Score = True Report comes in log
What are Node Components
Sol :-
- Node Name - logical CPU name
- fast Name - Server name or system name
- Pools – logical area where stages are executed
- resource – memory associated with node
Disk – permanent
“C :/ IBM / Information Server / Server/ Datasets”
Scratch disk - temporary
“C :/ IBM / Information Server / Server/ Scratch”
What is default config file name ?
Sol :- every job is exe on default. Apt (actual parameter)
How many nodes in your project ?
Sol :- 8 or 16 (2^0, 2^1)………….
How to create a new Node Configuration file ?
Sol :- Tools configurations copy the code Select New part the Code 3 or 4 times change the node Names Node 1 Node2 Node 3……Save configuration check configuration configured ‘0’ errors detected
How to run a job on a Specific Config file ?
Sol :- $apt- config- file Job properties parameters Add Environment variables Parameter name $ apt – config – file ok
Compile and RUN
We can browse and change the path
if uni processing System with 1 CPU needs minimum 1 node to run a job, then for SMP with 4 CPU needs How many minimum nodes ?
Sol :- 1 Node
For indepth understanding of DataStage click on