Shared Resources:
Shared memory version number: 6413723 Busy After Image Extent: /scratch/doc/117/testdb.a3 Locking table entries in use: 0 Locking table high water mark: 1 Number of semaphores used: 33 Broker status: Executing BI Writer status: Not executing AI Writer status: Not executing Watchdog status: Not executing Number of page writers: 0 Number of self-service users: 0 Number of remote users: 0 Number of servers: 0 Number of shut-downs: 0 Number of monitors: 1 After-image Management Archival Directory List (-aiarcdir): Not Enabled Create After-image Management Archival Directory(s) (-aiarcdircreate): Not Enabled After-image Management Archival Interval (-aiarcinterval): -1 Number of After-Image Buffers (-aibufs): 20 After-Image Stall (-aistall): Not Enabled Starting index number for statistics range (-baseindex): 1 Starting table number for statistics range (-basetable): 1 Starting index number per user for statistics range (-baseuserindex): 1 Starting table number per user for statistics range (-baseusertable): 1 Number of Before-Image Buffers (-bibufs): 20 BI File Threshold Stall (-bistall): Disabled. BI File Threshold size (-bithold): 0.0 Bytes Database Blocksize (-blocksize): 4096 BIW writer delay (-bwdelay): 0 Allowed index cursors (-c): 84 CDC cache size (-cdcsize): 200k bytes SSL Certificate Store Path (-certstorepath): Not Enabled Character Set (-cpinternal): iso8859-1 Physical Database Name (-db): jan28 Diagnostic directory (-diagDir): Not Enabled Diagnostic events value (-diagEvent): LockTable:0,BiThold:0,SysErr:0 Diagnostic event level (-diagEvtLevel): 0 Diagnostic field separator (-diagFS): ' ' Diagnostic data format (-diagFormat): csv Diagnostic pause length (-diagPause): 0 Diagnostic prefix value (-diagPrefix): diagEvent_ Diagnostic procedure (-diagProc): Not Enabled Direct I/O (-directio): Not Enabled Database Type (-dt): PROGRESS Encryption cache size (-ecsize): 1000 Group delay (-groupdelay): 10 Hash Table Entries (-hash): 887 Crash Recovery (-i): Enabled Number of indexes included in statistics collection (-indexrangesize): 50 TCP/IP Version (-ipver): Not Enabled SSL Key Alias Name (-keyalias): Not Enabled Lock table hash table size (-lkhash): 1237 Original Lock Release Algorithm (-lkrela): Not Enabled Number of LRU force skips (-lruskips): 0 Number of LRU2 force skips (-lru2skips): 0 Maximum Area Number (-maxArea): 32000 Size of JTA transaction table (-maxxids): 100 Maximum Port for Auto Servers (-maxport): 0 Minimum Port for Auto Servers (-minport): 0 Multi-tenancy partition cache size (-mtpmsize): 1024 Use muxlatches (-mux): 1 Maximum Number of Users (-n): 21 Minimum time to nap at first -spin exhaustion (-nap): 10 Maximum time to nap at -spin exhaustion (-napmax): 250 SSL No Host Verify (-nohostverify): Not Enabled Disable LRU mechanism (-nolru): Not Enabled SSL No Session Cache (-nosessioncache): Not Enabled SSL No Session Reuse (-nosessionreuse): Not Enabled Login Governor (-nGovernor): 0 of 21 Number of checkpoint statistics to record (-numCheckpointStats): 32 Storage object cache size (-omsize): 1024 Database Service Manager - IPC Queue Size (-pica): 64.0 KBytes Shared memory segments locked (-pinshm): Not Enabled Use pollset mechanism for client/server (-pollset): Not Enabled Delay first prefetch message (-prefetchDelay): Not Enabled Prefetch message fill percentage (-prefetchFactor): 0 Minimum records in prefetch msg (-prefetchNumRecs): 16 Suspension queue poll priority (-prefetchPriority): 0 APW queue scan cycle time in milliseconds (-pwqdelay): 100 APW minimum queue length before write (-pwqmin): 1 APW buffer scan cycle time in seconds (-pwsdelay): 1 APW maximum number of buffers to scan per cycle (-pwscan): 5 APW maximum number of buffers to write per cycle (-pwwmax): 25 Before-Image File I/O (-r -R): Reliable Record free chain search depth factor (-recspacesearchdepth): 5 Security cache size (-secsize): 512 Number of Semaphore Sets (-semsets): 3 SSL Session Timeout (-sessiontimeout): 0 Maximum Shared Memory Segment Size (-shmsegsize): 0 Mb Current Spin Lock Tries (-spin): 24000 SSL Encryption for TCP/IP connections (-ssl): Not Enabled STS Debug Logging Level default (-stslogginglevel): 0 Number of tables included in statistics collection (-tablerangesize): 50 User Notification Time (-usernotifytime): 0 seconds Number of indexes per user included in statistics collection (-userindexrangesize): 50 Number of tables per user included in statistics collection (-usertablerangesize): 50 Area block consistency check (-AreaCheck): Not Enabled Number of Database Buffers (-B): 3000 Number of Alternate Database Buffers (-B2): 0 Maximum private buffers per user (-Bpmax): 64 Database block consistency check (-DbCheck): Not Enabled Database Service Manager - Service(s) to start (-DBService): Not Enabled Enhanced Read-Only mode (-ERO): Not Enabled Force Access (-F): Not Enabled Before-Image Truncate Interval (-G): 0 Host Name (-H): Not Enabled Index block consistency check (-IndexCheck): Not Enabled Current Size of Lock Table (-L): 8192 Lock Governor (-LGovernor): 0% Maximum Number of Clients Per Server (-Ma): 4 Memory overwrite check (-MemCheck): Not Enabled Delay of Before-Image Flush (-Mf): 3 Minimum Clients Per Server (-Mi): 0 Message Buffer Size (-Mm): 0 Maximum Number of Servers (-Mn): 5 Servers per Protocol (-Mp): 0 Maximum Servers Per Broker (-Mpb): 0 Excess Shared Memory Size (-Mxs): 26 Network Type (-N): Server network message wait time (-Nmsgwait): 2 Pending client connection timeout (-PendConnTimeout): 0 Service Name (-S): 0 Broker server group support (-ServerType): BOTH SQL Server Max Open Cursors (-SQLCursors): 0 SQL Server Stack Size (-SQLStack): 0 SQL Server Statement Cache Size (-SQLStmtCache): 0 Size [1K byte units] of SQL Server temp table buffer (-SQLTempStoreBuff): 0 Size [1K byte units] of SQL Server temp table disk storage (-SQLTempStoreDisk): 0 Size [1K byte units] of SQL Server temp table data page (-SQLTempStorePageSize): 0 Authorized data truncation (-SQLTruncateTooLarge): OFF SQL Autonomous Schema Update (-SQLWidthUpdate): OFF Record block consistency check (-TableCheck): Not Enabled TXE Lock retry limit (-TXERetryLimit): 0 TXE Commit lock skip limit (-TXESkipLimit): 10000 RETURN - repeat, U - continue uninterrupted, Q - quit: |
#SEM = Max-possible-users (-n) + Max-possible-servers (-Mn) + 4
|