Loading into db2 using db2z stage
Posted: Fri Jan 15, 2010 6:42 pm
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.......
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.......