DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
G.K.K
Participant



Joined: 13 May 2008
Posts: 61

Points: 728

Post Posted: Sun Feb 15, 2009 11:32 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
hi,

i want to take backup of particular folder in datastage IBM websphere PX through command line dsexport. but it seems we can take for a particular jobs alone as a backup. but i dont know how to take backup of all the jobs in a particular folder.

E.g: the below shows for particular job to take export,
dsexport /H=192.215.23.19 /U=kamal /P=password /O=1 MT-SEVER/PROJECT1 /xml /job=JOBNAME_KAMAL KAMAL.xml

but i dont know how to take a folder as backup? Sad please anyone help me in solving this. pls share this knowledge.

Thanks in Advance
kamal
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 38733
Location: Denver, CO
Points: 197762

Post Posted: Mon Feb 16, 2009 8:07 am Reply with quote    Back to top    

You can't - one job or the entire project are your two choices. You'd have to use the GUI to export a folder / category.

_________________
-craig

You may ask yourself, "Well, how did I get here?"
Rate this response:  
Not yet rated
Raftsman


since November 2006

Group memberships:
Premium Members

Joined: 26 May 2005
Posts: 331
Location: Ottawa, Canada
Points: 2688

Post Posted: Mon Feb 16, 2009 8:39 am Reply with quote    Back to top    

There is a way but you would need to use a DOS bat file. Follow this link to Kim Dukes website http://www.duke-consulting.com/. The is a BAT script that will help you accomplish your request.

_________________
Jim Stewart
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 38733
Location: Denver, CO
Points: 197762

Post Posted: Mon Feb 16, 2009 8:53 am Reply with quote    Back to top    

True. From what I recall it generates a list of job names in the category and then exports them one job at a time, appending. The key still being one job at a time. Wink

_________________
-craig

You may ask yourself, "Well, how did I get here?"
Rate this response:  
Not yet rated
kduke

Premium Poster


since February 2006

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 29 May 2003
Posts: 5086
Location: Dallas, TX
Points: 33874

Post Posted: Mon Feb 16, 2009 6:26 pm Reply with quote    Back to top    

There is a post on how to do this. You need to use Dwn_ExecTCL.exe to run a SELECT statement against DS_JOBS to get the job names in the category. Next you need to use the bat file to export these job ...

_________________
Mamu Kim
Rate this response:  
Not yet rated
G.K.K
Participant



Joined: 13 May 2008
Posts: 61

Points: 728

Post Posted: Mon Feb 16, 2009 10:38 pm Reply with quote    Back to top    

chulett wrote:
You can't - one job or the entire project are your two choices. You'd have to use the GUI to export a folder / category. ...



What is that GUI export .. in the above you mentioned?
Rate this response:  
Not yet rated
richdhan



Group memberships:
Premium Members

Joined: 12 Feb 2004
Posts: 364

Points: 2614

Post Posted: Tue Feb 17, 2009 12:26 am Reply with quote    Back to top    

Hi,

The GUI export is the one that is available through Datastage Designer.

--Rich
Rate this response:  
Not yet rated
G.K.K
Participant



Joined: 13 May 2008
Posts: 61

Points: 728

Post Posted: Tue Feb 17, 2009 12:36 am Reply with quote    Back to top    

richdhan wrote:
Hi,

The GUI export is the one that is available through Datastage Designer.

--Rich


what is the syntax for that GUI export? please share it!!!

thanks in advance
kamal
Rate this response:  
Not yet rated
richdhan



Group memberships:
Premium Members

Joined: 12 Feb 2004
Posts: 364

Points: 2614

Post Posted: Tue Feb 17, 2009 12:47 am Reply with quote    Back to top    

Hi,

The Export and Import options are available in DS Designer. There is no coding or syntax required.

I recommend that you go through the documentation.

http://dwbalie.googlepages.com/dsbooks.pdf

This is the DS 7.5 documentation but good for a start. Go through the Manager Guide.

HTH
--Rich
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 38733
Location: Denver, CO
Points: 197762

Post Posted: Tue Feb 17, 2009 6:10 am Reply with quote    Back to top    

G.K.K. in a private message wrote:
what is that GUI export of folder category? can u explain how to do it.. please!!

thanks in Advance
kamal

First off, please just post your questions in the forum thread, there's no need to also send two private messages with questions.

Secondly, Rich has already got you covered. This 'GUI' is the Manager in releases before 8.x and part of the Designer client now in 8. You can 'export DataStage components' either individually, by category or export everything in the attached project.

_________________
-craig

You may ask yourself, "Well, how did I get here?"
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51685
Location: Canberra, Australia
Points: 280696

Post Posted: Tue Feb 17, 2009 2:44 pm Reply with quote    Back to top    

Did you forward that private message to U ?

U is the name of one of our members. The second person personal pronoun in English is spelled "you", not "u". Please strive to maintain a professional standard of written communication when using DSXchange. You wouldn't document your work with SMS-style abbreviations, would you?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
lakshmi.vasu
Participant



Joined: 22 Oct 2009
Posts: 6
Location: Bangalore
Points: 35

Post Posted: Mon Feb 22, 2010 2:44 am Reply with quote    Back to top    

how to use Dwn_ExecTCL.exe to get the list of job names in the particular folder or category ?
Need help on this.

Thanks,
Lakshmi.

kduke wrote:
There is a post on how to do this. You need to use Dwn_ExecTCL.exe to run a SELECT statement against DS_JOBS to get the job names in the category. Next you need to use the bat file to export these job ...

_________________
Thanks,
Lakshmi
Rate this response:  
Not yet rated
lakshmi.vasu
Participant



Joined: 22 Oct 2009
Posts: 6
Location: Bangalore
Points: 35

Post Posted: Mon Feb 22, 2010 3:07 am Reply with quote    Back to top    

Hi Kamal,
You have posted a query how to take backup of a paricular folder through command line. Did you get a solution on this. Even i want to export the jobs in a particular folder. Please share the script if you have implemented this task as it would be useful for me as well.

Thanks in advance,
Lakshmi.


G.K.K wrote:
hi,

i want to take backup of particular folder in datastage IBM websphere PX through command line dsexport. but it seems we can take for a particular jobs alone as a backup. but i dont know how to take backup of all the jobs in a particular folder.

E.g: the below shows for particular job to take export,
dsexport /H=192.215.23.19 /U=kamal /P=password /O=1 MT-SEVER/PROJECT1 /xml /job=JOBNAME_KAMAL KAMAL.xml

but i dont know how to take a folder as backup? Sad please anyone help me in solving this. pls share this knowledge.

Thanks in Advance
kamal

_________________
Thanks,
Lakshmi
Rate this response:  
Not yet rated
lakshmi.vasu
Participant



Joined: 22 Oct 2009
Posts: 6
Location: Bangalore
Points: 35

Post Posted: Mon Feb 22, 2010 5:48 am Reply with quote    Back to top    

Hi,

Can you please share the script which is used to get the list of jobnames from a particular folder and then take the export of that folder
Please reply ASAP

Thanks in advance,


kduke wrote:
There is a post on how to do this. You need to use Dwn_ExecTCL.exe to run a SELECT statement against DS_JOBS to get the job names in the category. Next you need to use the bat file to export these job ...

_________________
Thanks,
Lakshmi
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 38733
Location: Denver, CO
Points: 197762

Post Posted: Mon Feb 22, 2010 8:53 am Reply with quote    Back to top    

lakshmi.vasu wrote:
Please reply ASAP

Why? What makes this urgent for Kim or anyone else for that matter? Confused

Search here for any DS_JOBS query and add a filter on CATEGORY. Any export would need to be done either for the entire project or one job at a time, as has been mentioned here over and over. So you solve your 'folder' conundrum by building a list of all jobs in that category and then exporting them one by one in a loop, appending the results. This too has been discussed many times here.

_________________
-craig

You may ask yourself, "Well, how did I get here?"
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours