You are on page 1of 1

PK

I1
I2
I3
I4

NUMBER
VARCHAR(50)
CHAR(2)
NUMBER
VARCHAR(9)

I1
I2

PK
PK
PK
PK

PK

PK

ORDERNO
DO_NO
IF_NO
ACTION
EXECSIGN
ROWORDER

CMR_DO

CMR_FORCEJ

JOBNAME
REMOTE_CTM
REMOTE_LIB
SCHEDTAB
SDATE

NUMBER
NUMBER
NUMBER
VARCHAR(20)
CHAR(2)
NUMBER

NUMBER
NUMBER
NUMBER
VARCHAR(64)
VARCHAR(20)
VARCHAR(44)
VARCHAR(770)
CHAR(8)

NUMBER
NUMBER
NUMBER
CHAR(2)
VARCHAR(255)
VARCHAR(255)
TEXT
VARCHAR(99)
CHAR(2)

CMR_MAIL

ATTACH_SYSOUT
CC_DEST
LOGIC_DEST
MESSAGE
SUBJECT
URGENCY

NUMBER
NUMBER
NUMBER

ORDERNO
IF_NO
DO_NO

ORDERNO
IF_NO
ROWORDER
VARCHAR(255)
VARCHAR(132)

CMR_QR_J
NUMBER
VARCHAR(64)

CMR_ONSTMT

CODE
STMT

ORDERNO
QRESNAME
NUMBER
NUMBER

VARCHAR(4000)

NUMBER
NUMBER
NUMBER
VARCHAR(64)

QNUMBER
ROWORDER

ORDERNO
IF_NO
DO_NO
FIELD_NAME

CMR_REMEDY

FIELD_VALUE

NUMBER
NUMBER
NUMBER
NUMBER

CMR_SETVAR

ORDERNO
IF_NO
DO_NO
ROWORDER
CHAR(2)
CHAR(2)
VARCHAR(128)
TEXT
VARCHAR(20)

CHAR(2)
NUMBER
VARCHAR(16)
VARCHAR(255)
CHAR(2)
NUMBER
CHAR(2)
CHAR(4)
CHAR(2)
CHAR(2)
VARCHAR(10)

NUMBER
NUMBER
NUMBER
NUMBER

GLOBALIND
SETVARTYPE
VAR
VAREXPR
VARSCOPE

CMR_SHOUT

CMR_SYSOUT
NUMBER
NUMBER
NUMBER
NUMBER
CHAR(2)
VARCHAR(255)
CHAR(2)

NUMBER

SYSOPT
SYSPRM
SYSTYPE

VARCHAR(20)

PK
PK
PK

PK

PK
PK

PK
I1

VARCHAR(30)
VARCHAR(50)
VARCHAR(10)

CMR_CM_ACCOUNTS_STATUS

ACCOUNT
NODEID
APPLTYPE
VARCHAR(999)
CHAR(7)
CHAR(2)

NODEID
VARCHAR(255)
VARCHAR(255)
VARCHAR(14)
VARCHAR(255)
CHAR(2)
VARCHAR(14)
CHAR(2)
CHAR(1)
VARCHAR(255)
VARCHAR(255)
VARCHAR(50)
VARCHAR(32)
VARCHAR(255)

VARCHAR(50)

CMR_NODES

MESSAGE
MESSAGE_ID
AGSTAT

DOMAIN_NAME
ERROR_MSG
FIRST_SET
HOSTNAME
IS_DEFAULT
LAST_UPD
AGSTAT
NODETYPE
OS_NAME
PERMHOSTS
PHYS_NODEID
PLATFORM
VERSION

NODEID
AGENTID
CHAR(2)

VARCHAR(50)
VARCHAR(50)

CMR_NODES_RJX_STATUS

AGSTAT

VARCHAR(20)
NUMBER
VARCHAR(64)

WL_NAME
WL_POSITION

CHAR(2)

VARCHAR(20)
NUMBER

VARCHAR(50)

VARCHAR(128)

GRPNAME
NODEID
CHAR(22)

VARCHAR(50)
VARCHAR(50)

CHAR(2)

VARCHAR(64)

CMR_SP_DIAG_REQUEST

SPNAME

CHAR(22)

DIAGREQ

CMR_STATIS

VARCHAR(10)

WL_FILTER_NAME
WL_FILTER_VALUE
WL_NAME

VARCHAR(50)

VARCHAR(20)
VARCHAR(770)
VARCHAR(20)

CMS_WL_FILTERS

NAME

NUMBER
VARCHAR(20)

CMS_WL_MEMBERSHIP_CURRENT

CMS_WL_LOCAL_NAMES

ORDERNO
WL_NAME

WL_RES_MAX
WL_PERIOD_DATA

WL_NAME
WL_RES_NAME
WL_PERIOD_PRIORITY

VARCHAR(50)

VARCHAR(20)
VARCHAR(50)

NUMBER
VARCHAR(40)

VARCHAR(20)
VARCHAR(64)
NUMBER

CMR_QRTAB

VARCHAR(64)
NUMBER
NUMBER
CHAR(2)
NUMBER

PK
PK
PK

PK
PK

PK

PK
PK

PK

PK
PK
PK

PK
PK
PK

PK

PK
PK

PK
PK

PK
PK
PK

PK
PK
PK
PK

VARCHAR(50)
VARCHAR(50)
VARCHAR(40)

VARCHAR(10)
VARCHAR(10)

TARGET_MACHINE
VARCHAR(1024)

VARCHAR(128)
I3

PK

VARCHAR(64)
VARCHAR(50)
VARCHAR(12)

VARCHAR(512)

OWNER
TARGET_MACHINE

VARCHAR(512)
CHAR(1)
VARCHAR(512)

VARCHAR(30)
VARCHAR(128)

I1

PK
PK

PK

PK
PK

PK

PK

JOBNO
VARCHAR(8)
CHAR(2)
CHAR(32)
VARCHAR(30)
VARCHAR(64)
VARCHAR(64)
VARCHAR(10)
VARCHAR(10)
VARCHAR(64)
CHAR(2)
CHAR(2)
VARCHAR(14)
VARCHAR(64)
TEXT
VARCHAR(10)
CHAR(2)
VARCHAR(30)
VARCHAR(14)
VARCHAR(64)
CHAR(2)
CHAR(2)
CHAR(2)
VARCHAR(6)
VARCHAR(30)
VARCHAR(30)
NUMBER
VARCHAR(160)
NUMBER
TEXT
VARCHAR(255)
VARCHAR(64)
CHAR(4)
NUMBER
CHAR(2)
TEXT
TEXT
VARCHAR(64)
VARCHAR(8)
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(255)
VARCHAR(64)
CHAR(12)
CHAR(2)
VARCHAR(50)
VARCHAR(50)
VARCHAR(255)
VARCHAR(30)
VARCHAR(20)
NUMBER
CHAR(2)
CHAR(2)
CHAR(2)
TEXT
VARCHAR(770)
CHAR(4)
CHAR(2)
CHAR(9)
NUMBER
CHAR(3)
CHAR(2)
CHAR(2)
VARCHAR(9)
NUMBER
NUMBER
CHAR(4)
VARCHAR(50)
VARCHAR(30)

NUMBER

JOBNO
ROWORDER

VARCHAR(128)
CHAR(1)
VARCHAR(128)
VARCHAR(64)
NUMBER
NUMBER
NUMBER

NUMBER
NUMBER

UNIQEID

ORDER_TIME
RESPONSE_MSG

ROWORDER
UNIQEID

AGENT_CUR_VER
APPL_CUR_VER
APPLICATION
CHANGE_TICKET
CHECK_PREREQ_OID
CKSUM
CREATION_TIME
DEPLOY_END
DEPLOY_OID
DEPLOY_START
DESCRIPTION
EMAIL
HOST
INSTALL_USER
INTERN_STATE
MESSAGE
PACKAGE
PREPARE_OID
STATE
STATUS_TIME
TARGET_ACTIVITY
TRANSFER_END
TRANSFER_START
VERIFY_OID

ACTIVITY_ID

VARCHAR(14)
VARCHAR(14)
VARCHAR(20)

VARCHAR(100)

VARCHAR(14)
TEXT

NUMBER
VARCHAR(100)

VARCHAR(30)
VARCHAR(30)
VARCHAR(50)
VARCHAR(255)
NUMBER
VARCHAR(255)
VARCHAR(14)
VARCHAR(14)
NUMBER
VARCHAR(14)
VARCHAR(1024)
VARCHAR(512)
VARCHAR(100)
VARCHAR(100)
VARCHAR(20)
VARCHAR(255)
VARCHAR(100)
NUMBER
VARCHAR(30)
VARCHAR(14)
VARCHAR(30)
VARCHAR(14)
VARCHAR(14)
NUMBER

NUMBER

VAL1
VAL2
VAL3
VAL4
VAL5
VAL6

ID

VARCHAR(50)
VARCHAR(50)
VARCHAR(50)
VARCHAR(50)
VARCHAR(50)
VARCHAR(50)

NUMBER

CMR_PERF_TEST

CMR_OUTGOING_REMORDERS

CMR_INCOMING_REMORDERS

RESPONSE_TIME
SEND_TIME
REMOTE_CTM

AUTO_DEPLOY

DELIMITER
CAPTURE_BY
CAPTURE_INTO
SEARCH_STRING
SKIP
SKIP_LINES
TAKE_COUNT

CMS_CAPTURE_DEFS

ACTTILL
ADJUST_COND
AJFSONSTR
APPLFORM
APPLGROUP
APPLIC
APPLTYPE
APPLVER
AUTHOR
AUTOARCH
CAL_ANDOR
CHANGEDATETIME
CHANGEUSERID
CMDLINE
CMVER
CONF
CONFCAL
CREATIONDATETIME
CREATIONUSERID
CRITICAL
CYCLIC
CYCLIC_TYPE
CYCLICINT
DATEMEM
DAYSCAL
DAYSKEEPINNOTOK
DAYSTR
DELAY
DESCRIPT
DOCLIB
DOCMEM
FROMTIME
GROUPID
INSTREAM_IND
INSTREAM_SCRIPT
INTERVAL_SEQUENCE
JOBNAME
ACTFROM
MAXDAYS
MAXRERUN
MAXRUNS
MAXWAIT
MEMLIB
MEMNAME
MONTHSTR
MULTIAGENT
NODEGRP
NODEID
OVERLIB
OWNER
PLATFORM
PRIORITY
RELATIONSHIP
REMOVEATONCE
RETRO
RUN_TIMES
SCHEDTAB
SHIFT
STARTENDCYCIND
STATEMSK
TABROWNO
TASKCLASS
TASKTYPE
TIMEREF
TIMEZONE
TOLERANCE
UNKNOWNTIM
UNTIL
WDAYSTR
WEEKCAL

CMS_JOBDEF

DATABASE SCHEMA

CMS_NODGRP_NODEID_COND
CHAR(8)
VARCHAR(255)
VARCHAR(50)
VARCHAR(50)

GRPNAME
NODEID
WL_PERIOD_DATA

VARCHAR(4000)

VARCHAR(128)
VARCHAR(50)

VARCHAR(10)
VARCHAR(50)

CMVER
APPLVER

NUMBER

CMS_NODID

TARGET_MACHINE
RJX_NAME

SYSOUT_DIRECTORY

I2

VARCHAR(50)
VARCHAR(64)
VARCHAR(30)

CMS_ACTAUT

NODEID
USERNAME
OWNER
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)

USERNAME
NODEID
RESTYPE

CHAR(2)
CHAR(2)
CHAR(2)
VARCHAR(14)
VARCHAR(64)
VARCHAR(12)

CMS_IOAAUT

CONF
DELETEACT
FORCE
HOLD
KILLJOB
LOG
MAYORDER
RERUN
STATIST
SYSOUTVIEW
C1
C2
C3
WHY
ZNS

ADDACT
CHANGEACT
DELETEACT
CHECKSUM
RESNAME
RESTYPE

AUTHENTICATION_KEY_NAME

NUMBER
VARCHAR(20)
TEXT
VARCHAR(999)
VARCHAR(999)
VARCHAR(10)

CMS_SECURITY_KEYS
BITS
FORMAT
OWNER_KEY
PASSWORD_KEYPHRASE
PASSWORD_KEYPHRASE_TMP
TYPE

PASS_AUTH_KEY_NAME_TMP
PASSWORD_KEY_FLAG
PASS_AUTH_KEY_NAME

VARCHAR(128)

CMS_SECURITY_MAP

TARGET_MACHINE

VARCHAR(99)
NUMBER
CHAR(2)

VARCHAR(64)
VARCHAR(50)
TEXT
VARCHAR(32)

VARCHAR(64)
VARCHAR(50)
VARCHAR(770)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)

CMS_SCHAUT

CMS_USERS

CMS_SSH_DETAILS
ENCRYPTION_METHOD
PORT_NUMBER
COMPRESSION

USERNAME
NODEID
USERDESCR
USERGROUP

USERNAME
NODEID
SCHEDTAB
ADDACT
READACT
DELETEACT
UPDATEACT
MAYORDER

I4

SECURITY DEFINITIONS

CMS_WMI_DETAILS

CMS_RJX_NAMES

ROWORDER

APPLTYPE
NODEID

PERIOD_DATA_RAW

CMS_NODGRP_NODEID_PERIOD

CONDDATE
CONDNAME
GRPNAME
NODEID

JOBNO
DO_NO
IF_NO
ROWTYPE

VARCHAR(255)
CHAR(4)
CHAR(2)
CHAR(2)
NUMBER

NUMBER
NUMBER
NUMBER
CHAR(2)

CMS_CON_J

CONDNAME
DATEREF
OP
PARENTHESES
ROWORDER

CHAR(2)

NUMBER
VARCHAR(64)
NUMBER

CMS_CTL_J
JOBNO
CONTROL
ROWORDER

CMS_DO

CMS_DATES

NUMBER
NUMBER
NUMBER

NUMBER
CHAR(8)
VARCHAR(20)

CHAR(1)
TEXT
TEXT

VARCHAR(30)
CHAR(4)

CMS_DATEMM

CMODE

CALNAME
JOBYEAR

JOBNO
JOBDATE
TAGNAME

CALTYPE
DAYMASK
CALDESC

PK
PK
PK

JOBNO
IF_NO
DO_NO

VARCHAR(20)
NUMBER

NUMBER
NUMBER
NUMBER

CMS_FORCEJ
JOBNO
IF_NO
DO_NO

VARCHAR(64)
VARCHAR(20)
VARCHAR(44)
VARCHAR(770)
CHAR(8)

ACTION
ROWORDER

JOBNAME
REMOTE_CTM
REMOTE_LIB
SCHEDTAB
SDATE

JOBNO
IF_NO
DO_NO

CHAR(2)
VARCHAR(255)
VARCHAR(255)
TEXT
VARCHAR(99)
CHAR(2)

NUMBER
NUMBER
NUMBER

CMS_MAIL

ATTACH_SYSOUT
CC_DEST
LOGIC_DEST
MESSAGE
SUBJECT
URGENCY

NUMBER
NUMBER
NUMBER

CMS_ONSTMT

VARCHAR(255)
VARCHAR(132)

VARCHAR(50)

NUMBER
NUMBER

NUMBER
VARCHAR(64)

JOBNO
IF_NO
ROWORDER

CMS_QR_J

CODE
STMT

JOBNO
QRESNAME
QNUMBER
ROWORDER

ADMIN
GRPNAME

NUMBER

CMR_PRE_CHANGED_NODGRP
PK

JOBNO

CMR_PRE_ORDER
PK

VARCHAR(14)

RESOURCE_NAME
RESOURCE_TYPE

CHAR(14)

VARCHAR(255)
NUMBER

CMR_RESOURCELOCK
LASTEND

FILENAME
RELATIVE_PATH

NUMBER
NUMBER
VARCHAR(14)
TEXT
NUMBER
VARCHAR(14)
NUMBER

VARCHAR(64)
VARCHAR(1024)

CMS_FILE_SYNC
FILESIZE
MANDATORY
MODIFICATION_TIME
FILE_DATA
SYNC_STATUS
SYNC_TIME
SYNC_TYPE

VERSION:

PK
PK
PK
PK

PK
PK

NUMBER
NUMBER
VARCHAR(64)
NUMBER

CMS_REMEDY
JOBNO
IF_NO
FIELD_NAME
DO_NO

VARCHAR(4000)

CMS_SCHEDT

CMS_SETVAR

CMS_SYSOUT

CHAR(2)
VARCHAR(255)
CHAR(2)

NUMBER
NUMBER
NUMBER
NUMBER

CHAR(2)
NUMBER
CHAR(2)
NUMBER
VARCHAR(16)
VARCHAR(255)
CHAR(4)
CHAR(2)
CHAR(2)
VARCHAR(10)

NUMBER
NUMBER
NUMBER
NUMBER

CHAR(2)
CHAR(2)
VARCHAR(128)
TEXT
VARCHAR(20)

NUMBER
NUMBER
NUMBER
NUMBER

VARCHAR(10)
VARCHAR(770)

FIELD_VALUE

DAILYNAME
SCHEDTAB

PK
DO_NO
PK
IF_NO
PK, I1 JOBNO
PK,I1 ROWORDER
I1

SETVARTYPE
GLOBALIND
VAR
VAREXPR
VARSCOPE

CMS_SHOUT
PK,I1,I2 JOBNO
PK,I2 DO_NO
PK,I2 IF_NO
PK,I1 ROWORDER

JOBNO
DO_NO
IF_NO
ROWORDER

EXECOPER
EXECPARM
EXECTYPE
DAYSOFFSET
LOGIC_DEST
MESSAGE
SHOUTIME
SHOUTYPE
URGENCY
WHENCOND

SYSOPT
SYSPRM
SYSTYPE

I1

PK,I1
PK
PK
PK

NUMBER
VARCHAR(20)

CMS_TAG
GROUPID
TAGNAME

VARCHAR(30)
VARCHAR(160)
CHAR(2)
CHAR(2)
VARCHAR(30)
NUMBER
CHAR(12)
CHAR(2)
NUMBER
CHAR(4)
VARCHAR(8)
VARCHAR(8)
VARCHAR(50)
VARCHAR(30)

JOBNO
TAGNAME

CHAR(2)
NUMBER
NUMBER

NUMBER
VARCHAR(20)

REQ_ID

CHAR(4)
VARCHAR(255)
NUMBER
VARCHAR(14)
NUMBER
TEXT

CHAR(32)

ODATE
JOBNAME
ERROR_CODE
ERROR_MESSAGE
GROUP_ORD
REQ_ID
TABROWNO
TASKTYPE

ORDERNO
KEYSTMP

CHAR(8)
VARCHAR(64)
CHAR(4)
VARCHAR(255)
NUMBER
CHAR(32)
NUMBER
CHAR(2)

NUMBER
CHAR(22)

CMR_AC_ORDER_RESULTS

REQ_ERROR_CODE
REQ_ERROR_MESSAGE
REQ_ERROR_SEVERITY
REQ_DATETIME
REQ_STATE
REQ_XML

CMR_AC_ASYNC_COMMANDS

EXCLUDE_RBC
ROWORDER
GROUPID

CMS_TAGLINK

DAYSCAL
DAYSTR
EXCLUDE_RBC
CAL_ANDOR
CONFCAL
MAXWAIT
MONTHSTR
RETRO
ROWORDER
SHIFT
TAGFROM
TAGTILL
WDAYSTR
WEEKCAL

I1

PK
PK

PK
PK

PK

PK
PK

I1

PK
PK

PK

PK
PK

PK

PK
PK

PK

PK

PK
PK

NUMBER

VARCHAR(10)

VARCHAR(255)

NUMBER
VARCHAR(30)

VARCHAR(30)
VARCHAR(30)

VARCHAR(24)

VARCHAR(10)
VARCHAR(50)

CHAR(5)
CHAR(2)
VARCHAR(32)
NUMBER
NUMBER
VARCHAR(255)
NUMBER
NUMBER
NUMBER
NUMBER
CHAR(5)

PK

PK

PK

PK
PK
PK
PK

PROCNAME

LAST_UPDATE_TIMESTAMP
PARAM_VALUE

PARAM_NAME

AUTOCOPY
AUTODELARC
C1
C2
CM_DATE
CMD_ALLOW
ACT_SH_TAB
CTMSMODE
CURR_IOALOG_DAY
CURR_JOBINF_DAY
CURRENT_STATE
DATETYPE
DAYTIME
DBLOCKTIME
DBVERSION
DEFPRT
DELRETAIN
DESIRED_STATE
IOALOGLM
IOALOGLM_USE
LOGDIR
MAX_RUNCOUNT
MAXAJFREC
MAXBATQJB
MAXJOBLOG
MAXLOGFILE
MAXSHUT
MAXTRY
MESS_LANG
MIRRORDB
MSGCHAR
MSGLENGTH
N1
N2
NONSWAP
A1
PAUSE
PERCALGAP
PRIMARY_MIRROR
PROCLIB
QUELIB
QUENAME
RUNCOUNT
SBMMSGQ
SBMMSGQLIB
SBRETAIN
SECURE
SLEEPINT
SSL_ENBL
STATIST
SWEEK
SYSOUTRETN
SYSOUTRETN_USE
UNKNOWNTIM
UNQJOB
A2

COMPUTER
CMVERSION
OPSYS
VERSION

VARCHAR(14)

VARCHAR(24)

VARCHAR(14)
VARCHAR(1024)

VARCHAR(64)

CHAR(2)
CHAR(2)
CHAR(2)
CHAR(2)
CHAR(8)
CHAR(2)
VARCHAR(10)
CHAR(2)
NUMBER
NUMBER
VARCHAR(15)
CHAR(8)
VARCHAR(6)
NUMBER
CHAR(10)
VARCHAR(50)
CHAR(2)
VARCHAR(15)
NUMBER
NUMBER
VARCHAR(255)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
CHAR(3)
CHAR(2)
CHAR(3)
NUMBER
NUMBER
NUMBER
CHAR(2)
VARCHAR(20)
CHAR(2)
NUMBER
CHAR(2)
VARCHAR(255)
VARCHAR(10)
VARCHAR(20)
NUMBER
VARCHAR(10)
VARCHAR(10)
CHAR(2)
CHAR(2)
NUMBER
CHAR(2)
CHAR(2)
CHAR(2)
NUMBER
NUMBER
NUMBER
CHAR(2)
VARCHAR(20)

VARCHAR(20)
CHAR(10)
VARCHAR(20)
VARCHAR(32)

HOST_ID
HOST
ACCOUNT
COMPUTER
OPSYS

HA_ROLE

VARCHAR(1024)
VARCHAR(1024)
VARCHAR(1024)
VARCHAR(20)
VARCHAR(20)

VARCHAR(15)

CMS_HA_SYSPRM

CMS_HA_TIMESTAMP

CMS_HA_PARAMS

TIMESTAMP

CMS_SYSPRM

CONFIGURATION PARAMETERS

CMR_LASTNO

CMR_ECSMSG

ECSMSG_ISN
USERNAME

MESSAGE

TABLENAME

LASTISN

CATEGORY
TOPIC

VARCHAR(14)
VARCHAR(1024)
NUMBER
VARCHAR(14)
NUMBER
NUMBER
VARCHAR(3)
NUMBER
NUMBER

CMR_LIFE_CHECK_MESSAGES

MESSAGE_TIMESTAMP
MSG_TEXT
NOTIFICATION_COUNT
NOTIFICATION_TIMESTAMP
PENDING_DELIVERY
PRIORITY
RETENTION_MODE
RETENTION_VALUE
STATUS_CODE

PROCNAME

CHAR(2)
VARCHAR(16)
NUMBER
CHAR(2)
CHAR(2)
VARCHAR(14)
VARCHAR(14)
NUMBER
NUMBER
NUMBER
CHAR(2)

CMR_PRFLAG

KERNELPR
PROCID
DEBUGRUN
PROCSTAT
PSTAT_REQ
PSTATR_TIM
RETRY_TIM
RETRYNO
SHD_TIME_L
SLEEP_TIME
STANDALONE

VARCHAR(24)
CHAR(2)
VARCHAR(16)
NUMBER
CHAR(2)
CHAR(2)
VARCHAR(14)
VARCHAR(14)
NUMBER
NUMBER
NUMBER
CHAR(2)

CMS_APPGRP

CMR_PRFLAG_BACKUP

PROCNAME
KERNELPR
PROCID
DEBUGRUN
PROCSTAT
PSTAT_REQ
PSTATR_TIM
RETRY_TIM
RETRYNO
SHD_TIME_L
SLEEP_TIME
STANDALONE

APPLTYPE
GRPNAME

VARCHAR(64)

CHAR(2)

CM_RELVER
APPL_ID
DATA_CNTR_NAME
DB_BASE
DBU_LEVEL
EXE_PATH
IN_PORT
MAX_SERV
MIN_SERV
OUT_PORT
WS_RELVER

VARCHAR(1024)

CMS_CMNPRM

PARAM_NAME

DATA_CNTR

PARAM_VALUE

VARCHAR(10)
VARCHAR(16)

CMS_SHDEST

CMS_INSTALL_PARAMS

ACT_SH_TAB
LOGIC_DEST

ADMIN

CHAR(2)
VARCHAR(255)
CHAR(2)
VARCHAR(50)

WORKLOAD POLICY

ADDRTYP
DESTARGET
DESTYPE
NODEID

ACTIVE JOBS

AGENTS AND REMOTE HOSTS

Primary Key
Indexed Field
Unique Constraint

JOB AND CALENDAR DEFINITION

PK
I
U

SECURITY DEFINITIONS

RUNTIME STATISTICS AND LOGS

RESOURCES

CONFIGURATION PARAMETERS

The information provided here describes data layouts that are part of the internal product operation of BMC Software. This information is provided to help you understand the operation of our products. By providing this information, BMC does not intend to sanction or to
support user applicaton access. This informatuion is likely to change without any notice in the future, and BMC is not obligated to support user application that may depend on this information. Any customer access to internal database information that is not performed via
aproved utilities or interfaces is done at the customer’s risk. The furnishing of this document does not give rights to any BMC intellectual property contained within it. Indexes, unique constraints, and keys many vary based on database type used.

For questions related to this poster or any of the Control-M products please contact Customer Support at www.bmc.com/support or call your local support center.

BMC Software, the BMC Software logos, and all other BMC Software product or service names are registered trademarks of BMC Software, Inc. All other trademarks or registered trademarks belong to their respective companies. Copyright ©2015 BMC Software, Inc. All rights
reserved.

*XXXXX7*

BMC Control-M Workload Automation
9.0.00

PK
PK

PK
PK

PRE_ORDER_TIMESTAMP

PK
PK

PK
PK
PK

PK
PK
PK

PK
PK
PK

PK
PK
PK

PK
PK

PK
PK
PK

PK
PK
PK
PK

JOB AND CALENDAR DEFINITION

BMC Control-M Server 9
NODEID
NUMBER
NUMBER
NUMBER
NUMBER
CHAR(2)
NUMBER
NUMBER
CHAR(2)
CHAR(2)
VARCHAR(50)
NUMBER
NUMBER
NUMBER
NUMBER
CHAR(1)
CHAR(2)
CHAR(2)
NUMBER

TARGET_MACHINE
VARCHAR(10)

TIMESTMP

CMS_NODGRP

EXECUTION_MODE

CMS_MACHINE_MAP

AVPOLTIM
COMTIMOUT
COMTRYNO
COMTRYTIM
COMVERSION
LONG_TIME
MAX_DISCONNECT_TIME
ALLOW_AG_DISCONNECTION
PERSISTENT_CONNECTION
PHYS_NODEID
POLLTIME
PORTNUM
SESSION_IDLE_TIMEOUT
SHORT_TIME
SSL_ENBL
SSL_SYNC
UNAV_URGENCY
UNAVPOLTIM

CMS_AGPRM

AGENTS AND REMOTE HOSTS
PK

PK

PK
PK

I6
I1
I2
I4
I5

VARCHAR(64)
VARCHAR(255)
VARCHAR(64)
VARCHAR(50)
VARCHAR(770)
CHAR(22)
NUMBER
NUMBER
NUMBER
NUMBER

CHAR(8)
CHAR(8)

CMR_UDLAST

DAILYNAME

KEYSTMP

CHAR(22)

LASTEND
LASTRUN

PK

PK
PK
PK

PK
PK

CHAR(2)
CHAR(2)

CMS_WL_MEMBERSHIP_PREV

NUMBER
VARCHAR(20)

WL_NAME
WL_SRC_NODE

QRTOTAL
QRUSED
QTYPE
RSRVNO

QRESNAME

CMS_WL_PLCY_NODGRP_MAP
WL_DEST_NODE

CMS_WL_PLCY_MAX_QRSRC

PK,I1 ORDERNO
PK
WL_NAME

PK
PK
PK

PK
PK

PK

VARCHAR(50)
CHAR(14)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER

CMR_USAGE_MEASURE

I1
I2

NAME
TIME
NUM1
NUM2
NUM3
NUM4
NUM5
NUM6
NUM7
NUM8

PK

JOBNAME
LIBRARY
MEMNAME
NODEID
SCHEDTAB
KEYSTMP
CPUTIME
CPUTIME_SD
ELAPSED
ELAPSED_SD

PK, I3 TIMESTMP

PK

RUNTIME STATISTICS AND LOGS
CHAR(22)
NUMBER

CMR_DBLOG

KEYSTMP
DBULVL
TEXT
CHAR(2)
NUMBER

CMR_RUNINF

DBMESSAGE
DBMESSAGE_1_32
MSGSIZE

NUMBER
NUMBER
CHAR(22)
CHAR(4)
VARCHAR(64)
NUMBER
VARCHAR(255)
VARCHAR(64)
VARCHAR(50)
NUMBER
VARCHAR(999)
NUMBER
VARCHAR(30)
VARCHAR(16)
NUMBER
CHAR(2)
VARCHAR(50)
NUMBER
VARCHAR(770)
VARCHAR(14)
CHAR(2)
NUMBER

CMR_SP_DIAG_MESSAGES
VARCHAR(64)
VARCHAR(2048)
NUMBER
CHAR(22)

CHAR(4)
CHAR(4)
NUMBER

NUMBER

WL_STATE

VARCHAR(50)

VARCHAR(40)
VARCHAR(40)

STATE
TASKTYPE

WORKLOAD POLICY
WL_NAME
WL_PERIOD_PRIORITY
WL_RES_NAME

ORDERNO

VARCHAR(50)

CHAR(14)

CMR_WORKLOAD_GLOBAL

NODEID

NUMBER
NUMBER

NUMBER
TEXT

CMR_POOLS

VARCHAR(40)

POOLNAME
VARNAME

POOLNAME

ROWORDER
VAREXPR

CMR_POOL_VARIABLES

CMS_NODEID_RESTRICTION
MAX_JOBS
MAX_CPU

CMR_WORKLOADS

WL_SYNC_LEVEL

NODE

CMR_WL_PREVIOUS_MAPPING

F
T
WL_RES_MAX

CMR_WL_PREV_QRSRC

SPNAME
MESSAGE
KEYCNT
TIMESTMP

ENDRUN
JOBNAME
JOBNO
MEMLIB
MEMNAME
NODEID
CPUTIME
OSCOMPMSG
OSCOMPSTAT
OWNER
PROCID
RES1
RES2
RES3
ELAPTIME
SCHEDTAB
STARTRUN
STATUS
SYSOUTSIZE

PK
ORDERNO
PK
RUNCOUNT
PK, I1 TIMESTMP
I3
I2
I4

I1

PK
PK
PK

PK

PK

PK
U1

PK

PK
PK

RESOURCES

CHAR(2)
NUMBER
NUMBER
CHAR(2)
VARCHAR(64)

VARCHAR(64)

CMR_CTLTAB

ORDERNO

CONTROL

WL_NAME

CMR_WL_EXEC_J

DO_NO
IF_NO
ORDERNO
ROWORDER

EXECTYPE
DAYSOFFSET
LOGIC_DEST
MESSAGE
EXECOPER
EXECPARM
SHOUTED
SHOUTIME
SHOUTYPE
URGENCY
WHENCOND

PK,I1,I2 ORDERNO
PK
IF_NO
PK
DO_NO
PK,I1 ROWORDER

I1
I1

PK, I1
PK
PK
PK

PK
PK
PK
PK

PK
PK

PK
PK
PK

PK
PK
PK

I1

PK, I1 ORDERNO
PK
DO_NO
PK
IF_NO

PK
PK
PK

ACTIVE JOBS
ORDERNO
NODEID
STATE
GROUP_ORD
TIMEZONE
CHAR(2)
CHAR(32)
VARCHAR(30)
VARCHAR(64)
VARCHAR(64)
VARCHAR(10)
VARCHAR(10)
VARCHAR(64)
CHAR(2)
VARCHAR(20)
CHAR(10)
VARCHAR(32)
TEXT
VARCHAR(10)
CHAR(2)
CHAR(2)
NUMBER
CHAR(2)
NUMBER
CHAR(2)
CHAR(2)
VARCHAR(6)
VARCHAR(10)
NUMBER
VARCHAR(50)
NUMBER
TEXT
VARCHAR(255)
VARCHAR(64)
NUMBER
VARCHAR(14)
NUMBER
CHAR(4)
CHAR(2)
CHAR(2)
TEXT
TEXT
VARCHAR(64)
NUMBER
NUMBER
NUMBER
NUMBER
NUMBER
VARCHAR(255)
VARCHAR(64)
CHAR(2)
CHAR(8)
VARCHAR(14)
NUMBER
VARCHAR(50)
CHAR(1)
CHAR(8)
VARCHAR(14)
VARCHAR(999)
NUMBER
VARCHAR(255)
VARCHAR(30)
CHAR(8)
CHAR(8)
NUMBER
VARCHAR(16)
CHAR(2)
NUMBER
CHAR(2)
VARCHAR(50)
TEXT
NUMBER
VARCHAR(770)
NUMBER
CHAR(2)
VARCHAR(14)
CHAR(9)
CHAR(2)
CHAR(3)
CHAR(2)
CHAR(2)
NUMBER
VARCHAR(30)
NUMBER
CHAR(4)

CMR_AJF

ADJUST_COND
AJFSONSTR
APPLFORM
APPLGROUP
APPLIC
APPLTYPE
APPLVER
AUTHOR
AUTOARCH
BIMINFO
BYPASS_OPTIONS
CM_STATUS
CMDLINE
CMVER
CONFIRM_R
CONFIRMED
CPUTIME
CRITICAL
CURRENT_RUN
CYCLIC
CYCLIC_TYPE
CYCLICINT
DAILYNAME
DAYSKEEPINNOTOK
DEF_NODEGRP
DELAY
DESCRIPT
DOCLIB
DOCMEM
ELAPTIME
ENDRUN
FAILCOUNT
FROMTIME
HOLDFLAG
INSTREAM_IND
INSTREAM_SCRIPT
INTERVAL_SEQUENCE
JOBNAME
JOBNO
MAXDAYS
MAXRERUN
MAXRUNS
MAXWAIT
MEMLIB
MEMNAME
MULTIAGENT
NEXTDATE
NEXTTIME
NEXTTIME_DST
NODEGRP
NODEGRP_REASON
ODATE
ORDER_TIME
OSCOMPMSG
OSCOMPSTAT
OVERLIB
OWNER
PPCMDATE
PREVDATE
PRIORITY
PROCID
REMOVEATONCE
RERUN_NO
RETRO
RJX_AGENT_NAME
RUN_TIMES
RUNCOUNT
SCHEDTAB
SMART_ORDERNO
STARTENDCYCIND
STARTRUN
STATEMSK
STATUS
TASKCLASS
TASKTYPE
TIMEREF
TOLERANCE
TRIGGER_TAG
UNKNOWNTIM
UNTIL

NUMBER
NUMBER

CMR_CAPTURE_DEFS

ORDERNO
ROWORDER
VARCHAR(128)
CHAR(1)
VARCHAR(128)
VARCHAR(64)
NUMBER
NUMBER
NUMBER

NUMBER
NUMBER
NUMBER
NUMBER
CHAR(2)

PK
PK
DELIMITER
CAPTURE_BY
CAPTURE_INTO
SEARCH_STRING
SKIP
SKIP_LINES
TAKE_COUNT

ORDERNO
DO_NO
IF_NO
ROWORDER
ROWTYPE

CMR_CON_J

PK, I1
PK
PK
PK
PK
CHAR(2)
VARCHAR(255)
CHAR(4)
CHAR(2)

NUMBER
VARCHAR(64)
NUMBER
CHAR(2)

CHAR(8)
VARCHAR(255)

CHAR(2)
VARCHAR(14)

CMR_CONTAB

CMR_CTL_J

OP
CONDNAME
DATEREF
PARENTHESES

SIGN
TIMESTAMP

CONDDATE
CONDNAME

ROWORDER
CMODE

ORDERNO
CONTROL

I3
I2

PK
PK

PK
PK

CMODE
RESCOUNT
USECOUNT
CMODE
CONTROL

PK