Version 8.51 of Extended Parallel Server introduces three new or enhanced environment variables:
| Environment Variable | Description |
|---|---|
| IBM_XPS_PARAMS | The IBM_XPS_PARAMS environment variable now accepts a setting of the form 'USABLE_SPACES = space [, space ... ]' where space is a dbspace or dbslice. For more information about the USABLE_SPACES session environment setting, see Restricting DDL Storage Spaces. |
| IFMX_AIXKAIO_NUM_REQ | The maximum value that the IFMX_AIXKAIO_NUM_REQ environment variable supports on AIX 5.1 and 5.2 platforms is now 8192, which is twice the former limit of XPS 8.50 and earlier versions. For more information about this feature, see Expanded Parallel KAIO Requests on AIX Platforms. |
| IFMX_ROLES_WITH_GRANT | This new IFMX_ROLES_WITH_GRANT environment variable enables support for the WITH GRANT OPTION keywords of the GRANT statement for privileges granted to roles. Users who hold both DBA access privilege and a role that received privileges with this attribute can grant the privileges of the role to other users or roles. For more information about this feature, see Propagating Access Privileges Through Roles. |