Table and fragment pfsc_boost argument: Enable or disable a boosted partition free space cache (PFSC)

You can enable and disable a boosted partition free space cache for a table or fragment using SQL administration API admin() or task() functions and arguments.

The built-in SQL administration API admin() or task() functions are defined in the sysadmin database of each Informix® instance. By default, only user informix can invoke these functions. If Connect privilege on the sysadmin database is granted to user root or to DBSA group members, they too can invoke the SQL administration API admin() or task() functions when they are connected directly or remotely to the sysadmin database.

The SQL administration API admin() or task() command arguments that you can use to enable or disable boosted PFSCs in tables and table fragments are:

table pfsc_boost enable: Use the "table pfsc_boost enable" sysadmin task() or admin() command to create a boosted PFSC for a table. For example:
```
execute function task("table pfsc_boost enable", "<table name>", "<database name>");
```
fragment pfsc_boost enable: Use the "fragment pfsc_boost enable" sysadmin task() or admin() command to create a boosted PFSC for a specific fragment. For example:
```
execute function task("fragment pfsc_boost enable", "<partnum>");
```
table pfsc_boost disable: Use the "table pfsc_boost disable" sysadmin task() or admin() command to disable a boosted PFSC for a table. For example:
```
execute function task("table pfsc_boost disable", "<table name>", "<database name>");
```
fragment pfsc_boost disable: Use the "fragment pfsc_boost disable" sysadmin task() or admin() command to disable a boosted PFSC for a specific fragment. For example:
```
execute function task("fragment pfsc_boost disable", "<partnum>");
```

Note: Boosted partition free space caches are re-created automatically in shared memory on server restart.

Note: The oncheck -p[tT] “TBLspace Flags” section will contain the string “Boosted partition free space cache” if a table or fragment has a boosted PFSC.

For more information, see Boosted Partition Free Space Caches (PFSC).