DSXchange

For text columns from SQL Server, we have been using the LongVarChar data type within the OLEDB stage. This has worked fine with a length of 128K. But recently some of the users have decided to write complete novels in the text field. :roll: A SQL Server text field can be up to 2GB (2^31) but the DS...

Approximately (packet_size / row_size) or a small multiple thereof should be your starting point for experimentation. This makes sense. However, if the rows are typically larger than the packet size, each row will always be fragmented, and so the packet size really becomes no longer part of the equ...

The other day, I noticed a post asking about how to determine which routine/module is used by what other module. One post suggested a SELECT statement, another suggested the Usage Analysis capability -- but that is only valid if you've checked the option during import. That led me to wonder: Is ther...

Once DataStage Server had been selected as our ETL tool, I attended a one week class with an Ascential instructor. Personally, I felt the class was worthless to a great extent. The class took us through running the clients (which I could have just have easily done on my own) and went through buildin...

Finally reached a resolution with IBM. It seems this only occurs in 7.5 and prior. It is apparently fixed in 7.5.1 and beyond.

Now, as to why we are still running 7.5, that is a different story.

Finally reached a resolution with IBM. It seems this only occurs in 7.5 and prior. It is apparently fixed in 7.5.1 and beyond.

Now, as to why we are still running 7.5, that is a different story.

:lol: Yeah, they do know best. :wink: I actually understand the need for the quotes since AT is a command line program and so the quotes are required for it to treat it as a single value rather than breaking at the space. However, knowing that and that the quotes are put there by Director when the j...

On Windows Server, the AT command is used to schedule jobs on the server. In the process of creating the command, any string parameter containing spaces gets passed with quotes (") around it. This does not happen when running a job manually. For example, if the value of the parameter is CLIENT ...

No, all jobs in this sequence have only OK triggers. The exception stage is intended to catch everything else. From your responses, I gather that you agree the exception stage should have been triggered? Does Job A have a specific Failure trigger? This would be used in preference to the Exception Ha...

I have the "Log warnings after activities that finish with status other than OK" enabled on all my jobs for this purpose. I do use the "Logging text" ability in particular cases. Each Sequence stage has a 'Logging Text' property. Use that to leave clues about which stages are act...

When an exception stage is triggered, it is reported in the log as: "<controlling_stage>.JobControl (@<error_stage>): Will execute error activity: <exception_stage>" For example: "seqUpdatePatches.JobControl (@ImportPatch): Will execute error activity: Exception" On a typical run...

I have a sequence that has the "Automatically handle activities that fail" option set and includes an Exception stage to catch them. It has a couple job stages 'A' and 'B' with OK triggers feeding a sequencer (set to "All") and the sequencer feeds another job stage 'C' that ends ...

I've confirmed that, in both of the examples (below), the first and second values of the parameter set (delimited by slashes -- "0/50") are "Row Limit" value and the "Warn Limit" value visible from the Run dialog. When doing a "Validate" (rather than a "R...

ray.wurlod wrote:I did ask Ascential this question once, but they claimed it was proprietary knowledge and refused to tell me.

Thanks, Ray. I will research this further then. I have some ideas based upon the available options when running a job. I'll post back what I find.

When I view the properties for a uvsh.exe program from a task manager, I see something like the following as the command line: C:\Ascential\DataStage\Engine/bin/uvsh DSD.RUN seqProcessAgentSummary. 0/50/1/0/0 Or C:\Ascential\DataStage\Engine/bin/uvsh DSD.StageRun jobBuildAgentSummarySnapShot. jobBui...