Search found 26 matches

by Palermo
Mon Jul 31, 2017 3:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to customize "Content-Type" for Hierarchical D
Replies: 0
Views: 2029

How to customize "Content-Type" for Hierarchical D

Hi All, Could you please advice how to add a value to "Content-Type: application" for the Hierarchical Data stage? I got the following error: RESTWSTextToTextBodyParser] [] the expected content type: application/json does not match the received content type: application/gsa-group https://s...
by Palermo
Tue Jul 11, 2017 1:44 am
Forum: General
Topic: The client session to the service tier is lost
Replies: 3
Views: 3782

You need to update the client to 11.3.1.2
by Palermo
Mon Jul 10, 2017 12:57 pm
Forum: General
Topic: Sequence job aborted after 'Waiting for job to start'
Replies: 8
Views: 4053

I don't know the details because I am a developer and I was not involved in solving the problem.
by Palermo
Thu Jul 06, 2017 2:00 am
Forum: General
Topic: Sequence job aborted after 'Waiting for job to start'
Replies: 8
Views: 4053

The support team reported that was GSKit. Now the problem was solved.
by Palermo
Mon Jul 03, 2017 10:06 am
Forum: General
Topic: Sequence job aborted after 'Waiting for job to start'
Replies: 8
Views: 4053

UCDI, At this time 44 jobs are running. OS was not updated. The Workload Management was disabled 1,5 year ago and I am not sure that the following parameters limit a number of running jobs: T30FILE=4096, RLTABSZ=480 (Maximum running jobs=900) CHulett - I agree with you. Support team opened PMR ticke...
by Palermo
Sun Jul 02, 2017 3:45 pm
Forum: General
Topic: Sequence job aborted after 'Waiting for job to start'
Replies: 8
Views: 4053

Sequence job aborted after 'Waiting for job to start'

Hi all, I faced a serious challenge. Sequence jobs have been aborting for the whole week and this happens with different sequence jobs chaotically. Before the jobs worked fine for the last 6 months. Here is an example of log. As you can see, TRIGGERS_JobSeq (1) ran PRCSSD_TRGGR_IND_SET_Y_PJob (2) bu...
by Palermo
Tue Dec 06, 2016 1:52 am
Forum: General
Topic: $PROJDEF in an encrypted variable replaced by a wrong value
Replies: 4
Views: 2558

I installed the patch and the issue was fixed. Thank you.
by Palermo
Thu Dec 01, 2016 1:40 pm
Forum: General
Topic: $PROJDEF in an encrypted variable replaced by a wrong value
Replies: 4
Views: 2558

Thank you very much. I think it will help me solve the problem. As I understand correctly, I should update my Director client. Now I have 11.3.1.2 version. Server version is 11.3. Which of versions should be used in my case or install fix pack? In the description of JR53246 mentioned 11.5.1.
by Palermo
Thu Dec 01, 2016 1:55 am
Forum: General
Topic: $PROJDEF in an encrypted variable replaced by a wrong value
Replies: 4
Views: 2558

$PROJDEF in an encrypted variable replaced by a wrong value

Hi Everyone, So, I have a problem when I reschedule my jobs which contain encrypted variables and have $PROJDEF as default, $PROJDEF is replaced by a wrong value. For example, $TEST=test in Administrator and this variable was added to a job and value was set $PROJDEF instead of *****. When I schedul...
by Palermo
Thu Aug 18, 2016 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: V 11.5 Netezza TWT Issue
Replies: 1
Views: 2405

1. Try to use User-defined SQL: truncate table [[table]]; insert into [[table]] (col1, col2) select col1, col2 from [[twt]]; 2. Try to create a temporary table and use in existing mode: https://s3.postimg.org/wx53iwff7/2016_08_18_221449.png 3. Insert Transformer stage between the source connector an...
by Palermo
Sun Jul 17, 2016 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record loaded issue
Replies: 6
Views: 4114

I suppose that data is dropped. Compare data type and length of columns between the connector stage and the target table, check runtime column propagation in stages.
by Palermo
Sun Jul 17, 2016 2:42 pm
Forum: General
Topic: Determine if a ExeCmd is invoked inside Exception Block
Replies: 7
Views: 4864

Re: Determine if a ExeCmd is invoked inside Exception Block

There is no variable to detect an exception. You can define an environment variable (for example, status_variable=0) with DataStage Administrator client and change it before running your shell script inside 'Exception Block' with 'Execute Command' stage in 'Command' filed. status_variable=1; sh /tmp...
by Palermo
Fri Jul 15, 2016 2:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to calculate sum in ?.checksum file under RT_BPxxx.O?
Replies: 1
Views: 1878

I found out how to calculate sum. After modifying osh file, run user routine which calls DSCheckSum:

Code: Select all

* 1: result (0-Error, 1-No Error)
* 2: JobName
* 3: Update (0-No, 1-Yes) ?.checksum file under RT_BPxxx.O folder

Call DSCheckSum (result,JobName,Update)

by Palermo
Thu Jul 14, 2016 10:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to calculate sum in ?.checksum file under RT_BPxxx.O?
Replies: 1
Views: 1878

How to calculate sum in ?.checksum file under RT_BPxxx.O?

Hi Everyone, I want to make a quick fix in osh file but when I modify osh file, DS resets compiled job status to not compiled in Director client. I think DS compares checksum between actual files and value from ?.checksum file under RT_BPxxx.O folder. How to calculate sum in '?.checksum' file or dis...
by Palermo
Wed Dec 09, 2015 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deadlock in DB2 z/OS
Replies: 4
Views: 3114

The job runs on multiple nodes. I think that the problem is on database side but I have no idea how to catch and reproduce the same situation and run on a single node because if I rerun the job finishes successfully. All the DB2 connectors work in sequential mode.