.. 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 User Defined Query
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
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
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