|
View previous topic :: View next topic
|
| Author |
Message |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi All,
I am trying to load the data in partition tablespace & got following error
UNEXPECTED PROCESSING ERROR, REASON=X'00E40318' ON TABLE
DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C90099
TYPE 00000220
I am just trying to load latest image copy data from production to test environment.Partition keys are also same in both the environment.
Please advise. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Dick & Enrico,
Thanks for this.
I already referred those manual but the question is its already existing in prod subsystem with same partition key & space then why its giving problem in test environment.
I have checked the number of allocated extents for that artition dataset & its only 8 so should be the problem related to max extet already allocated. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Possibly not enough space on the volume. |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
| Agree Dick, But its should be multi volume VSam file |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| Agree Dick, But its should be multi volume VSam file |
Why not just run a LISTCAT and find out for sure, rather than saying it should be one way or another? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Did You get any SMS messages related to allocation? |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Enrico,
I dis not get any sms related message .Just received follwoing error
UNEXPECTED PROCESSING ERROR, REASON=X'00E40318' ON TABLE
DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C90099
TYPE 00000220 |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
I echo Dick, Possibly not enough space on the volume.
| guptae wrote: |
| already existing in prod subsystem with same partition key & space then why its giving problem in test environment. |
Not necessarily test and production environment are tailored to deal with same volume of data and when DB2 attempted to load data into a partition, partition is full.
Based on the high key value specified in the index for each partition, the utility needs to load a record into the proper partition. Loading this record requires DB2 to build a new page with a page number that is one higher than the last page in the partition. However, this new page is in the next partition. |
|
| Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008
Posts: 193
Location: chennai
|
|
|
|
Hi guptae
What Anuj D posted is correct. You can do a REORG on the partition if you know the part number. That will remove the unused space from your tablespace/partition. As per the message by DB2, you are trying to load data into a partition. Based on the key value, DB2 tries to load into the appropriate partition, but no space available in that partition
Regards
Raghu |
|
| Back to top |
|
|
|
|
