DB2 Enterprise User Defined Query

[srikanthd1978]

.. 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

[ray.wurlod]

Check your configuration file.

The reported error is "a node of the producing operator, ccsidbu1,
has no disks in the default disk pool".

Does this coincide with that your configuration file specifies?

[srikanthd1978]

ray,

the following is how the node ccsidbu1 is defined as

node "ccsidbu1"
{
fastname "ccsidbu1"
pools "DB2"
resource DB2 "1" {pools "DB2"}
resource disk "/opt/etl/staging/mad/resource/dataset/dataset1" {pools "DB2"}
resource scratchdisk "/tmp/" {}
}

is this related to space , i mean not enough resource space or scratch space..

thanks

[Eric]

You may also need to check permissions, the DB2 users may need access to the resource disk as well as the user running the DataStage job.