Start of change

-STOP CDDS (Db2)

The -STOP CDDS command directs all members of a Db2 data sharing group to close and deallocate the compression dictionary data set (CDDS).

Abbreviation: -STO CDDS

Environment for -STOP CDDS

This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program that uses the instrumentation facility interface (IFI).

This command must be issued from the source or proxy data sharing group in an implementation of the GDPS® Continuous Availability with zero data loss solution.

Data sharing scope: Group

Authorization for -STOP CDDS

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:

  • BSDS privilege
  • SYSCTRL authority
  • SYSADM authority

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. Start of changeA logged-on z/OS user ID must be defined in RACF or a similar security server.End of change

Syntax for -STOP CDDS

Read syntax diagramSkip visual syntax diagram STOP CDDS

Usage notes for -STOP CDDS

Before you can recover a logically damaged CDDS without bringing down its data sharing group, you need to issue -STOP CDDS. See Recovering the compression dictionary data set without bringing down a Db2 data sharing group in a GDPS Continuous Availability with zero data loss environment for more information.

Trace information for data sharing members
When this command with group scope is issued in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.

Examples for -STOP CDDS

Example: Making the CDDS unavailable to all members of a source data sharing group in a GDPS Continuous Availability with zero data loss environment
Issue this command:
-STOP CDDS

If the command is successful, output like this is displayed:

DSNJ375I - DSNJB101 CDDS DSNAME = cdds-name IS INACTIVE IN SOURCE MODE.                                                                                        
DSN9022I - DSNJC001 'STOP CDDS' NORMAL COMPLETION
End of change