Importing dsx using command line

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
thanush9sep
Premium Member
Premium Member
Posts: 54
Joined: Thu Oct 18, 2007 4:20 am
Location: Chennai

Importing dsx using command line

Post by thanush9sep »

Hi all,

I took a export of the project from the DataStage Manager choosing the options a) Job Design b)Executables including program sources

1. While I tried to import the dsx with the DataStage Manager, all the jobs were imported successfully and all Job design were available and I was able to run the Master sequence properly... No issue here

2. While I tried to import the dsx from the command line using the following command

$DSHOME/bin/dsjob -import dstage_APS Corpor.dsx -OVERWRITE > $HOME/LOG/Corpor.log

and I got the log like:

Starting import for executable of job: JX_001_CORPORATE_AUDIT_EXCH_RATE

...Temporarily renaming previous job 'JX_001_CORPORATE_AUDIT_EXCH_RATE' to 'JX_001_CORPORATE_AUDIT_EXCH_RATE$temp$'

...Creating new job 'JX_001_CORPORATE_AUDIT_EXCH_RATE'

Creating file RT_CONFIG2016

Creating file RT_STATUS2016

Creating file RT_LOG2016

Creating file RT_BP2016

Creating file RT_BP2016.O

Creating file DS_TEMP2016

...Deleting previous job 'JX_001_CORPORATE_AUDIT_EXCH_RATE'

Deleting file RT_CONFIG1976

Deleting file RT_STATUS1976

Deleting file RT_LOG1976

Deleting file RT_BP1976

Deleting file RT_BP1976.O

Deleting file DS_TEMP1976

Deleting file RT_SC1976

...'JX_001_CORPORATE_AUDIT_EXCH_RATE' imported OK


i) I tried to run the job using the following command

dsjob -server $DS_SVR -user $DS_USR -password $DS_PWD -run -jobstatus $DS_PROJECT JS_001_CORPORATE_GEO

ii) I was not able to see the Job Design and it gave me an error like "NO JOB DESIGN TIME INFORMATION AVAILABLE"

My question: Have I used the correct commandline IMPORT syntax to import the job design and executables or is there anything else I am missing

I went through IBM forum
http://www.ibm.com/developerworks/forum ... 0&tstart=0

Even the Parallel Job Advanced User Guide says

The dsjob command can be used to import job executables from a
DSX file into a specified project. Note that this command is only
available on UNIX servers.

so does it mean that job design cannot be imported from command line
Regards
LakshmiNarayanan
thanush9sep
Premium Member
Premium Member
Posts: 54
Joined: Thu Oct 18, 2007 4:20 am
Location: Chennai

Post by thanush9sep »

Well, as time passes
I think the import command imports only the job executable not the job design.
I wonder a Datastage projects without a job design would be useful or not.

Please correct me If any
Regards
LakshmiNarayanan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That is correct, that command line function will not import the 'design time information' in your version. As to how useful those jobs would be, that is debatable. It used to be the only option and IMHO made supporting versions outside of the dev environment problematical.

Stick with the GUI for the imports.
-craig

"You can never have too many knives" -- Logan Nine Fingers
thanush9sep
Premium Member
Premium Member
Posts: 54
Joined: Thu Oct 18, 2007 4:20 am
Location: Chennai

Post by thanush9sep »

Thanks Craig

I will put this topic as Resolved and explain the situation I have faced

1. I took a export of the project from Datastage Manager
2. Saved the .dsx in the DataStage home directory and imported the dsx from the command line
3. I found that there were no job design available in the Designer Canvas
4. While importing the dsx from the command line, Note that "Only the job executables will be imported" and not the job design
Regards
LakshmiNarayanan
Post Reply