Informix11.7里面有默认四个数据库server,分别为:
sysadmin
sysmaster
sysuser
sysutils
这四个server里面到底有那些表呢?如下cp一份,以备后查。
一、sysadmin
aus_cmd_comp
aus_cmd_info
aus_cmd_list
aus_command
command_history
storagepool
mon_sysenv
mon_prof
mon_table_names
mon_onconfig
mon_profile
mon_table_profile
mon_memory_system
mon_checkpoint
mon_users
mon_config
mon_vps
ph_bg_jobs
ph_bg_jobs_seq
ph_task
ph_config
ph_run
ph_group
ph_alert
ph_threshold
ph_bg_jobs_results
ph_alerts
ph_version
二、sysmaster
flags_text syscdr_rcv syscdrrecvqprog syscmsm sysdistcache syslicenseinfo sysnetworkio
logmessage syscdr_ris syscdrs syscmsmsla sysdrcb syslocks sysonlinelog
smi_build_status syscdr_risdir syscdrsend_buf syscmsmtab sysdri syslocktab sysopendb
sysactptnhdr syscdr_rqm syscdrsend_txn syscompdicts sysdsc syslogfil syspaghdr
sysadtinfo syscdr_rqmhandle syscdrsync_buf syscompdicts_full sysdual syslogs sysphyspaghdrs
sysaqt syscdr_rqmstamp syscdrsync_txn sysconblock sysdwacoord syslowmemorymgr sysplog
sysaqtjp syscdr_state syscdrtx sysconditions sysenv syslrus syspoollst
sysaqttab syscdrack_buf syscfgtab sysconfig sysenvses sysmachineinfo syspools
sysaudit syscdrack_txn syscheckpoint sysconlst sysextents sysmchktab sysprc
sysbaract_log syscdrcntrlqprog syschfree sysconq sysextspaces sysmchktab_fast sysprobecolumns
sysbtcreq syscdrctrl_buf syschkextents syscrtadt sysfeatures sysmgmgates sysprobejds
sysbufhdr syscdrctrl_txn syschkio sysdatabases sysfileinfo sysmgminfo sysprobejps
sysbufpool syscdrlatency syschktab sysdbslocale sysha_lagtime sysmgmquery sysprobetables
sysbufprofile syscdrprog syschktab_fast sysdbspaces sysha_nodes sysmtxlst sysproccache
syscdr_ats syscdrq syschunks sysdbspartn sysha_type sysmutexes sysprof_address
syscdr_atsdir syscdrrecv_buf syschunks_fast sysdbstab sysha_workload sysmutq sysprof_func
syscdr_ddr syscdrrecv_stats sysckptinfo sysdic sysipl sysnetclienttype sysprof_percentage
syscdr_nif syscdrrecv_txn syscluster sysdiccache syslcktab sysnetglobal
sysrepstats syssqexplain systabpagtypes
sysprofile sysrsslog syssqlcacheprof systcblst
sysproftab sysrstcb syssqlcurall systhreads
sysproxyagents sysscblst syssqlcurses systhreadwaits
sysproxydistribut+ syssdblock syssqlhosts systraces
sysproxysessions sysseglst syssqlstat systrans
sysproxytxnops syssegments syssqltrace systrgrss
sysproxytxns syssesappinfo syssqltrace_hvar systrgsds
sysptnbit syssesprof syssqltrace_info systwaits
sysptncol syssessions syssqltrace_iter systxptab
sysptnext sysseswts syssqscb sysuserthreads
sysptnhdr sysshmem syssrcrss sysvplst
sysptnkey sysshmhdr syssrcsds sysvpprof
sysptntab sysshmvals sysstoragemgr sysxatab
sysptprof syssltdat syssymtab
sysrawdsk sysslttab systabextents
sysreorgops syssmx systabinfo
sysrepevtreg syssmxses systabnames
三、sysuser
sysauth
sysdbsecadmauth
sysintauthusers
syssurrogategroups
syssurrogates
systcxattributes
systcxusers
systrustedcontext
sysusermap
四、sysutils
bar_action
bar_instance
bar_object
bar_orderseq
bar_ordertab
bar_server