Newbie question regarding a debugger
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Mon Jul 11, 2011 6:20 am
Newbie question regarding a debugger
Hi all,
i worked in the past with SSIS but now i've just started to use Datastage and i'm looking for something similar to the DataViewer of SSIS (an instrument to display data during the execution of job).
Is there something similar to it?
Could you suggest me some link/tutorial to start learning it?
Thanks in advance
Simon
i worked in the past with SSIS but now i've just started to use Datastage and i'm looking for something similar to the DataViewer of SSIS (an instrument to display data during the execution of job).
Is there something similar to it?
Could you suggest me some link/tutorial to start learning it?
Thanks in advance
Simon
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
The specific functionality you ask about is called the Data Browser in DataStage; it's invoked usually by clicking on a View Data button or link.
There is a tutorial that ships with DataStage software; find the tutorial manual in your documentation set and work with that.
The specific functionality you ask about is called the Data Browser in DataStage; it's invoked usually by clicking on a View Data button or link.
There is a tutorial that ships with DataStage software; find the tutorial manual in your documentation set and work with that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 7
- Joined: Mon Jul 11, 2011 6:20 am
Hi,
i saw the View Data button but (if i understand well) it works when i'm in design mode and not during the execution like the tool of SSIS.
About the documentation the software is not mine but it's installed at our customer server where we can connect just with remote desktop sofware and on that is installed ONLY Datastage and that's all. So, unfortunately, i cannot look at the tutorial you talked about it.
i saw the View Data button but (if i understand well) it works when i'm in design mode and not during the execution like the tool of SSIS.
About the documentation the software is not mine but it's installed at our customer server where we can connect just with remote desktop sofware and on that is installed ONLY Datastage and that's all. So, unfortunately, i cannot look at the tutorial you talked about it.
-
- Participant
- Posts: 6
- Joined: Wed Mar 09, 2005 9:35 am
Simon, it looks like you seek functionality that doesn't exist: debugging access to the data being processed while the job is running. DS provides Peek and other debug stages, but I don't see that helping you.
The only workaround I can think of is to insert copy stages at the points where you want to examine the data. The secondary link would be to a file stage. This would give you, at best, a hindsight perspective on the data at those points.
Good luck.
The only workaround I can think of is to insert copy stages at the points where you want to examine the data. The secondary link would be to a file stage. This would give you, at best, a hindsight perspective on the data at those points.
Good luck.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Considering the functionality DS offers, I was honestly surprised that PX did not have interactive debugging. Debug stages feels like an old-timer's solution, like inserting debug/display code into Cobol programs.chulett wrote:The Server product has always had an interactive debugger, thought the same would make it into the PX side of the house eventually but for whatever reason it hasn't happened yet.
That's my comparison point, and why I speculate that interactive debugging is likely far down on anyone's development list: Micro Focus' Cobol development suite has it, in spades, and the accompanying software and hardware footprint is enormous. I don't know of a Cobol developer who bemoans the cost -- indeed, Micro Focus provides economies and efficiencies for Cobol on the same scale as DS does for ETL -- but they had it very early on and kept it a high priority in subsequent versions. If IBM has to do something like it from scratch, I think we are are well-advised to not hold our breaths.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Point taken, Craig. Permit me a moment of cynicism, though: in the ETL world, where does DataStage stand? Is it at risk of losing market share, or would it remain competitive without what the competitors have? If the reality is the latter, I don't see them being motivated to get started.
Before I met Micro Focus, which thankfully was early in my Cobol career, I faced what most other Cobolers faced: massive assembler dumps, cryptic system and other software error messages, and legacy spaghetti code everyone prayed wouldn't break or wouldn't be assigned to them for maintenance or new code. I'm a relative newcomer to ETL and DataStage (four years in a vast realm does not make me a veteran, I would opine), and I've not seen an analogous aspect, certainly not in the DataStage environment. Shrug.
Before I met Micro Focus, which thankfully was early in my Cobol career, I faced what most other Cobolers faced: massive assembler dumps, cryptic system and other software error messages, and legacy spaghetti code everyone prayed wouldn't break or wouldn't be assigned to them for maintenance or new code. I'm a relative newcomer to ETL and DataStage (four years in a vast realm does not make me a veteran, I would opine), and I've not seen an analogous aspect, certainly not in the DataStage environment. Shrug.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage server jobs do have an interactive debugger. Creating one for parallel jobs is on IBM's roadmap, but it's a huge technical exercise - just imagine some of the challenges - for example tracing a row that may suddenly jump to a different machine on the network.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.