Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

REASON 00C90099 TYPE 00000220

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon May 25, 2009 9:49 pm    Post subject: REASON 00C90099 TYPE 00000220
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Mon May 25, 2009 9:52 pm    Post subject: Reply to: REASON 00C90099 TYPE 00000220
Reply with quote

look at the manual to see to resource corresponding to type 220
work with Your support to find out why the resource was not available
and how to fix the issue

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.msgs/db2z_resourcetypes.htm
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon May 25, 2009 9:54 pm    Post subject:
Reply with quote

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1J15/SPTWQ2870

Found by using IBM Look-At: http://www-03.ibm.com/systems/z/os/zos/bkserv/lookat/
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon May 25, 2009 10:02 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon May 25, 2009 10:10 pm    Post subject:
Reply with quote

Possibly not enough space on the volume.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon May 25, 2009 10:17 pm    Post subject:
Reply with quote

Agree Dick, But its should be multi volume VSam file
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Mon May 25, 2009 10:20 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Mon May 25, 2009 10:20 pm    Post subject: Reply to: REASON 00C90099 TYPE 00000220
Reply with quote

Did You get any SMS messages related to allocation?
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon May 25, 2009 10:28 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 26, 2009 11:57 am    Post subject:
Reply with quote

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
View user's profile Send private message
Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Tue May 26, 2009 6:03 pm    Post subject: Reply to: REASON 00C90099 TYPE 00000220
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Ccompar BLOB (images of type jpg) on ... nihad DB2 0 Sun Feb 05, 2017 3:13 pm
No new posts Query using SUBSTRING on a column of ... sasanka DB2 5 Mon Jul 04, 2016 1:01 pm
No new posts Invalid frequency code, dataset descr... Bhanu Praveen JCL & VSAM 4 Fri Feb 05, 2016 10:43 am
No new posts Data Type and Size senthamizh DB2 2 Fri Aug 21, 2015 2:34 pm
No new posts IGGCSI00 R15 = 8, CSI reason = X'FFFF... steve-myers PL/I & Assembler 6 Thu Aug 06, 2015 10:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us