Search found 511 matches
- Thu Mar 02, 2023 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unstructured stage - dynamic ranges
- Replies: 1
- Views: 20112
Unstructured stage - dynamic ranges
Hello Does anyone know how to set a dynamic range for the unstructured stage. I can pass the range as a parameter into the Range Expression but it doesnt update the Template Data Range. This means every time the Excel sheet changes I lose some data. Has anyone found a workaround for this ? Thanks Wh...
- Wed Feb 15, 2023 7:04 am
- Forum: General
- Topic: Datastage Health check
- Replies: 2
- Views: 7687
Datastage Health check
Hello I am looking to create a job that checks the health of Datastage before running a job. IBM support say I need to do this manually through the Admin console but I can't check that manually before each run. Has anyone come up with any good ways to check DS and the server before running a job ? T...
- Wed Feb 15, 2023 3:42 am
- Forum: General
- Topic: Datastage On Premises Pricing
- Replies: 1
- Views: 23102
Datastage On Premises Pricing
Hi I am currently starting negotiations for a two core production linux server with an IBM partner.Once the application goes into production we will need to get an additional two core development server. I'm wondering if anyone can give me an idea of what I should be paying for this. Obviously not t...
- Wed Jun 29, 2022 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SMTP Server Change
- Replies: 2
- Views: 10690
Re: SMTP Server Change
Found the answer.
I reconfigured the servers in the etc/mail/sendmail.cf file.
I reconfigured the servers in the etc/mail/sendmail.cf file.
- Wed Jun 29, 2022 1:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SMTP Server Change
- Replies: 2
- Views: 10690
SMTP Server Change
Hello
Our infrastructure team has recently changed our SMTP server from Lotus Notes to Outlook. None of my jobs will allow mails to be sent now.
I have changed the server in the common_event_mail.properties file, but this has not made any difference
Any suggestions
Thanks
Colin
Our infrastructure team has recently changed our SMTP server from Lotus Notes to Outlook. None of my jobs will allow mails to be sent now.
I have changed the server in the common_event_mail.properties file, but this has not made any difference
Any suggestions
Thanks
Colin
- Fri Sep 14, 2018 2:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Global Column Length Change
- Replies: 4
- Views: 3165
- Fri Sep 14, 2018 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Global Column Length Change
- Replies: 4
- Views: 3165
- Mon Sep 10, 2018 5:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Global Column Length Change
- Replies: 4
- Views: 3165
Global Column Length Change
Hello
I have a varchar(20) that I have to change to a varchar(200). This is across multiple stages in a job and multiple jobs.
I only have Datastage (No metadata workbench etc). Is there some way to do this (simply)?
Thanks
I have a varchar(20) that I have to change to a varchar(200). This is across multiple stages in a job and multiple jobs.
I only have Datastage (No metadata workbench etc). Is there some way to do this (simply)?
Thanks
- Wed Dec 06, 2017 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored procedure stage with DB2/ZOS 11 array functionality
- Replies: 0
- Views: 2450
Stored procedure stage with DB2/ZOS 11 array functionality
I am trying to test using the DB2 v11 array functionality to put values into a table which have been read in array format from DB2 e.g. PERSON_ID|PERSON_ID_2 COL1,COL2|A1,A2 Would write two records to a table PERSON_ID|PERSON_ID_2 COL1 | A1 COL2 | A2 I have not managed to get this to work, whereas o...
- Thu Nov 16, 2017 3:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Retry on JDBC connector
- Replies: 3
- Views: 5101
- Thu Nov 16, 2017 2:49 am
- Forum: General
- Topic: Detect Datastage Server is healthy
- Replies: 4
- Views: 4207
- Thu Nov 16, 2017 2:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Retry after failure - JDBC connector
- Replies: 2
- Views: 3595
Re: Retry after failure - JDBC connector
We have not been able to get to the bottom of why this is failing. Even though we have installed the latest JDBC connector we still get intermittent failures. I have asked the production team who run the DS script to re-run the script up to 5 times if they get an error code returned from the DS scri...
- Thu Nov 16, 2017 2:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unstructured Stage - Array index out of range
- Replies: 7
- Views: 8061
- Thu Nov 16, 2017 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Create SQL statements instead of using database stages
- Replies: 11
- Views: 8639
For reference and completeness, I am adding what we have decided to do after many weeks of discussion. We have two modes for our inserts - full and delta. Full is for an initial run when the business rules have changed and delta for daily differences. Old technique Full mode - Bulk load using DB2 co...
- Fri Nov 03, 2017 2:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unstructured Stage - Array index out of range
- Replies: 7
- Views: 8061