IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Temporary tables



IBM's flagship relational database management system
Post a reply

Temporary tables

Postby Panda15 » Mon Mar 14, 2011 3:42 pm

Hi

I am facing an issue where temporary tablespace is reaching 255 extents and application is still accessing it. What do i do to ensure that it allows the access still?

Thanks
Panda15
Panda15
 
Posts: 9
Joined: Sun Feb 27, 2011 8:05 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Temporary tables

Postby NicC » Mon Mar 14, 2011 6:04 pm

Reorganize your table so that it uses fewer extents - see your DBA
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top

Re: Temporary tables

Postby Panda15 » Tue Mar 15, 2011 8:29 pm

This is temporary table. It probably can't be reorganized. moreover, reorg is not possible, when the users are accessing it. is there a way that we can still allow access to it by users and can reduce the extents also as the same time?

Thanks
Panda15
Panda15
 
Posts: 9
Joined: Sun Feb 27, 2011 8:05 pm
Has thanked: 0 time
Been thanked: 0 time
Top
Post a reply

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks