Search found 1315 matches
- Mon Oct 08, 2018 7:23 am
- Forum: General
- Topic: DataStage Job Deployment Datetime from XMETA Database
- Replies: 4
- Views: 4149
I created a datastage job that I run as my admin user id. I connect to xmeta and run the following extract. SELECT DSNAMESPACE_XMETA, NAME_XMETA, XMETA_MODIFIED_BY_USER_XMETA, (TIMESTAMP('01/01/1970', '00:00:00') + (XMETA_MODIFICATION_TIMESTAMP_XMETA / 1000) SECONDS) - 8 HOURS AS XMETA_MODIFICATION_...
- Tue Sep 04, 2018 8:28 am
- Forum: General
- Topic: Double Down Event
- Replies: 1
- Views: 2030
I remember the last IBM conference I attended in Vegas... I'm standing next to Ray W and Ray D (lead admin at WM), chatting away when the other lead admin from WM (my old stomping grounds) sees Ray D and shoves a camera into my hands asking me to take their picture. The green horn was a tad star str...
- Tue Sep 04, 2018 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Jobs are aborting
- Replies: 6
- Views: 3525
- Tue Sep 04, 2018 8:19 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6947
- Fri Aug 31, 2018 8:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Jobs are aborting
- Replies: 6
- Views: 3525
- Tue Aug 21, 2018 11:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem Extracting Data From Oracle Database
- Replies: 9
- Views: 4735
I would reach out to your Oracle DBA team to see if Stats were gathered on those tables. From what I remember, there is something on the Oracle side that you can do to optimize an execution. I know that when it was done... fast result sets, when it wasn't done in a long time... poor performance. I s...
- Mon Jul 30, 2018 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we copy Datasets from one server to another?
- Replies: 11
- Views: 7648
- Wed Jul 25, 2018 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we copy Datasets from one server to another?
- Replies: 11
- Views: 7648
if you make your own schema, then you do not have to worry about an APT file that has different node name info. You could even have a different degree of parallelism. I'm dead set against someone copying over the .ds header file to another host. that is just plain silly. shame on IBM for recommendin...
- Wed Jul 25, 2018 10:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we copy Datasets from one server to another?
- Replies: 11
- Views: 7648
Andy, that method lacks the schema information that will be required for the dataset. The method I listed above is basically that + schema. I'm (not) surprised that IBM left the schema information out of their explanation. How the heck would you translate anything into a field other than a var char ...
- Tue Jul 24, 2018 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we copy Datasets from one server to another?
- Replies: 11
- Views: 7648
I have written a custom set of jobs to dump a generic named dataset (parm to the job) into a sequential file + a schema file. The schema file was created with the orchadmin command to dump the schema, filter that via a few awk commands and echo statements and you can easily recreate the schema text ...
- Wed Jul 18, 2018 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with asian UTF8 characters loading to Teradat
- Replies: 0
- Views: 1918
I would start with confirming the character set on the table with your TD DBA. I would then ensure that your TD connector stages are set to that character set. I would also ensure that your DataStage JOB is set to that character set. UTF16 is the most likely candidate since you are using a double by...
- Mon Jul 16, 2018 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: identifying conductor node in default pool
- Replies: 10
- Views: 4857
- Wed Jul 11, 2018 8:31 am
- Forum: General
- Topic: istool.sh ExportError:unable to create temporary archive fil
- Replies: 3
- Views: 4353
- Fri Jun 22, 2018 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Long time in completion of job, after executing all stages
- Replies: 3
- Views: 3053
- Fri Jun 22, 2018 7:40 am
- Forum: General
- Topic: DataStage application is running too slow
- Replies: 8
- Views: 5784