Drop Tablespace Partition with RCQ and RC/U

book

Article ID: 192331

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Management for DB2 for z/OS - Administration Suite CA Endevor SCM Interface for DB2 for z/OS CA Endevor SCM Interface for Remote DB2 for z/OS CA RC/Extract for DB2 for z/OS CA RC/Migrator for DB2 for z/OS CA RC/Merger for DB2 for z/OS CA RC/Query for DB2 for z/OS CA RC/Secure for DB2 for z/OS CA RC/Update for DB2 for z/OS

Issue/Introduction


RCQ can drop a partition of a table space but RC/U does not will drop the partition.

Environment

Release : 20.0

Component : CA RC/Update for DB2 for z/OS

Resolution


Select the TCP table for alter.
 When in panel 'CA - Table Alter',
type LIMITS in the COMMAND line like (COMMAND ===> LIMITS) and hit ENTER.

This will enter panel 'Table Partitioning & Limit Key Values'.
In this panel is a line command under 'CMND'
type 'D' to delete the partition.