DB2 Enterprise User Defined Query
Posted: Thu Nov 18, 2004 9:41 am
.. I am using a User defined query in the DB2 Enterprise stage to extract data and i am trying to throw it to a dataset..i do not have nay operators in between..
Db2 enterprise( Exec Mode: Sequential) --> dataset( exec mode: Parallel)
( usr defined qry)
I get the follwoing error..
main_program: Fatal Error: Could not create the output file dataset /opt/etl/staging/mad/work/lkpfileset/lkpDS_GDAcctDDAHIghLow.ds,
because a node of the producing operator, ccsidbu1,
has no disks in the default disk pool.
This step has 1 dataset:
ds0: {op0[1p] (sequential DDAHigh_LowActvTables)
->
/opt/etl/staging/mad/work/lkpfileset/lkpDS_GDAcctDDAHIghLow.ds}
It has 1 operator:
op0[1p] {(sequential DDAHigh_LowActvTables)
on nodes (
ccsidbu1[op0,p0]
)}
It runs 1 process on 6 nodes.
however when i change the execution mode of the Dataset to be sequential , the Job succeeds..and also if i put any other operator like copy, modify..in between the Enterprise and dataset without doing any modifications to the execution mode ..the Job succeeds..
any thought on this behaviour..
thanks
Db2 enterprise( Exec Mode: Sequential) --> dataset( exec mode: Parallel)
( usr defined qry)
I get the follwoing error..
main_program: Fatal Error: Could not create the output file dataset /opt/etl/staging/mad/work/lkpfileset/lkpDS_GDAcctDDAHIghLow.ds,
because a node of the producing operator, ccsidbu1,
has no disks in the default disk pool.
This step has 1 dataset:
ds0: {op0[1p] (sequential DDAHigh_LowActvTables)
->
/opt/etl/staging/mad/work/lkpfileset/lkpDS_GDAcctDDAHIghLow.ds}
It has 1 operator:
op0[1p] {(sequential DDAHigh_LowActvTables)
on nodes (
ccsidbu1[op0,p0]
)}
It runs 1 process on 6 nodes.
however when i change the execution mode of the Dataset to be sequential , the Job succeeds..and also if i put any other operator like copy, modify..in between the Enterprise and dataset without doing any modifications to the execution mode ..the Job succeeds..
any thought on this behaviour..
thanks