Documentation
Documentation generated on: 10/29/2008 10:37:41 PM
Database objects
Database properties
| name | value |
|---|
| name | stores_demo |
| server | summer |
| size |
|
| created | 9/16/2007 12:00:00 AM |
| status | |
| owner | Jesse |
| version | IBM Informix Dynamic Server Version 10.00.TC5I1 |
Server Properties
| name | value |
|---|
| ROOTNAME | rootdbs |
| ROOTPATH | C:\IFMXDATA\summer\rootdbs_dat.000 |
| DBSERVERNAME | summer |
| MIRRORPATH | |
| PHYSDBS | rootdbs |
| MSGPATH | C:\PROGRA~1\IBM\Informix\summer.log |
| CONSOLE | C:\PROGRA~1\IBM\Informix\consummer.log |
| TAPEDEV | \\.\TAPE0 |
| LTAPEDEV | NUL |
| ROOTOFFSET | 0 |
| ROOTSIZE | 51200 |
| MIRROR | 0 |
| MIRROROFFSET | 0 |
| PHYSFILE | 2000 |
| LOGFILES | 6 |
| LOGSIZE | 2000 |
| TAPEBLK | 16 |
| TAPESIZE | 10240 |
| LTAPEBLK | 16 |
| LTAPESIZE | 10240 |
| SERVERNUM | 0 |
| DEADLOCK_TIMEOUT | 60 |
| RESIDENT | 0 |
| LOCKS | 2000 |
| BUFFERS | 1000 |
| ONDBSPACEDOWN | 2 |
| OPCACHEMAX | 0 |
| PHYSBUFF | 32 |
| LOGBUFF | 32 |
| DYNAMIC_LOGS | 2 |
| CLEANERS | 1 |
| SHMBASE | 0xc000000 |
| CKPTINTVL | 300 |
| LRUS | 8 |
| LRU_MAX_DIRTY | 60.000000 |
| LRU_MIN_DIRTY | 50.000000 |
| SINGLE_CPU_VP | 0 |
| LTXHWM | 70 |
| LTXEHWM | 80 |
| TXTIMEOUT | 300 |
| NUMCPUVPS | 1 |
| DRAUTO | 0 |
| SHMVIRTSIZE | 0x2000 |
| USEOSTIME | 0 |
| NOAGE | 0 |
| AFF_SPROC | 0 |
| AFF_NPROCS | 0 |
| RA_PAGES | 4 |
| RA_THRESHOLD | 2 |
| NUMAIOVPS | 1 |
| NETTYPE | soctcp,1,50,NET |
| DBSERVERALIASES | |
| MULTIPROCESSOR | 0 |
| FILLFACTOR | 90 |
| STACKSIZE | 64 |
| DBSPACETEMP | |
| STAGEBLOB | |
| DRNODE | 0 |
| DRNAME | |
| DRINTERVAL | 30 |
| DRTIMEOUT | 30 |
| DRLOSTFOUND | \tmp |
| OFF_RECVRY_THREADS | 10 |
| ON_RECVRY_THREADS | 1 |
| DUMPSHMEM | 1 |
| DUMPGCORE | 0 |
| DUMPCORE | 0 |
| DUMPCNT | 1 |
| DUMPDIR | C:\PROGRA~1\IBM\Informix\tmp |
| DATASKIP | off |
| ALRM_ALL_EVENTS | 0 |
| DS_MAX_QUERIES | 1 |
| DS_TOTAL_MEMORY | 2000 |
| DS_MAX_SCANS | 1048576 |
| SHMADD | 0x800000 |
| SHMTOTAL | 0x0 |
| OPTCOMPIND | 2 |
| MAX_PDQPRIORITY | 100 |
| HETERO_COMMIT | 0 |
| BAR_ACT_LOG | C:\PROGRA~1\IBM\Informix\bar_summer.log |
| BAR_DEBUG_LOG | C:\PROGRA~1\IBM\Informix\bar_summer.log |
| BAR_MAX_BACKUP | 0 |
| BAR_RETRY | 1 |
| BAR_NB_XPORT_COUNT | 20 |
| BAR_XFER_BUF_SIZE | 15 |
| BAR_DEBUG | 0 |
| BAR_BSALIB_PATH | C:\ISM\2.20\bin\libbsa.dll |
| VPCLASS | |
| SBSPACENAME | sbspace |
| BLOCKTIMEOUT | 3600 |
| AFFAIL | 1025 |
| AFWARN | 1025 |
| AFCRASH | 1537 |
| AFLINES | 0 |
| SYSALARMPROGRAM | C:\PROGRA~1\IBM\Informix/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 |
| 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\Informix\extend\krakatoa\krakatoa.jar;C:\PROGRA~1\IBM\Informix\extend\krakatoa\jdbc.jar |
| JVPHOME | C:\PROGRA~1\IBM\Informix\extend\krakatoa |
| JVPLOGFILE | C:\PROGRA~1\IBM\Informix\extend\krakatoa\summer_jvp.log |
| JVPPROPFILE | C:\PROGRA~1\IBM\Informix\extend\krakatoa\.jvpprops_summer |
| JVPJAVAHOME | C:\PROGRA~1\IBM\Informix\extend\krakatoa\jre |
| JVPJAVAVM | jsig;dbgmalloc;hpi;jvm;java;net;zip;jpeg |
| JVPJAVALIB | \bin\ |
| JDKVERSION | 1.4 |
| JVMTHREAD | green |
| JVPDEBUG | 0 |
| BAR_PROGRESS_FREQ | 0 |
| NOFUZZYCKPT | 0 |
| BAR_HISTORY | 0 |
| STMT_CACHE_NOLIMIT | 1 |
| JVPARGS | |
| STMT_CACHE_NUMPOOL | 1 |
| STMT_CACHE_HITS | 0 |
| SBSPACETEMP | |
| CLOSEPARTP | 0 |
| PART_INCR | 50 |
| PLOG_OVERFLOW_PATH | |
| SEQ_CACHE_SIZE | 10 |
| PAM_STACKSIZE | 32 |
| NONEXCLTRIG | 0 |
| TBLTBLFIRST | 1000 |
| TBLTBLNEXT | 200 |
| DRIDXAUTO | 0 |
| MSCVP_STACKSIZE | 128 |
| FAST_RESTART_PHYSLOG | 0 |
| FAST_RESTART_CKPT_FUZZYLOG | 0 |
| IFX_EXTEND_ROLE | 1 |
| CDR_SUPPRESS_ATSRISWARN | |
| DS_NONPDQ_QUERY_MEM | 128 |
| BTSCANNER | |
| MULTIPREPSTMT | 0 |
| ONLIDX_MAXMEM | 5120 |
| DISABLE_B162428_XA_FIX | 0 |
| SECURITY_LOCALCONNECTION | 0 |
| UNSECURE_ONSTAT | 0 |
| DB_LIBRARY_PATH | |
| IFX_FOLDVIEW | 0 |
| EXTSHMADD | 0x800000 |
| XA_CONN_LEVEL_SETTING | 1 |
| DRDA_COMMBUFFSIZE | 32768 |
| FASTPOLL | 0 |
| BAR_IXBAR_PATH | |
| VP_MEM_CACHE_KB | 0 |