sybsystemdb

name srvsecmech N N

Master Database
sysresourcelimits
name appname rangeid limitid enforced action limitvalue scope spare
rangeid N appname 1 program_name N suid spid 1 N id 1

systimeranges
name id startday endday starttime endtime

syscoordinations
participant starttime coordtype owner protocol state bootcount dbid logvers spare status xactkey gtrid partdata srvname nodeid

participant N srvname N

srvid

sysservers
srvstatus srvclass srvsecmech srvcost
1

syscurconfigs*
config value comment status value2 defvalue memory_used display_level config datatype 1 message_num apf_percent unit type nodeid
config 1

sysconfigures
config value comment status name parent value2 value3 value4

Sybase Adaptive Server Enterprise

1 srvid srvname srvname 1 srvnetname srvid

sysprocesses*
spid kpid enginenum status suid hostname program_name hostprocess cmd cpu physical_io memusage blocked dbid uid gid tran_name time_blocked
uid N

minimum_value maximum_value
remotesrvid 1

sysengines systransactions
spid 1

engine 1 cur_kpid 1 last_kpid 1

enginenum N kpid 1 kpid 1 sys_id, ses_id 1

sysremotelogins
remoteserverid remoteusername suid status
suid N name 1

sysmessages
error severity dlevel description langid sqlstate
langid langid 1 N

syslogins
suid status accdate totcpu totio spacelimit timelimit resultlimit dbname name password language pwdate audflags fullname srvname logincount procid
suid 1 suid suid 1 1 suid 1

suid

xactkey starttime failover type coordinator state connection status

status2 spid masterdbid loid namelen xactname srvname nodeid

engine osprocid osprocname status affinitied cur_kpid last_kpid

idle_1 idle_2 idle_3 idle_4 starttime nodeid

loid N

loid N

syslocks*
id dbid partitionid page type spid class fid context row loid partitionid nodeid

network_pktsz fid execlass priority affinity id stmtnum linenum origsuid block_xloid clientname clienthostname clientapplname sys_id ses_id ipaddr nodeid
spid1 1

sec_mech_name

systestlog
iterations kpid iterdate

System Tables Diagram

syssecmechs*
sec_mech_name available_service

syslisteners*
net_type address_info nodeid

sysmonitors*
field_name group_name field_id value description nodeid

fid, spid N loid N dbid N id N

fid, spid 1 block_xloid N

loggedindatetime
dbid N dbid 1 dbid 1

sysloginroles
suid srid status
srid name N language N suid 1 suid N suid 1

syssessions*
name 1 name

sysdatabases
name dbid suid status version logptr crdate dumptrdate status2 audflags deftabaud defvwaud defpraud def_remote_type def_remote_loc status3 status4 audflags2
name 1 name 1

syslanguages
langid dateformat datefirst upgrade name
langid 1

sys_id ses_id N state spare

alias months shortmonths days

status dbid name nodeid ses_data

sys_id, ses_id 1 dbid N

dbid spid1 1 1

dbid 1

dbname N suid

suid N

Sybase Adaptive Server Enterprise System Tables Diagram, an entity relationship diagram for Sybase Adaptive Server Enterprise 15.0
To order additional posters, call (800) 8-SYBASE (in USA and Canada) Part Number L00297 Sybase, Inc. One Sybase Drive Dublin, CA 94568 U.S.A.

1 name 1 dbid

name 1

srid

dbid spid1 1 dbid 1 1 dbid 1

syscharsets
type id csid status
id

syssrvroles
srid name password pwdate status logincount
srid 1

sysdevices
low high status cntrltype name phyname mirrorname vdevno vdevno 1 crdate resizedate status2
vdevno N

sysusages
dbid segmap lstart size vstart
segmap N

name description definition sortfile

pad unreservedpgs crdate vdevno

syslogshold*
dbid reserved spid page xactid

masterxactid starttime xactid name 1 xloid

Key
bitmask role vector langid N uid N suid N suid N currauth id, indid, partitionid segment N 1

systhresholds

segment N

segment segment 1

segment

sysslices
xactid 1

Configuration Users, Roles & Permissions Remote Servers Storage

syssegments
segment name status
segment 1

syspartitions
indoampg firstpage rootpage data_partitionid crdate cdataptnname
id N

sysusermessages*
error uid description langid dlevel
error 1

sysalternates
suid altsuid
altsuid N

segment free_space N status

proc_name proc_name suid N currauth

id

id

1 segment N id, indid 1 id, indid 1 conditionid N id N

sysroles
id lrid
lrid 1

type status

sysindexes
maxlen maxirow keycnt keys1 keys2 keys3 soid csid base_partition fill_factor res_page_gap exp_rowsize identitygap crdate partitiontype conditionid maxrowsperpage conditionid minlen name id indid csid, soid doampg ioampg N oampgtrips status3 status2 ipgtrips first root distribution id, indid usagecnt segment 1 status
1

name indid id, indid id partitionid N segment id status dataoampg 1

syskeys
id N

state id partitionid

firstpage controlpage spare

name 1 id 1 id 1 id 1 id 1 id id 1 1 id 1 uid N

id

1 id 1 id 1 id id 1 id id 1 id 1 id id 1 1 1 1 id 1

partitionid

id type depid keycnt size key1 key8 depkey1 depkey8 spare1

syslogs*
xactid op

sysgams* sysqueryplans
uid gid hashkey id type sequence status text
uid N

sysobjects
name id uid type userstat sysstat indexdel schemacnt sysstat2 crdate expdate deltrig
crdate id 1 1 id 1

sysattributes
class attribute object_type object_cinfo object object_info1 object_info2 object_info3 int_value char_value text_value image_value comment
id, indid, partitionid 1

sysprotects
id uid action protecttype columns grantor
uid N grantor N id N

suid 1 uid 1 uid 1

uid

suid

uid

1 uid 1

sysusers
suid uid gid
uid 1 uid 1

name environ
uid 1

instrig updtrig seltrig ckfirst cache audflags objspare versionts loginame identburnmax spacestate erlchgts
id 1

Time Ranges & Limits Messages Objects Integrity Relationships Processes & Locks, Fake Catalogs Language & Character Sets Miscellaneous
The lines represent key relationships and potentially useful joins. The column names for the relationships appear above or to the left of the lines, and the type of relationship (1:1, 1:N, N:N) appears below or to the right of the lines. A comma separating column names means that the relationship requires both columns. Asterisks (*) by table names denote all-pages-locked (APL) tables. The rest are data-only-locked (DOL) tables.

id

sysdepends
id N

systabstats
indid id activestatid indexheight leafcnt pagecnt rowcnt forwrowcnt delrowcnt dpagecrcnt ipagecrcnt drowcrcnt oamapgcnt extent0pgcnt datarowsize leafrowsize

id N

sysjars
jstatus jid jname jbinary
jid 1

status plljoindegree id, indid spare2 N rslastoam rslastpage uid N frlastoam frlastpage systypes conopt_thld plldegree uid printfmt emptypgcnt usertype prec spare4 usertype variable scale partitionid allownulls ident 1 spare5 type hierarchy statmoddate length xtypeid unusedpgcnt tdefault xdbid oampagecnt domain accessrule name
domain 1 tdefault N

sysstatistics
statid id sequence moddate formatid usedcount colidarray c0 c79 indid ststatus partitionid spare2 spare3

id N id N id N id N

syspartitionkeys
indid id
id, indid encrkeyid N N id N id, colid 1 encrkeydb tableid N constrid N

id number depid depnumber status

selall resultobj readobj columns

colid position
id, colid 1 tableid reftaid N constrid N pmrydbname N

syscomments
id number colid texttype language
N id N

text colid2 status partitionid

partitionid N computedcol

encrdate 1 usertype id encrkeyid N N

syscolumns
number colid status type length offset usertype cdefault domain name printfmt prec scale

sysreferences
indexid constrid tableid reftabid keycnt status frgndbid pmrydbid spare2 fokey1 fokey16 refkey1 refkey16 frgndbname pmrydbname

ekpairid, id

sysencryptkeys
uid N

sysxtypes
xtcontainer xtutid N xtid

xtmetatype xtstatus xtcontainer

xtid xtname xtsource 1 xtbinaryinrow xtbinaryoffrow

id ekalgorithm type status eklen value

uid id eksalt 1 ekpairid pwdate expdate ekpwdwarn

sysprocedures
type id sequence
id N

id N

cdefault N domain N xtype N

status number version

id N

N remote_type N remote_name sysconstraints tableid, xstatus constrid colid xtype colid error 1 1 xdbid constrid status accessrule tableid spare2 constrid id, colid status2 error 1 constrid 1 1 1 status3 computedcol id, colid tableid, fokey1...16 encrtype 1 N encrlen id, colid reftabid, refkey1...16 encrkeyid 1 N encrkeydb xdbid encrdate N

frgndbname N

All Databases

MLG part number DC70204-01-1500-01