show ddl

Shows DDL statements execution status.

Syntax

show ddl {[-ddl ddl_id] [-count cnt] | [-failed_only]}
          [-support] 
          [-verbose]

Options

Table 2-97 GDSCTL show ddl Options

Option	Description
-count cnt	The maximum number of entries to display.
-ddl ddl_id	DDL numeric identifier.
-failed_only	Use this option to display only errored out statements.
-support	If specified, GDSCTL output displays additional support information.
-verbose	Enable verbose mode.

Usage Notes

If -DDL and -COUNT are both unspecified, the command returns only the last 10 DDL statements.

If -DDL is specified but -COUNT is not, the command returns detailed information about the DDL statement. The -COUNT option defines the maximum number of DDLs to display.

Examples

GDSCTL> show ddl -count 20

Note:

The show dll command output might be truncated. You can run SELECT ddl_text FROM gsmadmin_internal.ddl_requests on the catalog to see the full text of the statements.