Drop Tablespace Partition with RCQ and RC/U

Products

• RC Compare for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Endevor Interface for Db2 for z/OS
• Endevor Interface for Remote Db2 for z/OS
• RC/Extract for DB2 for z/OS
• RC/Migrator for DB2 for z/OS
• RC/Merger for DB2 for z/OS
• RC/Query for DB2 for z/OS
• RC/Secure for DB2 for z/OS
• 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.