DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 413
Location: New York City
Points: 4531

Post Posted: Tue Mar 27, 2018 6:46 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: For automatic validation purpose
Hello All,
Is there a way to check from command line that a connection could be established from the DataStage clients to Information Server?

We have a validation script to test the health of our ETL infrastructure but in case that a connection can not be established to the clients Production Support team won't be able to do much .. hence the need to add this check if there is way to avoid a manual check

We do check that the dsrpc daemon is up but due to an incident in one non-prod environment we discover that the daemon could be running and is possible that a connection can't established. We also use the Operational Console in case of any failures....

Let me know

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Tue Mar 27, 2018 7:46 am Reply with quote    Back to top    

I seem to recall that, at one time, you could issue the "dsjob" command from the Windows client command line. You would Need to get that executable (and associated libraries) from the windows DataStag ...

_________________

Image
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: 54367
Location: Sydney, Australia
Points: 294901

Post Posted: Tue Mar 27, 2018 5:25 pm Reply with quote    Back to top    

The ISA Lite health check verifies this connection, though it's probably overkill for what you require. The dsjob.exe and dssearch.exe commands should be available on the client tier. Th ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 413
Location: New York City
Points: 4531

Post Posted: Wed Mar 28, 2018 6:22 am Reply with quote    Back to top    

Thanks to both of you.

My understanding is that dsjob uses a different connection mechanism and the goal is to ensure that a connection via a DS client could be established. We don't have the luxury of recycling the services in the middle of the day

I will explore Ray's suggestions

A good news is that on the new 11.7 version we won't need to worry about it

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Rate this response:  
Not yet rated
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 413
Location: New York City
Points: 4531

Post Posted: Wed Mar 28, 2018 6:22 am Reply with quote    Back to top    

Thanks to both of you.

My understanding is that dsjob uses a different connection mechanism and the goal is to ensure that a connection via a DS client could be established. We don't have the luxury of recycling the services in the middle of the day

I will explore Ray's suggestions

A good news is that on the new 11.7 version we won't need to worry about it

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Rate this response:  
Not yet rated
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 692
Location: Malvern, PA
Points: 6561

Post Posted: Wed Mar 28, 2018 8:07 am Reply with quote    Back to top    

The only way to be sure is to use a "robot", automated keystroke routines that replace the user actions. We are using Blue Prism for similar work, replacing high-volume, repeated user activity (like acting on data defects that require updates via a user interface).

Good luck.

_________________
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: http://www.dsxchange.com/viewtopic.php?t=143596 Using CFF FAQ: http://www.dsxchange.com/viewtopic.php?t=157872
Rate this response:  
Not yet rated
DSUser2000
Participant



Joined: 20 Oct 2009
Posts: 41

Points: 499

Post Posted: Mon Apr 16, 2018 9:45 am Reply with quote    Back to top    

Datastage Designer does have command line parameters so that you can start without any interaction:
dsdesign.exe /H=<host> /D=<domain> /U=<user> /P=<password <project>
By this, you only need to check if it opened and then close it.

It could also be enough if you check other things which are fully command-line-tools:
- Job export/import using istool: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.iisinfsv.assetint.doc/topics/commandset.html
- Job Compilation: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.design.doc/topics/r_ddesref_Compiling_from_the_Client_Command_Line.html
- Generate a job report: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.design.doc/topics/r_ddesref_Requesting_a_Job_Report_from_the_Command_Line.html This one also uses dsdesign.exe so it should show a pretty comparable result to the normal client...
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