Search found 57 matches

by ramesh_inform
Tue Nov 11, 2008 4:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TPT(teradata parallel transporter) error
Replies: 4
Views: 3652

we are using different sync id's for different TPT stages and different jobs
by ramesh_inform
Tue Nov 11, 2008 4:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TPT(teradata parallel transporter) error
Replies: 4
Views: 3652

yes the sync table is one and the same. but we are using different sync ID's.
by ramesh_inform
Tue Nov 11, 2008 2:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TPT(teradata parallel transporter) error
Replies: 4
Views: 3652

TPT(teradata parallel transporter) error

we are doing a version migration as well as database migration in our project. version migration is from 7.5.2 to 8.1 and database migration from DB2 to teradata we exported our jobs in current environment and imported into new environment. we changed our target DB2 stages to TPT stage we sometimes ...
by ramesh_inform
Thu Oct 23, 2008 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: teradata connector stage
Replies: 4
Views: 2938

when i tried to view performance statistics it is showing 1080105 records got loaded.

I could see only 1077570 records from the table(select count(*) from tablename)
by ramesh_inform
Thu Oct 23, 2008 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: teradata connector stage
Replies: 4
Views: 2938

teradata connector stage

we are replacing DB2 stage with teradata connector stage. the design is as follows dataset--->modify----->teradata connector Iam getting the following error. CC_TeraAdapter::selectLoadErrorTable1, file CC_TeraAdapter.cpp, line 7,056) [pxbridge.C:2833 I observed the data and it is fine I have 1080105...
by ramesh_inform
Tue Oct 21, 2008 3:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change from DB2 to teradata connector stage
Replies: 5
Views: 3055

Change from DB2 to teradata connector stage

I just replaced DB2 stage with teradata connector stage. the job is running fine before with DB2 stage. After replacing with connectoer stage it shows the following error "main_program: Fatal Error: Transfer does not have this output interface as its destination. [api/interface.C:199]"[/b]...
by ramesh_inform
Tue Sep 23, 2008 10:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacing DB2 enterprise stage with teradata enterprise stag
Replies: 11
Views: 4285

thanke every one ...we are doing it manually :)
by ramesh_inform
Mon Sep 22, 2008 10:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacing DB2 enterprise stage with teradata enterprise stag
Replies: 11
Views: 4285

hamzaqk

Could u please give me some idea on how to proceed? :o
by ramesh_inform
Mon Sep 22, 2008 1:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacing DB2 enterprise stage with teradata enterprise stag
Replies: 11
Views: 4285

around 1500 jobs..........
anyways i dont think changing the dsx will be the feasible solution.
It is not possible. i've tried many ways but unsuccessful.
by ramesh_inform
Sat Sep 20, 2008 9:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacing DB2 enterprise stage with teradata enterprise stag
Replies: 11
Views: 4285

replacing DB2 enterprise stage with teradata enterprise stag

Hi Iam involved in a mogration project where we are migrating from DB2 platform to Teradata platform. So there are several jobs where the target stage is DB2 and they need to be changed to Teradata. Is there any way that we can take export of job which contains DB2 stage and change the script to mak...
by ramesh_inform
Sun Aug 24, 2008 11:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: View data error on the dataset
Replies: 2
Views: 2071

fore most thing is that the question is incomplete 1.probable answer may be there may be "0" rows in your dataset/sequential file(whatever you are trying to view). 2.after clicking 'yes' in the message "no rows were returned......" on the right most corner check the box "vie...
by ramesh_inform
Thu Jul 03, 2008 5:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify
Replies: 10
Views: 4764

oddjob,


yes i did the same
but iam getting junk values in the output
by ramesh_inform
Thu Jul 03, 2008 4:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify
Replies: 10
Views: 4764

yes
how to remove the warning?
by ramesh_inform
Wed Jul 02, 2008 9:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: modify
Replies: 10
Views: 4764

i created a sample job DB2--->modify------>sort------->DB2 i used the following transformation REMARK_OCCR_NR : nullable string[5] = REMARK_OCCR_NR job ran but with following warnings modify: When checking operator: When binding output schema variable "outRec": When binding output interfac...