Defining DB2 Records › How Do You Maintain DB2 Infostorage Records? › DELETE: Deleting DB2 Records › Syntax › Examples

Examples

The following example deletes the OPTS record for the PROD DB2 subsystem.

DELETE OPTS SYSID(PROD)

The next example deletes the OPTS records for all DB2 subsystem IDs that begin with DB2.

DEL OPTS MSYS(DB2*)

The following example deletes a SAFELIST record for the PROD DB2 subsystem.

DEL SAFELIST.PLN SYSID(PROD)