DBPARAMERS.txt
#
# how to see the database paramters
#
#
#
# run testplus
#
~$ testplus TST test test
+-----------------------------------------------------------+
| TST : uid=test |
| connected |
| type 'help' for commands |
+-----------------------------------------------------------+
#
# run 'select * from db_paramters'
#
SQL/command > select * from dbparameters;
+-----------------------------------------------------------+
| DESCRIPTION | VALUE |
+-----------------------------------------------------------+
| ARCHIVE_LOG_001 | /var/opt/dbpaq/recovery/TST.rec |
+-----------------------------------------------------------+
| ARCHIVE_SIZE_001 | 19200 |
+-----------------------------------------------------------+
| BACKUP_BLOCK_CNT | 8 |
+-----------------------------------------------------------+
| CAT_CACHE_SUPPLY | 1312 |
+-----------------------------------------------------------+
| CONTROLUSERID | DBM |
+-----------------------------------------------------------+
| CONVERTER_CACHE | 14 |
+-----------------------------------------------------------+
| DATADEV_0001 | /var/opt/dbpaq/data/TST.d01 |
+-----------------------------------------------------------+
| DATADEV_0002 | /var/opt/dbpaq/data/TST.d02 |
+-----------------------------------------------------------+
| DATA_CACHE | 2050 |
+-----------------------------------------------------------+
| DATA_SIZE_0001 | 6400 |
+-----------------------------------------------------------+
| DATA_SIZE_0002 | 6400 |
+-----------------------------------------------------------+
| DATE_TIME_FORMAT | INTERNAL |
+-----------------------------------------------------------+
| DEADLOCK_DETECTION | 4 |
+-----------------------------------------------------------+
| DEFAULT_CODE | ASCII |
+-----------------------------------------------------------+
| DIAG_HISTORY_NUM | 2 |
+-----------------------------------------------------------+
| DIAG_HISTORY_PATH | /var/opt/dbpaq/indep_data/wrk/TST/DIAGHISTORY |
+-----------------------------------------------------------+
| INSTANCE_TYPE | OLTP |
+-----------------------------------------------------------+
| JOIN_MAXTAB_LEVEL4 | 16 |
+-----------------------------------------------------------+
| JOIN_MAXTAB_LEVEL9 | 5 |
+-----------------------------------------------------------+
| JOIN_SEARCH_LEVEL | 0 |
+-----------------------------------------------------------+
| KERNELDIAGSIZE | 100 |
+-----------------------------------------------------------+
| KERNELTRACESIZE | 519 |
+-----------------------------------------------------------+
| KERNELVERSION | KERNEL 7.3.0 BUILD 048-001-001-001 |
+-----------------------------------------------------------+
| LOG_BACKUP_TO_PIPE | NO |
+-----------------------------------------------------------+
| LOG_IO_QUEUE | 50 |
+-----------------------------------------------------------+
| LOG_MODE | SINGLE |
+-----------------------------------------------------------+
| LOG_SEGMENT_SIZE | 0 |
+-----------------------------------------------------------+
| LRU_FOR_SCAN | NO |
+-----------------------------------------------------------+
| MAXARCHIVELOGS | 2 |
+-----------------------------------------------------------+
| MAXBACKUPDEVS | 2 |
+-----------------------------------------------------------+
| MAXCPU | 1 |
+-----------------------------------------------------------+
| MAXDATADEVSPACES | 6 |
+-----------------------------------------------------------+
| MAXDATAPAGES | 25600 |
+-----------------------------------------------------------+
| MAXLOCKS | 10000 |
+-----------------------------------------------------------+
| MAXRGN_REQUEST | 300 |
+-----------------------------------------------------------+
| MAXSERVERTASKS | 16 |
+-----------------------------------------------------------+
| MAXUSERTASKS | 40 |
+-----------------------------------------------------------+
| MP_RGN_LOOP | 0 |
+-----------------------------------------------------------+
| OMS_HEAP_LIMIT | 0 |
+-----------------------------------------------------------+
| OPMSG1 | /dev/console |
+-----------------------------------------------------------+
| OPMSG2 | /dev/null |
+-----------------------------------------------------------+
| OPTIM_BUILD_RESLT | 15 |
+-----------------------------------------------------------+
| OPTIM_FETCH_RESLT | 15 |
+-----------------------------------------------------------+
| OPTIM_JOIN_FETCH | 0 |
+-----------------------------------------------------------+
| OPTIM_KEY_INV_RATE | 0 |
+-----------------------------------------------------------+
| OPTIM_MAX_MERGE | 500 |
+-----------------------------------------------------------+
| OPTIM_ORDERBY_IDX | 2 |
+-----------------------------------------------------------+
| OPTIM_OR_DISTINCT | 5 |
+-----------------------------------------------------------+
| PACKET_SIZE | 36864 |
+-----------------------------------------------------------+
| REQUEST_TIMEOUT | 30 |
+-----------------------------------------------------------+
| RESERVED_REDO_SIZE | 0 |
+-----------------------------------------------------------+
| ROLLBACK_CACHE | 16 |
+-----------------------------------------------------------+
| RUNDIRECTORY | /var/opt/dbpaq/indep_data/wrk/TST |
+-----------------------------------------------------------+
| SEQUENCE_CACHE | 1 |
+-----------------------------------------------------------+
| SESSION_TIMEOUT | 900 |
+-----------------------------------------------------------+
| SUPPRESS_CORE | YES |
+-----------------------------------------------------------+
| SYSDEV_001 | /var/opt/dbpaq/data/TST.sys |
+-----------------------------------------------------------+
| TRACE_PAGES_AL | 5 |
+-----------------------------------------------------------+
| TRACE_PAGES_BUP | 0 |
+-----------------------------------------------------------+
| TRACE_PAGES_CS | 2 |
+-----------------------------------------------------------+
| TRACE_PAGES_DW | 3 |
+-----------------------------------------------------------+
| TRACE_PAGES_EV | 2 |
+-----------------------------------------------------------+
| TRACE_PAGES_GC | 0 |
+-----------------------------------------------------------+
| TRACE_PAGES_SV | 5 |
+-----------------------------------------------------------+
| TRACE_PAGES_TI | 2 |
+-----------------------------------------------------------+
| TRACE_PAGES_US | 10 |
+-----------------------------------------------------------+
| TRACE_PAGES_UT | 5 |
+-----------------------------------------------------------+
| USE_OPEN_DIRECT | NO |
+-----------------------------------------------------------+
| UTILITY_PROTSIZE | 100 |
+-----------------------------------------------------------+
| _AK_DUMP_ALLOWED | YES |
+-----------------------------------------------------------+
| _BACKUP_HISTFILE | dbm.knl |
+-----------------------------------------------------------+
| _BACKUP_MED_DEF | dbm.mdf |
+-----------------------------------------------------------+
| _CAT_CACHE_MINSIZE | 262144 |
+-----------------------------------------------------------+
| _COPY_IO_BLOCK_CNT | 4 |
+-----------------------------------------------------------+
| _DATA_CACHE_RGNS | 8 |
+-----------------------------------------------------------+
| _DELAY_COMMIT | NO |
+-----------------------------------------------------------+
| _DELAY_LOGWRITER | 0 |
+-----------------------------------------------------------+
| _DIAG_SEM | 1 |
+-----------------------------------------------------------+
| _DW_COPY_BOUNDARY | 60 |
+-----------------------------------------------------------+
| _DW_IO_AREA_FLUSH | 50 |
+-----------------------------------------------------------+
| _DW_IO_AREA_SIZE | 50 |
+-----------------------------------------------------------+
| _DW_LRU_TAIL_FLUSH | 25 |
+-----------------------------------------------------------+
| _DYN_TASK_STACK | NO |
+-----------------------------------------------------------+
| _EVENTFILE | knldiag.evt |
+-----------------------------------------------------------+
| _EVENTSIZE | 0 |
+-----------------------------------------------------------+
| _EVENT_ALIVE_CYCLE | 0 |
+-----------------------------------------------------------+
| _FBM_CACHE | 7 |
+-----------------------------------------------------------+
| _FBM_DEVSP_BALANCE | 10 |
+-----------------------------------------------------------+
| _FBM_DEVSP_COMPR | 50 |
+-----------------------------------------------------------+
| _FBM_LOW_IO_RATE | 10 |
+-----------------------------------------------------------+
| _IDXFILE_LIST_SIZE | 0 |
+-----------------------------------------------------------+
| _IOPROCS_FOR_PRIO | 0 |
+-----------------------------------------------------------+
| _IOPROCS_PER_DEV | 2 |
+-----------------------------------------------------------+
| _IOPROCS_SWITCH | 2 |
+-----------------------------------------------------------+
| _KERNELDIAGFILE | knldiag |
+-----------------------------------------------------------+
| _KERNELDUMPFILE | knldump |
+-----------------------------------------------------------+
| _KERNELTRACEFILE | knltrace |
+-----------------------------------------------------------+
| _LOCK_SUPPLY_BLOCK | 100 |
+-----------------------------------------------------------+
| _LOG_COPY_DISTANCE | 0 |
+-----------------------------------------------------------+
| _LOG_START_COPY | 0 |
+-----------------------------------------------------------+
| _MAXAUTOBACKUPDEVS | 1 |
+-----------------------------------------------------------+
| _MAXDATAWRITER | 8 |
+-----------------------------------------------------------+
| _MAXDEVSPACES | 9 |
+-----------------------------------------------------------+
| _MAXEVENTTASKS | 0 |
+-----------------------------------------------------------+
| _MAXGARBAGE_COLL | 0 |
+-----------------------------------------------------------+
| _MAXSYSDEVSPACES | 1 |
+-----------------------------------------------------------+
| _MAXTASK_STACK | 310 |
+-----------------------------------------------------------+
| _MAXTRANS | 232 |
+-----------------------------------------------------------+
| _MAX_MESSAGE_FILES | 0 |
+-----------------------------------------------------------+
| _MBLOCK_DATA_SIZE | 32768 |
+-----------------------------------------------------------+
| _MBLOCK_QUAL_SIZE | 8192 |
+-----------------------------------------------------------+
| _MBLOCK_STACK_SIZE | 16384 |
+-----------------------------------------------------------+
| _MINREPLY_SIZE | 4096 |
+-----------------------------------------------------------+
| _MIRRORED_DATA | NO |
+-----------------------------------------------------------+
| _MP_DISP_LOOPS | 2 |
+-----------------------------------------------------------+
| _MP_DISP_PRIO | NO |
+-----------------------------------------------------------+
| _MP_RGN_BUSY_WAIT | NO |
+-----------------------------------------------------------+
| _MP_RGN_DIRTY_READ | NO |
+-----------------------------------------------------------+
| _MP_RGN_PRIO | NO |
+-----------------------------------------------------------+
| _MP_RGN_QUEUE | YES |
+-----------------------------------------------------------+
| _MULTIBYTE_CACHE | 0 |
+-----------------------------------------------------------+
| _MULTIBYTE_SET1 | NOT_USED |
+-----------------------------------------------------------+
| _MULTIBYTE_SET2 | NOT_USED |
+-----------------------------------------------------------+
| _MULTIBYTE_SET3 | NOT_USED |
+-----------------------------------------------------------+
| _MULTIBYTE_SET4 | NOT_USED |
+-----------------------------------------------------------+
| _MULTIBYTE_SET5 | NOT_USED |
+-----------------------------------------------------------+
| _MULT_IO_BLOCK_CNT | 8 |
+-----------------------------------------------------------+
| _OMS_RGNS | 8 |
+-----------------------------------------------------------+
| _PAGE_SIZE | 8192 |
+-----------------------------------------------------------+
| _PNO_SUPPLY_SIZE | 25600 |
+-----------------------------------------------------------+
| _PRIO_BASE_COM | 10 |
+-----------------------------------------------------------+
| _PRIO_BASE_IOC | 80 |
+-----------------------------------------------------------+
| _PRIO_BASE_RAV | 80 |
+-----------------------------------------------------------+
| _PRIO_BASE_REX | 40 |
+-----------------------------------------------------------+
| _PRIO_BASE_U2U | 100 |
+-----------------------------------------------------------+
| _PRIO_FACTOR | 80 |
+-----------------------------------------------------------+
| _READAHEAD_BLOBS | 25 |
+-----------------------------------------------------------+
| _RESTART_TIME | 600 |
+-----------------------------------------------------------+
| _ROW_RGNS | 8 |
+-----------------------------------------------------------+
| _RTEDUMPFILE | rtedump |
+-----------------------------------------------------------+
| _SERVERDB_FOR_SAP | YES |
+-----------------------------------------------------------+
| _SERVER_CMD_CACHE | 17 |
+-----------------------------------------------------------+
| _SERVER_DESC_CACHE | 59 |
+-----------------------------------------------------------+
| _SHAREDDYNDATA | 2368 |
+-----------------------------------------------------------+
| _SHAREDDYNPOOL | 4579 |
+-----------------------------------------------------------+
| _SHMCHUNK | 32 |
+-----------------------------------------------------------+
| _SHMKERNEL | 28162 |
+-----------------------------------------------------------+
| _SVP_1_CONV_FLUSH | NO |
+-----------------------------------------------------------+
| _TAB_RGNS | 8 |
+-----------------------------------------------------------+
| _TASKCLUSTER_01 | tw;al;ut;2000*sv,100*bup;10*ev,10*gc; |
+-----------------------------------------------------------+
| _TASKCLUSTER_02 | ti,100*dw,cs;30000*us; |
+-----------------------------------------------------------+
| _TASKCLUSTER_03 | compress |
+-----------------------------------------------------------+
| _TRANS_RGNS | 8 |
+-----------------------------------------------------------+
| _TREE_RGNS | 2 |
+-----------------------------------------------------------+
| _UNICODE | NO |
+-----------------------------------------------------------+
| _USE_IOPROCS_ONLY | NO |
+-----------------------------------------------------------+
| _USE_PROC_SCOPE | NO |
+-----------------------------------------------------------+
| _USE_THRD_FOR_TSK | NO |
+-----------------------------------------------------------+
| _USM_CACHE | 4 |
+-----------------------------------------------------------+
| _UTILITY_PROTFILE | dbm.utl |
+-----------------------------------------------------------+
| _WORKDATA_SIZE | 4096 |
+-----------------------------------------------------------+
| _WORKSTACK_SIZE | 8192 |
+-----------------------------------------------------------+
| __PARAM_CHANGED___ | 0 |
+-----------------------------------------------------------+
fetched rows : 163
#
# quit
#
SQL/command > quit;
+-----------------------------------------------------------+
| disconnected |
| commit=sql : no autocommit has been done |
| statement(s) after your last commit will be rollbacked |
+-----------------------------------------------------------+
bye
All SourceForge.net projects that use the SourceForge.net project web services
are required to display the SourceForge.net logo on all web pages :