Advanced topics include system-level set commands and the SYS and cirrosys tables.

The following pages and posts are tagged with

TitleTypeExcerpt
cirrosys.cirroactionrun Page cirrosys.cirroquery lists metadata for.
cirrosys.cirroalert Page cirrosys.cirroalert lists metadata for.
cirrosys.cirroconnection Page cirrosys.cirroconnections is a connection and SQL Access log table.
cirrosys.cirroconnection Page cirrosys.cirroconnections is a connection and SQL Access log table.
cirrosys.cirroquery Page CIRROSYS.CIRROQUERY is a connection and SQL access log table.
cirrosys.cirroquery Page CIRROSYS.CIRROQUERY is a connection and SQL access log table.
cirrosys.cirroquery_archive Page cirrosys.cirroquery_archive lists metadata for.
cirrosys.cirrosession Page cirrosys.cirrosession is a Connection and SQL Access log table.
cirrosys.cirrosession Page cirrosys.cirrosession is a Connection and SQL Access log table.
cirrosys.datamovement Page cirrosys.datamovement is a connection and SQL access log table.
cirrosys.datamovement Page cirrosys.datamovement is a connection and SQL access log table.
cirrosys.datamovement_exceptions Page cirrosys.datamovement_exceptions is a connection and SQL access log table.
cirrosys.datamovement_exceptions Page cirrosys.datamovement_exceptions is a connection and SQL access log table.
cirrosys.excel_vb Page cirrosys.excel_vb lists metadata for.
cirrosys.fqoplans Page cirrosys.fqoplans is a connection and SQL access log table.
cirrosys.fqoplans Page cirrosys.fqoplans is a connection and SQL access log table.
cirrosys.fqoplans_archive Page cirrosys.fqoplans_archive lists metadata for.
cirrosys.google_analytics_dimensions_metrics Page cirrosys.google_analytics_dimensions_metrics lists metadata for.
cirrosys.jobstatus Page cirrosys.jobstatus is a scheduler table.
cirrosys.jobstatus Page cirrosys.jobstatus lists metadata for.
cirrosys.keyvaluepairs Page cirrosys.keyvaluepairs lists metadata for.
cirrosys.map_reduce_functions Page cirrosys.map_reduce_functions lists metadata for.
cirrosys.map_reduce_parameters Page cirrosys.map_reduce_parameters lists metadata for.
cirrosys.mapreducestats Page cirrosys.mapreducestats lists metadata for.
cirrosys.object_destination_lineage Page cirrosys.object_destination_lineage lists metadata for.
cirrosys.object_source_lineage Page cirrosys.object_source_lineage lists metadata for.
cirrosys.permdesc Page cirrosys.permdesc lists metadata for.
cirrosys.project_runs Page cirrosys.project_runs lists metadata for.
cirrosys.projects Page cirrosys.projects lists metadata for.
cirrosys.qrtz_blob_triggers Page cirrosys.qrtz_blob_triggers lists metadata for.
cirrosys.qrtz_calendars Page cirrosys.qrtz_calendars lists metadata for.
cirrosys.qrtz_cron_triggers Page cirrosys.qrtz_cron_triggers lists metadata for.
cirrosys.qrtz_fired_triggers Page cirrosys.qrtz_fired_triggers lists metadata for.
cirrosys.qrtz_job_details Page cirrosys.qrtz_job_details lists metadata for.
cirrosys.qrtz_locks Page cirrosys.qrtz_locks lists metadata for.
cirrosys.qrtz_paused_trigger_grps Page cirrosys.qrtz_paused_trigger_grps metadata for.
cirrosys.qrtz_scheduler_state Page Column Name Type Length Nullable Contents sched_name character varying (480)     instance_name character varying (800)     last_checkin_time bigint       checkin_interval bigint      
cirrosys.qrtz_simple_triggers Page Column Name Type Length Nullable Contents sched_name character varying (480)     trigger_name character varying (800)     trigger_group character varying (800)     repeat_count bigint       repeat_interval bigint       ...
cirrosys.qrtz_simprop_triggers Page cirrosys.qrtz_simprop_triggers metadata for.
cirrosys.qrtz_triggers Page cirrosys.qrtz_triggers metadata for.
cirrosys.rmsexecexceptions Page Column Name Type Length Nullable Contents rmsid integer      
cirrosys.rule_check_log Page cirrosys.rule_check_log is a connection and SQL access log table.
cirrosys.rule_check_log Page cirrosys.rule_check_log is a connection and SQL access log table.
cirrosys.run_detail Page cirrosys.run_detail metadata for.
cirrosys.schema_update Page cirrosys.schema_update metadata for.
cirrosys.sysremotefunctionelements Page cirrosys.sysremotefunctionelements table lists the elements (remote system functions and parameters) of a Cirro remote function definition.
cirrosys.sysremotefunctionparameters Page cirrosys.sysremotefunctionparameters defines the parameters of remote system functions.
cirrosys.sysremotefunctions Page cirrosys.sysremotefunctions lists the remote functions which have been created using the CREATE REMOTE FUNCTION command.
job_table_rows Page job_table_rows is a data projects table.
project_runs Page project_runs is a Data Projects table.
projects Page cirrosys.projects lists metadata for.
run_detail Page run_detail is a data projects table.
public.user_validation Page public_user_validation is a security model table.
public.user_validation Page public_user_validation is a security model table.
rms.sysviews Page rms.sysviews This table lists metadata for views on systems configured as remote databases.
rms.sysviews Page rms.sysviews This table lists metadata for views on systems configured as remote databases.
security.authorization_providers Page security.authorization_providers is a third-party authorization proivider table that contains authorization providers set-up in the system.
Security Model System Tables Page Use these system tables to determine the permissions already set in the system.
security_password_hashes Page security.password_hashes is a security model table.
security_password_hashes Page security.password_hashes is a security model table.
security.password_requirements Page security.password_requirements is a Login & Password Policy table.
security.rule_alerts Page security.rule_alerts is a security model table.
security.rule_alerts Page security.rule_alerts is a security model table.
security.rules Page security.rules is a security model table.
security.rules Page security.rules is a security model table.
security.syspermissions Page security.syspermissions is a security model table that tracks explicit GRANT and DENY permissions against Cirro users.
security.syspermissions Page security.syspermissions is a security model table that tracks explicit GRANT and DENY permissions against Cirro users.
security.sysroles Page security.sysroles is a security model table that contains Cirro roles.
security.sysroles Page security.sysroles is a security model table that contains Cirro roles.
security.tag_values Page security.tag_values is a security model table.
security.tag_values Page security.tag_values is a security model table.
security.tags Page security.tags is a security model table.
security.tags Page security.tags is a security model table.
security.user_auth_providers Page security.user_auth_providers is a third-party authorization providers table that contains authorization providers set-up in the system.
security.userid_requirements Page security.userid_requirements is a Login & Password Policy table.
security.users Page security.users is a security model table that contains information on Cirro users.
security.users Page security.users is a security model table that contains information on Cirro users.
SYS.CIRROCOLUMNS Page SYS.CIRROCOLUMNS lists metadata for all columns on Cirro systems.
SYS.CIRROJOBS Page sys.cirrojob is a scheduler table that returns information on scheduled jobs.
SYS.CIRROJOB Page SYS.CIRROJOB returns information on scheduled jobs.
SYS.CIRROREMOTEDATABASES Page SYS.CIRROREMOTEDATABASES provides information on configured remote databases.
SYS.CIRROSCHEMAS Page SYS.CIRROSCHEMAS lists metadata for all schemas on Cirro Systems.
SYS.CIRROTABLES Page SYS.CIRROTABLES lists metadata for all tables on Cirro systems.
SYS.CIRROVIEWS Page This table lists metadata for all views on Cirro systems.
SYS.DRIVERS Page The sys.drivers view shows the configured drivers.
SYS.DRIVERSRESOURCE Page The sys.driversresource view shows configured resources.
sys.privatekeys Page Table used to store system Private Keys.
SYS.RMISERVICE Page SYS.SYSRMISERVICE shows agent systems, RDMSRMS or data movement agents together with Sqoop and Hadoop systems since these are also technically agents.
SYS.SYSCACHEDRESULTSET Page This table provides information on Cirro system cached data.
SYS.SYSCOLUMNS Page This table lists metadata for all columns on systems configured with 3-part names.
SYS.SYSEXCLUDEDSCHEMAS Page This table provides a list of all excluded schemas from remote data sources.
SYS.SYSFILESTRUCTURES Page This table table provides information on remote system file structures.
SYS.SYSPERMISSIONS Page This table tracks explicit GRANT and DENY permissions against Cirro users.
SYS.SYSPOLICIES Page This table tracks Cirro user security policies set with ALTER POLICY command. These values are specified through the Admin Console or using UPDATE commands.
SYS.SYSREMOTEDATABASES Page This table lists the local synonyms which have been mapped to remote databases.
SYS.SYSREMOTESYSTEMS Page SYS.SYSREMOTESYSTEMS lists all the RDBMS systems, or the systems that can be viewed that way. This table provides information on configured remote systems.
SYS.SYSREMOTESYSTEMTYPES Page This table provides a list of remote system types, referenced in SYS.SYSREMOTESYSTEMS.
SYS.SYSROLES Page This table provides information on Cirro roles.
SYS.SYSSCHEMAS Page This table lists metadata for schemas on systems configured as remote databases.
SYS.SYSTABLES Page This table lists metadata for tables on systems configured as remote databases.
SYS.SYSVIEWS Page This table lists metadata for views on systems configured as remote databases.
SYS.USERS Page This table provides information on Cirro users.