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 : SourceForge.net Logo Support This Project