Documentation
Documentation generated on: 5/14/2009 9:50:26 PM
Database objects
Database properties
| name | value |
|---|
| name | stores_demo |
| server | ol_svr_custom |
| size |
|
| created | 5/3/2009 12:00:00 AM |
| status | |
| owner | informix |
| version | IBM Informix Dynamic Server Version 11.50.TC3DE |
Server Properties
| name | value |
|---|
| ROOTNAME | rootdbs |
| ROOTPATH | C:\IFMXDATA\ol_svr_custom\rootdbs_dat.000 |
| DBSERVERNAME | ol_svr_custom |
| MIRRORPATH | |
| PHYSDBS | rootdbs |
| MSGPATH | C:\PROGRA~1\IBM\IBMINF~1\11.50\ol_svr_custom.log |
| CONSOLE | C:\PROGRA~1\IBM\IBMINF~1\11.50\conol_svr_custom.log |
| TAPEDEV | \\.\TAPE0 |
| LTAPEDEV | NUL |
| ROOTOFFSET | 0 |
| ROOTSIZE | 204800 |
| MIRROR | 0 |
| MIRROROFFSET | 0 |
| PHYSFILE | 50000 |
| LOGFILES | 6 |
| LOGSIZE | 10000 |
| TAPEBLK | 16 |
| TAPESIZE | 0 |
| LTAPEBLK | 16 |
| LTAPESIZE | 0 |
| SERVERNUM | 0 |
| DEADLOCK_TIMEOUT | 60 |
| RESIDENT | 0 |
| LOCKS | 20000 |
| BUFFERS | 10000 |
| ONDBSPACEDOWN | 2 |
| OPCACHEMAX | 0 |
| PHYSBUFF | 128 |
| LOGBUFF | 64 |
| DYNAMIC_LOGS | 2 |
| CLEANERS | 8 |
| SHMBASE | 0x0C000000 |
| CKPTINTVL | 300 |
| LRUS | 8 |
| LRU_MAX_DIRTY | 60.000000 |
| LRU_MIN_DIRTY | 50.000000 |
| SINGLE_CPU_VP | 1 |
| LTXHWM | 70 |
| LTXEHWM | 80 |
| TXTIMEOUT | 300 |
| NUMCPUVPS | 1 |
| DRAUTO | 0 |
| SHMVIRTSIZE | 32656 |
| USEOSTIME | 0 |
| NOAGE | 1 |
| AFF_SPROC | 0 |
| AFF_NPROCS | 0 |
| RA_PAGES | 64 |
| RA_THRESHOLD | 16 |
| NUMAIOVPS | 1 |
| QSTATS | 0 |
| DD_HASHSIZE | 31 |
| DD_HASHMAX | 10 |
| NETTYPE | soctcp,1,50,CPU |
| DBSERVERALIASES | svc_drda |
| WSTATS | 0 |
| MULTIPROCESSOR | 0 |
| FILLFACTOR | 90 |
| STACKSIZE | 64 |
| PC_HASHSIZE | 31 |
| PC_POOLSIZE | 127 |
| DBSPACETEMP | |
| STAGEBLOB | |
| DRNODE | 0 |
| DRNAME | |
| DRINTERVAL | 30 |
| DRTIMEOUT | 30 |
| DRLOSTFOUND | C:\PROGRA~1\IBM\IBMINF~1\11.50\etc\dr.lostfound |
| DS_HASHSIZE | 31 |
| DS_POOLSIZE | 127 |
| OFF_RECVRY_THREADS | 10 |
| ON_RECVRY_THREADS | 1 |
| DUMPSHMEM | 1 |
| DUMPGCORE | 0 |
| DUMPCORE | 0 |
| DUMPCNT | 1 |
| DUMPDIR | C:\PROGRA~1\IBM\IBMINF~1\11.50\tmp |
| DATASKIP | off |
| ALRM_ALL_EVENTS | 0 |
| DS_MAX_QUERIES | 1 |
| DS_TOTAL_MEMORY | 2000 |
| DS_MAX_SCANS | 1048576 |
| SHMADD | 8388608 |
| SHMTOTAL | 1073741824 |
| OPTCOMPIND | 2 |
| MAX_PDQPRIORITY | 100 |
| ALARMPROGRAM | C:\PROGRA~1\IBM\IBMINF~1\11.50\etc\alarmprogram.bat |
| HETERO_COMMIT | 0 |
| BAR_ACT_LOG | C:\PROGRA~1\IBM\IBMINF~1\11.50\bar_ol_svr_custom.log |
| BAR_DEBUG_LOG | C:\PROGRA~1\IBM\IBMINF~1\11.50\bar_ol_svr_custom.log |
| BAR_MAX_BACKUP | 0 |
| BAR_RETRY | 1 |
| BAR_NB_XPORT_COUNT | 20 |
| BAR_XFER_BUF_SIZE | 15 |
| BAR_DEBUG | 0 |
| BAR_BSALIB_PATH | |
| VPCLASS | |
| SBSPACENAME | sbspace |
| BLOCKTIMEOUT | 3600 |
| AFFAIL | 1025 |
| AFWARN | 1025 |
| AFCRASH | 1537 |
| AFLINES | 0 |
| SYSALARMPROGRAM | C:\PROGRA~1\IBM\IBMINF~1\11.50/etc/evidence.bat |
| DIRECTIVES | 1 |
| TBLSPACE_STATS | 1 |
| CDR_EVALTHREADS | 1,2 |
| CDR_DSLOCKWAIT | 5 |
| CDR_QUEUEMEM | 4096 |
| CDR_QHDR_DBSPACE | |
| CDR_NIFCOMPRESS | 0 |
| CDR_QDATA_SBSPACE | |
| CDR_SERIAL | 0,0 |
| CDR_DBSPACE | |
| CDR_MAX_DYNAMIC_LOGS | 0 |
| RESTARTABLE_RESTORE | 1 |
| ALLOW_NEWLINE | 0 |
| SYSSBSPACENAME | sbspace |
| ISM_DATA_POOL | ISMData |
| ISM_LOG_POOL | ISMLogs |
| OPT_GOAL | -1 |
| LOG_BACKUP_MODE | MANUAL |
| STMT_CACHE | 0 |
| STMT_CACHE_SIZE | 512 |
| JVPCLASSPATH | C:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\krakatoa.jar;C:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\jdbc.jar |
| JVPHOME | C:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa |
| JVPLOGFILE | C:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\ol_svr_custom_jvp.log |
| JVPPROPFILE | C:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\.jvpprops_ol_svr_custom |
| JVPJAVAHOME | C:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\jre |
| JVPJAVAVM | jvm |
| JVPJAVALIB | \bin |
| JDKVERSION | |
| JVMTHREAD | green |
| JVPDEBUG | 0 |
| BAR_PROGRESS_FREQ | 0 |
| BAR_HISTORY | 0 |
| STMT_CACHE_NOLIMIT | 0 |
| JVPARGS | |
| STMT_CACHE_NUMPOOL | 1 |
| STMT_CACHE_HITS | 0 |
| SBSPACETEMP | |
| DEF_TABLE_LOCKMODE | page |
| CLOSE_PARTP | 0 |
| PART_INCR | 50 |
| PLOG_OVERFLOW_PATH | |
| SEQ_CACHE_SIZE | 10 |
| ENCRYPT_CIPHERS | |
| ENCRYPT_MAC | medium |
| ENCRYPT_MACFILE | builtin |
| ENCRYPT_CDR | 0 |
| ENCRYPT_HDR | 0 |
| ENCRYPT_SWITCH | 0,0 |
| MAX_FILL_DATA_PAGES | 0 |
| PAM_STACKSIZE | 32 |
| NONEXCLTRIG | 0 |
| TBLTBLFIRST | 1000 |
| TBLTBLNEXT | 200 |
| DRIDXAUTO | 0 |
| MSCVP_STACKSIZE | 128 |
| EXT_DIRECTIVES | 0 |
| LISTEN_TIMEOUT | 60 |
| MAX_INCOMPLETE_CONNECTIONS | 1024 |
| IFX_EXTEND_ROLE | 1 |
| BUFFERPOOL | size=4K,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000 |
| BUFFERS_DEFAULT | size=4K |
| LRUS_DEFAULT | lrus=4 |
| MAX_DIRTY_DEFAULT | lru_max_dirty=0 |
| MIN_DIRTY_DEFAULT | lru_min_dirty=0 |
| CDR_SUPPRESS_ATSRISWARN | |
| DS_NONPDQ_QUERY_MEM | 128 |
| BTSCANNER | num=1,threshold=5000,rangesize=-1,alice=6,compression=med |
| MULTIPREPSTMT | 0 |
| ONLIDX_MAXMEM | 5120 |
| DISABLE_B162428_XA_FIX | 0 |
| SECURITY_LOCALCONNECTION | 0 |
| UNSECURE_ONSTAT | 0 |
| DB_LIBRARY_PATH | |
| IFX_FOLDVIEW | 0 |
| EXTSHMADD | 8388608 |
| XA_CONN_LEVEL_SETTING | 1 |
| DRDA_COMMBUFFSIZE | 65536 |
| FASTPOLL | 1 |
| BAR_IXBAR_PATH | |
| VP_MEMORY_CACHE_KB | 0 |
| ADMIN_USER_MODE_WITH_DBSA | 0 |
| SHMVIRT_ALLOCSEG | 0.000000 |
| RTO_SERVER_RESTART | 0 |
| RAS_PLOG_SPEED | 6250 |
| RAS_LLOG_SPEED | 0 |
| AUTO_LRU_TUNING | 1 |
| AUTO_CKPTS | 1 |
| AUTO_AIOVPS | 1 |
| INDEX_SELFJOIN | 1 |
| EXPLAIN_STAT | 1 |
| SQLTRACE | level=off,ntraces=1000,size=1,size=1 |
| USELASTCOMMITTED | NONE |
| SORT_MERGE_SIZE | 0 |
| PLCY_HASHSIZE | 31 |
| PLCY_POOLSIZE | 127 |
| USRC_HASHSIZE | 31 |
| USRC_POOLSIZE | 127 |
| TEMPTAB_NOLOG | 0 |
| LOG_INDEX_BUILDS | 0 |
| ENCRYPT_SMX | 0 |
| SDS_ENABLE | 0 |
| SDS_PAGING | |
| SDS_TIMEOUT | 20 |
| ADMIN_MODE_USERS | |
| DIRECT_IO | 0 |
| AUTO_REPREPARE | 1 |
| USE_BATCHEDREAD | 0 |
| USE_KOBATCHEDREAD | 0 |
| BAR_PERFORMANCE | 0 |
| BACKUP_FILTER | |
| RESTORE_FILTER | |
| EILSEQ_COMPAT_MODE | 0 |
| SHMNOACCESS | |
| HA_ALIAS | |
| SSL_KEYSTORE_LABEL | |
| STORAGE_FULL_ALARM | 600,3 |
| FAILOVER_CALLBACK | |
| CHECKALLDOMAINSFORUSER | 0 |
| NUMFDSERVERS | 10 |
| MSG_DATE | 0 |
| UPDATABLE_SECONDARY | 0 |
| RALLOC_MODE | HEAP |
| LIMITNUMSESSIONS | 0,1 |
| INTERRUPT_FREQ_PAGES | 128 |