lookup error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
lookup error
Hi All,
My etl job sometimes aborts with this error;
Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table
can anyone please suggest me what might be causing this error message and the job to abort.
Thanks
Mark
My etl job sometimes aborts with this error;
Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table
can anyone please suggest me what might be causing this error message and the job to abort.
Thanks
Mark
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have not defined a default disk pool (one whose name is "") in your configuration file, but have used a stage type that requires the existence of the default disk pool.
Solution: add a default disk pool (ideally containing all resource disks).
Solution: add a default disk pool (ideally containing all resource disks).
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.
Don't really see how this can be a 'sometimes' thing, unless you mean you only use the Lookup stage sometimes or do lookups with this particular config file sometimes. Or are you saying that your problematic job sometimes works correctly and sometimes generates this error?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
lookup error
Actually now all the jobs are aborting (which ran successfully previously) with this error message;
Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table.
this is what I see in my config file;
{
node "node1"
{
fastname "XXXX"
pools ""
resource disk "/opt/IBM/IIS/dstage0" {pools "export"}
resource scratchdisk "/opt/IBM/IIS/scratch0" {pools "sort"}
resource scratchdisk "/opt/IBM/IIS/scratch0" {pools "buffer"}
}
node "node2"
{
fastname "XXXX"
pools ""
resource disk "/opt/IBM/IIS/dstage1" {pools "export"}
resource scratchdisk "/opt/IBM/IIS/scratch1" {pools "sort"}
resource scratchdisk "/opt/IBM/IIS/scratch1" {pools "buffer"}
}
}
Please advice me
Thanks
Mark
Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table.
this is what I see in my config file;
{
node "node1"
{
fastname "XXXX"
pools ""
resource disk "/opt/IBM/IIS/dstage0" {pools "export"}
resource scratchdisk "/opt/IBM/IIS/scratch0" {pools "sort"}
resource scratchdisk "/opt/IBM/IIS/scratch0" {pools "buffer"}
}
node "node2"
{
fastname "XXXX"
pools ""
resource disk "/opt/IBM/IIS/dstage1" {pools "export"}
resource scratchdisk "/opt/IBM/IIS/scratch1" {pools "sort"}
resource scratchdisk "/opt/IBM/IIS/scratch1" {pools "buffer"}
}
}
Please advice me
Thanks
Mark
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
lookup error
I executed df, it appears There is enough space in the directories;
Filesystem 512-blocks Free %Used Iused %Iused Mounted on
/dev/fs18 33554432 20534560 39% 457 1% /opt/IBM/IIS/dstage0
/dev/fs19 33554432 11569544 66% 405 1% /opt/IBM/IIS/dstage1
/dev/fs20 50331648 49999784 1% 56 1% /opt/IBM/IIS/scratch0
/dev/fs21 50331648 50001184 1% 51 1% /opt/IBM/IIS/scratch1
Thanks
Mark
Filesystem 512-blocks Free %Used Iused %Iused Mounted on
/dev/fs18 33554432 20534560 39% 457 1% /opt/IBM/IIS/dstage0
/dev/fs19 33554432 11569544 66% 405 1% /opt/IBM/IIS/dstage1
/dev/fs20 50331648 49999784 1% 56 1% /opt/IBM/IIS/scratch0
/dev/fs21 50331648 50001184 1% 51 1% /opt/IBM/IIS/scratch1
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
lookup error
[quote="Sainath.Srinivasan"]Add a default pool for all resources.
Alternatively change all jobs which uses the pools to use your named ones.
To include the available in default, append "" after each pool definition. ...[/quote]
I can't change in each job since i have around 200 etl jobs.
Can you please tell me how do I add default pool for all resources.
Thanks
Mark
Alternatively change all jobs which uses the pools to use your named ones.
To include the available in default, append "" after each pool definition. ...[/quote]
I can't change in each job since i have around 200 etl jobs.
Can you please tell me how do I add default pool for all resources.
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
lookup error
I changed the default pool in my configuration file and all jobs competed successfully.
Thanks All.
Thanks
Mark
Thanks All.
Thanks
Mark