Search found 58 matches
- Mon Sep 27, 2021 11:28 am
- Forum: General
- Topic: InfoSphere DataStage Client logon fails
- Replies: 1
- Views: 14152
InfoSphere DataStage Client logon fails
Hi, I am in a situation to not able to login to datastage designer or director client from windows. Gives an error "failed to authenticate the current user against the selected Services Tier". However I am able to login through web console and manager client. Also I am able to login to the...
- Thu Nov 15, 2018 10:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Checksum Stage limitation
- Replies: 2
- Views: 3114
Checksum Stage limitation
Hi, I am using concatenated result of 5 columns (different datatypes) to calculate the checksum value. The problem is even though the concatenated string of the 5 columns is different, it is generating the same checksum value. Is there any restriction on the length of string (input value) to generat...
- Wed Aug 15, 2018 5:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change of namespace in xml
- Replies: 2
- Views: 2683
Change of namespace in xml
Hi, I have a problem for which I was unable to find some solution from the search. Posting it here. I have an exiting job with xml unpack stage to read the xml file and output data to some text files. Now there is a change in xsd from the source, change of namespace and additional elements Earlier t...
- Mon May 15, 2017 3:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Skip header record from complex flat file stage
- Replies: 9
- Views: 8218
- Thu May 11, 2017 2:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Skip header record from complex flat file stage
- Replies: 9
- Views: 8218
- Thu May 11, 2017 1:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Skip header record from complex flat file stage
- Replies: 9
- Views: 8218
Skip header record from complex flat file stage
Hi, I am receiving zipped binary (EBCDIC))complex flat file This is a fixed width file and contains a header record Could you please suggest how an I filter the header record in the complex flat file stage At the job level the file is being unzipped and on running the job, the job is failing with th...
- Wed Nov 16, 2016 10:25 am
- Forum: General
- Topic: Replication of scenario, Job sequence with status as CRASHED
- Replies: 15
- Views: 9135
- Fri Nov 04, 2016 2:06 pm
- Forum: General
- Topic: Replication of scenario, Job sequence with status as CRASHED
- Replies: 15
- Views: 9135
Hi Mike, The reason for CRASHED was because of an unplanned restart of the server and not because of resource issue or design issue. As suggested I would implement the manual intervention by email or by monitoring. The query still I have in my mind is why is the job restarting again automatically af...
- Fri Nov 04, 2016 12:03 pm
- Forum: General
- Topic: Replication of scenario, Job sequence with status as CRASHED
- Replies: 15
- Views: 9135
Personally, I would never attempt to automate the restart of a STOPPED or CRASHED job. These are unexpected ways for a job to end. I would require human intervention to perform analysis and take corrective action based on the analysis. Had to automate as per the project requirement. Would you sugge...
- Fri Nov 04, 2016 12:01 pm
- Forum: General
- Topic: Replication of scenario, Job sequence with status as CRASHED
- Replies: 15
- Views: 9135
It shouldn't restart, complete, and then run it all over again.... unless perhaps (just a guess) if there were multiple scripts or restart commands issued at the same time with the -wait option. I would want to try to reproduce that behavior, because it sounds like an unusual problem. It is a singl...
- Fri Nov 04, 2016 10:24 am
- Forum: General
- Topic: Replication of scenario, Job sequence with status as CRASHED
- Replies: 15
- Views: 9135
To stop the engine is difficult as there are other projects that are running on this server. $HOME_DS/bin/dsjob -jobinfo PROJECT SEQUENCE_NAME In the script logic validating if the status of the job is FAILED/STOPPED/CRASHED and if the job is restartable(check pointed sequence) In my case the sequen...
- Wed Nov 02, 2016 10:37 am
- Forum: General
- Topic: Replication of scenario, Job sequence with status as CRASHED
- Replies: 15
- Views: 9135
Replication of scenario, Job sequence with status as CRASHED
Hello All, I have below requirement to validate the status of a job/sequence before running the job from command line using dsjob $HOME_DS/bin/dsjob -jobinfo PROJECT SEQUENCE_NAME Validate the status of the job for the status of STOPPED/FAILED/CRASHED/ and reset the job in case encountered any of th...
- Wed Feb 10, 2016 5:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restructuring of data
- Replies: 2
- Views: 2038
Restructuring of data
I have to rearrange data from an activities table to have an activity and its consecutive activity in a single row from historical data which has each activity recorded (1 record for each activity) I have data similar to below in the history table id,app_id,task 1,1234,entry 2,3245,entry 3,1234,acce...
- Fri Dec 11, 2015 2:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Get Date from a String
- Replies: 4
- Views: 3070
- Fri Dec 11, 2015 9:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Get Date from a String
- Replies: 4
- Views: 3070