on 02-22-2013 7:21 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Naresh,
The command you run to set the RunDirectoryPath is correct, but It looks like the parameter CONTROLUSERID is not set to the correct value.
What actions caused this error ?
Did you make any changes the MaxDB parameter file ?
Is M01 a copy of some other instance ?
If you do not know the Control/DBM user-id for your database instance M01, run the statement "sql_execute select * from users" to get the list of database users. Adjust the parameter CONTROLUSERID to its correct value.
dbmcli on m01>param_put CONTROLUSERID <control user>
Now, adjust the RunDirectoryPath parameter
dbmcli on m01>param_put RunDirectoryPath /sapdb/data/wrk/M01
If the problem still persists, Update the thread with the output of following commands
> dbmcli on m01> param_checkall
> dbmcli on m01> sql_execute select * from users
> dbmcli on m01> param_versions
> dbmcli on m01> param_directget CONTROLUSERID
Attach to the thread "m01.pah" file from the RUN directory
Regards,
Yashwanth
Hi Yashwanth,
Thanks for reply.
please find below info.
What actions caused this error ? After system copy it works but later issue came.
Did you make any changes the MaxDB parameter file ?-->No
Is M01 a copy of some other instance ? Yes
and i tried commands but not got solution.
dbmcli on m01>param_put CONTROLUSERID control
ERR
-24973,ERR_XPCHECK: param check failure/request
CONTROLPASSWORD Mandatory
the output of following commands
> dbmcli on m01> param_checkall
ERR
-24973,ERR_XPCHECK: param check failure/request
CONTROLUSERID Mandatory
> dbmcli on m01> sql_execute select * from users
dbmcli on m01>sql_execute select * from users
ERR
-24936,ERR_DBNORUN: Database instance is not running
-24783,ERR_WRONGDBSTATE: Operational state OFFLINE of the database instance is unsuitable.
-24780,ERR_DBSTATENEEDED3: Database instance must be in one of the operational states ADMIN, STANDBY or ONLINE.
> dbmcli on m01> param_versions
dbmcli on m01>param_versions
OK
/sapdb/M01/data/config/M01.01
/sapdb/M01/data/config/M01.04
/sapdb/M01/data/config/M01.07
/sapdb/M01/data/config/M01.05
/sapdb/M01/data/config/M01.03
/sapdb/M01/data/config/M01.02
/sapdb/M01/data/config/M01.06
> dbmcli on m01> param_directget CONTROLUSERID
dbmcli on m01>param_directget CONTROLUSERID
ERR
-24979,ERR_XPNOTFOUND: parameter not found
Attach to the thread "m01.pah" file from the RUN directory
/sapdb/M01/data/config/M01.pah
20130215 00115323 KernelVersion | KERNEL | 7.8.01 BUILD 014-121-233-288 | C GENERAL | |||
20130215 00115323 InstanceType | OLTP | C GENERAL param_init | ||||
20130215 00115323 MCODIndicator | NO | C GENERAL | ||||
20130215 00115323 BridgeType | NONE | C GENERAL | ||||
20130215 00115323 UseExtendedOracleSQLMode | YES | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter22 | YES | C NO | ||||
20130215 00115323 DefaultCodePage | ASCII | C EXTENDED | ||||
20130215 00115323 DateTimeFormat | INTERNAL | C EXTENDED | ||||
20130215 00115323 CONTROLUSERID | CONTROL | C NO | param_init | |||
20130215 00115323 MinPasswordLength | 1 | C NO | ||||
20130215 00115323 MaxLogVolumes | 1 | C GENERAL | ||||
20130215 00115323 MaxDataVolumes | 1 | C GENERAL | ||||
20130215 00115323 EnableLogBackupToPipe | NO | C EXTENDED | ||||
20130215 00115323 MaxBackupMedia | 2 | C GENERAL | ||||
20130215 00115323 UseMirroredLog | NO | C GENERAL | ||||
20130215 00115323 MaxVolumes | 3 | C NO | ||||
20130215 00115323 LogIOClusterSize | 8 | C SUPPORT | ||||
20130215 00115323 DataIOClusterSize | 64 | C SUPPORT | ||||
20130215 00115323 EnableDataVolumeBalancing | YES | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter01 | 64 | C NO | ||||
20130215 00115323 MaxLogWriterTasks | 0 | C EXTENDED | ||||
20130215 00115323 MaxLogwriterDelay | 0 | C SUPPORT | ||||
20130215 00115323 AdditionalLogQueueIOLimitation 0 | C SUPPORT | |||||
20130215 00115323 LogQueueSize | 50 | C EXTENDED | ||||
20130215 00115323 MaxSavepointTimeInterval | 600 | C SUPPORT | ||||
20130215 00115323 MaxCPUs | 1 | C GENERAL | ||||
20130215 00115323 UseableCPUs | 1 | C EXTENDED | ||||
20130215 00115323 LocalRedoLogBufferSize | 0 | C EXTENDED | ||||
20130215 00115323 MaxLogQueues | 1 | C SUPPORT | ||||
20130215 00115323 LogQueues | 1 | C EXTENDED | ||||
20130215 00115323 MaxUserTasks | 50 | C GENERAL | ||||
20130215 00115323 TransactionLockManagementStripes 8 | C EXTENDED | |||||
20130215 00115323 TableLockManagementStripes | 8 | C EXTENDED | ||||
20130215 00115323 OmsMaxUserStripes | 0 | C NO | ||||
20130215 00115323 OmsMaxStripes | 7 | C NO | ||||
20130215 00115323 OmsMaxHeapSize | 0 | C NO | ||||
20130215 00115323 OmsSubHeaps | 1 | C NO | ||||
20130215 00115323 OmsHeapBlockSize | 10000 | C NO | ||||
20130215 00115323 OmsHeapThreshold | 100 | C NO | ||||
20130215 00115323 OmsVersionThreshold | 2097152 | C NO | ||||
20130215 00115323 CheckAllocator | 0 | C NO | ||||
20130215 00115323 RowLockManagementStripes | 8 | C EXTENDED | ||||
20130215 00115323 ReservedServerTasks | 7 | C SUPPORT | ||||
20130215 00115323 MinServerTasks | 9 | C SUPPORT | ||||
20130215 00115323 MaxServerTasks | 9 | C EXTENDED | ||||
20130215 00115323 PreservedEventTasks | 3 | C SUPPORT | ||||
20130215 00115323 PreservedDBAnalyzerTasks | 2 | C SUPPORT | ||||
20130215 00115323 FloatingServiceTasks | 8 | C SUPPORT | ||||
20130215 00115323 GarbageCollectors | 1 | C SUPPORT | ||||
20130215 00115323 MaxTransactions | 468 | C SUPPORT | ||||
20130215 00115323 MaxSQLLocks | 4680 | C GENERAL | ||||
20130215 00115323 InternalLockStructureEntries | 100 | C SUPPORT | ||||
20130215 00115323 DeadlockDetectionLevel | 4 | C EXTENDED | ||||
20130215 00115323 SessionTimeout | 900 | C EXTENDED | ||||
20130215 00115323 OmsStreamTimeout | 30 | C SUPPORT | ||||
20130215 00115323 RequestTimeout | 3600 | C EXTENDED | ||||
20130215 00115323 EnableSynchronousTaskIO | YES | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter38 | NO | C NO | ||||
20130215 00115323 UseDataCacheScanOptimization | NO | C EXTENDED | ||||
20130215 00115323 CommandBufferSize | 131072 | C SUPPORT | ||||
20130215 00115323 ReservedCommandBufferReplySize 4096 | C SUPPORT | |||||
20130215 00115323 DeprecatedParameter03 | 32768 | C NO | ||||
20130215 00115323 InternalOrderQualificationSize 32768 | C SUPPORT | |||||
20130215 00115323 InternalOrderStackSize | 32768 | C SUPPORT | ||||
20130215 00115323 InterpreterWorkStackSize | 32768 | C SUPPORT | ||||
20130215 00115323 InterpreterWorkDataSize | 8192 | C SUPPORT | ||||
20130215 00115323 TaskSpecificCatalogCacheMinSize 262144 | C SUPPORT | |||||
20130215 00115323 CAT_CACHE_SUPPLY | 3776 | C EXTENDED | ||||
20130215 00115323 InitialAllocatorSize | 532480 | C SUPPORT | ||||
20130215 00115323 SessionAllocatorSupplementSize 131072 | C SUPPORT | |||||
20130215 00115323 SessionAllocatorBlockKeepCount 1 | C SUPPORT | |||||
20130215 00115323 EnableMultipleServerTaskUKT | NO | C SUPPORT | ||||
20130215 00115323 TaskCluster01 | tw;lw;ut;2000*sv;10*fs;10*gc; | C SUPPORT | ||||
20130215 00115323 TaskCluster02 | ti,100*pg;1*bup,30000*us; | C SUPPORT | ||||
20130215 00115323 TaskCluster03 | compress | C SUPPORT | ||||
20130215 00115323 DeferStackAllocation | NO | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter04 | YES | C NO | ||||
20130215 00115323 DeprecatedParameter05 | DEFAULT | C NO | ||||
20130215 00115323 DeprecatedParameter06 | DEFAULT | C NO | ||||
20130215 00115323 TaskSchedulerRetryLoops | 2 | C SUPPORT | ||||
20130215 00115323 ScheduleInterval | 10000 | C NO | ||||
20130215 00115323 ForceSchedulePrioritizedTask | DEFAULT | C SUPPORT | ||||
20130215 00115323 MaxExclusiveLockCollisionLoops -1 | C EXTENDED | |||||
20130215 00115323 _MP_RGN_PRIO | DEFAULT | C NO | ||||
20130215 00115323 ExclusiveLockRescheduleThreshold -1 | C EXTENDED | |||||
20130215 00115323 TaskNiceElevationValue | 80 | C SUPPORT | ||||
20130215 00115323 TaskRequestPriorityLow | 10 | C SUPPORT | ||||
20130215 00115323 TaskRequestPriorityAboveLow | 30 | C SUPPORT | ||||
20130215 00115323 TaskRequestPriorityBelowNormal 50 | C SUPPORT | |||||
20130215 00115323 TaskRequestPriorityNormal | 80 | C SUPPORT | ||||
20130215 00115323 TaskRequestPriorityAboveNormal 90 | C SUPPORT | |||||
20130215 00115323 TaskRequestPriorityBelowHigh | 100 | C SUPPORT | ||||
20130215 00115323 TaskRequestPriorityHigh | 240 | C SUPPORT | ||||
20130215 00115323 TaskRequestPriorityAboveHigh | 400 | C SUPPORT | ||||
20130215 00115323 TaskYieldRequestPriority | AboveLow | C SUPPORT | ||||
20130215 00115323 TaskCommunicationRequestPriority Low | C SUPPORT | |||||
20130215 00115323 TaskLockGrantRequestPriority | AboveHigh | C SUPPORT | ||||
20130215 00115323 TaskResumeRequestPriority | BelowHigh | C SUPPORT | ||||
20130215 00115323 MaxTaskStackSize | 768 | C SUPPORT | ||||
20130215 00115323 MaxServerTaskStackSize | 500 | C SUPPORT | ||||
20130215 00115323 MaxSpecialTaskStackSize | 500 | C SUPPORT | ||||
20130215 00115323 DataCacheIOAreaSize | 50 | C SUPPORT | ||||
20130215 00115323 DataCacheIOAreaFlushThreshold | 50 | C SUPPORT | ||||
20130215 00115323 CacheMemorySize | 510848 | C GENERAL | ||||
20130215 00115323 DataCachePinAreaThreshold | 5 | C SUPPORT | ||||
20130215 00115323 EnableLivecachePinAreaUsage | NO | C SUPPORT | ||||
20130215 00115323 EnableRemoveUndoOnTransactionEnd NO | C SUPPORT | |||||
20130215 00115323 DataCacheLRUAreaFlushThreshold 25 | C SUPPORT | |||||
20130215 00115323 UseFineGranularSynchronization YES | C SUPPORT | |||||
20130215 00115323 DataCacheStripes | 64 | C EXTENDED | ||||
20130215 00115323 DataCacheSyncGranularity | 3991 | C SUPPORT | ||||
20130215 00115323 ConverterStripes | 8 | C EXTENDED | ||||
20130215 00115323 MaxPagerTasks | 64 | C SUPPORT | ||||
20130215 00115323 SequenceCacheSize | 1 | C EXTENDED | ||||
20130215 00115323 MaxTempFilesPerIndexCreation | 2048 | C SUPPORT | ||||
20130215 00115323 ConverterVolumeIdLayout | 8 | C EXTENDED | ||||
20130215 00115323 IndexlistsMergeThreshold | 500 | C EXTENDED | ||||
20130215 00115323 EnableIndexOnlyStrategy | YES | C EXTENDED | ||||
20130215 00115323 UseStrategyCache | NO | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter09 | 0 | C NO | ||||
20130215 00115323 JoinSearchLevel | 0 | C EXTENDED | ||||
20130215 00115323 JoinSearchTableThreshold4 | 16 | C EXTENDED | ||||
20130215 00115323 JoinSearchTableThreshold9 | 5 | C EXTENDED | ||||
20130215 00115323 ReadAheadLobThreshold | 32 | C SUPPORT | ||||
20130215 00115323 ReadAheadTableThreshold | 100 | C SUPPORT | ||||
20130215 00115323 MaxDataAreaReadAheadRequests | 0 | C SUPPORT | ||||
20130215 00115323 ClusterWriteThreshold | 80 | C EXTENDED | ||||
20130215 00115323 UseLobClustering | YES | C EXTENDED | ||||
20130215 00115323 ClusterCompressionThreshold | 5 | C NO | ||||
20130215 00115323 ClusterCompressionFillThreshold 10 | C EXTENDED | |||||
20130215 00115323 RunDirectoryPath | /sapdb/M01/data/wrk/M01 | C GENERAL param_init | ||||
20130215 00115323 MessageOutputDevice1 | /dev/console | C NO | ||||
20130215 00115323 MessageOutputDevice2 | /dev/null | C NO | ||||
20130215 00115323 KernelMessageFileSize | 800 | C EXTENDED | ||||
20130215 00115323 EventFileName | knldiag.evt | C SUPPORT | ||||
20130215 00115323 EventFileSize | 0 | C SUPPORT | ||||
20130215 00115323 MaxEvents | 150 | C EXTENDED | ||||
20130215 00115323 KernelTraceFile | knltrace | C SUPPORT | ||||
20130215 00115323 TraceBufferSizeTITask | 2 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizeGCTask | 20 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizeLWTask | 5 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizePGTask | 3 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizeUSTask | 10 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizeUTTask | 5 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizeSVTask | 5 | C EXTENDED | ||||
20130215 00115323 TraceBufferSizeFSTask | 2 | C EXTENDED | ||||
20130215 00115323 KernelTraceSize | 787 | C SUPPORT | ||||
20130215 00115323 EnableExternalDumpRequest | NO | C NO | ||||
20130215 00115323 EnableAKDump | YES | C SUPPORT | ||||
20130215 00115323 KernelDumpFileName | knldump | C SUPPORT | ||||
20130215 00115323 RTEDumpFileName | rtedump | C SUPPORT | ||||
20130215 00115323 MaxParallelLiveCacheTraceFiles 0 | C EXTENDED | |||||
20130215 00115323 KernelMessageHistoryCount | 5 | C EXTENDED | ||||
20130215 00115323 DiagnoseHistoryCount | 2 | C EXTENDED | ||||
20130215 00115323 DiagnoseHistoryPath | /sapdb/M01/data/wrk/M01/DIAGHISTORY | C EXTENDED | ||||
20130215 00115323 InstanceShutdownIndicator | 0 | C NO | ||||
20130215 00115323 ShowMaxStackUsage | NO | C SUPPORT | ||||
20130215 00115323 ShowDataAccessMaxStackUsage | NO | C SUPPORT | ||||
20130215 00115323 AutoLogBackupSize | 0 | C GENERAL | ||||
20130215 00115323 AbortHandlingMode | BacktraceOnly | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter40 | YES | C NO | ||||
20130215 00115323 VolumeFormattingMode | PARALLEL | C EXTENDED | ||||
20130215 00115323 FormatDataVolume | YES | C EXTENDED | ||||
20130215 00115323 DeprecatedParameter30 | NONE | C NO | ||||
20130215 00115323 DeprecatedParameter31 | NONE | C NO | ||||
20130215 00115323 UKTCPUBinding | NONE | C SUPPORT | ||||
20130215 00115323 HighResolutionTimer | CPU | C EXTENDED | ||||
20130215 00115323 LoadBalancingCheckInterval | 4 | C EXTENDED | ||||
20130215 00115323 DeprecatedParameter41 | 4 | C NO | ||||
20130215 00115323 LoadBalancingWorkloadThreshold 10 | C SUPPORT | |||||
20130215 00115323 LoadBalancingWorkloadDeviation 5 | C SUPPORT | |||||
20130215 00115323 HotStandbyStorageDLLPath | libhsscopy | C EXTENDED | ||||
20130215 00115323 HotStandbySyncInterval | 50 | C EXTENDED | ||||
20130215 00115323 DeprecatedParameter29 | YES | C NO | ||||
20130215 00115323 UseFilesystemCacheForVolume | NO | C SUPPORT | ||||
20130215 00115323 UseFilesystemCacheForBackup | YES | C SUPPORT | ||||
20130215 00115323 EnableSymbolDemangling | YES | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter13 | NO | C NO | ||||
20130215 00115323 JoinTableBufferSize | 256 | C EXTENDED | ||||
20130215 00115323 UseVolumeLock | YES | C SUPPORT | ||||
20130215 00115323 UseSharedSQL | YES | C EXTENDED | ||||
20130215 00115323 SharedSQLCleanupThreshold | 75 | C EXTENDED | ||||
20130215 00115323 SharedSQLCommandCacheSize | 262144 | C EXTENDED | ||||
20130215 00115323 MaxMemoryAllocationSize | 0 | C EXTENDED | ||||
20130215 00115323 UseSystemPageCache | YES | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter32 | NO | C NO | ||||
20130215 00115323 DeprecatedParameter33 | NO | C NO | ||||
20130215 00115323 DeprecatedParameter34 | NO | C NO | ||||
20130215 00115323 DeprecatedParameter35 | YES | C NO | ||||
20130215 00115323 DeprecatedParameter36 | YES | C NO | ||||
20130215 00115323 TaskingMode | COROUTINES | C SUPPORT | ||||
20130215 00115323 MinRetentionTime | 60 | C EXTENDED | ||||
20130215 00115323 MaxRetentionTime | 480 | C EXTENDED | ||||
20130215 00115323 HashJoinSingleTableMemorySize | 512 | C EXTENDED | ||||
20130215 00115323 HashJoinTotalMemorySize | 5120 | C EXTENDED | ||||
20130215 00115323 DeprecatedParameter14 | 0 | C NO | ||||
20130215 00115323 UseHashedResultset | YES | C EXTENDED | ||||
20130215 00115323 HashedResultsetCacheSize | 65536 | C EXTENDED | ||||
20130215 00115323 UseDataTempTableFile | NO | C SUPPORT | ||||
20130215 00115323 TempResultsetPinPagesThreshold 10 | C SUPPORT | |||||
20130215 00115323 CheckHashedResultSet | 0 | C TRACE | ||||
20130215 00115323 UseAutomaticBadIndexRecreation OFF | C NO | |||||
20130215 00115323 BacktraceOnError | 0 | C NO | ||||
20130215 00115323 TraceAK | NO | C TRACE | ||||
20130215 00115323 TraceDefault | NO | C TRACE | ||||
20130215 00115323 TraceDelete | NO | C TRACE | ||||
20130215 00115323 TraceInsert | NO | C TRACE | ||||
20130215 00115323 DeprecatedParameter26 | NO | C NO | ||||
20130215 00115323 TraceSQLLock | 0 | C TRACE | ||||
20130215 00115323 DeprecatedParameter15 | NO | C NO | ||||
20130215 00115323 TraceObject | NO | C TRACE | ||||
20130215 00115323 TraceNewObject | NO | C TRACE | ||||
20130215 00115323 TraceAlterObject | NO | C TRACE | ||||
20130215 00115323 TraceFreeObject | NO | C TRACE | ||||
20130215 00115323 TraceGetObject | NO | C TRACE | ||||
20130215 00115323 TraceOptimizer | NO | C TRACE | ||||
20130215 00115323 TraceOrder | NO | C TRACE | ||||
20130215 00115323 TraceOrderStandard | NO | C TRACE | ||||
20130215 00115323 DeprecatedParameter16 | NO | C NO | ||||
20130215 00115323 DeprecatedParameter27 | NO | C NO | ||||
20130215 00115323 TraceSelect | NO | C TRACE | ||||
20130215 00115323 TraceTime | NO | C TRACE | ||||
20130215 00115323 TraceUpdate | NO | C TRACE | ||||
20130215 00115323 TraceStopErrorcode | 0 | C TRACE | ||||
20130215 00115323 TraceAllocator | 0 | C TRACE | ||||
20130215 00115323 TraceCatalog | 0 | C TRACE | ||||
20130215 00115323 TraceCatalogCache | 0 | C TRACE | ||||
20130215 00115323 TraceClientKernelCommunication 0 | C TRACE | |||||
20130215 00115323 TraceCommon | 0 | C TRACE | ||||
20130215 00115323 TraceCommunication | 0 | C TRACE | ||||
20130215 00115323 TraceConverter | 0 | C TRACE | ||||
20130215 00115323 TraceDataAgent | 0 | C TRACE | ||||
20130215 00115323 TraceDataChain | 0 | C TRACE | ||||
20130215 00115323 TraceDataLob | 0 | C TRACE | ||||
20130215 00115323 TraceDataCache | 0 | C TRACE | ||||
20130215 00115323 TraceDataPageAccessManager | 0 | C TRACE | ||||
20130215 00115323 TraceDataSource | 0 | C TRACE | ||||
20130215 00115323 TraceDataTempHashFile | 0 | C TRACE | ||||
20130215 00115323 TraceDataTree | 0 | C TRACE | ||||
20130215 00115323 TraceDataIndex | 0 | C TRACE | ||||
20130215 00115323 CheckCatalogCache | 0 | C TRACE | ||||
20130215 00115323 CheckDataTempHashFile | 0 | C TRACE | ||||
20130215 00115323 CheckDataTree | 0 | C TRACE | ||||
20130215 00115323 TraceDBProcedure | 0 | C TRACE | ||||
20130215 00115323 TraceDML | 0 | C TRACE | ||||
20130215 00115323 TraceDQE | 0 | C TRACE | ||||
20130215 00115323 TraceFreeBlockManager | 0 | C TRACE | ||||
20130215 00115323 TraceFileDirectory | 0 | C TRACE | ||||
20130215 00115323 TraceFrameControl | 0 | C TRACE | ||||
20130215 00115323 TraceIOManager | 0 | C TRACE | ||||
20130215 00115323 TraceInterProcessCommunication 0 | C TRACE | |||||
20130215 00115323 TraceJoinPlanOptimizer | 0 | C TRACE | ||||
20130215 00115323 TraceAccessPlanOptimizer | 0 | C TRACE | ||||
20130215 00115323 TraceJoin | 0 | C TRACE | ||||
20130215 00115323 TraceGG | 0 | C TRACE | ||||
20130215 00115323 TraceInterpreter | 0 | C TRACE | ||||
20130215 00115323 TraceKB | 0 | C TRACE | ||||
20130215 00115323 TraceSQLExecution | 0 | C TRACE | ||||
20130215 00115323 TraceInternalSQL | 0 | C TRACE | ||||
20130215 00115323 TraceLockManager | 0 | C TRACE | ||||
20130215 00115323 TraceLogAction | 0 | C TRACE | ||||
20130215 00115323 TraceLogHistory | 0 | C TRACE | ||||
20130215 00115323 TraceLogPage | 0 | C TRACE | ||||
20130215 00115323 TraceLogTransaction | 0 | C TRACE | ||||
20130215 00115323 TraceLogArea | 0 | C TRACE | ||||
20130215 00115323 TraceMemory | 0 | C TRACE | ||||
20130215 00115323 TraceMessage | 0 | C TRACE | ||||
20130215 00115323 TraceMonitor | 0 | C TRACE | ||||
20130215 00115323 TraceMultiVersionRead | 0 | C TRACE | ||||
20130215 00115323 TraceObjectContainer | 0 | C TRACE | ||||
20130215 00115323 TraceOmsContainerDirectory | 0 | C TRACE | ||||
20130215 00115323 TraceOmsContext | 0 | C TRACE | ||||
20130215 00115323 TraceOmsError | 0 | C TRACE | ||||
20130215 00115323 TraceOmsCacheFlush | 0 | C TRACE | ||||
20130215 00115323 TraceOmsInterface | 0 | C TRACE | ||||
20130215 00115323 TraceOmsKey | 0 | C TRACE | ||||
20130215 00115323 TraceOmsKeyRange | 0 | C TRACE | ||||
20130215 00115323 TraceOmsLock | 0 | C TRACE | ||||
20130215 00115323 TraceOmsMemory | 0 | C TRACE | ||||
20130215 00115323 TraceOmsHeap | 0 | C TRACE | ||||
20130215 00115323 TraceOmsNewObject | 0 | C TRACE | ||||
20130215 00115323 TraceOmsObject | 0 | C TRACE | ||||
20130215 00115323 TraceOmsSession | 0 | C TRACE | ||||
20130215 00115323 TraceOmsStream | 0 | C TRACE | ||||
20130215 00115323 TraceOmsTransaction | 0 | C TRACE | ||||
20130215 00115323 TraceOmsVarobject | 0 | C TRACE | ||||
20130215 00115323 TraceOmsVersion | 0 | C TRACE | ||||
20130215 00115323 TracePager | 0 | C TRACE | ||||
20130215 00115323 TracePlanExecution | 0 | C TRACE | ||||
20130215 00115323 TraceQueryAnalysis | 0 | C TRACE | ||||
20130215 00115323 TraceQuerySQLGeneration | 0 | C TRACE | ||||
20130215 00115323 TraceQueryRewrite | 0 | C TRACE | ||||
20130215 00115323 TraceQueryExecution | 0 | C NO | ||||
20130215 00115323 TraceRunTime | 0 | C TRACE | ||||
20130215 00115323 TraceRunTimeDiagnose | 0 | C TRACE | ||||
20130215 00115323 TraceSharedSQL | 0 | C TRACE | ||||
20130215 00115323 TraceTransaction | 0 | C TRACE | ||||
20130215 00115323 CheckSharedSQL | 0 | C TRACE | ||||
20130215 00115323 TraceSQLManager | 0 | C TRACE | ||||
20130215 00115323 TraceServerTask | 0 | C TRACE | ||||
20130215 00115323 TraceSynchronisation | 0 | C TRACE | ||||
20130215 00115323 TraceSyntax | 0 | C TRACE | ||||
20130215 00115323 TraceSystemView | 0 | C TRACE | ||||
20130215 00115323 TraceTable | 0 | C TRACE | ||||
20130215 00115323 TraceValueExpression | 0 | C TRACE | ||||
20130215 00115323 TraceVolume | 0 | C TRACE | ||||
20130215 00115323 CheckDataCache | NO | C TRACE | ||||
20130215 00115323 DeprecatedParameter17 | NO | C NO | ||||
20130215 00115323 DeprecatedParameter23 | NO | C NO | ||||
20130215 00115323 CheckSQLLock | 0 | C TRACE | ||||
20130215 00115323 DeprecatedParameter25 | NO | C NO | ||||
20130215 00115323 DeprecatedParameter18 | NO | C NO | ||||
20130215 00115323 CheckTaskSpecificCatalogCache | NO | C TRACE | ||||
20130215 00115323 DeprecatedParameter24 | NO | C NO | ||||
20130215 00115323 CheckTransactionManagement | 0 | C TRACE | ||||
20130215 00115323 CheckTree | NO | C TRACE | ||||
20130215 00115323 DeprecatedParameter28 | NO | C NO | ||||
20130215 00115323 CheckCommon | 0 | C TRACE | ||||
20130215 00115323 CheckConverter | 0 | C TRACE | ||||
20130215 00115323 CheckDataLogpage | 0 | C TRACE | ||||
20130215 00115323 CheckDataIndex | 0 | C TRACE | ||||
20130215 00115323 CheckFreeBlockManager | 0 | C TRACE | ||||
20130215 00115323 CheckIOManager | 0 | C TRACE | ||||
20130215 00115323 CheckLogHistory | 0 | C TRACE | ||||
20130215 00115323 CheckLogPage | 0 | C TRACE | ||||
20130215 00115323 CheckLogTransaction | 0 | C TRACE | ||||
20130215 00115323 CheckLogArea | 0 | C TRACE | ||||
20130215 00115323 CheckServerTask | 0 | C TRACE | ||||
20130215 00115323 EnableAggregationOptimization | YES | C SUPPORT | ||||
20130215 00115323 EnableStarJoinOptimization | YES | C SUPPORT | ||||
20130215 00115323 EnableFetchReverseOptimization YES | C SUPPORT | |||||
20130215 00115323 EnableOnePhaseJoin | YES | C SUPPORT | ||||
20130215 00115323 EnableOuterJoinOptimization | YES | C SUPPORT | ||||
20130215 00115323 EnableMinMaxAggregationOptimizer YES | C SUPPORT | |||||
20130215 00115323 EnableFirstRowAccessOptimization YES | C SUPPORT | |||||
20130215 00115323 EnableJoinHashTableOptimization YES | C SUPPORT | |||||
20130215 00115323 JoinHashMinimalRatio | 1 | C SUPPORT | ||||
20130215 00115323 ParallelJoinMinThreshold | 1000000 | C SUPPORT | ||||
20130215 00115323 ParallelJoinServerTasks | 0 | C SUPPORT | ||||
20130215 00115323 EnableJoinIntermediateSort | YES | C SUPPORT | ||||
20130215 00115323 EnableQualificationBypass | YES | C SUPPORT | ||||
20130215 00115323 EnableQualificationOnIndex | YES | C SUPPORT | ||||
20130215 00115323 UseDDLTrigger | YES | C SUPPORT | ||||
20130215 00115323 EnableSubTreeLock | YES | C SUPPORT | ||||
20130215 00115323 MonitorDataPageReadThreshold | 2147483647 | C SUPPORT | ||||
20130215 00115323 MonitorRunTimeThreshold | 2147483647 | C SUPPORT | ||||
20130215 00115323 MonitorSelectivityThreshold | 0 | C SUPPORT | ||||
20130215 00115323 MaxMonitorEntries | 0 | C SUPPORT | ||||
20130215 00115323 CallStackLevel | 0 | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter19 | NO | C NO | ||||
20130215 00115323 QueryAnalysisMode | EXTENDED | C SUPPORT | ||||
20130215 00115323 EnableQueryRewrite | YES | C EXTENDED | ||||
20130215 00115323 QueryProcessingMode | NORMAL | C NO | ||||
20130215 00115323 CheckQueryAnalysis | 0 | C TRACE | ||||
20130215 00115323 CheckQueryRewrite | 0 | C TRACE | ||||
20130215 00115323 CheckQueryExecution | 0 | C NO | ||||
20130215 00115323 UseDataCacheMemoryProtection | NO | C SUPPORT | ||||
20130215 00115323 FileDirectorySpinlockPoolSize | 10 | C EXTENDED | ||||
20130215 00115323 TransactionHistorySize | 0 | C EXTENDED | ||||
20130215 00115323 TransactionHistoryThreshold | 60 | C EXTENDED | ||||
20130215 00115323 UseSystemTrigger | YES | C SUPPORT | ||||
20130215 00115323 ThrowDBFillingAboveLimitEvent | 70L80M85M90H95H96H97H98H99H | C NO | ||||
20130215 00115323 ThrowDBFillingBelowLimitEvent | 70L80L85L90L95L | C NO | ||||
20130215 00115323 ThrowLogAboveLimitEvent | 50L75L90M95M96H97H98H99H | C NO | ||||
20130215 00115323 ThrowDataCacheAboveLimitEvent | 20H30H40H50H60M70M80L90L95L99L | C NO | ||||
20130215 00115323 ThrowDataCacheBelowLimitEvent | 20H30H40H50H60M70M80L90L95L | C NO | ||||
20130215 00115323 ThrowAutoLogBackupEvent | 1 | C NO | ||||
20130215 00115323 ThrowBackupResultEvent | 1 | C NO | ||||
20130215 00115323 ThrowCheckTableProgressEvent | 1 | C NO | ||||
20130215 00115323 ThrowCheckDatabaseProgressEvent 1 | C NO | |||||
20130215 00115323 ThrowCheckDataEvent | 1 | C NO | ||||
20130215 00115323 ThrowEventChangedEvent | 1 | C NO | ||||
20130215 00115323 ThrowAdminEvent | 1 | C NO | ||||
20130215 00115323 ThrowOnlineEvent | 1 | C NO | ||||
20130215 00115323 ThrowUpdateStatWantedEvent | 1 | C NO | ||||
20130215 00115323 ThrowOutOfSessionsEvent | 3 | C NO | ||||
20130215 00115323 ThrowErrorEvent | 3 | C NO | ||||
20130215 00115323 ThrowSystemerrorEvent | 3 | C NO | ||||
20130215 00115323 ThrowDatabaseFullEvent | 1 | C NO | ||||
20130215 00115323 ThrowLogFullEvent | 1 | C NO | ||||
20130215 00115323 ThrowLogSegmentFullEvent | 1 | C NO | ||||
20130215 00115323 ThrowStandbyEvent | 1 | C NO | ||||
20130215 00115323 ThrowOfflineEvent | 1 | C NO | ||||
20130215 00115323 ThrowCrashEvent | 1 | C NO | ||||
20130215 00115323 ThrowReconnectEvent | 1 | C NO | ||||
20130215 00115323 ThrowDBM:DispatcherStopEvent | 1 | C NO | ||||
20130215 00115323 ThrowDBM:DispatcherStartEvent | 1 | C NO | ||||
20130215 00115323 ThrowDBM:DispConfigChangeEvent 1 | C NO | |||||
20130215 00115323 ThrowDBM:TestEvent | 1 | C NO | ||||
20130215 00115323 ThrowDBM:MissedEventEvent | 1 | C NO | ||||
20130215 00115323 UseSelectFetchOptimization | YES | C SUPPORT | ||||
20130215 00115323 EnableVariableOutput | YES | C SUPPORT | ||||
20130215 00115323 EnableVariableInput | YES | C SUPPORT | ||||
20130215 00115323 UpdateStatParallelServerTask | 0 | C SUPPORT | ||||
20130215 00115323 UpdateStatSampleAlgorithm | 1 | C EXTENDED | ||||
20130215 00115323 RequestUpdateStatisticsThreshold 30 | C EXTENDED | |||||
20130215 00115323 UseMultiVersionReadSupport | NO | C SUPPORT | ||||
20130215 00115323 UseMVCCAux | NO | C NO | ||||
20130215 00115323 UseVectorIOSimulation | NEVER | C SUPPORT | ||||
20130215 00115323 UseColumnCompression | YES | C SUPPORT | ||||
20130215 00115323 MapRunTimeMemoryToFile | YES | C SUPPORT | ||||
20130215 00115323 UseTableWidthCheckDuringDDL | NO | C SUPPORT | ||||
20130215 00115323 MaxMessageListEntries | 100 | C SUPPORT | ||||
20130215 00115323 EnableSymbolResolution | YES | C SUPPORT | ||||
20130215 00115323 DeprecatedParameter37 | 1 | C NO | ||||
20130215 00115323 EnablePreAllocateIOWorker | NO | C SUPPORT | ||||
20130215 00115323 IndexLeafCachingLevel | 2 | C SUPPORT | ||||
20130215 00115323 VolumeIOQueuesForLowPriority | 1 | C SUPPORT | ||||
20130215 00115323 VolumeIOQueuesForMediumPriority 4 | C SUPPORT | |||||
20130215 00115323 VolumeIOQueuesForHighPriority | 5 | C SUPPORT | ||||
20130215 00115323 IOQueueFillingThreshold | 1 | C SUPPORT | ||||
20130215 00115323 EnableIOTimeStatistic | YES | C SUPPORT | ||||
20130215 00115323 MinIOPoolWorkers | 0 | C SUPPORT | ||||
20130215 00115323 MaxIOPoolWorkers | 0 | C SUPPORT | ||||
20130215 00115323 IOWorkerStackSize | 0 | C SUPPORT | ||||
20130215 00115323 IOPoolIdleTimeout | 0 | C SUPPORT | ||||
20130215 00115323 RetiredIOJobCount | 8 | C SUPPORT | ||||
20130215 00115323 NetworkWorkerThreadCount | 2 | C SUPPORT | ||||
20130215 00115323 EnableOptimizedNetworkProcessing YES | C SUPPORT | |||||
20130215 00115323 UseFilesystemSynchronisation | YES | C NO | ||||
20130215 00115323 DeprecatedParameter39 | NO | C NO | ||||
20130215 00115323 EnableFileCounterInitialization YES | C SUPPORT | |||||
20130215 00115323 MaxSpinlockHotLoops | 1000 | C SUPPORT | ||||
20130215 00115323 SpinlockBackoffBase | 1 | C SUPPORT | ||||
20130215 00115323 SpinlockBackoffFactor | 2 | C SUPPORT | ||||
20130215 00115323 SpinlockBackoffMaximum | 64 | C SUPPORT | ||||
20130215 00115323 UseDBAnalyzer | NO | C NO | ||||
20130215 00115323 DBAnalyzerDays | 0 | C NO | ||||
20130215 00115323 UseLoadSystemTables | YES | C NO | ||||
20130215 00115323 DeprecatedParameter20 | 8192 | C NO | ||||
20130215 00115323 TraceBackup | 0 | C TRACE | ||||
20130215 00115323 CheckBackup | 0 | C NO | ||||
20130215 00115323 RowLocksPerTransactionThreshold 50 | C EXTENDED | |||||
20130215 00115323 UseUnicodeColumnCompression | NO | C EXTENDED | ||||
20130215 00115323 JavaHomePath | jvm | C NO | ||||
20130215 00115323 DeprecatedParameter42 | NO | C NO | ||||
20130215 00115323 BridgeCommunicationTimeout | 600 | C SUPPORT | ||||
20130215 00115323 CommSegmentLockNanoSleepRatio | 0 | C NO | ||||
20130215 00115323 CommSegmentLockNanoSleepTime | 8000 | C NO | ||||
20130215 00115323 EnableLegacyOuterJoinSyntax | NO | C SUPPORT | ||||
20130215 00115323 UseTasksInUKT | -1 | C NO | ||||
20130215 00115323 EnableCommandMonitor | YES | C SUPPORT | ||||
20130215 00115323 UseExtendedTimeMeasurement | NO | C SUPPORT | ||||
20130215 00115323 ThrowBadIndexesEvent | 1 | C NO | ||||
20130215 00115323 MaxKernelMessageArchiveSize | 10000 | C EXTENDED | ||||
20130215 00115323 DBAnalyzerCreateProcessMode | VFORK | C SUPPORT | ||||
20130215 00115327 DataVolumeName0001 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0001 | C NO | addvolume | |||
20130215 00115327 DataVolumeType0001 | F | C NO | addvolume | |||
20130215 00115327 DataVolumeSize0001 | 947200 | C NO | addvolume | |||
20130215 00115327 MaxDataAreaReadAheadRequests | 2 | 0 | C SUPPORT | |||
20130215 00115327 MaxDataVolumes | 11 | 1 | C GENERAL addvolume | |||
20130215 00115327 MaxVolumes | 13 | 3 | C NO | |||
20130215 00115327 ReservedServerTasks | 17 | 7 | C SUPPORT | |||
20130215 00115327 MinServerTasks | 29 | 9 | C SUPPORT | |||
20130215 00115327 MaxServerTasks | 29 | 9 | C EXTENDED | |||
20130215 00115327 KernelTraceSize | 887 | 787 | C SUPPORT | |||
20130215 00115330 DataVolumeName0002 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0002 | C NO | addvolume | |||
20130215 00115330 DataVolumeType0002 | F | C NO | addvolume | |||
20130215 00115330 DataVolumeSize0002 | 947200 | C NO | addvolume | |||
20130215 00115330 MaxDataAreaReadAheadRequests | 4 | 2 | C SUPPORT | |||
20130215 00115330 MaxDataVolumes | 12 | 11 | C GENERAL addvolume | |||
20130215 00115330 MaxVolumes | 14 | 13 | C NO | |||
20130215 00115330 ReservedServerTasks | 18 | 17 | C SUPPORT | |||
20130215 00115330 MinServerTasks | 31 | 29 | C SUPPORT | |||
20130215 00115330 MaxServerTasks | 31 | 29 | C EXTENDED | |||
20130215 00115330 KernelTraceSize | 897 | 887 | C SUPPORT | |||
20130215 00115333 DataVolumeName0003 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0003 | C NO | addvolume | |||
20130215 00115333 DataVolumeType0003 | F | C NO | addvolume | |||
20130215 00115333 DataVolumeSize0003 | 947200 | C NO | addvolume | |||
20130215 00115333 MaxDataAreaReadAheadRequests | 6 | 4 | C SUPPORT | |||
20130215 00115333 MaxDataVolumes | 13 | 12 | C GENERAL addvolume | |||
20130215 00115333 MaxVolumes | 15 | 14 | C NO | |||
20130215 00115333 ReservedServerTasks | 19 | 18 | C SUPPORT | |||
20130215 00115333 MinServerTasks | 33 | 31 | C SUPPORT | |||
20130215 00115333 MaxServerTasks | 33 | 31 | C EXTENDED | |||
20130215 00115333 KernelTraceSize | 907 | 897 | C SUPPORT | |||
20130215 00115337 DataVolumeName0004 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0004 | C NO | addvolume | |||
20130215 00115337 DataVolumeType0004 | F | C NO | addvolume | |||
20130215 00115337 DataVolumeSize0004 | 947200 | C NO | addvolume | |||
20130215 00115337 MaxDataAreaReadAheadRequests | 8 | 6 | C SUPPORT | |||
20130215 00115337 MaxDataVolumes | 14 | 13 | C GENERAL addvolume | |||
20130215 00115337 MaxVolumes | 16 | 15 | C NO | |||
20130215 00115337 ReservedServerTasks | 20 | 19 | C SUPPORT | |||
20130215 00115337 MinServerTasks | 35 | 33 | C SUPPORT | |||
20130215 00115337 MaxServerTasks | 35 | 33 | C EXTENDED | |||
20130215 00115337 KernelTraceSize | 917 | 907 | C SUPPORT | |||
20130215 00115340 DataVolumeName0005 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0005 | C NO | addvolume | |||
20130215 00115340 DataVolumeType0005 | F | C NO | addvolume | |||
20130215 00115340 DataVolumeSize0005 | 947200 | C NO | addvolume | |||
20130215 00115340 MaxDataAreaReadAheadRequests | 10 | 8 | C SUPPORT | |||
20130215 00115340 MaxDataVolumes | 15 | 14 | C GENERAL addvolume | |||
20130215 00115340 MaxVolumes | 17 | 16 | C NO | |||
20130215 00115340 ReservedServerTasks | 21 | 20 | C SUPPORT | |||
20130215 00115340 MinServerTasks | 37 | 35 | C SUPPORT | |||
20130215 00115340 MaxServerTasks | 37 | 35 | C EXTENDED | |||
20130215 00115340 KernelTraceSize | 927 | 917 | C SUPPORT | |||
20130215 00115343 DataVolumeName0006 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0006 | C NO | addvolume | |||
20130215 00115343 DataVolumeType0006 | F | C NO | addvolume | |||
20130215 00115343 DataVolumeSize0006 | 947200 | C NO | addvolume | |||
20130215 00115343 MaxDataAreaReadAheadRequests | 12 | 10 | C SUPPORT | |||
20130215 00115343 MaxDataVolumes | 16 | 15 | C GENERAL addvolume | |||
20130215 00115343 MaxVolumes | 18 | 17 | C NO | |||
20130215 00115343 ReservedServerTasks | 22 | 21 | C SUPPORT | |||
20130215 00115343 MinServerTasks | 39 | 37 | C SUPPORT | |||
20130215 00115343 MaxServerTasks | 39 | 37 | C EXTENDED | |||
20130215 00115343 KernelTraceSize | 937 | 927 | C SUPPORT | |||
20130215 00115346 DataVolumeName0007 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0007 | C NO | addvolume | |||
20130215 00115346 DataVolumeType0007 | F | C NO | addvolume | |||
20130215 00115346 DataVolumeSize0007 | 947200 | C NO | addvolume | |||
20130215 00115346 MaxDataAreaReadAheadRequests | 14 | 12 | C SUPPORT | |||
20130215 00115346 MaxDataVolumes | 17 | 16 | C GENERAL addvolume | |||
20130215 00115346 MaxVolumes | 19 | 18 | C NO | |||
20130215 00115346 ReservedServerTasks | 23 | 22 | C SUPPORT | |||
20130215 00115346 MinServerTasks | 41 | 39 | C SUPPORT | |||
20130215 00115346 MaxServerTasks | 41 | 39 | C EXTENDED | |||
20130215 00115346 KernelTraceSize | 947 | 937 | C SUPPORT | |||
20130215 00115350 DataVolumeName0008 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0008 | C NO | addvolume | |||
20130215 00115350 DataVolumeType0008 | F | C NO | addvolume | |||
20130215 00115350 DataVolumeSize0008 | 947200 | C NO | addvolume | |||
20130215 00115350 MaxDataAreaReadAheadRequests | 16 | 14 | C SUPPORT | |||
20130215 00115350 MaxDataVolumes | 18 | 17 | C GENERAL addvolume | |||
20130215 00115350 MaxVolumes | 20 | 19 | C NO | |||
20130215 00115350 ReservedServerTasks | 24 | 23 | C SUPPORT | |||
20130215 00115350 MinServerTasks | 43 | 41 | C SUPPORT | |||
20130215 00115350 MaxServerTasks | 43 | 41 | C EXTENDED | |||
20130215 00115350 KernelTraceSize | 957 | 947 | C SUPPORT | |||
20130215 00115353 DataVolumeName0009 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0009 | C NO | addvolume | |||
20130215 00115353 DataVolumeType0009 | F | C NO | addvolume | |||
20130215 00115353 DataVolumeSize0009 | 947200 | C NO | addvolume | |||
20130215 00115353 ConverterStripes | 16 | 8 | C EXTENDED | |||
20130215 00115353 MaxDataAreaReadAheadRequests | 18 | 16 | C SUPPORT | |||
20130215 00115353 MaxDataVolumes | 19 | 18 | C GENERAL addvolume | |||
20130215 00115353 MaxVolumes | 21 | 20 | C NO | |||
20130215 00115353 ReservedServerTasks | 25 | 24 | C SUPPORT | |||
20130215 00115353 MinServerTasks | 45 | 43 | C SUPPORT | |||
20130215 00115353 MaxServerTasks | 45 | 43 | C EXTENDED | |||
20130215 00115353 KernelTraceSize | 967 | 957 | C SUPPORT | |||
20130215 00115356 DataVolumeName0010 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0010 | C NO | addvolume | |||
20130215 00115356 DataVolumeType0010 | F | C NO | addvolume | |||
20130215 00115356 DataVolumeSize0010 | 947200 | C NO | addvolume | |||
20130215 00115356 MaxDataAreaReadAheadRequests | 20 | 18 | C SUPPORT | |||
20130215 00115356 MaxDataVolumes | 20 | 19 | C GENERAL addvolume | |||
20130215 00115356 MaxVolumes | 22 | 21 | C NO | |||
20130215 00115356 ReservedServerTasks | 26 | 25 | C SUPPORT | |||
20130215 00115356 MinServerTasks | 47 | 45 | C SUPPORT | |||
20130215 00115356 MaxServerTasks | 47 | 45 | C EXTENDED | |||
20130215 00115356 KernelTraceSize | 977 | 967 | C SUPPORT | |||
20130215 00115359 DataVolumeName0011 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0011 | C NO | addvolume | |||
20130215 00115359 DataVolumeType0011 | F | C NO | addvolume | |||
20130215 00115359 DataVolumeSize0011 | 947200 | C NO | addvolume | |||
20130215 00115359 MaxDataAreaReadAheadRequests | 22 | 20 | C SUPPORT | |||
20130215 00115359 MaxDataVolumes | 21 | 20 | C GENERAL addvolume | |||
20130215 00115359 MaxVolumes | 23 | 22 | C NO | |||
20130215 00115359 ReservedServerTasks | 27 | 26 | C SUPPORT | |||
20130215 00115359 MinServerTasks | 49 | 47 | C SUPPORT | |||
20130215 00115359 MaxServerTasks | 49 | 47 | C EXTENDED | |||
20130215 00115359 KernelTraceSize | 987 | 977 | C SUPPORT | |||
20130215 00115402 DataVolumeName0012 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0012 | C NO | addvolume | |||
20130215 00115402 DataVolumeType0012 | F | C NO | addvolume | |||
20130215 00115402 DataVolumeSize0012 | 947200 | C NO | addvolume | |||
20130215 00115402 MaxDataAreaReadAheadRequests | 24 | 22 | C SUPPORT | |||
20130215 00115402 MaxDataVolumes | 22 | 21 | C GENERAL addvolume | |||
20130215 00115402 MaxVolumes | 24 | 23 | C NO | |||
20130215 00115402 ReservedServerTasks | 28 | 27 | C SUPPORT | |||
20130215 00115402 MinServerTasks | 51 | 49 | C SUPPORT | |||
20130215 00115402 MaxServerTasks | 51 | 49 | C EXTENDED | |||
20130215 00115402 KernelTraceSize | 997 | 987 | C SUPPORT | |||
20130215 00115405 LogVolumeName001 | /sapdb/SM1/sapdblog/M01/sapdblog/DISKL001 | C NO | addvolume | |||
20130215 00115405 LogVolumeType001 | F | C NO | addvolume | |||
20130215 00115405 LogVolumeSize001 | 384000 | C NO | addvolume | |||
20130215 00115405 LogVolumePartition001 | 1 | C NO | addvolume | |||
20130215 00115405 AutoLogBackupSize | 128000 | 0 | C GENERAL | |||
20130215 00115405 MaxLogVolumes | 2 | 1 | C GENERAL addvolume | |||
20130215 00115405 MaxVolumes | 25 | 24 | C NO | |||
20130215 00115412 LogQueueSize | 200 | 50 | C EXTENDED | |||
20130215 00115412 GarbageCollectors | 10 | 1 | C SUPPORT | |||
20130215 00115412 MaxUserTasks | 100 | 50 | C GENERAL | |||
20130215 00115412 CAT_CACHE_SUPPLY | 10000 | 3776 | C EXTENDED | |||
20130215 00115412 MaxCPUs | 2 | 1 | C GENERAL | |||
20130215 00115412 JoinSearchTableThreshold4 | 64 | 16 | C EXTENDED | |||
20130215 00115413 HashJoinTotalMemorySize | 24000 | 5120 | C EXTENDED | |||
20130215 00115413 HashJoinSingleTableMemorySize | 4000 | 512 | C EXTENDED | |||
20130215 00115413 MaxSQLLocks | 300000 | 4680 | C GENERAL | |||
20130215 00115413 CacheMemorySize | 340608 | 510848 | C GENERAL | |||
20130215 00115413 UseableCPUs | 2 | 1 | C EXTENDED | |||
20130215 00115413 MaxLogQueues | 2 | 1 | C SUPPORT | |||
20130215 00115413 OmsSubHeaps | 2 | 1 | C NO | |||
20130215 00115413 MaxTransactions | 868 | 468 | C SUPPORT | |||
20130215 00115413 TaskCluster02 | ti,100*pg;1*bup,50*us; | ti,100*pg;1*bup,30000*us; | C SUPPORT | |||
20130215 00115413 TaskCluster03 | equalize | compress | C SUPPORT | |||
20130215 00115413 KernelTraceSize | 1677 | 997 | C SUPPORT | |||
20130215 00120530 MCODIndicator | YES | NO | C GENERAL | |||
20130215 00133217 DataVolumeName0013 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0013 | C NO | addvolume | |||
20130215 00133217 DataVolumeType0013 | F | C NO | addvolume | |||
20130215 00133217 DataVolumeSize0013 | 947200 | C NO | addvolume | |||
20130215 00133217 MaxDataAreaReadAheadRequests | 26 | 24 | C SUPPORT | |||
20130215 00133305 DataVolumeName0014 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0014 | C NO | addvolume | |||
20130215 00133305 DataVolumeType0014 | F | C NO | addvolume | |||
20130215 00133305 DataVolumeSize0014 | 947200 | C NO | addvolume | |||
20130215 00133305 MaxDataAreaReadAheadRequests | 28 | 26 | C SUPPORT | |||
20130215 00133402 DataVolumeName0015 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0015 | C NO | addvolume | |||
20130215 00133402 DataVolumeType0015 | F | C NO | addvolume | |||
20130215 00133402 DataVolumeSize0015 | 947200 | C NO | addvolume | |||
20130215 00133402 MaxDataAreaReadAheadRequests | 30 | 28 | C SUPPORT | |||
20130215 00151851 MaxDataVolumes | 25 | 22 | C GENERAL addvolume | |||
20130215 00151851 MaxVolumes | 28 | 25 | C NO | |||
20130215 00151851 ReservedServerTasks | 31 | 28 | C SUPPORT | |||
20130215 00151851 MinServerTasks | 57 | 51 | C SUPPORT | |||
20130215 00151851 MaxServerTasks | 57 | 51 | C EXTENDED | |||
20130215 00151851 KernelTraceSize | 1707 | 1677 | C SUPPORT | |||
20130215 00154003 DataVolumeName0016 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0016 | C NO | addvolume | |||
20130215 00154003 DataVolumeType0016 | F | C NO | addvolume | |||
20130215 00154003 DataVolumeSize0016 | 947200 | C NO | addvolume | |||
20130215 00154003 MaxDataAreaReadAheadRequests | 32 | 30 | C SUPPORT | |||
20130215 00154058 DataVolumeName0017 | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0017 | C NO | addvolume | |||
20130215 00154058 DataVolumeType0017 | F | C NO | addvolume | |||
20130215 00154058 DataVolumeSize0017 | 947200 | C NO | addvolume | |||
20130215 00154058 MaxDataAreaReadAheadRequests | 34 | 32 | C SUPPORT | |||
20130215 00154859 MaxDataVolumes | 27 | 25 | C GENERAL addvolume | |||
20130215 00154859 MaxVolumes | 30 | 28 | C NO | |||
20130215 00154859 ReservedServerTasks | 33 | 31 | C SUPPORT | |||
20130215 00154859 MinServerTasks | 61 | 57 | C SUPPORT | |||
20130215 00154859 MaxServerTasks | 61 | 57 | C EXTENDED | |||
20130215 00154859 KernelTraceSize | 1727 | 1707 | C SUPPORT | |||
20130215 00171216 DataVolumeName0017 | <<parameter inactive>> | /sapdb/SM1/sapdblog/M01/sapdata/DISKD0017 | D NO | deletevolume | ||
20130215 00171216 DataVolumeType0017 | <<parameter inactive>> | F | D NO | deletevolume | ||
20130215 00171216 DataVolumeSize0017 | <<parameter inactive>> | 947200 | D NO | deletevolume | ||
20130215 00181217 MaxDataAreaReadAheadRequests | 32 | 34 | C SUPPORT | |||
20130215 00181838 KernelVersion | KERNEL | 7.8.02 BUILD 028-121-245-008 | KERNEL | 7.8.01 BUILD 014-000-000-000 | C GENERAL implicit change by migration | |
20130215 00181839 MaxTransactions | 1308 | 868 | C SUPPORT | |||
20130215 00181839 DedicatedServerTaskUKTs | YES | C SUPPORT | ||||
20130215 00181839 MaxServerTaskUKTs | 1 | C SUPPORT | ||||
20130215 00181839 CAT_CACHE_SUPPLY | 10496 | 10000 | C EXTENDED | |||
20130215 00181839 _MP_RGN_PRIO | <<parameter inactive>> | D EXTENDED | ||||
20130215 00181839 ExclusiveLockFavorPrioTasks | DEFAULT | C EXTENDED | ||||
20130215 00181839 KernelMessageFileSize | 10000 | 800 | C EXTENDED | |||
20130215 00181839 IOTicketQueueSynchronizationMode DEFAULT | C SUPPORT | |||||
20130215 00181839 EnableGenericSecurityService | NO | C EXTENDED | ||||
20130215 00181839 TraceDQEODBC | 0 | C TRACE | ||||
20130215 00181839 TraceDQETPT | 0 | C TRACE | ||||
20130215 00181839 EnableNewJoinCostFunc | NO | C SUPPORT | ||||
20130215 00181839 EnableVariableOutput | NO | YES | C SUPPORT | |||
20130215 00181839 RunTimeMemoryMapFileSize | 1048576 | C SUPPORT | ||||
20130215 00181839 UseBackupCheck | YES | C SUPPORT | ||||
20130215 00181839 EnableLobTransactionConsistency YES | C SUPPORT | |||||
20130215 00181839 EnableNewIndexCostfunction | YES | C SUPPORT |
Thanks,
Naresh Kumar
+91 9811734907
Hello Naresh,
Are you a SAP Customer ?
How did you do the system copy ? If backup/restore method - did you copy the parameters from source system backup ?
It looks like you did a system copy on 2013/02/15 correct ? You said the problem was not there after the system copy
Set the parameter CONTROLPASSWORD to its correct value. If you still not able to resolve the issue, you can try restoring the last backed up version of your parameter file as follows:
There is one parameter file for each MaxDB instance - the currently active one.
It's the file /sapdb/data/config/<SID>. Rename it to <SID>.old
Run the command
param_restore 1
to get the last backed up version of the parameter file.
Let me know
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.