IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Error : REASON 00C90099 , TYPE 00000210


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Gousiya Mulla

New User


Joined: 02 Jun 2008
Posts: 87
Location: Bangalore

PostPosted: Thu Oct 09, 2008 6:47 pm
Reply with quote

One job has abended giving the below error .
DSNT500I DSNUGBAC - RESOURCE UNAVAILABLE
REASON 00C90099
TYPE 00000210
NAME DB name .TB space.Partition number
DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40318' CAUSE=X'00C9000A'

One of the Partition has reached to its maximum limit .
Is there any way we can allocate/increase the Page/Partition limits .

Asked DBA team to alter DSSIZE but replied is not part of the Alter table space .

Can any one please help in this case .
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Fri Oct 10, 2008 12:38 pm
Reply with quote

Hi Gousiya,

Try to REORG the tablespace. Might Work.

Sushanth
Back to top
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Mon Oct 13, 2008 4:30 pm
Reply with quote

Hi,

Look at the below explanation. Might be of some help to you.

Explanation: An attempt was made to load data into a partition, but the partition is full. Based on the High Key value specified in the Index for each partition, utilities instructed Data Manager to load a record into the proper partition. This required Data Manager to build a new page with a page number one higher than the last page in the partition. However, this new page is in the next partition.

This abend reason code is issued by the following CSECT: DSNILPG

System Action: The requested action is not performed.

User Response: Redefine the High Key values in the Index and retry the load.

If you receive this code during a reorganization, query the catalog to check the PCTFREE and FREEPAGE values. You might be able to decrease the amount of free space to allow the REORG utility to complete successfully.

Thanks,
KJ
Back to top
View user's profile Send private message
Gousiya Mulla

New User


Joined: 02 Jun 2008
Posts: 87
Location: Bangalore

PostPosted: Tue Oct 14, 2008 2:52 pm
Reply with quote

Hi karthikaj ,

Thanks for your information . I already had look at the above from mainframe guides . But I thought might be some other easiest way can get .

Anyways I am only left with redifining my partition keys and I have done the same .
Back to top
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Tue Oct 14, 2008 2:55 pm
Reply with quote

Good to see that you got the solution.

Regards,
KJ
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts REASON 00D70014 in load utility DB2 6
Search our Forums:

Back to Top