teatadata connector stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
iskapalli
Participant
Posts: 76
Joined: Wed Jul 25, 2007 12:36 am

teatadata connector stage

Post by iskapalli »

Hi,

terdata Upgrade was happend recently in the produciton. Before terdata Upgrade job is runing fine. After that job is failing with below error.
error message:
[IIS-CONN-TERA-005004] RDBMS code 220: Completed successfully. SQL statement: SELECT

it is throwing error while extracting the data from the teradata connector stage.

properties;

transactin mode= ANSI
client character set= UTF8
automap characterset encoding= yes
logon mechanisam= TD2
generate sql=no
enable quote identfiers=no
access method=buld
record count=
array size
sleep=0
tenacity=0


max session=0
mix partion sessions=0
min sessions=0
max buffer size=0
progress intervel 100000
parallel synchronizaiton no
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

"Completed successfully" does not strike me as being an error. Perhaps you can be a bit more explicit about the actual error you allege is being thrown, which would allow more targeted diagnosis.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Might also be handy to state FROM and TO versions for TD upgrade.
Post Reply