Loading into db2 using db2z 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
suneelchallagali
Participant
Posts: 251
Joined: Tue Dec 02, 2008 3:09 pm

Loading into db2 using db2z stage

Post by suneelchallagali »

Hi,

I am trying load the data into db2 database which on main frames from sequential file using db2 z stage under properties tab it got so many options such as

Job Flow: SEQ_FILE--------------------------------->DB2Z_STAGE

mode= append
table name=abc
database name=123
database password=456
database username=777
transfer to = hostname of where db2 installed (main frames)
type file = ftp
dns prefix =abc

actually i dont what exact value need to be set for dsn prefix. i have set usr01.myzload value for dsnprefix and run the job i have got following errors

db2z_1:error occured during initializefromargs{}

main_program:error when inserting partitioner uri: ftp://hostname/'usr01.myzload.IN00000' is having following ftp error
db2z_1:when checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0


First Time i am using this stage please help if any has worked on it

Thank you.......
Post Reply