IBM Mainframe Forum

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

Reorganize your table so that it uses fewer extents - see your DBA

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