LISTDEF

The LISTDEF utility enables you to group database objects into reusable lists. You can then specify these lists in other utility control statements to indicate that the utility is to process all of the items in the list.

You can use LISTDEF to standardize object lists and the utility control statements that refer to them. This standardization reduces the need to customize or alter utility job streams.

If you do not use lists and you want to run a utility on multiple objects, you must run the utility multiple times or specify an itemized list of objects in the utility control statement.

Output

Output from the LISTDEF control statement consists of a list with a name.

Authorization required

To execute the LISTDEF utility, you must have SELECT authority on SYSIBM.SYSINDEXES, SYSIBM.SYSTABLES, and SYSIBM.SYSTABLESPACE.

Start of changeYou must use a privilege set that includes one of the following authorities:End of change

Start of change
  • SELECT authority on SYSIBM.SYSINDEXES, SYSIBM. SYSTABLES, and SYSIBM.SYSTABLESPACE
  • SQLADM authority
  • DATAACCESS authority
  • System DBADM authority
  • SYSCTRL or SYSADM authority
End of change

Additionally, you must have the authority to execute the utility that is used to process the list, as currently documented in the "Authorization required" topic for each utility.

If you do not have authorization to execute the utility on one or more of the items in the list, the utility will stop on the first authorization error. To skip items in the list that return an error, use the OPTIONS (ITEMERROR, SKIP) control statement.

Execution phases of LISTDEF

The LISTDEF control statement executes entirely within the UTILINIT phase.