DS jobs

[das_nirmalya]

In which directory datastage generally store its jobs in windows and Unix.
and whats its extension.

[ag_ram]

Supposing that you work on DataStage 7.x(as you mentioned)

In Windows:

C:\Ascential\DataStage\Projects\<Project Name>

And DataStage does not store the DS Jobs as it is, instead it stores all metadata in different types of Hashed files in this directory for files/file entries generated at Design time and Run time of a Job.

A few DataStage files:

Code: Select all

DS_JOBS
DS_JOBOBJECTS
DS_DATATYPES
DS_CONTAINERS
DS_METADATA
DS_ROUTINES
DS_STAGETYPES
DS_AUDIT
DS_TRANSFORMS

Do a search over these terms in this site for more information.

[das_nirmalya]

Supposing that you work on DataStage 7.x(as you mentioned)

In Windows:

C:\Ascential\DataStage\Projects\<Project Name>

And DataStage does not store the DS Jobs as it is, instead it stores all metadata in different types of Hashed files in this directory for files/file entries generated at Design time and Run time of a Job.

A few DataStage files:

Code: Select all

DS_JOBS
DS_JOBOBJECTS
DS_DATATYPES
DS_CONTAINERS
DS_METADATA
DS_ROUTINES
DS_STAGETYPES
DS_AUDIT
DS_TRANSFORMS

Do a search over these terms in this site for more information.

Thank you,
can you pls tell me in case Unix where it store?

[ArndW]

For both Windows and UNIX the administrator can choose a different path for each project. The files listed above will be in the project directory.

[ag_ram]

For both Windows and UNIX the administrator can choose a different path for each project.

Yes. The project location can be choosen when the project is added using DS Administrater Client.

The mentioned location is the default location of the DataStage Project.

[ArndW]

thanks for confirming what I stated, ag_ram.

[sachin1]

also @PATH system variable can you the information.

[ray.wurlod]

DO NOT, whatever you do, attempt to edit these objects using a UNIX editor. You WILL corrupt them by doing so.

[das_nirmalya]

For both Windows and UNIX the administrator can choose a different path for each project. The files listed above will be in the project directory. ...

Thank you
Suppose i designed a DS job (say XYZ) in Designer and compiled it, it is working fine in director. Now i want to execute it from Unix . From which directory i can run this XYZ job. What will be the command.

[deanwalker]

Search for 'dsjob', this is used to run jobs from the command-line, specifying server,project,job,parameters,...

[ag_ram]

Now i want to execute it from Unix . From which directory i can run this XYZ job. What will be the command.

Directory: /opt/Ascential/DataStage/DSEngine/bin
Command :

Code: Select all

'dsjob' Command Syntax:
        dsjob [-file <file> <server> | [-server <server>][-user <user>][-passwor
d <password>]]
                        <primary command> [<arguments>]

Valid primary command options are:
        -run
        -stop
        -lprojects
        -ljobs
        -linvocations
        -lstages
        -llinks
        -projectinfo
        -jobinfo
        -stageinfo
        -linkinfo
        -lparams
        -paraminfo
        -log
        -logsum
        -logdetail
        -lognewest
        -report
        -jobid

use -run option of dsjob.

[ArndW]

The location of the "dsjob" executable has nothing to do with the projects and their locations. It is determined by the administrator when installing DataStage and the default locations depend upon which operating system is used.
The location is best found by using $DSHOME/bin/dsjob; and the DSHOME environment variable, if not set, can be set using the value in "/.dshome" on most systems.

[ag_ram]

Regretting that a mistake unknowingly happened and i edited my post.

[chulett]

You can 'run' dsjob from any directory as long as $PATH is setup correctly.