To prove what you have said when you were young! ——Alexy Young

Follow Your Heart

PM/ACP/PRINCE2……

   :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

 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

 

posted on 2015-08-18 11:41  Alexy Young  阅读(740)  评论(0编辑  收藏  举报

Alexy Young CHASEDREAM