VED#STABI has more than 3% pending free pages

[sivakumar_kilari3]

Hi,

I have installed ecc ehp4 versi.on on windows and database db2 9.7 fp3 , when I am executing db02--->table space, the following warning message iam getting

Tablespace VED#STABI has more than 3% pending free pages

How to correct this waring message?

Thanks

Siva

[Former Member · Accepted solution]

Hello Siva,

Assuming that your cockpit is setup correctly with the reorgchk_all job set etc, You should check SAP note 899953.

Also, you should look at a tablespaces, database snapshot. Hwew you should see the values for number of pages, usable, used, pending free pages etc.

Check also the high water mark, if this has scope to be reduced, you can check note 486559

Regards,

Paul

[sivakumar_kilari3 · Accepted solution]

Thanks for your reply,

I think this sap 899953 note is helpful,

Can I ignore the warning message pending free pages

Thanks

siva

[Former Member · Accepted solution]

Hi Siva,

It depends on how much fragmentation there is here... you should have a closer look at the page usage under the space analysis in the dbacockpit, and using the methods mentioned above.

Regards,

Paul

[Former Member · Accepted solution]

Pending free pages are generally freed up when the system activity allows it. Usually what I do after reducing hwm (performing reorg) is to run db2 list tablespaces show detail

Check the pending free pages after you run this. If it still shows up, then wait for a restart. The system does not have any problems with "pending free pages" as they have already been released by the tablespaces.

[paul_power]

Hello Siva,

The pending free pages are referred to the number of pages in a table

space which would become free if all pending transactions are committed

or rolled back and new space is requested for an object.

Therefore as long as there are transactions (from database point of view) are running,

you will see pages in the "pending free" status.

Please also take a look at note 899953

899953 Pending free pages

Check the output of

db2 get snapshot for database on <sid>

db2 get snapshot for tablespaces on <sid>

Check the output for the section

Total number of pages =

Number of usable pages =

Number of used pages =

Number of pending free pages =

Number of free pages =

High water mark (pages) =

if you see a high number of pending free pages, as per note 899953

"

The pending free pages are not reclaimed until you add another extent

to any of the existing tables OR if you create another table to that

tablespace.

"

regards,

Paul

[donald_voorhees]

A quick and esy way to deal with these errors, and actually reclaim the free pages is to use DB6CONV.

Read SAP note 1513862